public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents) { try { ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting(); return(iDataAccessSelect.GetPCBInfo(tblDailyIssuedComponents)); } catch (Exception ex) { throw ex; } }
public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents) { var list = new List <tblDailyIssuedComponents>(); try { list = _CommonManager.GetPCBInfo(tblDailyIssuedComponents); } catch (Exception ex) { } return(list); }
public Result InsertIssuedComponents(tblDailyIssuedComponents issuedComponents) { try { return(_CommonManager.InsertIssuedComponents(issuedComponents)); } catch (Exception ex) { return(new Result { IsSuccess = false, Message = ex.Message }); } }
public bool InsertIssuedComponents(tblDailyIssuedComponents issuedComponents) { try { _entity.tblDailyIssuedComponents.Add(issuedComponents); _entity.SaveChanges(); } catch (Exception ex) { throw ex; } return(true); }
public List <tblDailyIssuedComponents> GetPCBInfo(tblDailyIssuedComponents tblDailyIssuedComponents) { List <tblDailyIssuedComponents> list; try { list = _wcmsEntities.tblDailyIssuedComponents .WhereIf(tblDailyIssuedComponents.ComponentCode != null, x => x.ComponentCode == tblDailyIssuedComponents.ComponentCode) .WhereIf(tblDailyIssuedComponents.ProjectId != null, x => x.ProjectId == tblDailyIssuedComponents.ProjectId) .AsNoTracking().ToList(); } catch (Exception) { throw; } return(list); }
public Result InsertIssuedComponents(tblDailyIssuedComponents issuedComponents) { try { IInsertingSetupCommon _IDataAccessInsert = new WCMS_Common_Inserting(); using (var transaction = new TransactionScope(TransactionScopeOption.Required, ApplicationState.TransactionOptions)) { var result = new Result(); issuedComponents.AddedDate = DateTime.Now; result.IsSuccess = _IDataAccessInsert.InsertIssuedComponents(issuedComponents); if (result.IsSuccess) { transaction.Complete(); } return(result); } } catch (Exception ex) { throw ex; } }
public JsonResult InsertIssuedComponents(tblDailyIssuedComponents issuedComponents) { long userId = (long)IDictionary[2].Id; long projectId = (long)IDictionary[3].Id; long lineId = (long)IDictionary[4].Id; DateTime startDate = DateTime.Today; DateTime endDate = startDate.AddDays(1).AddTicks(-1); var result = new Result(); if (userId != 0 && lineId != 0 && projectId != 0)//&& lineId != 0 && projectId != 0 { try { var isComponentExists = _CommonService.GetPCBInfo(new tblDailyIssuedComponents() { ComponentCode = (issuedComponents.ComponentCode).Trim() }).FirstOrDefault(); if (isComponentExists == null) { issuedComponents.ProjectName = _CommonService.GetAssemblineInfo(new tblAssemblyLineSetup() { ProjectId = Convert.ToInt32(projectId) }).Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).Select(x => x.ProjectName).FirstOrDefault(); issuedComponents.ComponentName = issuedComponents.ComponentName; issuedComponents.LineId = lineId; issuedComponents.ComponentCode = issuedComponents.ComponentCode.Trim(); issuedComponents.ProjectId = projectId; issuedComponents.AddedBy = userId; result = _CommonService.InsertIssuedComponents(issuedComponents); if (result.IsSuccess) { // var objstate = componentsCount.Select(x => new { pendingListCount = componentsCount.Count,message="Added Successfully" }).ToList(); return(Json(result)); } } else { result.Message = "Duplicate PCB Code !"; return(Json(result)); } } catch (Exception exception) { throw; } } else { return(Json(new Result { Id = "0" })); // return Json(new Result {Message = "Error Occured Please Logout and Login Again !"}); } return(Json(result)); }