public void DeleteUserType(SMIM_UserType_ST userType) { try { db.Entry(userType).State = EntityState.Deleted; db.SaveChanges(); } catch (Exception ex) { throw ex; //return 0; } }
public void UpdateUserType(SMIM_UserType_ST userType) { try { db.Configuration.ProxyCreationEnabled = false; db.Entry(userType).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { throw ex; //return 0; } }
public int DeleteUserType(SMIM_UserType_ST userType) { try { dbUser.Timeout = System.Threading.Timeout.Infinite; int UserTypeId = 0; bool specified = false; dbUser.DeleteUserType(userType); dbUser.Dispose(); dbUser.Abort(); return(userType.UserTypeId); } catch (Exception ex) { dbUser.Dispose(); dbUser.Abort(); throw ex; } }
public ActionResult UserType(SMIM_UserType_ST userType) { try { string strMessage = ""; bool _success = false; if (userType.UserTypeId > 0) { int maxValue = dbUser.UpdateUserType(userType); if (maxValue > 0) { strMessage = "Record successfully updated."; _success = true; } else { strMessage = "Application server error."; } } else { int maxValue = dbUser.InsertUserType(userType); userType.UserTypeId = maxValue; if (maxValue > 0) { strMessage = "Record successfully saved."; _success = true; } else { strMessage = "Application server error."; } } return(Json(new { success = _success, response = strMessage })); } catch (Exception ex) { Log.LogWrite(ex.Message, "User Type Insert/Edit", ex); return(Json(new { success = false, response = ex.Message.ToString() })); } }
public int InsertUserType(SMIM_UserType_ST userType) { try { int maxUserTypeId = 0; if (db.SMIM_UserType_ST.Count() > 0) { maxUserTypeId = db.SMIM_UserType_ST.Select(x => x.UserTypeId).Max(); } maxUserTypeId = maxUserTypeId + 1; userType.UserTypeId = maxUserTypeId; db.SMIM_UserType_ST.Add(userType); db.SaveChanges(); return(maxUserTypeId); } catch (Exception ex) { throw ex; //return 0; } }