/// <summary> /// Возвращает все данные о всех пользователей и добавляет в ListBox /// </summary> private void Get_All_Data() { using (db = new UsersDBEntities()) { SelectAllUserDataGridView.Rows.Clear(); DbSet users = db.Users; foreach (User us in users) { SelectAllUserDataGridView.Rows.Add(new string[] { us.User_Id.ToString(), us.First_Name, us.Last_Name, us.Login_Name, us.Password, us.Email, us.Phone }); } } }
/// <summary> /// Удоляет пользователя по User_Id /// </summary> private void Delete_User_Button_Click(object sender, EventArgs e) { int userID = Convert.ToInt32(DeleteUserTextBoxID.Text); using (db = new UsersDBEntities()) { user = db.Users .Where(us => us.User_Id == userID) .FirstOrDefault(); db.Users.Remove(user); db.SaveChanges(); } DeleteUserTextBoxID.Text = string.Empty; Get_All_Data(); }
/// <summary> /// Возвращает данные о пользователя по User_Id /// </summary> private void Update_User_Data_Button_Get_User_Data_Click(object sender, EventArgs e) { using (db = new UsersDBEntities()) { int user_ID = Convert.ToInt32(UpdateUserDataTextBoxID.Text); user = db.Users .Where(us => us.User_Id == user_ID) .FirstOrDefault(); UpdateUserDataTextBoxLoginName.Text = user.Login_Name; UpdateUserDataTextBoxPassword.Text = user.Password; UpdateUserDataTextBoxLastName.Text = user.Last_Name; UpdateUserDataTextBoxFirstName.Text = user.First_Name; UpdateUserDataTextBoxPhone.Text = user.Phone; UpdateUserDataTextBoxEmail.Text = user.Email; } Get_All_Data(); }
/// <summary> /// Создает нового пользователя /// </summary> private void New_User_Button_Sign_Up_Click(object sender, EventArgs e) { using (db = new UsersDBEntities()) { user = new User() { Login_Name = NewUserTextBoxLoginName.Text, Password = NewUserTextBoxPassword.Text, Last_Name = NewUserTextBoxLastName.Text, First_Name = NewUserTextBoxFirstName.Text, Phone = NewUserTextBoxPhone.Text, Email = NewUserTextBoxEmail.Text }; db.Users.Add(user); db.SaveChanges(); } ClearTextBoxs.Clear(newUserTextBoxsArr); Get_All_Data(); }
/// <summary> /// Обнавляет данные Пользователя по User_Id /// </summary> private void Update_User_Data_Button_Click(object sender, EventArgs e) { using (db = new UsersDBEntities()) { int userID = Convert.ToInt32(UpdateUserDataTextBoxID.Text); user = db.Users .Where(us => us.User_Id == userID) .FirstOrDefault(); user.Login_Name = UpdateUserDataTextBoxLoginName.Text; user.Password = UpdateUserDataTextBoxPassword.Text; user.Last_Name = UpdateUserDataTextBoxLastName.Text; user.First_Name = UpdateUserDataTextBoxFirstName.Text; user.Phone = UpdateUserDataTextBoxPhone.Text; user.Email = UpdateUserDataTextBoxEmail.Text; db.SaveChanges(); } ClearTextBoxs.Clear(updateUserDataTextBoxArr); Get_All_Data(); }