public void DeleteUserAccess(SMIM_UserAccess_ST userAccess)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
dbUser.DeleteUserAccess(userAccess);
dbUser.Dispose();
dbUser.Abort();
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public void InsertUserAccess(SMIM_UserAccess_ST userAccess)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
int UserTypeId = 0;
bool specified = false;
dbUser.InsertUserAccess(userAccess, out UserTypeId, out specified);
dbUser.Dispose();
dbUser.Abort();
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public int InsertUserAccess(SMIM_UserAccess_ST UserAccess)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
int maxAccessId = 0;
if (db.SMIM_UserAccess_ST.Count() > 0)
{
maxAccessId = db.SMIM_UserAccess_ST.Select(x => x.CoAccId).Max();
}
maxAccessId = maxAccessId + 1;
UserAccess.CoAccId = maxAccessId;
db.SMIM_UserAccess_ST.Add(UserAccess);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
public void DeleteUserAccess(SMIM_UserAccess_ST UserAccess)
{
db.Configuration.ProxyCreationEnabled = false;
db.Entry(UserAccess).State = EntityState.Deleted;
db.SaveChanges();
}
