public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster) { try { ICKD iDataAccessSelect = new WCMS_DAL_CKD(); return(iDataAccessSelect.GetCkdMmiMasterInfo(tblCkdMmiMaster)); } catch (Exception ex) { throw ex; } }
public Result UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent) { try { return(_ckdManage.UpdateCkdMmiInfo(mmItabltestComponent)); } catch (Exception ex) { return(new Result { IsSuccess = false, Message = ex.Message }); } }
public Result InsertCkdMmiComponentInfo(tblCkdMmiMaster mmItabltestComponent) { try { //tblTest mmItabltestComponent = null; return(_ckdManage.InsertCkdMmiComponentInfo(mmItabltestComponent)); } catch (Exception ex) { return(new Result { IsSuccess = false, Message = ex.Message }); } }
//For MMI public bool InsertCkdMmiComponentInfo(tblCkdMmiMaster mmItabltestComponent) { try { _entity.tblCkdMmiMaster.Add(mmItabltestComponent); _entity.SaveChanges(); return(true); } catch (Exception exception) { throw exception; } }
public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster) { List <tblCkdMmiMaster> mmiMasterList; try { mmiMasterList = _ckdManage.GetCkdMmiMasterInfo(tblCkdMmiMaster); } catch (Exception ex) { throw ex; } return(mmiMasterList); }
public List <tblCkdMmiMaster> GetCkdMmiMasterInfo(tblCkdMmiMaster tblCkdMmiMaster) { List <tblCkdMmiMaster> mmiList; try { mmiList = _entity.tblCkdMmiMaster .WhereIf(tblCkdMmiMaster.ProjectId != null, x => x.ProjectId == tblCkdMmiMaster.ProjectId) .WhereIf(tblCkdMmiMaster.BarCode != null, x => x.BarCode == tblCkdMmiMaster.BarCode) .AsNoTracking().ToList(); } catch (Exception ex) { throw ex; } return(mmiList); }
public Result UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent) { try { using ( var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions)) { var result = new Result(); result.IsSuccess = _ickd.UpdateCkdMmiInfo(mmItabltestComponent); if (result.IsSuccess) { transaction.Complete(); } return(result); } } catch (Exception ex) { throw ex; } }
public bool UpdateCkdMmiInfo(tblCkdMmiMaster mmItabltestComponent) { _entity.Configuration.LazyLoadingEnabled = false; var mmiMaster = _entity.tblCkdMmiMaster.FirstOrDefault(x => x.BarCode == mmItabltestComponent.BarCode); if (mmiMaster != null) { if (mmItabltestComponent.Passed != null) { mmiMaster.Passed = mmItabltestComponent.Passed; } if (mmItabltestComponent.UpdatedBy != null) { mmiMaster.UpdatedBy = mmItabltestComponent.UpdatedBy; } if (mmItabltestComponent.UpdatedDate != null) { mmiMaster.UpdatedDate = mmItabltestComponent.UpdatedDate; } _entity.Entry(mmiMaster).State = EntityState.Modified; _entity.SaveChanges(); } else { return(false); } return(true); }
public JsonResult InsertCkdMmiStationInformation(tblCkdMmiMaster mmItabltestComponent, List <tblCkdRework> reworkList) { WCMSEntities entities = new WCMSEntities(); var startDate = DateTime.Today; var endDate = startDate.AddDays(1).AddTicks(-1); var userId = (long)_dictionary[2].Id; var projectId = (long)_dictionary[3].Id; long lineId = (long)_dictionary[4].Id; var result = new Result(); try { var isBarCodeExists = _ckdService.GetCkdMmiMasterInfo(new tblCkdMmiMaster { BarCode = mmItabltestComponent.BarCode }) .Any(); if (isBarCodeExists) { mmItabltestComponent.AddedBy = userId; mmItabltestComponent.AddedDate = DateTime.Now; mmItabltestComponent.UpdatedBy = userId; mmItabltestComponent.UpdatedDate = DateTime.Now; result = _ckdService.UpdateCkdMmiInfo(mmItabltestComponent); if (result.IsSuccess == true && mmItabltestComponent.Passed.ToUpper() == "N") { var Reresult = new Result(); var rework = new tblCkdRework(); foreach (tblCkdRework item in reworkList) { rework.LineId = lineId; rework.ProjectId = userId; //projectId; rework.BarCode = item.BarCode; rework.Issues = item.Issues; rework.FailedStation = item.FailedStation; rework.Type = item.Type; rework.Model = item.Model; rework.LotNumber = item.LotNumber; rework.Supplier = item.Supplier; rework.Code = item.Code; rework.Status = "P"; rework.AddedBy = userId; rework.AddedDate = DateTime.Now; Reresult = _ckdService.InsertCkdRework(rework); } } } else { mmItabltestComponent.LineId = lineId; mmItabltestComponent.AddedBy = userId; mmItabltestComponent.AddedDate = DateTime.Now; mmItabltestComponent.UpdatedBy = userId; mmItabltestComponent.UpdatedDate = DateTime.Now; result = _ckdService.InsertCkdMmiComponentInfo(mmItabltestComponent); if (result.IsSuccess == true && mmItabltestComponent.Passed.ToUpper() == "N") { var Reresult = new Result(); tblCkdRework rework = new tblCkdRework(); foreach (tblCkdRework item in reworkList) { rework.LineId = lineId; rework.ProjectId = userId; //projectId; rework.BarCode = item.BarCode; rework.Issues = item.Issues; rework.FailedStation = item.FailedStation; rework.Type = item.Type; rework.Model = item.Model; rework.LotNumber = item.LotNumber; rework.Supplier = item.Supplier; rework.Code = item.Code; rework.Status = "P"; rework.AddedBy = userId; rework.AddedDate = DateTime.Now; Reresult = _ckdService.InsertCkdRework(rework); } } } } catch (Exception ex) { //throw ex; result.Message = ex.ToString(); } return(Json(result)); }