private void TenantsButton_Click(object sender, EventArgs e) { Tenants tenants = new Tenants(); tenants.Show(); this.Hide(); }
private void DeleteRoomButton_Click(object sender, EventArgs e) { if (MessageBox.Show("Are You Sure To Delete???", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { query = "DELETE FROM New_student WHERE UserName='******'"; fn.setData(query, "Deleted Successfully...."); userNameTextBox.Text = FullTextBox.Text = PassTextBox.Text = BloodGroupComboBox.Text = DateTimePicker.Text = PhoneNumberTextBox.Text = TextBoxEmail.Text = GenderComboBox.Text = AddressTextBox.Text = EmergencyContactTextBox.Text = EmergencyPhoneNumberTextBox.Text = emergencyRelationTextBox.Text = IdNumberTextBox.Text = RoomNoText.Text = string.Empty; Tenants tenants = new Tenants(); tenants.Show(); this.Hide(); } }
private void UpdateInfoButton_Click(object sender, EventArgs e) { Int64 mobile = Int64.Parse(PhoneNumberTextBox.Text); Int64 eMobile = Int64.Parse(EmergencyPhoneNumberTextBox.Text); String bookingStatus = RoomType.Text; query = " UPDATE New_student SET UserName ='******',FullName='" + FullTextBox.Text + "',Password='******',BloodGroup='" + BloodGroupComboBox.Text + "',DateOfBirth='" + DateTimePicker.Text + "',PhoneNumber=" + mobile + ",Email='" + TextBoxEmail.Text + "',Gender='" + GenderComboBox.Text + "',Address='" + AddressTextBox.Text + "',EmergencyContact='" + EmergencyFullNameTextBox.Text + "',EmergencyPhoneNumber=" + eMobile + ",EmergencyRelation='" + emergencyRelationTextBox.Text + "',VerficationId='" + IdNumberTextBox.Text + "',RoomNumber=" + RoomNoText.Text + " WHERE UserName='******' UPDATE rooms set Booked='" + bookingStatus + "' WHERE RoomNumber=" + RoomNoText.Text + ""; fn.setData(query, "Updated Successfully......"); userNameTextBox.Text = FullTextBox.Text = PassTextBox.Text = BloodGroupComboBox.Text = DateTimePicker.Text = PhoneNumberTextBox.Text = TextBoxEmail.Text = GenderComboBox.Text = AddressTextBox.Text = EmergencyContactTextBox.Text = EmergencyPhoneNumberTextBox.Text = emergencyRelationTextBox.Text = IdNumberTextBox.Text = RoomNoText.Text = string.Empty; Tenants tenants = new Tenants(); tenants.Show(); this.Hide(); }