private void ClearMethod() { FirstNameTB.Clear(); LastNametextBox.Clear(); DateOfBirthTB.Value = DateTime.Now; GenderTB.SelectedIndex = -1; ContacttextBox.Text = "03"; NICtextBox.Clear(); HouseNOtextBox.Clear(); AddLine1Tb.Clear(); AddLine2tb.Clear(); postCodetextBox.Clear(); DepartmentTextBoc.SelectedIndex = -1; designationtextBox.SelectedIndex = -1; ; StatuscomboBox.SelectedIndex = -1; DateOfHired.Value = DateTime.Now; BasicSalarytextBox.Clear(); JobTitletextBox.Clear(); PasswordTb.Clear(); ImgLocation = ""; ProfilePicture.Image = Resources.User1; }
private void AddButton_Click(object sender, RoutedEventArgs e) { if(StudentListBox.SelectedItem == null) { var sID = int.TryParse(StudentIDTB.Text, out int studentID); if (sID == false) { MessageBox.Show("Invalid Entry. Please enter a valid number"); } var sFirstName = FirstNameTB.Text; var sLastName = LastNameTB.Text; var age = int.TryParse(AgeTB.Text, out int sAge); var allergies = AllergiesTB.Text; var parentName = ParentNameTB.Text; var parentContact = ParentContactNoTB.Text; var parentEmail = ParentEmailTB.Text; var classID = int.TryParse(ClassIDTB.Text, out int sClassID); _crudManager.AddStudent(studentID, sFirstName, sLastName, sAge, allergies, parentName, parentContact, parentEmail, sClassID); } PopulateStudentListBox(); StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); }
private void Button_Click(object sender, RoutedEventArgs e) { //добавление данных о пользователе в БД, если все данные введены верно if (PasswordTB.Password == RepPasswordTB.Password) { DB dB = new DB(Properties.Settings.Default.CinemaDBConnectionString); object login = dB.ExecuteScalarQuery($"SELECT Логин FROM Пользователь WHERE Логин = '{LoginTB.Text}'"); if (login == null) { int rows = dB.ExecuteQuery($"INSERT INTO [Пользователь] Values(N'{LoginTB.Text}', N'{PasswordTB.Password}', N'{EmailTB.Text}', N'{PhoneTB.Text}', 0, 0, N'{LastNameTB.Text}', N'{FirstNameTB.Text}', N'{MiddleNameTB.Text}')"); if (rows == 1) { MessageBox.Show("Регистрация прошла успешно!"); LastNameTB.Clear(); FirstNameTB.Clear(); MiddleNameTB.Clear(); EmailTB.Clear(); PhoneTB.Clear(); LoginTB.Clear(); PasswordTB.Clear(); RepPasswordTB.Clear(); AddText(); } } else { MessageBox.Show("Такой логин уже существует!"); } } else { MessageBox.Show("Пароли не совпадают!"); } }
private void ClearMethod() { IDTB.Clear(); FirstNameTB.Clear(); LastNametextBox.Clear(); designationtextBox.Clear(); DepartmentTextBoc.Clear(); BasicSalarytextBox.Clear(); ConvancetextBox.Clear(); MedicalAlltextBox.Clear(); TotalAmounttextBox.Clear(); HouseRentTextBoc.Clear(); AbsenceTextBox.Text = "0"; LateTextBox.Text = "0"; HalfDayTextBox.Text = "0"; OverTimeHrtextBox.Text = "0"; AddedAllowanceTB.Clear(); DeductedAmountTB.Clear(); IncomeTextextBox.Clear(); NetSalaryTB.Clear(); Off = 0; NetSalary = 0; Allownc = 0; Deducted = 0; incomeTex = 0; OvertimeAmount = 0; OvertimeHours = 0; TotalAmount = 0; AtdDec = 0; halfDayAmount = 0; button3.Enabled = false; }
private void ClearMethod() { IDTB.Clear(); FirstNameTB.Clear(); LastNametextBox.Clear(); DateOfBirthTB.Value = DateTime.Now; GenderTB.SelectedIndex = -1; ContacttextBox.Clear(); NICtextBox.Clear(); HouseNOtextBox.Clear(); AddLine1Tb.Clear(); AddLine2tb.Clear(); postCodetextBox.Clear(); DepartmentTextBoc.SelectedIndex = -1; designationtextBox.SelectedIndex = -1; StatuscomboBox.SelectedIndex = -1; DateOfHired.Value = DateTime.Now; BasicSalarytextBox.Clear(); JobTitletextBox.Clear(); PasswordTb.Clear(); UpdateBtn.Enabled = false; button1.Enabled = false; ReadID(); ProfilePicture.Image = Resources.User1; }
private void ResetBt_Click(object sender, RoutedEventArgs e) { StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); }
private void ClearMethod() { FirstNameTB.Clear(); designationtextBox.Clear(); LastNametextBox.Clear(); StatusTB.Clear(); DateOfHired.Clear(); BasicSalaryTB.Clear(); Amountlabel.Text = "Basic Salary : 0"; UpdatedSalaryTb.Text = "Salary After Updation : 0"; perradioButton.Checked = false; AmountradioButton.Checked = false; }
private void DeleteBt_Click(object sender, RoutedEventArgs e) { _crudManager.DeleteStudent(int.Parse(StudentIDTB.Text)); StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); StudentListBox.ItemsSource = null; PopulateStudentListBox(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (FirstNameTB.Text != "" || EmailTB.Text != "" || PhoneTB.Text != "" || LoginTB.Text != "" || PasswordTB.Password != "" || RepPasswordTB.Password != "") { if (PasswordTB.Password == RepPasswordTB.Password) { using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\OlineCinema\OlineCinema\CinemaDB.mdf;Integrated Security=True")) { try { connection.Open(); } catch { MessageBox.Show("Ошибка соединения с базой данных!"); return; } string query = $"INSERT INTO [Пользователь] Values('{LoginTB.Text}', '{PasswordTB.Password}', '{EmailTB.Text}', '{PhoneTB.Text}', 0, 0, '{LastNameTB.Text}', '{FirstNameTB.Text}', '{MiddleNameTB.Text}')"; SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); MessageBox.Show("Регистрация прошла успешно!"); LastNameTB.Clear(); FirstNameTB.Clear(); MiddleNameTB.Clear(); EmailTB.Clear(); PhoneTB.Clear(); LoginTB.Clear(); PasswordTB.Clear(); RepPasswordTB.Clear(); } } else { MessageBox.Show("Пароли не свопадают!"); } } else { MessageBox.Show("Есть незаполненные поля!"); } }
private void ClearMethod() { IDTB.Clear(); FirstNameTB.Clear(); LastNametextBox.Clear(); DateOfBirthTB.Value = DateTime.Now; DepartmentTextBoc.Clear(); BasicSalarytextBox.Clear(); AmounttextBox.Text = "0"; ReasonCB.SelectedIndex = -1; AttendanceAllowancetb.SelectedIndex = -1; MonthYear.Value = DateTime.Now; ConvenceAllLBL.Text = "0"; HouseRentLbl.Text = "0"; MedicalLBL.Text = "0"; Amountlabel.Text = "Total Amount : 0"; button1.Enabled = false; button3.Enabled = false; }
private void ClearMethod() { IDTB.Clear(); FirstNameTB.Clear(); LastNametextBox.Clear(); DateOfHired.Clear(); BasicSalarytextBox.Clear(); DepartmentTextBoc.Clear(); designationtextBox.Clear(); StatusTB.Clear(); MonthYear.Value = DateTime.Now; perradioButton.Checked = false; AmountradioButton.Checked = false; PertextBox.Clear(); AmounttextBox.Clear(); ReasontextBox.Clear(); button1.Enabled = false; button3.Enabled = false; Amountlabel.Text = "Total Salary : 0"; DeductionSalaryTb.Text = "Salary After Deduction : 0"; }
private void FirstNameTBGotFocus(object sender, RoutedEventArgs e) { FirstNameTB.Clear(); }