public bool UpdateGlueStation(tblGlueMaster tblglueMaster) { try { var masterData = _entity.tblGlueMaster.FirstOrDefault(x => x.Code == tblglueMaster.Code); if (masterData != null) { if (!string.IsNullOrEmpty(tblglueMaster.Code)) { masterData.Passed = tblglueMaster.Passed; } if (tblglueMaster.UpdatedBy != null) { masterData.UpdatedBy = tblglueMaster.UpdatedBy; } if (tblglueMaster.UpdatedDate != null) { masterData.UpdatedDate = tblglueMaster.UpdatedDate; } _entity.Entry(masterData).State = EntityState.Modified; _entity.SaveChanges(); } } catch (Exception exception) { throw exception; } return(true); }
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster) { try { return(_iLcdGlueStation.GetGlueStationInfo(tblGlueMaster)); } catch (Exception ex) { throw ex; } }
public Result UpdateGlueStation(tblGlueMaster tblglueMaster) { try { return(_lcdGlueStationManager.UpdateGlueStation(tblglueMaster)); } catch (Exception ex) { return(new Result { IsSuccess = false, Message = ex.Message }); } }
public bool InsertGlueStation(tblGlueMaster tblGlueMaster) { try { _entity.tblGlueMaster.Add(tblGlueMaster); _entity.SaveChanges(); } catch (Exception ex) { throw ex; } return(true); }
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster) { var tplcd = new tblGlueMaster(); try { tplcd = _lcdGlueStationManager.GetGlueStationInfo(tblGlueMaster); } catch (Exception ex) { } return(tplcd); }
public tblGlueMaster GetGlueStationInfo(tblGlueMaster tblGlueMaster) { tblGlueMaster master; try { master = _entity.tblGlueMaster.WhereIf(tblGlueMaster.Code != null, x => x.Code == tblGlueMaster.Code) .WhereIf(tblGlueMaster.Passed != null, x => x.Passed == tblGlueMaster.Passed) .WhereIf(tblGlueMaster.AddedBy != null, x => x.AddedBy == tblGlueMaster.AddedBy) .FirstOrDefault(); } catch (Exception ex) { throw ex; } return(master); }
public Result UpdateGlueStation(tblGlueMaster tblglueMaster) { try { using ( var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions)) { var result = new Result { IsSuccess = _iLcdGlueStation.UpdateGlueStation(tblglueMaster) }; if (result.IsSuccess) { transaction.Complete(); } return(result); } } catch (Exception ex) { throw ex; } }
public JsonResult InsertGlueStation(tblGlueMaster glueMaster, List <tblLcdGlueRework> reworkList) { var userId = (long)_dictionary[2].Id; var projectId = (long)_dictionary[3].Id; var result = new Result(); try { var isExists = _lcdGlueStationService.GetGlueStationInfo(new tblGlueMaster { Code = glueMaster.Code }); var workingProject = _lcdGlueStationService.LoadWorkingModelData() .FirstOrDefault(a => a.AddedBy == userId && a.CurentlyRunning == "Y"); if (isExists == null) { if (workingProject != null) { var tblGlueMaster = new tblGlueMaster(); tblGlueMaster.Code = glueMaster.Code; tblGlueMaster.ProjectId = workingProject.ProjectId; tblGlueMaster.ProjectName = workingProject.ProjectName; tblGlueMaster.Passed = glueMaster.Passed.ToUpper(); tblGlueMaster.AddedBy = userId; tblGlueMaster.AddedDate = DateTime.Now; result = _lcdGlueStationService.InsertGlueStation(tblGlueMaster); if (result.IsSuccess == true && glueMaster.Passed.ToUpper() == "N") { var Reresult = new Result(); var rework = new tblLcdGlueRework(); foreach (tblLcdGlueRework item in reworkList) { //rework.LineId = lineId; rework.ProjectId = workingProject.ProjectId; rework.ProjectName = workingProject.ProjectName; rework.Code = glueMaster.Code; rework.Issue = item.Issue; rework.FailedFrom = "GLUE"; rework.Status = "P"; rework.AddedBy = userId; rework.AddedDate = DateTime.Now; Reresult = _lcdGlueStationService.InsertTpLcdReworkStation(rework); } } } else { result.Message = "No Project Or Model Found"; } } else { if (workingProject != null) { var tblglueMaster = new tblGlueMaster(); tblglueMaster.Code = glueMaster.Code; //tblTpLcdMaster.ProjectId = workingProject.ProjectId; //tblTpLcdMaster.ProjectName = workingProject.ProjectName; tblglueMaster.Passed = glueMaster.Passed.ToUpper(); tblglueMaster.UpdatedBy = userId; tblglueMaster.UpdatedDate = DateTime.Now; result = _lcdGlueStationService.UpdateGlueStation(tblglueMaster); if (result.IsSuccess == true && glueMaster.Passed.ToUpper() == "N") { var Reresult = new Result(); var rework = new tblLcdGlueRework(); foreach (tblLcdGlueRework item in reworkList) { //rework.LineId = lineId; rework.ProjectId = isExists.ProjectId; rework.ProjectName = workingProject.ProjectName; rework.Code = glueMaster.Code; rework.Issue = item.Issue; rework.FailedFrom = "GLUE"; rework.Status = "P"; rework.AddedBy = userId; rework.AddedDate = DateTime.Now; Reresult = _lcdGlueStationService.InsertTpLcdReworkStation(rework); } } } else { result.Message = "No Project Or Model Found"; } } } catch (Exception) { throw; } return(Json(result)); }