public bool UpdateLoginUser(tblLogin login, string newPassword) { _entity.Configuration.LazyLoadingEnabled = false; tblLogin loginList = _entity.tblLogin.FirstOrDefault(x => x.Id == login.Id && x.Password == login.Password); //FirstOrDefault(x => x.Id == login.Id && x.Password == login.Password); if (loginList != null) { if (login.Password != "") { loginList.Password = newPassword; } _entity.Entry(loginList).State = EntityState.Modified; _entity.SaveChanges(); } else { return(false); } return(true); }
public bool UpdateProductionLine(tblProductionLine productionLine) { _entity.Configuration.LazyLoadingEnabled = false; tblProductionLine list = _entity.tblProductionLine.FirstOrDefault(x => x.LineId == productionLine.LineId); if (list != null) { if (productionLine.LineName != "") { list.LineName = productionLine.LineName; } _entity.Entry(list).State = EntityState.Modified; _entity.SaveChanges(); } else { return(false); } return(true); }
public bool UpdateBatteryLine(tblBatteryComponentInfo productionLine) { _entity.Configuration.LazyLoadingEnabled = false; tblBatteryComponentInfo list = _entity.tblBatteryComponentInfo.FirstOrDefault(x => x.Id == productionLine.Id); if (list != null) { if (productionLine.ProjectName != "") { list.ProjectName = productionLine.ProjectName; } list.PcbPassed = productionLine.PcbPassed; list.PcbIssued = productionLine.PcbIssued; list.PcbFailed = productionLine.PcbFailed; list.CellIssued = productionLine.CellIssued; list.CellPassed = productionLine.CellPassed; list.CellFailed = productionLine.CellFailed; _entity.Entry(list).State = EntityState.Modified; _entity.SaveChanges(); } else { return(false); } return(true); }
public bool UpdateGlueWorkingModels(tblLcdGlueWorkingModels workingModel) { try { _entity.Configuration.LazyLoadingEnabled = false; var startDate = DateTime.Today; var endDate = startDate.AddDays(1).AddTicks(-1); //if( workingModel.Id!=null) var wModel = _entity.tblLcdGlueWorkingModels.Where(x => x.AddedBy == workingModel.AddedBy && (x.AddedDate >= startDate && x.AddedDate <= endDate)).ToList(); if (wModel.Count > 0) { foreach (var items in wModel) { var workModels = _entity.tblLcdGlueWorkingModels.FirstOrDefault(x => x.AddedBy == items.AddedBy && (x.AddedDate >= startDate && x.AddedDate <= endDate) && x.ProjectName == items.ProjectName && x.ProjectId == items.ProjectId); if (workModels == null) { continue; } workModels.CurentlyRunning = workModels.Id == workingModel.Id ? "Y" : "N"; _entity.Entry(workModels).State = EntityState.Modified; _entity.SaveChanges(); } return(true); } else { return(false); } } 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 bool InsertInventoryOutInfo(List <tblInventoryForServiceItem> im) { try { foreach (var s in im) { var list = new tblInventoryForServiceItem(); list = _entities.tblInventoryForServiceItems.FirstOrDefault( x => x.IMEI1 == s.IMEI1 || x.IMEI2 == s.IMEI1); if (list != null) { if (s.IsInventoryOut == null) { list.IsInventoryOut = true; } if (s.IsInventoryOutDate == null) { list.IsInventoryOutDate = DateTime.Now; } _entities.Entry(list).State = EntityState.Modified; _entities.SaveChanges(); } else { return(false); } } } catch (Exception exception) { throw exception; } return(true); }
public bool UpdateQcStatusHistory(List <ProductionMaster> productionList) { foreach (var item in productionList) { _entity.Configuration.LazyLoadingEnabled = false; ProductionMaster productionMaster = _entity.ProductionMaster.FirstOrDefault(x => x.MobileCode == item.MobileCode); if (productionMaster != null) { if (item.Passed != null) { productionMaster.Passed = item.Passed; } if (item.QcStation != null) { productionMaster.QcStation = item.QcStation; } if (!string.IsNullOrEmpty(item.Imei1)) { productionMaster.Imei1 = item.Imei1; } if (!string.IsNullOrEmpty(item.Imei2)) { productionMaster.Imei2 = item.Imei2; } if (item.AddedBy != null) { productionMaster.AddedBy = item.AddedBy; } if (item.AddedDate != null) { productionMaster.AddedDate = item.AddedDate; } if (item.UpdatedBy != null) { productionMaster.UpdatedBy = item.UpdatedBy; } if (item.UpdatedDate != null) { productionMaster.UpdatedDate = item.UpdatedDate; } if (item.FinallyPassed != null) { productionMaster.FinallyPassed = item.FinallyPassed; } if (item.FinallyPassedBy != null) { productionMaster.FinallyPassedBy = item.FinallyPassedBy; } if (item.FinallyPassedTime != null) { productionMaster.FinallyPassedTime = item.FinallyPassedTime; } if (item.FunctionalBy != null) { productionMaster.FunctionalBy = item.FunctionalBy; } if (item.FunctionalAD != null) { productionMaster.FunctionalAD = item.FunctionalAD; } if (item.AestheticBy != null) { productionMaster.AestheticBy = item.AestheticBy; } if (item.AestheticAD != null) { productionMaster.AestheticAD = item.AestheticAD; } if (item.AgingBy != null) { productionMaster.AgingBy = item.AgingBy; } if (item.AgingAD != null) { productionMaster.AgingAD = item.AgingAD; } if (item.PackagingBy != null) { productionMaster.PackagingBy = item.PackagingBy; } if (item.PackagingAD != null) { productionMaster.PackagingAD = item.PackagingAD; } if (item.PackagingAstheticBy != null) { productionMaster.PackagingAstheticBy = item.PackagingAstheticBy; } if (item.PackagingAstheticAD != null) { productionMaster.PackagingAstheticAD = item.PackagingAstheticAD; } if (item.PackagingOQCBy != null) { productionMaster.PackagingOQCBy = item.PackagingOQCBy; } if (item.PackagingOQCAD != null) { productionMaster.PackagingOQCAD = item.PackagingOQCAD; } if (item.PackagingLineId != null) { productionMaster.PackagingLineId = item.PackagingLineId; } if (item.OQCBatchNumber != null) { productionMaster.OQCBatchNumber = item.OQCBatchNumber; } _entity.Entry(productionMaster).State = EntityState.Modified; _entity.SaveChanges(); } else { return(false); } } return(true); }