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); }