public void AddManagementAccount(managementaccount tempManagementAccount)
{
using (var context = new MSSContext())
{
managementaccount newManagementAccount = new managementaccount();
newManagementAccount.firstname = tempManagementAccount.firstname;
newManagementAccount.lastname = tempManagementAccount.lastname;
newManagementAccount.email = tempManagementAccount.email;
//Need to check if a name already exists by counting how many of the same names are in the database
int numOfNames = 0;
numOfNames = (from ma in context.managementaccounts
where ma.firstname == tempManagementAccount.firstname &&
ma.lastname == tempManagementAccount.lastname
select ma).Count();
if (numOfNames == 0)
{
newManagementAccount.username = (tempManagementAccount.firstname + tempManagementAccount.lastname).ToLower();
}
else
{
// if there is a least one other person with the same name, the UserName is set with the value of numOfNames for the UserName to be Unique
newManagementAccount.username = (tempManagementAccount.firstname + tempManagementAccount.lastname + numOfNames).ToLower();
}
newManagementAccount.userpassword = "******"; // unsure how the password is going to be generated
newManagementAccount.activeyn = true;
newManagementAccount.authorizationlevelid = tempManagementAccount.authorizationlevelid;
context.managementaccounts.Add(newManagementAccount);
context.SaveChanges();
}
}
public void DeleteManagementAccount(managementaccount tempManagementAccount)
{
using (var context = new MSSContext())
{
var managementaccount = context.managementaccounts.Find(tempManagementAccount.managementaccountid);
managementaccount.activeyn = false;
var existingManagementAccount = context.Entry(managementaccount);
existingManagementAccount.State = EntityState.Modified;
context.SaveChanges();
}
}
public void UpdateManagementAccount(managementaccount updatedManagementAccount)
{
using (var context = new MSSContext())
{
var managementaccount = context.managementaccounts.Find(updatedManagementAccount.managementaccountid);
managementaccount.userpassword = updatedManagementAccount.userpassword;
managementaccount.authorizationlevelid = updatedManagementAccount.authorizationlevelid;
managementaccount.caresites = updatedManagementAccount.caresites;
var existingManagementAccount = context.Entry(managementaccount);
existingManagementAccount.State = EntityState.Modified;
context.SaveChanges();
}
}
public Boolean LoginManagement(string attemptedUserName, string attemptedUserPassword)
{
Boolean succesfulLogin = false;
using (var context = new MSSContext())
{
managementaccount managementAccountExists = (from ma in context.managementaccounts
where ma.username == attemptedUserName &&
ma.userpassword == attemptedUserPassword &&
ma.activeyn == true
select ma).FirstOrDefault();
if (managementAccountExists == null)
{
throw new Exception("Invalid Username or Password. Please contact your System Administrator for further assistance");
}
else
{
succesfulLogin = true;
}
}
return(succesfulLogin);
}
