public object addUserTypeAccess(int accessid, int usertypeid)
{
db.Configuration.ProxyCreationEnabled = false;
dynamic toReturn = new ExpandoObject();
try
{
if (accessid == 0)
{
return(toReturn.Message = "Add Unsuccesful: Access Not Selected");
}
if (usertypeid == 0)
{
return(toReturn.Message = "Add Unsuccesful: User Type Not Selected");
}
Access access = db.Accesses.Where(x => x.AccessID == accessid).FirstOrDefault();
User_Type user_Type = db.User_Type.Where(x => x.UserTypeID == usertypeid).FirstOrDefault();
if (access != null && user_Type != null)
{
User_Type_Access newaccess = new User_Type_Access();
newaccess.UserTypeID = user_Type.UserTypeID;
newaccess.AccessID = access.AccessID;
newaccess.AccessGranted = DateTime.Now;
newaccess.Access = access;
newaccess.User_Type = user_Type;
User_Type_Access found = db.User_Type_Access.Where(x => x.AccessID == newaccess.AccessID && x.UserTypeID == newaccess.AccessID).FirstOrDefault();
if (found == null)
{
db.User_Type_Access.Add(newaccess);
db.SaveChanges();
toReturn.Message = "User Type Access Added";
}
else
{
toReturn.Message = "User Type Access Is Already Set";
}
}
}
catch
{
toReturn.Error = "Adding Access Unsuccesful ";
}
return(toReturn);
}
public object setUserTypeAccess(List <User_Type_Access> user_type_access)
{
db.Configuration.ProxyCreationEnabled = false;
dynamic toReturn = new ExpandoObject();
try
{
foreach (User_Type_Access Uaccess in user_type_access)
{
Access access = db.Accesses.Where(x => x.AccessID == Uaccess.AccessID).FirstOrDefault();
User_Type user_Type = db.User_Type.Where(x => x.UserTypeID == Uaccess.UserTypeID).FirstOrDefault();
if (access != null && user_Type != null)
{
User_Type_Access newaccess = new User_Type_Access();
newaccess.UserTypeID = user_Type.UserTypeID;
newaccess.AccessID = access.AccessID;
newaccess.AccessGranted = DateTime.Now;
newaccess.Access = access;
newaccess.User_Type = user_Type;
User_Type_Access found = db.User_Type_Access.Where(x => x.AccessID == newaccess.AccessID && x.UserTypeID == newaccess.AccessID).FirstOrDefault();
if (found == null)
{
db.User_Type_Access.Add(newaccess);
db.SaveChanges();
}
}
}
toReturn.Message = "User Type Access Updated";
}
catch
{
toReturn.Error = "Updating UserType Access Failed";
}
return(toReturn);
}
public object removeUserTypeAccess(int accessid, int usertypeid)
{
db.Configuration.ProxyCreationEnabled = false;
dynamic toReturn = new ExpandoObject();
try
{
if (accessid == 0)
{
return(toReturn.Message = "Remove Unsuccesful: Access Not Selected");
}
if (usertypeid == 0)
{
return(toReturn.Message = "Remove Unsuccesful: User Type Not Selected");
}
User_Type_Access found = db.User_Type_Access.Where(x => x.AccessID == accessid && x.UserTypeID == usertypeid).FirstOrDefault();
if (found != null)
{
db.User_Type_Access.Remove(found);
db.SaveChanges();
toReturn.Message = "User Type Access Removed";
}
else
{
toReturn.Error = "Cannot Remove Access Not Set";
}
}
catch
{
toReturn.Error = "Adding Access Unsuccesful ";
}
return(toReturn);
}
