public static ResponseModel UpdateStatusBOMFile(int BOMFileID, int BOMFileStatus) { string action = "UpdateStatusBOMFile(BOMFileModel)"; try { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_BOM_FILE _obj = context.USR_TMMA_BOM_FILE.FirstOrDefault(o => o.BOMFileID == BOMFileID); if (_obj != null) { _obj.BOMFileStatus = BOMFileStatus; context.SaveChanges(); return(new ResponseModel() { Source = SOURCE, Action = action, Status = true, Message = "Success" }); } return(new ResponseModel() { Source = SOURCE, Action = action, Status = false, Message = "BOMFileID 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 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 ResponseModel AddBOMFile(BOMFileModel m, ref int _newID) { string action = "AddBOMFile(BOMFileModel, out _newID)"; _newID = 0; try { if (m != null) { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_BOM_FILE _obj = Mapping(m); context.USR_TMMA_BOM_FILE.Add(_obj); if (context.SaveChanges() > 0) { _newID = _obj.BOMFileID; 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 }); } }
public static ResponseModel AddUser(UserModel user) { string action = "AddUser(UserModel)"; try { if (user != null) { using (UTMMABCDBEntities context = new UTMMABCDBEntities()) { USR_TMMA_USER _obj = Mapping(user); context.USR_TMMA_USER.Add(_obj); if (context.SaveChanges() > 0) { 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 }); } }