internal static AssignMaterialToRoutingFileModel Mapping(USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE o) { try { if (o != null) { return(new AssignMaterialToRoutingFileModel() { AssignMaterialToRoutingFileID = o.AssignMaterialToRoutingFileID, RecObjectName = o.RecObjectName, UserSAP = o.UserSAP, AssignMaterialToRoutingFilePath = o.AssignMaterialToRoutingFilePath, AssignMaterialToRoutingFileVersion = o.AssignMaterialToRoutingFileVersion, AssignMaterialToRoutingFileStatus = o.AssignMaterialToRoutingFileStatus, FileStatus = FileStatusDAL.GetFileStatus(o.AssignMaterialToRoutingFileStatus), ProductsTypeID = o.ProductsTypeID, IsActive = o.IsActive == 1, CreatedBy = o.CreatedBy, CreatedDate = o.CreatedDate, UpdatedBy = o.UpdatedBy, UpdatedDate = o.UpdatedDate }); } return(null); } catch (Exception ex) { throw ex; } }
public static ResponseModel UpdateStatusAssignMaterialToRoutingFile(int AssignMaterialToRoutingFileID, int AssignMaterialToRoutingFileStatus) { string action = "UpdateStatusAssignMaterialToRoutingFile(AssignMaterialToRoutingFileID, AssignMaterialToRoutingFileStatus)"; try { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE _obj = context.USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE.FirstOrDefault(o => o.AssignMaterialToRoutingFileID == AssignMaterialToRoutingFileID); if (_obj != null) { _obj.AssignMaterialToRoutingFileStatus = AssignMaterialToRoutingFileStatus; context.SaveChanges(); return(new ResponseModel() { Source = SOURCE, Action = action, Status = true, Message = "Success" }); } return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = "AssignMaterialToRoutingFileID Not Exist" }); } } catch (DbEntityValidationException ex) { return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = ex.Message, StackTrace = ex.StackTrace }); } catch (Exception ex) { return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = ex.Message, StackTrace = ex.StackTrace }); } }
public static AssignMaterialToRoutingFileModel GetAssignMaterialToRoutingFile(int assignMaterialToRoutingFileID) { ACTION = "GetAssignMaterialToRoutingFile(assignMaterialToRoutingFileID)"; try { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE obj = context.USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE.Where(o => o.AssignMaterialToRoutingFileID == assignMaterialToRoutingFileID).FirstOrDefault(); AssignMaterialToRoutingFileModel m = Mapping(obj); return(m); } } catch (Exception ex) { throw ex; } }
public static ResponseModel AddAssignMaterialToRoutingFile(AssignMaterialToRoutingFileModel m, ref int _newID) { string action = "AddAssignMaterialToRoutingFile(AssignMaterialToRoutingFileModel, out _newID)"; _newID = 0; try { if (m != null) { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE _obj = Mapping(m); context.USR_TMMA_ASSIGN_MATERIAL_TO_ROUTING_FILE.Add(_obj); if (context.SaveChanges() > 0) { _newID = _obj.AssignMaterialToRoutingFileID; return(new ResponseModel() { Source = SOURCE, Action = action, Status = true, Message = "Success" }); } return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = "Fail" }); } } return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = "Null" }); } catch (DbEntityValidationException ex) { return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = ex.Message, StackTrace = ex.StackTrace }); } catch (Exception ex) { return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = ex.Message, StackTrace = ex.StackTrace }); } }