private void Add_Renter_Button_Click(object sender, RoutedEventArgs e) { string tenantName, phoneNumber, emailAddress, renewal, renewalin30 = "NO", renewalin90 = "NO", depositDate = "", cleaningDepositDate = "", keyDepositDate = "", rentDueDate = ""; int rent = 0, deposit = 0, cleaningDeposit = 0, keyDeposit = 0; bool flag = true, tenantExists = false; string startDate, endDate; tenantName = addNameBox.Text; phoneNumber = addPhoneNumberBox.Text; emailAddress = addEmailBox.Text; renewal = "No Renewal"; try { renewal = addRenewalCombo.SelectedValue.ToString(); flag = false; } catch (Exception) { MessageBox.Show("Please select value for renewal"); } startDate = addStartDateBox.Text; endDate = addEndDateBox.Text; depositDate = addDepositDateBox.Text; cleaningDepositDate = addCleaningDateBox.Text; keyDepositDate = addKeyDateBox.Text; rentDueDate = addrentDateBox.Text; Renter renter; if (dbloc == "") { string executable = System.Reflection.Assembly.GetExecutingAssembly().Location; string path = (System.IO.Path.GetDirectoryName(executable)); AppDomain.CurrentDomain.SetData("DataDirectory", path); dbloc = @"Data Source=|DataDirectory|\DataFile\RentalDatabase.db"; } if (tenantName == "") { flag = false; MessageBox.Show("Please enter Tenant Name"); } else if (rentDueDate == "") { flag = false; MessageBox.Show("Please enter Rent Due Date"); } else if (cleaningDepositDate == "") { flag = false; MessageBox.Show("Please enter Cleaning Deposit Date"); } else if (keyDepositDate == "") { flag = false; MessageBox.Show("Please enter Key Deposit Date"); } else if (depositDate == "") { flag = false; MessageBox.Show("Please enter Deposit Date"); } else if (renewal == "") { flag = false; MessageBox.Show("Please select if there is a renewal"); } else if (addRentBox.Text == "") { flag = false; MessageBox.Show("Please enter Rent"); } else if (addDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter Deposit"); } else if (addCleaningDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter cleaning deposit"); } else if (addKeyDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter Key Deposit"); } else if (startDate == "") { flag = false; MessageBox.Show("Please enter start date"); } else if (endDate == "") { flag = false; MessageBox.Show("Please enter End Date"); } else if (rentDueDate == "" || cleaningDepositDate == "" || depositDate == "" || keyDepositDate == "" || tenantName == "" || renewal == "" || addRentBox.Text == "" || addCleaningDepositBox.Text == "" || addKeyDepositBox.Text == "" || startDate == "" || endDate == "" || phoneNumber == "" || emailAddress == "") { flag = false; MessageBox.Show("Please Enter Missing Values"); } else { flag = true; rent = Convert.ToInt32(addRentBox.Text); deposit = Convert.ToInt32(addDepositBox.Text); cleaningDeposit = Convert.ToInt32(addCleaningDepositBox.Text); keyDeposit = Convert.ToInt32(addKeyDepositBox.Text); } if (renewal == "Renewal in 30") { renewalin30 = "YES"; renewalin90 = "NO"; } else if (renewal == "Renewal in 90") { renewalin90 = "YES"; renewalin30 = "NO"; } else { renewalin30 = "NO"; renewalin90 = "NO"; } if (flag) { using (SQLiteConnection conn = new SQLiteConnection(dbloc)) { conn.Open(); SQLiteCommand command1 = new SQLiteCommand("Select * from Renter where TenantName ='" + tenantName + "'" + "AND AddressID=" + addressID, conn); SQLiteDataReader reader = command1.ExecuteReader(); if (reader.HasRows) { tenantExists = true; MessageBox.Show("Renter already exists for this address"); } } foreach (Renter r in renterList) { if (r.TenantName == tenantName) { tenantExists = true; MessageBox.Show("Renter already exists for this address"); } } if (!tenantExists) { renter = new Renter(tenantName, phoneNumber, emailAddress, rent, startDate, endDate, deposit, cleaningDeposit, keyDeposit, renewalin30, renewalin90, depositDate, keyDepositDate, cleaningDepositDate, rentDueDate); renterList.Add(renter); this.renterListView.Items.Add(renter); } } }
public void Save_Renter_Button_Click(object sender, RoutedEventArgs e) { string tenantName, phoneNumber, emailAddress, renewal, renewalin30 = "NO", renewalin90 = "NO", depositDate = "", cleaningDepositDate = "", keyDepositDate = "", rentDueDate = ""; int rent = 0, deposit = 0, cleaningDeposit = 0, keyDeposit = 0; bool flag = true, tenantExists = false; string startDate, endDate; tenantName = addNameBox.Text; phoneNumber = addPhoneNumberBox.Text; emailAddress = addEmailBox.Text; renewal = "No Renewal"; try { renewal = addRenewalCombo.SelectedValue.ToString(); flag = false; } catch (Exception) { MessageBox.Show("Please select value for renewal"); } startDate = addStartDateBox.Text; endDate = addEndDateBox.Text; depositDate = addDepositDateBox.Text; cleaningDepositDate = addCleaningDateBox.Text; keyDepositDate = addKeyDateBox.Text; rentDueDate = addrentDateBox.Text; Renter renter; if (dbloc == "") { string executable = System.Reflection.Assembly.GetExecutingAssembly().Location; string path = (System.IO.Path.GetDirectoryName(executable)); AppDomain.CurrentDomain.SetData("DataDirectory", path); dbloc = @"Data Source=|DataDirectory|\DataFile\RentalDatabase.db"; } if (tenantName == "") { flag = false; MessageBox.Show("Please enter Tenant Name"); } else if (rentDueDate == "") { flag = false; MessageBox.Show("Please enter Rent Due Date"); } else if (cleaningDepositDate == "") { flag = false; MessageBox.Show("Please enter Cleaning Deposit Date"); } else if (keyDepositDate == "") { flag = false; MessageBox.Show("Please enter Key Deposit Date"); } else if (depositDate == "") { flag = false; MessageBox.Show("Please enter Deposit Date"); } else if (renewal == "") { flag = false; MessageBox.Show("Please select if there is a renewal"); } else if (addRentBox.Text == "") { flag = false; MessageBox.Show("Please enter Rent"); } else if (addDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter Deposit"); } else if (addCleaningDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter cleaning deposit"); } else if (addKeyDepositBox.Text == "") { flag = false; MessageBox.Show("Please enter Key Deposit"); } else if (startDate == "") { flag = false; MessageBox.Show("Please enter start date"); } else if (endDate == "") { flag = false; MessageBox.Show("Please enter End Date"); } else if (rentDueDate == "" || cleaningDepositDate == "" || depositDate == "" || keyDepositDate == "" || tenantName == "" || renewal == "" || addRentBox.Text == "" || addCleaningDepositBox.Text == "" || addKeyDepositBox.Text == "" || startDate == "" || endDate == "" || phoneNumber == "" || emailAddress == "") { flag = false; MessageBox.Show("Please Enter Missing Values"); } else { flag = true; rent = Convert.ToInt32(addRentBox.Text); deposit = Convert.ToInt32(addDepositBox.Text); cleaningDeposit = Convert.ToInt32(addCleaningDepositBox.Text); keyDeposit = Convert.ToInt32(addKeyDepositBox.Text); } if (renewal == "Renewal in 30") { renewalin30 = "YES"; renewalin90 = "NO"; } else if (renewal == "Renewal in 90") { renewalin90 = "YES"; renewalin30 = "NO"; } else { renewalin30 = "NO"; renewalin90 = "NO"; } if (flag) { if (!tenantExists) { renter = new Renter(tenantName, phoneNumber, emailAddress, rent, startDate, endDate, deposit, cleaningDeposit, keyDeposit, renewalin30, renewalin90, depositDate, keyDepositDate, cleaningDepositDate, rentDueDate); renterList.Add(renter); } } save(); }