void GetStationTargets(StationGridModel stationDTO) // veri tabanındaki target ları çekiyoruz
{
TBL_TARGET targett = DB.targets.Where(x => x.STATION_ID == stationDTO.ID && x.IS_DELETED == false).FirstOrDefault();
stationDTO.JAN_PRODUCTION = targett.JAN_PRODUCTION;
stationDTO.FEB_PRODUCTION = targett.FEB_PRODUCTION;
stationDTO.MARCH_PRODUCTION = targett.MARCH_PRODUCTION;
stationDTO.APRIL_PRODUCTION = targett.APRIL_PRODUCTION;
stationDTO.MAY_PRODUCTION = targett.MAY_PRODUCTION;
stationDTO.JUNE_PRODUCTION = targett.JUNE_PRODUCTION;
stationDTO.JULY_PRODUCTION = targett.JULY_PRODUCTION;
stationDTO.AUGUST_PRODUCTION = targett.AUGUST_PRODUCTION;
stationDTO.SEP_PRODUCTION = targett.SEP_PRODUCTION;
stationDTO.OKT_PRODUCTION = targett.OKT_PRODUCTION;
stationDTO.NOV_PRODUCTION = targett.NOV_PRODUCTION;
stationDTO.DEC_PRODUCTION = targett.DEC_PRODUCTION;
stationDTO.JAN_IRRADIATION = targett.JAN_IRRADIATION;
stationDTO.FEB_IRRADIATION = targett.FEB_IRRADIATION;
stationDTO.MARCH_IRRADIATION = targett.MARCH_IRRADIATION;
stationDTO.APRIL_IRRADIATION = targett.APRIL_IRRADIATION;
stationDTO.MAY_IRRADIATION = targett.MAY_IRRADIATION;
stationDTO.JUNE_IRRADIATION = targett.JUNE_IRRADIATION;
stationDTO.JULY_IRRADIATION = targett.JULY_IRRADIATION;
stationDTO.AUGUST_IRRADIATION = targett.AUGUST_IRRADIATION;
stationDTO.SEP_IRRADIATION = targett.SEP_IRRADIATION;
stationDTO.OKT_IRRADIATION = targett.OKT_IRRADIATION;
stationDTO.NOV_IRRADIATION = targett.NOV_IRRADIATION;
stationDTO.DEC_IRRADIATION = targett.DEC_IRRADIATION;
stationDTO.YEAR_PRODUCTION = targett.YEAR_PRODUCTION;
stationDTO.YEAR_IRRADIATION = targett.YEAR_IRRADIATION;
}
public ActionResult UpdateTargetStation(StationGridModel statdDTO, int companyId)
{
if (ModelState.IsValid && companyId > 0)
{
//TBL_TARGET target = DB.targets.Where(x => x.STATION_ID == companyId && x.IS_DELETED == false).FirstOrDefault();
TBL_TARGET target = DB.targets.AsNoTracking().FirstOrDefault(x => x.STATION_ID == statdDTO.ID);
target.UPDATE_USER = User.Identity.GetUserId();
target.JAN_PRODUCTION = statdDTO.JAN_PRODUCTION;
target.FEB_PRODUCTION = statdDTO.FEB_PRODUCTION;
target.MARCH_PRODUCTION = statdDTO.MARCH_PRODUCTION;
target.APRIL_PRODUCTION = statdDTO.APRIL_PRODUCTION;
target.MAY_PRODUCTION = statdDTO.MAY_PRODUCTION;
target.JUNE_PRODUCTION = statdDTO.JUNE_PRODUCTION;
target.JULY_PRODUCTION = statdDTO.JULY_PRODUCTION;
target.AUGUST_PRODUCTION = statdDTO.AUGUST_PRODUCTION;
target.SEP_PRODUCTION = statdDTO.SEP_PRODUCTION;
target.OKT_PRODUCTION = statdDTO.OKT_PRODUCTION;
target.NOV_PRODUCTION = statdDTO.NOV_PRODUCTION;
target.DEC_PRODUCTION = statdDTO.DEC_PRODUCTION;
target.JAN_IRRADIATION = statdDTO.JAN_IRRADIATION;
target.FEB_IRRADIATION = statdDTO.FEB_IRRADIATION;
target.MARCH_IRRADIATION = statdDTO.MARCH_IRRADIATION;
target.APRIL_IRRADIATION = statdDTO.APRIL_IRRADIATION;
target.MAY_IRRADIATION = statdDTO.MAY_IRRADIATION;
target.JUNE_IRRADIATION = statdDTO.JUNE_IRRADIATION;
target.JULY_IRRADIATION = statdDTO.JULY_IRRADIATION;
target.AUGUST_IRRADIATION = statdDTO.AUGUST_IRRADIATION;
target.SEP_IRRADIATION = statdDTO.SEP_IRRADIATION;
target.OKT_IRRADIATION = statdDTO.OKT_IRRADIATION;
target.NOV_IRRADIATION = statdDTO.NOV_IRRADIATION;
target.DEC_IRRADIATION = statdDTO.DEC_IRRADIATION;
target.YEAR_PRODUCTION = statdDTO.YEAR_PRODUCTION;
target.YEAR_IRRADIATION = statdDTO.YEAR_IRRADIATION;
DB.Entry(target).State = EntityState.Modified;
DB.SaveChanges();
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
ViewData["EditableProduct"] = statdDTO;
}
return(PartialView("GridStationPartial", GetStationByCompanyId(companyId)));
}
public ActionResult SaveTargetStation(StationGridModel trgt, int stationId)
{
if (ModelState.IsValid && stationId > 0)
{
TBL_TARGET target = new TBL_TARGET();
target.STATION_ID = stationId;
target.CREATED_DATE = DateTime.Now;
target.UPDATED_DATE = DateTime.Now;
target.INSTALL_DATE = DateTime.Now;
target.UPDATE_USER = User.Identity.GetUserId();
if (trgt.JAN_IRRADIATION != null
&&
trgt.FEB_IRRADIATION != null
&&
trgt.MARCH_IRRADIATION != null
&&
trgt.APRIL_IRRADIATION != null
&&
trgt.MAY_IRRADIATION != null
&&
trgt.JUNE_IRRADIATION != null
&&
trgt.JULY_IRRADIATION != null
&&
trgt.AUGUST_IRRADIATION != null
&&
trgt.SEP_IRRADIATION != null
&&
trgt.OKT_IRRADIATION != null
&&
trgt.NOV_IRRADIATION != null
&&
trgt.DEC_IRRADIATION != null
&&
trgt.JAN_PRODUCTION != null
&&
trgt.FEB_PRODUCTION != null
&&
trgt.MARCH_PRODUCTION != null
&&
trgt.APRIL_PRODUCTION != null
&&
trgt.MAY_PRODUCTION != null
&&
trgt.JUNE_PRODUCTION != null
&&
trgt.JULY_PRODUCTION != null
&&
trgt.AUGUST_PRODUCTION != null
&&
trgt.SEP_PRODUCTION != null
&&
trgt.OKT_PRODUCTION != null
&&
trgt.NOV_PRODUCTION != null
&&
trgt.DEC_PRODUCTION != null
&&
trgt.YEAR_IRRADIATION != null
&&
trgt.YEAR_PRODUCTION != null)
{
target.JAN_PRODUCTION = trgt.JAN_PRODUCTION;
target.FEB_PRODUCTION = trgt.FEB_PRODUCTION;
target.MARCH_PRODUCTION = trgt.MARCH_PRODUCTION;
target.APRIL_PRODUCTION = trgt.APRIL_PRODUCTION;
target.MAY_PRODUCTION = trgt.MAY_PRODUCTION;
target.JUNE_PRODUCTION = trgt.JUNE_PRODUCTION;
target.JULY_PRODUCTION = trgt.JULY_PRODUCTION;
target.AUGUST_PRODUCTION = trgt.AUGUST_PRODUCTION;
target.SEP_PRODUCTION = trgt.SEP_PRODUCTION;
target.OKT_PRODUCTION = trgt.OKT_PRODUCTION;
target.NOV_PRODUCTION = trgt.NOV_PRODUCTION;
target.DEC_PRODUCTION = trgt.DEC_PRODUCTION;
target.JAN_IRRADIATION = trgt.JAN_IRRADIATION;
target.FEB_IRRADIATION = trgt.FEB_IRRADIATION;
target.MARCH_IRRADIATION = trgt.MARCH_IRRADIATION;
target.APRIL_IRRADIATION = trgt.APRIL_IRRADIATION;
target.MAY_IRRADIATION = trgt.MAY_IRRADIATION;
target.JUNE_IRRADIATION = trgt.JUNE_IRRADIATION;
target.JULY_IRRADIATION = trgt.JULY_IRRADIATION;
target.AUGUST_IRRADIATION = trgt.AUGUST_IRRADIATION;
target.SEP_IRRADIATION = trgt.SEP_IRRADIATION;
target.OKT_IRRADIATION = trgt.OKT_IRRADIATION;
target.NOV_IRRADIATION = trgt.NOV_IRRADIATION;
target.DEC_IRRADIATION = trgt.DEC_IRRADIATION;
target.YEAR_PRODUCTION = trgt.YEAR_PRODUCTION;
target.YEAR_IRRADIATION = trgt.YEAR_IRRADIATION;
}
else
{
target.JAN_IRRADIATION = 0;
target.JAN_PRODUCTION = 0;
target.FEB_IRRADIATION = 0;
target.FEB_PRODUCTION = 0;
target.MARCH_IRRADIATION = 0;
target.MARCH_PRODUCTION = 0;
target.APRIL_IRRADIATION = 0;
target.APRIL_PRODUCTION = 0;
target.MAY_IRRADIATION = 0;
target.MAY_PRODUCTION = 0;
target.JUNE_IRRADIATION = 0;
target.JUNE_PRODUCTION = 0;
target.JULY_IRRADIATION = 0;
target.JULY_PRODUCTION = 0;
target.AUGUST_IRRADIATION = 0;
target.AUGUST_PRODUCTION = 0;
target.SEP_IRRADIATION = 0;
target.SEP_PRODUCTION = 0;
target.OKT_IRRADIATION = 0;
target.OKT_PRODUCTION = 0;
target.NOV_IRRADIATION = 0;
target.NOV_PRODUCTION = 0;
target.DEC_IRRADIATION = 0;
target.DEC_PRODUCTION = 0;
target.YEAR_IRRADIATION = 0;
target.YEAR_PRODUCTION = 0;
}
DB.targets.Add(target);
DB.SaveChanges();
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
ViewData["EditableProduct"] = trgt;
}
return(PartialView("GridStationPartial", GetStationByCompanyId(stationId)));
}
