public bool NewUserRegister(UserRegisterModel regUser) { bool registerApproved = false; try { ConnectionStr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; conn = new SqlConnection(ConnectionStr); conn.Open(); string insertDate = regUser.DateOfJoining.ToString("MM/dd/yyyy"); cmd = new SqlCommand("SELECT UserRole FROM EmployeeDB WHERE EmployeeID = @userID", conn); cmd.Parameters.AddWithValue("userID", regUser.EmployeeID); string userRole = Convert.ToString(cmd.ExecuteScalar()); if (userRole != null && !userRole.Contains("U")) { userRole = userRole + "U"; cmd = new SqlCommand("INSERT INTO EmployeeDB (EmployeeID, EmployeeName, DoJ, Email, PhoneNo, Password, UserRole, Deductions) VALUES (@userID, @uname, @DoJ, @Email, @Phno, @pswd, @userRole, 0.0)", conn); cmd.Parameters.AddWithValue("userID", regUser.EmployeeID); cmd.Parameters.AddWithValue("uname", regUser.Name); cmd.Parameters.AddWithValue("DoJ", insertDate); cmd.Parameters.AddWithValue("Email", regUser.EmailId); cmd.Parameters.AddWithValue("Phno", regUser.PhoneNumber); cmd.Parameters.AddWithValue("pswd", regUser.Password); cmd.Parameters.AddWithValue("userRole", userRole); Debug.WriteLine("COMMAND: " + cmd.Parameters.ToString()); if (cmd.ExecuteNonQuery().Equals(1)) { registerApproved = true; } else { registerApproved = false; } } else { registerApproved = false; } conn.Close(); } catch (Exception) { registerApproved = false; } return registerApproved; }
public string Register(string UserId, string UserName, string JoiningDate, string Password, string EmailId, string PhoneNumber) { UserAccountDAL agent = new UserAccountDAL(); UserRegisterModel regUser = new UserRegisterModel(); regUser.EmployeeID = UserId; regUser.Name = UserName; regUser.DateOfJoining = Convert.ToDateTime(JoiningDate); regUser.PhoneNumber = PhoneNumber; regUser.EmailId = EmailId; regUser.Password = PasswordGenerator.EncryptPassword(Password); try { bool res = agent.NewUserRegister(regUser); if (res) { FormsAuthentication.SetAuthCookie(regUser.EmployeeID, false); Session["UserID"] = regUser.EmployeeID; Session["UserRole"] = "U"; return "DONE"; } else { //ModelState.AddModelError("", "The user name or password provided is incorrect."); //return View(regUser); return "ERROR: Registration incorrect"; } } catch { return "ERROR: Registration incorrect"; } }