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 UpdateStation(StationGridModel station)
{
int companyId = !string.IsNullOrEmpty(Request.Params["companyId"]) ? int.Parse(Request.Params["companyId"]) : 0;
if (ModelState.IsValid)
{
try
{
TBL_STATION stat = Mapper.Map <StationGridModel, TBL_STATION>(station);
stat.COMPANY_ID = companyId;
if (!stationService.IsStationExist(stat))
{
stat.UPDATE_USER = User.Identity.GetUserId();
//SaveStationUsers(station.ID, station.USERS);
//if (station.PHOTO != null && station.PHOTO.Length > 0)
//{
// string retVal = SaveStationPic(station.PHOTO, station.ID);
// if (retVal.Length > 0)
// {
// ViewData["EditError"] = "Could not save picture. " + retVal;
// ViewData["EditableProduct"] = station;
// }
// else
// {
// stat.PHOTO_PATH = stat.ID.ToString() + ".png";
// }
//}
//else
//{
// string retVal = DeleteStationPic(stat.ID);
// if (retVal.Length > 0)
// {
// ViewData["EditError"] = "Could not delete picture. " + retVal;
// ViewData["EditableProduct"] = station;
// }
// else
// {
// stat.PHOTO_PATH = "noimage.png";
// }
//}
stationService.UpdateStation(stat);
stationService.SaveStation();
UpdateTargetStation(station, companyId);
}
else
{
ViewData["EditError"] = "Name is already taken";
ViewData["EditableProduct"] = station;
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = companyId == 0 ? "Please select a company." : "Please, correct all errors.";
ViewData["EditableProduct"] = station;
}
return(PartialView("GridStationPartial", GetStationByCompanyId(companyId)));
}
public ActionResult SaveStation(StationGridModel station)
{
int companyId = !string.IsNullOrEmpty(Request.Params["companyId"]) ? int.Parse(Request.Params["companyId"]) : 0;
int stationId = !string.IsNullOrEmpty(Request.Params["stationId"]) ? int.Parse(Request.Params["stationId"]) : 0;
if (ModelState.IsValid && companyId > 0)
{
TBL_STATION stat = Mapper.Map <StationGridModel, TBL_STATION>(station);
try
{
stat.COMPANY_ID = companyId;
if (!stationService.IsStationExist(stat))
{
stat.CREATED_DATE = DateTime.Now;
stat.UPDATE_USER = User.Identity.GetUserId();
stationService.CreateStation(stat);
stationService.SaveStation();
//SaveStationUsers(stat.ID,station.USERS);
string photoFileName = string.Empty;
if (station.PHOTO != null && station.PHOTO.Length > 0)
{
string retVal = SaveStationPic(station.PHOTO, stat.ID);
if (retVal.Length > 0)
{
ViewData["EditError"] = "Could not save picture. " + retVal;
ViewData["EditableProduct"] = station;
photoFileName = "noimage.png";
}
else
{
photoFileName = stat.ID.ToString() + ".png";
}
}
else
{
photoFileName = "noimage.png";
}
stationService.UpdateStation(stat);
stationService.SaveStation();
stationId = stat.ID;
SaveTargetStation(station, stationId);
}
else
{
ViewData["EditableProduct"] = station;
ViewData["EditError"] = "Name is already taken";
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
ViewData["EditableProduct"] = station;
}
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)));
}
