private void AddBrrwrBtn_Click(object sender, EventArgs e) { string Name = NameTxt.Text; string SSN = SSNTxt.Text; string Address = AddressTxt.Text; string Phone = PhoneTxt.Text; string Email = EmailTxt.Text; bool SSN_Unique = Check_SSN(SSN); if (!string.IsNullOrEmpty(Name) && !string.IsNullOrEmpty(SSN) && !string.IsNullOrEmpty(Address)) { SSN = Format_SSN(SSN); if (SSN_Unique == true) { Execute_Add_Borrower(Name, SSN, Address, Phone, Email); } else { MessageBox.Show("The SSN number provided is already in use. Please enter another SSN or update the existing record."); } } else { MessageBox.Show("The values for Name, SSN, and Address must be filled in."); } NameTxt.Clear(); SSNTxt.Clear(); AddressTxt.Clear(); PhoneTxt.Clear(); EmailTxt.Clear(); Load_Borrower_View(); }
private void Refresh() { StudentRegTxt.Clear(); NameTxt.Clear(); SurnameTxt.Clear(); GenderCmb.ResetText(); CellNTxt.Clear(); EmailTxt.Clear(); Postaltxt.ResetText(); CourseCmb.ResetText(); Statuscmb.ResetText(); SemesterCmb.ResetText(); dataGridView1.DataSource = DataAccess.GetStudents(); dataGridView1.Columns["ID"].DisplayIndex = 0; dataGridView1.Columns["Name"].DisplayIndex = 1; dataGridView1.Columns["Surname"].DisplayIndex = 2; dataGridView1.Columns["Gender"].DisplayIndex = 3; dataGridView1.Columns["Cell"].DisplayIndex = 4; dataGridView1.Columns["Email"].DisplayIndex = 5; dataGridView1.Columns["PostalAddress"].DisplayIndex = 6; dataGridView1.Columns["CourseId"].DisplayIndex = 7; dataGridView1.Columns["Semester"].DisplayIndex = 8; dataGridView1.Columns["StatusId"].DisplayIndex = 9; }
private void ClearBtn_Click(object sender, EventArgs e) { SurnameTxt.Clear(); NameTxt.Clear(); PatronymicTxt.Clear(); ProfCmbBox.Text = ""; OrgCmbBox.Text = ""; }
private void CancelBtn_Click(object sender, EventArgs e) { NameTxt.Clear(); SSNTxt.Clear(); AddressTxt.Clear(); PhoneTxt.Clear(); EmailTxt.Clear(); }
public void ClearTextBox() { //Limpia los TXTBOX y Limpia la seleccion del listbox AgeTxt.Clear(); LastNametTxt.Clear(); NameTxt.Clear(); PaymentHTxt.Clear(); TotalHoursTxt.Clear(); listBox1.ClearSelected(); }
public void ClearTextBox() { //Limpia los TXTBOX y Limpia la seleccion del listbox AgeTxt.Clear(); LastNametTxt.Clear(); NameTxt.Clear(); PaymentHTxt.Clear(); TotalHoursTxt.Clear(); listBox1.ClearSelected(); pictureBox1.Image = null; TotalHoursTxt.ReadOnly = false; }
private void SaveBtn_Click(object sender, EventArgs e) { try { String name = NameTxt.Text; /*storing text from textbox into variable to designated datatypes*/ String address = AddressTxt.Text; Int64 contact = Convert.ToInt64(ContactTxt.Text); int age = Convert.ToInt32(AgeTxt.Text); String gender = comboGender.Text; String blood = BloodTxt.Text; String any = PreProblemTxt.Text; int pid = Convert.ToInt32(PaitionIdTxt.Text); System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(); con.ConnectionString = "data source = DESKTOP-G7R371A\\SQLEXPRESS; database = Hospital; integrated security = True"; System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = con; /*connecting database*/ cmd.CommandText = "insert into AddPatient values ('" + name + "', '" + address + "'," + contact + "," + age + ",'" + gender + "','" + blood + "','" + any + "'," + pid + ")"; System.Data.SqlClient.SqlDataAdapter DA = new System.Data.SqlClient.SqlDataAdapter(cmd); DataSet DS = new DataSet(); /*Data set to fill boxes*/ DA.Fill(DS); MessageBox.Show("Data Saved!"); } catch (Exception) { MessageBox.Show("Please fill up all boxes"); } /*Clearing all boxes*/ NameTxt.Clear(); AddressTxt.Clear(); ContactTxt.Clear(); AgeTxt.Clear(); BloodTxt.Clear(); PreProblemTxt.Clear(); PaitionIdTxt.Clear(); comboGender.ResetText(); }