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