/// <summary> /// Create new user record /// </summary> /// <param name="user">User model</param> public void Create(User user) { using (var command = new SqlCommand("sp_CreateUser", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@UserName", user.UserName); command.Parameters.AddWithValue("@LastName", user.LastName); command.Parameters.AddWithValue("@Login", user.Login); command.Parameters.AddWithValue("@PhoneNumber", user.PhoneNumber); command.Parameters.AddWithValue("@Email", user.Email); command.Parameters.AddWithValue("@Password", user.Password); command.Parameters.AddWithValue("@Role", user.Role); command.Parameters.AddWithValue("@Status", user.Status); if (user.DriverStatus == null) { command.Parameters.AddWithValue("@DriverStatus", DBNull.Value); } else { command.Parameters.AddWithValue("@DriverStatus", user.DriverStatus); } command.ExecuteNonQuery(); } }
public void CreateUser(User user) { using (var uow = new UnitOfWork(_appConfigConnection)) { uow.UserRepository.Create(user); } }
public static User Map(SqlDataReader record) { var user = new User { Id = (int)record["Id"], UserName = (string)record["Name"], LastName = (string)record["LastName"], Login = (string)record["Login"], PhoneNumber = (string)record["PhoneNumber"], Email = (string)record["Email"], Password = (string)record["Password"], Role = (int)record["Role"], Status = (int)record["Status"], DriverStatus = record.IsDBNull(record.GetOrdinal("DriverStatus")) == false ? (int?)record["DriverStatus"] : default(int?) }; return user; }
public ActionResult RegisterUser(RegistrationModel registrationModel) { if (ModelState.IsValid) { if (!_userBl.IsLoginBooked(registrationModel.Login)) { var user = new User { LastName = registrationModel.LastName, Login = registrationModel.Login, PhoneNumber = registrationModel.PhoneNumber, Email = registrationModel.Email, Password = registrationModel.Password, Role = (int) RolesEnum.Client, Status = (int) UserStatusEnum.Active, UserName = registrationModel.FirstName, DriverStatus = null }; _userBl.CreateUser(user); //Session["UserFullName"] = user.UserName + " " + user.LastName; //Session["UserLogin"] = user.Login; FormsAuthentication.SetAuthCookie(user.Login, false); return RedirectToAction("Index", "Home"); } else { ModelState.AddModelError("", "Such login already exists"); } } return View(registrationModel); }
/// <summary> /// Check is already user with the same login, but other id /// </summary> /// <param name="login">String login value</param> /// <param name="id"></param> /// <returns></returns> public bool IsLoginBookedByOtherId(string login, int id) { using (var command = new SqlCommand("sp_IsLoginBookedByOtherId", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Login", login); command.Parameters.AddWithValue("@ID", id); var user = new User(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { user = UserMapper.Map(reader); } } if (user.Login == login) { return true; } } return false; }
public User GetUserByLogInAndPassword(string login, string password) { using (var command = new SqlCommand("sp_GetUserByLogInAndPassword", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Login", login); command.Parameters.AddWithValue("@Password", password); var user = new User(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { user = UserMapper.Map(reader); } } return user; } }
/// <summary> /// Get user by id /// </summary> /// <param name="id"></param> /// <returns></returns> public User GetUserById(int id) { using (var command = new SqlCommand("sp_GetUserById", _connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id", id); var findUser = new User(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var user = UserMapper.Map(reader); findUser = user; } } return findUser; } }
public ActionResult GetUserProfile(EditProfileModel editProfileModel) { if (ModelState.IsValid) { var user = new User { LastName = editProfileModel.LastName, UserName = editProfileModel.FirstName, PhoneNumber = editProfileModel.PhoneNumber, Email = editProfileModel.Email, Id = editProfileModel.Id, Login = editProfileModel.Login, Role = (int) RolesEnum.Client, Status = (int) UserStatusEnum.Active, Password = editProfileModel.Password, DriverStatus = null, }; _userBl.UpdateUser(user); //Session["UserFullName"] = user.UserName + " " + user.LastName; return RedirectToAction("Index", "Home"); } return View(editProfileModel); }
protected void btnSaveEdit_Click(object sender, EventArgs e) { IAdminBl adminBl = HttpContext.Current.Application.GetContainer().Resolve<IAdminBl>(); string UserId; if (hiddenId.Value != "") { UserId = hiddenId.Value; hiddenId.Value = ""; } else { UserId = tbxFindOperatorByCategory.Text; } var updatedUser = new User() { Id = Convert.ToInt32(UserId), UserName = tbxEditOperatorName.Text, LastName = tbxEditLastName.Text, Login = tbxEditLogin.Text, PhoneNumber = tbxEditPhoneNumber.Text, Email = tbxEditEmail.Text, Password = tbxEditPassword.Text, Role = (int) RolesEnum.Operator, Status = (int)Enum.Parse(typeof(UserStatusEnum), ddlEditStatus.Text), DriverStatus = null }; if (!adminBl.IsLoginBookedByOtherId(updatedUser.Login, updatedUser.Id)) { adminBl.UpdateUser(updatedUser); Response.Redirect("~/WebForms/Operators.aspx"); } else { loginBooked.InnerText = "Login is booked!"; } }
protected void btnSaveEdit_Click(object sender, EventArgs e) { IAdminBl adminBl = HttpContext.Current.Application.GetContainer().Resolve<IAdminBl>(); string UserId; if (hiddenId.Value != "") { UserId = hiddenId.Value; hiddenId.Value = ""; } else { UserId = tbxFindTaxiDriverByCategory.Text; } var updatedUser = new User() { Id = Convert.ToInt32(UserId), UserName = tbxEditTaxiDriverName.Text, LastName = tbxEditLastName.Text, Login = tbxEditLogin.Text, PhoneNumber = tbxEditPhoneNumber.Text, Email = tbxEditEmail.Text, Password = tbxEditPassword.Text, Role = (int)RolesEnum.Driver, Status = (int)Enum.Parse(typeof(UserStatusEnum), ddlEditStatus.Text), DriverStatus = (int?)DriverStatusEnum.Free }; if (!adminBl.IsLoginBookedByOtherId(updatedUser.Login, updatedUser.Id)) { adminBl.UpdateUser(updatedUser); var updatedCar = new Car() { Id = updatedUser.Id, CarBrand = tbxCarBrand.Text, CarYear = tbxCarYear.Text, StartWorkTime = DateTime.Parse(tbxCarStartWorkTime.Text), FinishWorkTime = DateTime.Parse(tbxCarFinishWorkTime.Text), Latitude = tbxCarLatitude.Text, Longitude = tbxCarLongitude.Text }; if (adminBl.IsCarIdBooked(updatedCar.Id)) { adminBl.UpdateCar(updatedCar); } else { adminBl.CreateCar(updatedCar); } Response.Redirect("~/WebForms/TaxiDrivers.aspx"); } else { loginBooked.InnerText = "Login is booked!"; } }