private bool CorrectConsumption(ConsumptionInput consumption)
{
if (consumption.Amount <= 0)
{
return(false);
}
if (consumption.FoodName.Trim().Length <= 1)
{
return(false);
}
if (consumption.WeightUnitId == 0)
{
return(false);
}
if (consumption.PatientId == 0)
{
return(false);
}
if (consumption.Date > DateTime.Now)
{
return(false);
}
if (consumption.Date < DateTime.Now.AddYears(-1))
{
return(false);
}
return(true);
}
public JsonResult GetOemWise([FromBody] ConsumptionInput value)
{
var result = BusinessService.GetOemWise(value);
var r = new JsonResult(result);
return(r);
}
public List <KeyValuePair <string, string> > GetMessageData(ConsumptionInput input)
{
var msg1 = (from msg in Message_Data
orderby msg.id descending
select new { Data = msg.date.ToString("dd-MM-yyyy") + " " + msg.time.ToString(@"hh\:mm") }).FirstOrDefault();
//var msg2 = (from ftp in FTP_Data
// orderby ftp.id descending
// select ftp.readdatetime).FirstOrDefault();
var msg3 = (from m in Message_Data
where m.tamperstatus != 0
select m).Count();
//var msg4 = (from m in FTP_Data
// where m.alarms != null
// select m).Count();
var result = new List <KeyValuePair <String, string> >();
var ms1 = msg1 == null ? "" : msg1.Data;
result.Add(new KeyValuePair <string, string>("Last Message Received at", ms1));
//result.Add(new KeyValuePair<string, string>("Last File Received at", msg2.ToString("dd-MM-yyyy hh:mm")));
result.Add(new KeyValuePair <string, string>("Number of instances with Tamper Status", msg3.ToString()));
//result.Add(new KeyValuePair<string, string>("Number of instances with Alarms Status", msg4.ToString()));
return(result);
}
public List <NameValuePair <string, decimal> > GetOemWise(ConsumptionInput input)
{
var inp = Mapper.Map <DataModels.Dashboard.ConsumptionInput>(input);
var result = Repository.GetOemWise(inp);
var ret = Mapper.Map <List <NameValuePair <string, decimal> > >(result);
return(ret);
}
public IEnumerable <string> Get()
{
var value = new ConsumptionInput();
var result = BusinessService.GetMessageData(value);
//return result;
return(new string[] { "value1", "value2" });
}
public List <KeyValuePair <string, decimal> > GetDivisionWise(ConsumptionInput input)
{
var from = input.From.Split('-');
var to = input.To.Split('-');
var fromDate = new DateTime(Convert.ToInt32(from[0]), Convert.ToInt32(from[1]), 1);
var lastday = DateTime.DaysInMonth(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]));
var toDate = new DateTime(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]), lastday);
var result = new List <KeyValuePair <string, decimal> >();
var isAdmin = false;
var user = (from emp in Employee
join el in EmployeeLoginMap
on emp.employeeid equals el.employeeid
join lm in LoginMaster
on el.loginname equals lm.loginname
join rol in Roles
on lm.roles equals rol.roleid
where emp.employeeid == input.UserId
select rol.rolename).FirstOrDefault();
isAdmin = user == "Admin";
IQueryable <KeyValuePair <String, decimal> > qry;
if (isAdmin)
{
qry = from ucd in UnitsConsumptionDetails
join us in UnitSummary
on ucd.unitid equals us.id
join org in Organization
on us.divisionid equals org.organizationid
where ucd.daterecorded >= fromDate && ucd.daterecorded <= toDate
group ucd by new { Name = org.organizationname } into d
select new KeyValuePair <string, decimal>(d.Key.Name, d.Max(c => c.consumptioninmcube) - d.Min(c => c.consumptioninmcube));
}
else
{
qry = from ucd in UnitsConsumptionDetails
join us in UnitSummary
on ucd.unitid equals us.id
join org in Organization
on us.divisionid equals org.organizationid
where ucd.daterecorded >= fromDate && ucd.daterecorded <= toDate && us.consumerid == input.UserId
group ucd by new { Name = org.organizationname } into d
select new KeyValuePair <string, decimal>(d.Key.Name, d.Max(c => c.consumptioninmcube) - d.Min(c => c.consumptioninmcube));
}
return(qry.ToList());
}
public ConsumptionData <string, decimal> GetConsumptionData(ConsumptionInput input)
{
var inp = Mapper.Map <DataModels.Dashboard.ConsumptionInput>(input);
var result = Repository.GetConsumptionData(inp);
var ret = new ConsumptionData <string, decimal>();
var ret1 = new List <SeriesList <string, decimal> >();
foreach (var item in result.Data)
{
var k = item.Key;
var val = item.Value;
var row = new SeriesList <string, decimal>();
row.name = item.Key;
row.series = new List <NameValuePair <string, decimal> >();
foreach (var inner in val)
{
var r = new NameValuePair <string, decimal>()
{
name = inner.Key, value = inner.Value
};
row.series.Add(r);
}
ret1.Add(row);
}
var ret2 = new List <SeriesList <string, decimal> >();
foreach (var item in result.AlternateData)
{
var k = item.Key;
var val = item.Value;
var row = new SeriesList <string, decimal>();
row.name = item.Key;
row.series = new List <NameValuePair <string, decimal> >();
foreach (var inner in val)
{
var r = new NameValuePair <string, decimal>()
{
name = inner.Key, value = inner.Value
};
row.series.Add(r);
}
ret2.Add(row);
}
ret.Data = ret1;
ret.AlternateData = ret2;
return(ret);
}
public async Task <ActionResult> UpdateConsumption(HttpRequest req, string consumptionId)
{
if (!int.TryParse(consumptionId, out int Id))
{
return(new BadRequestObjectResult(Messages.ErrorIncorrectId));
}
ConsumptionView consumption = await consumptionRepository.GetConsumptionByConsumptionId(Id);
int targetPatientId = consumption.PatientId;
ConsumptionInput updateConsumption = new ConsumptionInput();
string consumptionJson = await new StreamReader(req.Body).ReadToEndAsync();
JsonConvert.PopulateObject(consumptionJson, updateConsumption);
if (!CorrectConsumption(updateConsumption))
{
return(new BadRequestObjectResult(Messages.ErrorInvalidConsumptionObject));
}
// Check if updated consumption patientId equals target patientId
if (updateConsumption.PatientId != targetPatientId)
{
return(new BadRequestObjectResult(Messages.ErrorPut));
}
// Auth check
if (!await Authorised(req, targetPatientId, false))
{
return(new BadRequestObjectResult(Messages.AuthNoAcces));
}
if (await consumptionRepository.UpdateConsumption(Id, updateConsumption))
{
return(new OkObjectResult(Messages.OKUpdate));
}
return(new BadRequestObjectResult(Messages.ErrorPut));
}
public List <KeyValuePair <string, decimal> > GetOemWise(ConsumptionInput input)
{
var from = input.From.Split('-');
var to = input.To.Split('-');
var fromDate = new DateTime(Convert.ToInt32(from[0]), Convert.ToInt32(from[1]), 1);
var lastday = DateTime.DaysInMonth(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]));
var toDate = new DateTime(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]), lastday);
var result = new List <KeyValuePair <string, decimal> >();
var qry = from ucd in UnitsConsumptionDetails
join us in UnitSummary
on ucd.unitid equals us.id
join mv in MasterValue
on us.oemname equals mv.code
join mas in Masters
on mv.mastersid equals mas.mastersid where mas.code == "MtrOEMName"
where ucd.daterecorded >= fromDate && ucd.daterecorded <= toDate
group ucd by mas.description into d
select new KeyValuePair <string, decimal>(d.Key, d.Max(c => c.consumptioninmcube) - d.Min(c => c.consumptioninmcube));
return(qry.ToList());
}
public async Task <ActionResult> AddConsumption(HttpRequest req)
{
ConsumptionInput newConsumption = new ConsumptionInput();
string consumptionJson = await new StreamReader(req.Body).ReadToEndAsync();
JsonConvert.PopulateObject(consumptionJson, newConsumption);
if (!CorrectConsumption(newConsumption))
{
return(new BadRequestObjectResult(Messages.ErrorInvalidConsumptionObject));
}
// Auth check
if (!await Authorised(req, newConsumption.PatientId, false))
{
return(new BadRequestObjectResult(Messages.AuthNoAcces));
}
if (await consumptionRepository.AddConsumption(newConsumption))
{
return(new OkObjectResult(Messages.OKPost));
}
return(new BadRequestObjectResult(Messages.ErrorPost));
}
public List <KeyValuePair <string, string> > GetMessageData(ConsumptionInput input)
{
var inp = Mapper.Map <DataModels.Dashboard.ConsumptionInput>(input);
return(Repository.GetMessageData(inp));
}
public List <KeyValuePair <string, string> > GetMessageData([FromBody] ConsumptionInput value)
{
var result = BusinessService.GetMessageData(value);
return(result);
}
public ConsumptionData GetConsumptionData(ConsumptionInput input)
{
var from = input.From.Split('-');
var to = input.To.Split('-');
var fromDate = new DateTime(Convert.ToInt32(from[0]), Convert.ToInt32(from[1]), 1);
var lastday = DateTime.DaysInMonth(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]));
var toDate = new DateTime(Convert.ToInt32(to[0]), Convert.ToInt32(to[1]), lastday);
var result = new ConsumptionData();
var result1 = new List <KeyValuePair <string, List <KeyValuePair <string, decimal> > > >();
var result2 = new List <KeyValuePair <string, List <KeyValuePair <string, decimal> > > >();
var isAdmin = false;
var user = (from emp in Employee
join el in EmployeeLoginMap
on emp.employeeid equals el.employeeid
join lm in LoginMaster
on el.loginname equals lm.loginname
join rol in Roles
on lm.roles equals rol.roleid
where emp.employeeid == input.UserId
select rol.rolename).FirstOrDefault();
isAdmin = user == "Admin";
IQueryable <ConsumptionResult> qry;
if (isAdmin)
{
qry = from ucd in UnitsConsumptionDetails
join us in UnitSummary
on ucd.unitid equals us.id
where ucd.daterecorded <= toDate &&
ucd.daterecorded >= fromDate
//where ucd.daterecorded >= DateTime.Now.AddYears(-1)
orderby ucd.daterecorded
group ucd by new { Month = ucd.daterecorded.Month, Year = ucd.daterecorded.Year, unitId = us.unitid } into d
select new ConsumptionResult {
period = new DateTime(d.Key.Year, d.Key.Month, 1), month = d.Key.Month, year = d.Key.Year, unitid = d.Key.unitId, consumption = d.Max(c => c.consumptioninmcube) - d.Min(e => e.consumptioninmcube)
}
;
}
else
{
qry = from ucd in UnitsConsumptionDetails
join us in UnitSummary
on ucd.unitid equals us.id
where ucd.daterecorded <= toDate &&
ucd.daterecorded >= fromDate &&
us.consumerid == input.UserId
//where ucd.daterecorded >= DateTime.Now.AddYears(-1)
orderby ucd.daterecorded
group ucd by new { Month = ucd.daterecorded.Month, Year = ucd.daterecorded.Year, unitId = us.unitid } into d
select new ConsumptionResult {
period = new DateTime(d.Key.Year, d.Key.Month, 1), month = d.Key.Month, year = d.Key.Year, unitid = d.Key.unitId, consumption = d.Max(c => c.consumptioninmcube) - d.Min(e => e.consumptioninmcube)
}
;
}
var distinctRows = (from m in qry
select m.unitid).Distinct()
;
foreach (var dr in distinctRows)
{
var sub = from row in qry
where row.unitid == dr
select new KeyValuePair <string, decimal>(row.period.ToString("MMM-yyyy"), row.consumption);
var r1 = new KeyValuePair <string, List <KeyValuePair <string, decimal> > >(dr.ToString(), sub.ToList());
result1.Add(r1);
}
var distinctRows1 = (from m in qry
select m.period).Distinct()
;
foreach (var dr in distinctRows1)
{
var sub = from row in qry
where row.period == dr
select new KeyValuePair <string, decimal>(row.unitid, row.consumption);
var r1 = new KeyValuePair <string, List <KeyValuePair <string, decimal> > >(dr.ToString("MMM-yyyy"), sub.ToList());
result2.Add(r1);
}
result.Data = result1;
result.AlternateData = result2;
return(result);
}
