public static void CreateUser(string username, string firstname, string lastname,
string email, string password, string gender,
int month, int day, int year,
string securityquestion, string securityanswer)
{
using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1())
{
Account user = new Account();
user.UserName = username;
user.FirstName = firstname;
user.LastName = lastname;
user.Email = email;
user.EmailConfirmed = false;
user.Password = password;
user.Gender = gender;
user.BirthDate = new DateTime(year, month, day);
user.SecurityQuestion = securityquestion;
user.SecurityAnswer = securityanswer;
user.LastLoginDate = DateTime.Now;
user.LastUpdateDate = DateTime.Now;
user.IsActivated = false;
user.IsLockedOut = false;
user.LastLockedOutDate = DateTime.Now;
user.LastLockedOutReason = "";
user.CreateDate = DateTime.Now;
db.Accounts.Add(user);
db.SaveChanges();
}
}
public static void SetPassword(string username, string newpassword)
{
using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1())
{
var result = from u in db.Accounts where (u.UserName == username) select u;
if (result.Count() != 0)
{
var dbuser = result.FirstOrDefault();
dbuser.Password = newpassword;
db.SaveChanges();
}
}
}
public static void UpdateLoginDate(string username)
{
using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1())
{
var result = from x in db.Accounts
where (x.UserName.ToLower() == username.ToLower())
select x;
if (result.Count() > 0)
{
Account user = result.FirstOrDefault();
user.LastLoginDate = DateTime.Now;
db.SaveChanges();
}
}
}