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();
}
