public ActionResult GetReportCrimes(long?id)
{
if (id == null)
{
id = 0;
}
try
{
SerialPort _serialPort = new SerialPort();
_serialPort.PortName = "COM4";
_serialPort.BaudRate = 9600;
_serialPort.Open();
/*if(!_serialPort.IsOpen)
* { _serialPort.Open(); }*/
ReportCrime rep = new ReportCrime();
//do some work here on the provider
var model = ReportCrimeProvider.getCrimes().Where(a => a.Id == id).Select(a => new ReportCrimeModel()
{
Id = a.Id,
Status = a.Status,
Name = a.Name,
ContactNo = a.ContactNo,
TypeOfCrime = a.TypeOfCrime,
Location = a.Location,
Date = a.Date,
Time = a.Time
}).Single();
// _serialPort.Write("1");
//dont forget to substring the location to 32 bit characters
string dataList = model.Location + "-" + model.TypeOfCrime;
string dataset = "";
if (dataList.Length > 27)
{
dataset = dataList.Substring(0, 26);
}
else
{
dataset = dataList;
}
_serialPort.Write(dataset + ".");
_serialPort.Close();
rep = DataContext.ReportCrimeSet.Where(a => a.Id == model.Id).SingleOrDefault();
rep.Status = "Reported";
DataContext.SaveChanges();
//test(model.TypeOfCrime, model.Location);
return(SerializeToAngular(model));
}
catch (ReportCrimeException e)
{
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, e.Message));
}
}
public ActionResult ReportGrid(GridModel model)
{
int begin = SetupGridParams(model);
var filteredQuery = ReportCrimeProvider.getCrimes()
.Select(a => new ReportGridModel()
{
Id = a.Id,
TypeOfCrime = a.TypeOfCrime,
Location = a.Location,
Time = a.Time,
Date = a.Date,
Name = a.Name,
Status = a.Status,
ContactNo = a.ContactNo
});
if (model.Searchfor != "null")
{
filteredQuery = filteredQuery.Where(r => r.TypeOfCrime.Contains(model.Searchfor) ||
r.Location.Contains(model.Searchfor) ||
r.Date.Contains(model.Searchfor) ||
r.Time.Contains(model.Searchfor) ||
r.Name.Contains(model.Searchfor) ||
r.Status.Contains(model.Searchfor)
);
}
//Get Reord count
var totalNumberOfRecords = filteredQuery.Count();
if (String.IsNullOrWhiteSpace(model.SortKey))
{
filteredQuery = filteredQuery.OrderBy(a => a.TypeOfCrime); //default sort order
}
//Setup sort order
switch (model.SortOrder)
{
case "ASC":
switch (model.SortKey)
{
case "status":
filteredQuery = filteredQuery.OrderBy(r => r.Status);
break;
case "name":
filteredQuery = filteredQuery.OrderBy(r => r.Name);
break;
case "contactNo":
filteredQuery = filteredQuery.OrderBy(r => r.ContactNo);
break;
case "typeOfCrime":
filteredQuery = filteredQuery.OrderBy(r => r.TypeOfCrime);
break;
case "location":
filteredQuery = filteredQuery.OrderBy(r => r.Location);
break;
case "date":
filteredQuery = filteredQuery.OrderBy(r => r.Date);
break;
case "time":
filteredQuery = filteredQuery.OrderBy(r => r.Time);
break;
}
break;
case "DESC":
switch (model.SortKey)
{
case "status":
filteredQuery = filteredQuery.OrderBy(r => r.Status);
break;
case "name":
filteredQuery = filteredQuery.OrderBy(r => r.Name);
break;
case "contactNo":
filteredQuery = filteredQuery.OrderBy(r => r.ContactNo);
break;
case "typeOfCrime":
filteredQuery = filteredQuery.OrderBy(r => r.TypeOfCrime);
break;
case "location":
filteredQuery = filteredQuery.OrderBy(r => r.Location);
break;
case "date":
filteredQuery = filteredQuery.OrderBy(r => r.Date);
break;
case "time":
filteredQuery = filteredQuery.OrderBy(r => r.Time);
break;
}
break;
}
//setup paging
filteredQuery = filteredQuery.Skip(begin).Take(model.RecordsPerPage.Value);
return(SerializeToAngular(new GridResultModel <ReportGridModel>(filteredQuery.ToList(), totalNumberOfRecords)));
}
