public Rents(Controller contobj1, MainPage M1)
{
InitializeComponent();
contobj = contobj1;
M = M1;
string[] Status = new string[3] {
"ALL", "Paid", "Not-Paid"
};
RS.DataSource = Status;
RS.Refresh();
DataTable dt1 = contobj.GetAllCollecters();
RC.DataSource = dt1;
RC.DisplayMember = "Employee_FirstName";
RC.ValueMember = "Employee_Id";
RC.Refresh();
DataTable dt2 = contobj.GetAllCollecters();
Collecter.DataSource = dt2;
Collecter.DisplayMember = "Employee_FirstName";
Collecter.ValueMember = "Employee_Id";
Collecter.Refresh();
DataTable dt3 = contobj.GetAllUnits();
Units.DataSource = dt3;
Units.ValueMember = "Unit_Id";
Units.Refresh();
DataTable dt4 = contobj.GetAllTenants();
tenants.DataSource = dt4;
tenants.DisplayMember = "Tenant_FirstName";
tenants.ValueMember = "Tenant_Id";
tenants.Refresh();
DataTable dt5 = contobj.GetAllBuildings();
BCC.DataSource = dt5;
BCC.DisplayMember = "Building_Name";
BCC.ValueMember = "Building_Id";
BCC.Refresh();
DataTable dt6 = contobj.GetAllOwners();
Owners.DataSource = dt6;
Owners.DisplayMember = "Owner_Name";
Owners.ValueMember = "Owner_Id";
Owners.Refresh();
}
private void UNPAY_Click(object sender, EventArgs e)
{
if (RIDT.Text.ToString() != "")
{
contobj.PayRent(0, Int32.Parse(RIDT.Text.ToString()));
MessageBox.Show("UN-Paid!!");
RS.Refresh();
dataGridView1.Refresh();
ALL_Click(sender, e);
contobj.UnPayRentToOwner(Int32.Parse(RDD.Text), Int32.Parse(Owners.SelectedValue.ToString()));
}
}
private void Search_Click(object sender, EventArgs e)
{
string a;
RS.Refresh();
if (RS.SelectedValue.ToString() == "Paid")
{
a = "1)";
}
else if (RS.SelectedValue.ToString() == "Not-Paid")
{
a = "0)";
}
else
{
a = "0 OR Rent_Statues = 1)";
}
string b;
b = " AND Rent_Amount >" + RAN.Value.ToString();
a += b;
if (Collecter.SelectedValue != null)
{
b = " AND Rent_CollecterId = " + Collecter.SelectedValue.ToString();
a += b;
}
if (DueS.Value != null)
{
b = " And Rent_DueDate <= '" + DueS.Value.ToString("yyyy-MM-dd") + "'";
a += b;
}
if (DDA.Value != null)
{
b = " And Rent_DueDate >= '" + DDA.Value.ToString("yyyy-MM-dd") + "'";
a += b;
}
if (Units.SelectedValue != null)
{
b = " And Unit_Rents_UnitId = " + Units.SelectedValue.ToString();
a += b;
}
if (tenants.SelectedValue != null)
{
b = " And Unit_Rents_TenantId = " + tenants.SelectedValue.ToString();
a += b;
}
if (BCC.SelectedValue != null)
{
b = " And Unit_BuildingNo = " + BCC.SelectedValue.ToString();
a += b;
}
DataTable dt1 = contobj.GetRentsByStat(a);
dataGridView1.DataSource = dt1;
if (dt1 != null)
{
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
dataGridView1.Columns[14].Visible = false;
dataGridView1.Columns[15].Visible = false;
dataGridView1.Columns[16].Visible = false;
dataGridView1.Columns[17].Visible = false;
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[1].HeaderText = "Amount";
dataGridView1.Columns[2].HeaderText = "Due Date";
dataGridView1.Columns[3].HeaderText = "Payment Statues";
/* dataGridView1.Columns[4].HeaderText = "Collecter Id";
* dataGridView1.Columns[5].HeaderText = "Lease Id";
* dataGridView1.Columns[6].HeaderText = "Tenant";
* dataGridView1.Columns[7].HeaderText = "Unit";
* dataGridView1.Columns[17].HeaderText = "Building ID";*/
}
dataGridView1.Refresh();
if (sender == Search)
{
MessageBox.Show("Search Done!!");
}
}
