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"); } }