public DataTable ValidateUser(string userName, string password)
{
DBCommonMethods commonMethods = new DBCommonMethods();
password = commonMethods.HashPassword(password);
DBManager objDBManager = new DBManager();
objDBManager.AddParameter("UserName", userName);
objDBManager.AddParameter("Password", password);
return(objDBManager.ExecuteDataTable("ValidateUser", "UnileverConnectionString"));
}
public static void SaveUser(string userId, string username, string password, string firstname, string lastname, string department, string Pno, string mobile, string email, string RoleId)
{
DBManager ObjDBManager = new DBManager();
DBCommonMethods commonMethods = new DBCommonMethods();
if (password == "!#!#!#!#!#!#!#!#Abcdefgh123")
{
password = "";
}
else
{
password = commonMethods.HashPassword(password);
}
ObjDBManager.AddParameter("@userId", userId);
ObjDBManager.AddParameter("@username", username);
ObjDBManager.AddParameter("@password", password);
ObjDBManager.AddParameter("@firstname", firstname);
ObjDBManager.AddParameter("@lastname", lastname);
if (department == "-- Select --")
{
department = "";
}
ObjDBManager.AddParameter("@address", department);
ObjDBManager.AddParameter("@city", Pno);
ObjDBManager.AddParameter("@mobile", mobile);
ObjDBManager.AddParameter("@email", email);
ObjDBManager.AddParameter("@RoleId", RoleId);
if (int.Parse(userId) == 0)
{
ObjDBManager.AddParameter("@created_by", HttpContext.Current.Profile.GetPropertyValue("UserId"));
ObjDBManager.AddParameter("@created_date", DateTime.Now);
ObjDBManager.InsertUpdateProcedure("AddUser", "UnileverConnectionString");
}
else
{
ObjDBManager.AddParameter("@modified_by", HttpContext.Current.Profile.GetPropertyValue("UserId"));
ObjDBManager.AddParameter("@modified_date", DateTime.Now);
ObjDBManager.InsertUpdateProcedure("UpdateUser", "UnileverConnectionString");
}
}
