private void GetAllFlat()
{
var flatDb = new FlatDb();
dgvFlat.DataSource = null;
dgvFlat.DataSource = flatDb.GetAllFlat();
}
private void btnRegister_Click(object sender, EventArgs e)
{
var numberOfEffectedRow = 0;
if (string.IsNullOrEmpty(tbFlatNo.Text) ||
string.IsNullOrEmpty(cbFlatOwner.Text) ||
string.IsNullOrEmpty(tbFlatOwnerName.Text) ||
string.IsNullOrEmpty(tbFlatOwnerLastName.Text) ||
string.IsNullOrEmpty(tbFlatTenantName.Text) ||
string.IsNullOrEmpty(tbFlatTenantLastName.Text) ||
string.IsNullOrEmpty(tbPaidMoney.Text) ||
string.IsNullOrEmpty(dtpLastPaymentDate.Text))
{
MessageBox.Show("Please don't left empty places");
}
else
{
// Expense Add // If ID empty, you should add new record.
if (string.IsNullOrEmpty(tbFlatID.Text))
{
var FlatDb = new FlatDb();
var flat = new Flat();
flat.FlatNo = Convert.ToInt32(tbFlatNo.Text);
flat.FlatOwner = cbFlatOwner.Text;
flat.FlatOwnerName = tbFlatOwnerName.Text;
flat.FlatOwnerLastName = tbFlatOwnerLastName.Text;
flat.FlatTenantName = tbFlatTenantName.Text;
flat.FlatTenantLastName = tbFlatTenantLastName.Text;
flat.PaidMoney = Convert.ToDouble(tbPaidMoney.Text);
flat.LastPaymentDate = Convert.ToDateTime(dtpLastPaymentDate.Text);
flat = FlatDb.AddNewFlat(flat);
numberOfEffectedRow++;
}
// Expense Update // Else, you double click datagrid and id come TbExpenseID
else
{
var FlatDb = new FlatDb();
var flat = new Flat();
flat.FlatNo = Convert.ToInt32(tbFlatNo.Text);
flat.FlatOwner = cbFlatOwner.Text;
flat.FlatOwnerName = tbFlatOwnerName.Text;
flat.FlatOwnerLastName = tbFlatOwnerLastName.Text;
flat.FlatTenantName = tbFlatTenantName.Text;
flat.FlatTenantLastName = tbFlatTenantLastName.Text;
flat.PaidMoney = Convert.ToDouble(tbPaidMoney.Text);
flat.LastPaymentDate = Convert.ToDateTime(dtpLastPaymentDate.Text);
flat = FlatDb.AddNewFlat(flat);
flat = FlatDb.UpdateFlat(flat);
numberOfEffectedRow++;
}
GetAllFlat();
MessageBox.Show(numberOfEffectedRow > 0 ? "Success" : "Failed!");
ChangeColumnsName();
//FormClear();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbFlatNo.Text) ||
string.IsNullOrEmpty(cbFlatOwner.Text) ||
string.IsNullOrEmpty(tbFlatOwnerName.Text) ||
string.IsNullOrEmpty(tbFlatOwnerLastName.Text) ||
string.IsNullOrEmpty(tbFlatTenantName.Text) ||
string.IsNullOrEmpty(tbFlatTenantLastName.Text) ||
string.IsNullOrEmpty(tbPaidMoney.Text) ||
string.IsNullOrEmpty(dtpLastPaymentDate.Text))
{
MessageBox.Show("Please don't left empty places");
}
else
{
var flatDb = new FlatDb();
var flat = new Flat();
flat.FlatID = Convert.ToInt32(tbFlatID.Text);
flat = flatDb.DeleteFlat(flat);
MessageBox.Show("Expense deleted!");
GetAllFlat();
btnDelete.Enabled = false;
}
}
