public int DeleteUserTypeAccess(SMIM_UserTypeAccess_ST UserTypeAccess)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
db.Entry(UserTypeAccess).State = EntityState.Deleted;
db.SaveChanges();
return(Convert.ToInt32(UserTypeAccess.UserTypeId));
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
public void DeleteUserTypeAccess(SMIM_UserTypeAccess_ST uTypeAccess)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
int UserTypeId = 0;
bool specified = false;
dbUser.DeleteUserTypeAccess(uTypeAccess, out UserTypeId, out specified);
dbUser.Dispose();
dbUser.Abort();
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public ActionResult AssignRoles(int UserType, string Allow, Guid?[] RoleId, string[] Description, int Count)
{
try
{
//bool result = false;
string strMessage = "";
for (int i = 0; i < Count; i++)
{
SMIM_UserTypeAccess_ST tb_access = new SMIM_UserTypeAccess_ST();
if (Allow == "Y")
{
tb_access.Allow = "Y";
tb_access.UserTypeId = UserType;
tb_access.UserTypeIdSpecified = true;
tb_access.AccessType = "U";
tb_access.Description = Description[i];
tb_access.RoleId = RoleId[i].ToString();
dbUser.InsertUserTypeAccess(tb_access);
}
else
{
tb_access = dbUser.getAccessByUserTypeAndRoleId(UserType, RoleId[i].Value).FirstOrDefault();
if (tb_access != null)
{
dbUser.DeleteUserTypeAccess(tb_access);
}
}
}
strMessage = "Roles succesfully assigned.";
//result = true;
return(Json(new { success = true, response = strMessage }));
}
catch (Exception ex)
{
return(Json(new { success = false, response = ex.Message.ToString() }));
}
}
public int InsertUserTypeAccess(SMIM_UserTypeAccess_ST UserTypeAccess)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
int maxAccessId = 0;
if (db.SMIM_UserTypeAccess_ST.Count() > 0)
{
maxAccessId = db.SMIM_UserTypeAccess_ST.Select(x => x.AccessId).Max();
}
maxAccessId = maxAccessId + 1;
UserTypeAccess.AccessId = maxAccessId;
db.SMIM_UserTypeAccess_ST.Add(UserTypeAccess);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
