public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew) { try { ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting(); return(iDataAccessSelect.GetScrewStationInfo(tblScrew)); } catch (Exception ex) { throw ex; } }
public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew) { var list = new List <tblScrew>(); try { list = _CommonManager.GetScrewStationInfo(tblScrew); } catch (Exception ex) { } return(list); }
public Result InsertScrewStationInfo(tblScrew screw) { try { return(_CommonManager.InsertScrewStationInfo(screw)); } catch (Exception ex) { return(new Result { IsSuccess = false, Message = ex.Message }); } }
public bool InsertScrewStationInfo(tblScrew screw) { try { _entity.tblScrew.Add(screw); _entity.SaveChanges(); } catch (Exception ex) { throw ex; } return(true); }
public List <tblScrew> GetScrewStationInfo(tblScrew tblScrew) { List <tblScrew> list; try { list = _wcmsEntities.tblScrew .WhereIf(tblScrew.MobileCode != null, x => x.MobileCode == tblScrew.MobileCode) .WhereIf(tblScrew.ProjectId != null, x => x.ProjectId == tblScrew.ProjectId) .AsNoTracking().ToList(); } catch (Exception) { throw; } return(list); }
public Result InsertScrewStationInfo(tblScrew screw) { try { IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting(); using (var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions)) { var result = new Result(); result.IsSuccess = _IDataAccessInsert.InsertScrewStationInfo(screw); if (result.IsSuccess) { transaction.Complete(); } return(result); } } catch (Exception ex) { throw ex; } }
public JsonResult InsertScrewStationInfo(tblScrew screw) { var result = new Result(); var startDate = DateTime.Today; var endDate = startDate.AddDays(1).AddTicks(-1); long userId = (long)IDictionary[2].Id; long projectId = (long)IDictionary[3].Id; long lineId = (long)IDictionary[4].Id; if (userId != 0 && lineId != 0)//&& lineId!=0 { var pcbStation = _CommonService.GetPCBInfo(new tblDailyIssuedComponents() { ComponentCode = screw.MobileCode.Trim() }).FirstOrDefault(); var isExists = _CommonService.GetScrewStationInfo(new tblScrew() { MobileCode = screw.MobileCode.Trim() }).FirstOrDefault(); if (isExists == null) { if (pcbStation != null) { screw.LineId = lineId; screw.ProjectName = pcbStation.ProjectName; // _CommonService.GetAssemblineInfo(new tblAssemblyLineSetup() { ProjectId = (int?)pcbStation.ProjectId }).Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).Select(x => x.ProjectName).FirstOrDefault(); screw.MobileCode = screw.MobileCode.Trim(); screw.ProjectId = pcbStation.ProjectId; //projectId; screw.AddedBy = userId; screw.AddedDate = DateTime.Now; result = _CommonService.InsertScrewStationInfo(screw); if (result.IsSuccess) { return(Json(result)); } } else { result.Message = "Not Scanned At PCB Station!!"; return(Json(result)); } } else { result.Message = "Duplicate Bar Code Number!!"; return(Json(result)); } } else { return(Json(new Result { Id = "0" })); } return(Json(result)); }