blob: 900827495fcbc134be07617947b6b7f7efafede2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using Tango.TCC.BL.Entities;
using Tango.TCC.Service.DB;
using Tango.TCC.Service.DTO;
using Tango.TCC.Service.Security;
using Tango.Web.Controllers;
using System.Data.Entity;
using Tango.TCC.BL.Web;
using Tango.TCC.Service.Storage;
using System.Web.Http.Results;
using Tango.TCC.Service.Filters;
using Microsoft.AspNet.SignalR;
using Tango.TCC.Service.Hubs;
namespace Tango.TCC.Service.Controllers
{
public class ResultsController : TangoController<TokenObject>
{
[JwtTokenFilter]
[HttpGet]
public List<ResultDTO> GetResults([FromUri] ResultsByDateRequest request)//int count)
{
List<ResultDTO> results = new List<ResultDTO>();
using (var db = TccDbContext.CreateTCC())
{
DateTime start, end;
if (!DateTime.TryParse(request.From, out start) || !DateTime.TryParse(request.To, out end))
{
return results;
}
var dbResults = (from RESULTS in db.Results
where DbFunctions.TruncateTime(RESULTS.Date) >= start.Date && DbFunctions.TruncateTime(RESULTS.Date) <= end.Date
join CARDS in db.Cards on RESULTS.CardGuid equals CARDS.Guid
join DEVICES in db.Devices on RESULTS.DeviceGuid equals DEVICES.Guid
where (request.Email == null || DEVICES.Email == request.Email) && (request.DeviceModel == null || DEVICES.DeviceModel == request.DeviceModel)
select new
{
Result = RESULTS,
DeviceModel = DEVICES.DeviceModel,
Email = DEVICES.Email,
CardCode = CARDS.Code,
DeviceID = DEVICES.DeviceID
}).ToList();
foreach (var item in dbResults)
{
ResultDTO dto = ResultDTO.createResultDTO(item.Result, item.CardCode, item.DeviceModel, item.Email, item.DeviceID);
results.Add(dto);
}
}
return results;
}
[HttpGet]
public RedirectResult GetResultSampleImage(String blobName)
{
return Redirect(TCCStorageManager.CreateSampleImageURL(blobName));
}
[HttpGet]
public RedirectResult GetResultSourceImage(String blobName)
{
return Redirect(TCCStorageManager.CreateSourceImageURL(blobName));
}
[JwtTokenFilter]
[HttpPost]
public VerificationResponse VerifyDeviceEmail(VerificationRequest request)//int count)
{
VerificationResponse response = new VerificationResponse();
response.Verified = false;
using (var db = TccDbContext.CreateTCC())
{
var device = db.Devices.FirstOrDefault(x => x.Email == request.Email);
if (device != null)
{
response.Verified = true;
}
}
return response;
}
[HttpPost]
public void Test()
{
var myHub = GlobalHost.ConnectionManager.GetHubContext<ResultsHub>() as ResultsHub;
ResultDTO dto = new ResultDTO();
dto.Guid = "123";
dto.Date = DateTime.Now;
dto.RawColor = -100000;
dto.ProcessedColor = -100000;
dto.SampleImageURL = "";
dto.SourceImageURL = "";
dto.ProcessTime = 55;
dto.CardGuid = "";
dto.CardCode = "";
dto.DeviceModel = "aaa";
dto.Email = "Victoria.Plitt@twine-s.com";
dto.DeviceGuid = "";
ResultsHub.PushResult(dto);
}
}
}
|
