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