/// <summary>
/// Adding New User to the database.
/// </summary>
/// <param name="fName"></param>
/// <param name="lName"></param>
/// <param name="userType"></param>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="regDate"></param>
/// <param name="address"></param>
/// <param name="tel"></param>
/// <param name="createdAt"></param>
public static int addUser(string fName, string lName, string userType, string userName, string password, DateTime regDate, string address, string tel, DateTime createdAt, DateTime updatedAt)
{
try
{
int isAdd = 0;
var Reg = new UsersReg
{
first_name = fName,
last_name = lName,
user_type = Aids.PickEnum(userType),
user_name = userName,
password = password.EncryptText("magic_encrypt1256"),
reg_date = regDate,
address = address,
tel = tel,
created_at = createdAt,
updated_at = updatedAt
};
using (var context = new ApplicationDataContext())
{
context.staffs.Add(Reg);
isAdd = context.SaveChanges();
}
return(isAdd);
}
catch (Exception)
{
throw;
}
}
public ActionResult Index(UsersReg user)
{
adminLoginEntities2 usersEntities = new adminLoginEntities2();
int?userId = usersEntities.ValidateUser(user.Username, user.Password).FirstOrDefault();
string message = string.Empty;
switch (userId.Value)
{
case -1:
message = "Username and/or password is incorrect.";
break;
case -2:
message = "Account has not been activated.";
break;
default:
FormsAuthentication.SetAuthCookie(user.Username, user.RememberMe);
return(RedirectToAction("Profile"));
}
ViewBag.Message = message;
return(View(user));
}
public void Can_Create_Admin_Test_12345Test()
{
//Arrange
var admin = new Admin("Test", "12345Test");
//Act
UsersReg.AddUser(admin);
//Assert
Assert.Contains(admin, UsersReg.Users);
}
public void Can_Create_Registered_User_Bill_12345Test()
{
//Arrange
var user = new RegisteredUser("Bill", "12345Test");
//Act
UsersReg.AddUser(user);
//Assert
Assert.Contains(user, UsersReg.Users);
}
public void Can_LogIn_Test_12345678TEST()
{
//Arrange
Guest g = new Guest();
UsersReg.AddUser(new RegisteredUser("Test", "12345678TEST"));
//Act
var newUser = g.LogIn("Test", "12345678TEST");
//Assert
Assert.Contains(newUser, UsersReg.Users);
}
public static int UpdateUserRecord(string userName, string column, string value)
{
try
{
int saved = 0;
using (var context = new ApplicationDataContext())
{
singleUser = context.staffs.Where(s => s.user_name == userName).FirstOrDefault <UsersReg>();
}
if (singleUser != null)
{
if (column == "firstName")
{
singleUser.first_name = value;
}
else if (column == "lastName")
{
singleUser.last_name = value;
}
else if (column == "address")
{
singleUser.address = value;
}
else if (column == "tel")
{
singleUser.tel = value;
}
using (var con = new ApplicationDataContext())
{
con.Entry(singleUser).State = System.Data.Entity.EntityState.Modified;
saved = con.SaveChanges();
}
}
return(saved);
}
catch (Exception)
{
throw;
}
}
