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;
}
}
