public static void SaveUser(Data_User user)
{
try
{
using (NewcourtEntities ctx = new NewcourtEntities())
{
Users record = ctx.Users.FirstOrDefault(a => a.Username == user.Username);
if (record != null)
{
record.Password = user.Password;
record.IsAdmin = user.IsAdmin ? (byte)1 : (byte)0;
}
else
{
ctx.Users.Add(new Users()
{
Username = user.Username,
Password = user.Password,
IsAdmin = user.IsAdmin ? (byte)1 : (byte)0
});
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Data_User GetUserByUsername(String username)
{
Data_User user = null;
try
{
using (NewcourtEntities ctx = new NewcourtEntities())
{
user = (from a in ctx.Users
where a.Username == username
select new Data_User()
{
Username = a.Username,
Password = a.Password,
IsAdmin = a.IsAdmin == 1,
LastLoggedIn = a.LastLoggedIn
}).FirstOrDefault();
}
}
catch (Exception ex)
{
Utils.ShowException(ex);
}
return(user);
}
public static Data_User LoginUser(String username, String password)
{
Data_User user = null;
try {
user = GetUserByUsername(username);
// LINQ will not do case-sensitive string comparisons so need to do this locally:
if (user != null)
{
if (!user.Password.Equals(password))
{
return(null);
}
}
} catch (Exception ex) {
Utils.ShowException(ex);
}
return(user);
}