public ActionResult KendoSave([DataSourceRequest] DataSourceRequest request, GetPreCommisioningDetailData_Result obj)
{
if (obj == null || !ModelState.IsValid)
{
return(Json(new[] { obj }.ToDataSourceResult(request, ModelState)));
}
string message = string.Empty;
tblPreCommissioningDetail model = new tblPreCommissioningDetail();
model.PCDetailId = obj.PCDetailId;
model.PCMachineId = obj.PCMachineId;
model.PCAccesseriesId = obj.PCAccesseriesId;
model.PCMachineIdList = obj.PCMachineIdList;
model.PCAccessoryIdList = obj.PCAccessoryIdList;
model.PreCommisoningDate = obj.PreCommisoningDate;
model.ServiceEngineerId = obj.ServiceEngineerId;
model.PrecommisioningRemark = obj.PrecommisioningRemark;
model.PreCommissionId = obj.PreCommissionId;
if (model.PCDetailId > 0)
{
model.ModifiedBy = SessionHelper.UserId;
model.ModifiedDate = DateTime.Now;
message = _dbRepository.Update(model);
}
else
{
model.CreatedBy = SessionHelper.UserId;
model.CreatedDate = DateTime.Now;
if (model.PCAccessoryIdList != null && model.PCAccessoryIdList.Count > 0)
{
foreach (int id in model.PCAccessoryIdList)
{
tblPreCommissioningDetail oldAccessory = _dbRepository.GetEntities().Where(m => m.PreCommissionId == model.PreCommissionId && m.PCAccesseriesId == id && m.IsLatest == true).FirstOrDefault();
if (oldAccessory != null)
{
oldAccessory.IsLatest = false;
_dbRepository.Update(oldAccessory);
}
model.PCMachineId = null;
model.PCAccesseriesId = id;
model.IsLatest = true;
message = _dbRepository.Insert(model);
}
}
if (model.PCMachineIdList != null && model.PCMachineIdList.Count > 0)
{
foreach (int id in model.PCMachineIdList)
{
tblPreCommissioningDetail oldMachine = _dbRepository.GetEntities().Where(m => m.PreCommissionId == model.PreCommissionId && m.PCMachineId == id && m.IsLatest == true).FirstOrDefault();
if (oldMachine != null)
{
oldMachine.IsLatest = false;
_dbRepository.Update(oldMachine);
}
model.PCAccesseriesId = null;
model.PCMachineId = id;
model.IsLatest = true;
message = _dbRepository.Insert(model);
}
}
}
ModelState.Clear();
if (!string.IsNullOrEmpty(message))
{
ModelState.AddModelError("PreCommisoningDate", message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult KendoDestroy([DataSourceRequest] DataSourceRequest request, GetPreCommisioningDetailData_Result model)
{
string deleteMessage = _dbRepository.Delete(model.PCDetailId);
ModelState.Clear();
if (!string.IsNullOrEmpty(deleteMessage))
{
ModelState.AddModelError(deleteMessage, deleteMessage);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
