public void Update(DistrictData disEntity, DistrictSummery sumEntity) { sumEntity.LastUpdateTime = DateTime.Now; if (disEntity.Id == 0) { disRepository.Add(disEntity); } else { disRepository.Update(disEntity); } if (sumEntity.Id == 0) { sumRepository.Add(sumEntity); } else { sumRepository.Update(sumEntity); } }
public ActionResult Save(DistrictSubmitModel model) { DistrictData entityDis = disDataService.Get(model.DistrictId, model.Date); DistrictSummery entityDisSum = disDataService.GetSummery(model.DistrictId); if (entityDisSum == null) { entityDisSum = new DistrictSummery(); } if (entityDis == null) { entityDis = new DistrictData(); entityDisSum.TotalQuarantine = entityDisSum.TotalQuarantine + model.NewQuarantine; entityDisSum.TotalReleased = entityDisSum.TotalReleased + model.ReleasedQuarantine; entityDisSum.TotalDoTestOn = entityDisSum.TotalDoTestOn + model.DoTestOn; entityDisSum.TotalDeath = entityDisSum.TotalDeath + model.Death; entityDisSum.TotalReliefFamily = entityDisSum.TotalReliefFamily + model.ReliefFamily; //entityDisSum.TotalReliefPerson = entityDisSum.TotalReliefPerson + model.ReliefPerson; entityDisSum.TotalRice = entityDisSum.TotalRice + model.Rice; entityDisSum.TotalDal = entityDisSum.TotalDal + model.Dal; entityDisSum.TotalPotato = entityDisSum.TotalPotato + model.Potato; entityDisSum.TotalMoney = entityDisSum.TotalMoney + model.Money; //entityDisSum.TotalOil = entityDisSum.TotalOil + model.Oil; //entityDisSum.TotalSoap = entityDisSum.TotalSoap + model.Soap; //entityDisSum.TotalOnion = entityDisSum.TotalOnion + model.Onion; //entityDisSum.TotalSalt = entityDisSum.TotalSalt + model.Salt; } else { entityDisSum.TotalQuarantine = entityDisSum.TotalQuarantine + (model.NewQuarantine - entityDis.NewQuarantine); entityDisSum.TotalReleased = entityDisSum.TotalReleased + (model.ReleasedQuarantine - entityDis.ReleasedQuarantine); entityDisSum.TotalDoTestOn = entityDisSum.TotalDoTestOn + (model.DoTestOn - entityDis.DoTestOn); entityDisSum.TotalDeath = entityDisSum.TotalDeath + (model.Death - entityDis.Death); entityDisSum.TotalReliefFamily = entityDisSum.TotalReliefFamily + (model.ReliefFamily - entityDisSum.TotalReliefFamily); //entityDisSum.TotalReliefPerson = entityDisSum.TotalReliefPerson + (model.ReliefPerson- entityDisSum.TotalReliefPerson); entityDisSum.TotalRice = entityDisSum.TotalRice + (model.Rice - entityDisSum.TotalRice); entityDisSum.TotalDal = entityDisSum.TotalDal + (model.Dal - entityDisSum.TotalDal); entityDisSum.TotalPotato = entityDisSum.TotalPotato + (model.Potato - entityDisSum.TotalPotato); entityDisSum.TotalMoney = entityDisSum.TotalMoney + (model.Money - entityDisSum.TotalMoney); //entityDisSum.TotalOil = entityDisSum.TotalOil + (model.Oil- entityDisSum.TotalOil); //entityDisSum.TotalSoap = entityDisSum.TotalSoap +( model.Soap- entityDisSum.TotalSoap); //entityDisSum.TotalOnion = entityDisSum.TotalOnion + (model.Onion- entityDisSum.TotalOnion); //entityDisSum.TotalSalt = entityDisSum.TotalSalt + (model.Salt- entityDisSum.TotalSalt); } entityDisSum.CurrentQuarantine = entityDisSum.TotalQuarantine - entityDisSum.TotalReleased - entityDisSum.TotalDeath; //running qrn, death, release, new qrn ModelCopier.CopyModel(model, entityDis); ModelCopier.CopyModel(model, entityDisSum); entityDis.Id = model.DetailId; entityDis.Remarks = model.RemarksDetail; entityDisSum.Id = model.SumId; entityDisSum.Remarks = model.RemarksSum; entityDis.InsertedById = SessionHelper.UserId; entityDisSum.InsertedById = SessionHelper.UserId; disDataService.Update(entityDis, entityDisSum); unitOfWork.Commit(); return(PartialView()); }
public JsonResult DataGridSum() { //bool visible = UserRole.Check("DISTRICT", SessionHelper.Role); int ec = int.Parse(Request.QueryString["sEcho"]); int take = int.Parse(Request.QueryString["iDisplayLength"]); int skip = int.Parse(Request.QueryString["iDisplayStart"]); //if (take == -1) { take = 100000000; skip = 0; } int?divId = null; try { divId = Convert.ToInt32(Request.QueryString["ContentTypeId1"]); } catch { } int?disId = null; try { disId = Convert.ToInt32(Request.QueryString["ContentTypeId2"]); } catch { } //DateTime FromDate = Convert.ToDateTime(Request.QueryString["FromDate"]); //DateTime ToDate = Convert.ToDateTime(Request.QueryString["ToDate"]); int count = 0; List <DistrictSummery> dataList = disDataService.GetSummery(divId, disId, skip, take, out count).ToList(); if (dataList.Count() > 0) { DistrictSummery tot = dataList.GroupBy(q => 1) .Select(g => new DistrictSummery { Id = 0 , StandingData = new StandingData { Name = "<span style=\"color:#ff6a00; font-size:14px;\">Total</span>" } , DivisionId = -1 , StandingData1 = new StandingData { Name = " " } , DistrictId = -1 , HospitalCount = g.Sum(c => c.HospitalCount) , BedCount = g.Sum(c => c.BedCount) , CurrentQuarantine = g.Sum(c => c.CurrentQuarantine) , TotalDeath = g.Sum(c => c.TotalDeath) , TotalDoTestOn = g.Sum(c => c.TotalDoTestOn) , TotalQuarantine = g.Sum(c => c.TotalQuarantine) , TotalReleased = g.Sum(c => c.TotalReleased) , TotalReliefFamily = g.Sum(c => c.TotalReliefFamily) //, //TotalReliefPerson = g.Sum(c => c.TotalReliefPerson) , TotalRice = g.Sum(c => c.TotalRice) , TotalDal = g.Sum(c => c.TotalDal) , TotalMoney = g.Sum(c => c.TotalMoney) , TotalPotato = g.Sum(c => c.TotalPotato) //, //TotalOil = g.Sum(c => c.TotalOil) //, //TotalOnion = g.Sum(c => c.TotalOnion) //, //TotalSalt = g.Sum(c => c.TotalSalt) //, //TotalSoap = g.Sum(c => c.TotalSoap) , InsertedById = -1 , UserProfile = new UserProfile { UserName = "" } } ).Single(); dataList.Insert(0, tot); } var obj = (from c in dataList select new object[] { c.StandingData.Name , c.StandingData1.Name , c.HospitalCount , c.BedCount , c.CurrentQuarantine , c.TotalQuarantine , c.TotalReleased , c.TotalDeath , c.TotalDoTestOn //,c.Remarks , c.TotalReliefFamily //,c.TotalReliefPerson , c.TotalRice , c.TotalDal , c.TotalPotato , c.TotalMoney //,c.TotalOnion //,c.TotalSalt //,c.TotalOil //,c.TotalSoap //,new GridButtonModel[] // { // new GridButtonModel{U=Url.Action("Edit",new {Id=c.Id}), T="Edit", D = GridButtonDialog.dialig1.ToString(), H="Edit", M="class=\"btn btn-mini btn-warning\"", V = visible} // } }).ToArray(); JQueryDataTable js = new JQueryDataTable(); js.sEcho = ec; js.iTotalDisplayRecords = count.ToString(); js.iTotalRecords = js.iTotalDisplayRecords; js.aaData = obj; return(Json(js, JsonRequestBehavior.AllowGet)); }