private void MReset_Click(object sender, EventArgs e)
{
Manager_sproperty_ID.Clear();
Manager_sproperty_custID.Clear();
Manager_sproperty_agentID.Clear();
Manager_sproperty_be.ResetText();
Manager_sproperty_ba.ResetText();
Manager_sproperty_type.ResetText();
Manager_sproperty_year.Clear();
Manager_sproperty_livarea.Clear();
Manager_sproperty_price.Clear();
Manpropsearchdatagrid.Rows.Clear();
}
private void MSearchproperty_Click(object sender, EventArgs e)
{
int searchparamcount = 0;
string query = "select P.* , P.Agent_ID , T.Transaction_ID, T.Trans_date, T.Flatrate, T.Additional, T.GST, C.Customer_ID, C.Cust_fname, C.Cust_lname, C.Cust_address, C.Cust_phone, A.Agent_fname,A.Agent_lname, P.Prop_price, R.Reg_date ";
query += "from Property P inner join Agent A on A.Agent_ID = P.Agent_ID inner join Registration R on R.Property_ID = P.Property_ID ";
query += "inner join Customer C on C.Customer_ID = R.Customer_ID ";
query += "left join Transaction T on T.Property_ID = P.Property_ID where ";
if (!String.IsNullOrEmpty(Manager_sproperty_ID.Text))
{
query += "P.Property_ID =" + "\"" + Manager_sproperty_ID.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_custID.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "C.Customer_ID =" + "\"" + Manager_sproperty_custID.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_agentID.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "A.Agent_ID =" + "\"" + Manager_sproperty_agentID.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_be.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Br =" + "\"" + Manager_sproperty_be.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_ba.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Ba =" + "\"" + Manager_sproperty_ba.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_type.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_type =" + "\"" + Manager_sproperty_type.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_year.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Yr =" + "\"" + Manager_sproperty_year.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_livarea.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_area =" + "\"" + Manager_sproperty_livarea.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Manager_sproperty_price.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_price =" + "\"" + Manager_sproperty_price.ToString() + "\"";
searchparamcount++;
}
if (searchparamcount == 0)
{
query = "select P.* , P.Agent_ID , T.Transaction_ID, T.Trans_date, T.Flatrate, T.Additional, T.GST, C.Customer_ID, C.Cust_fname, C.Cust_lname, C.Cust_address, C.Cust_phone, A.Agent_fname,A.Agent_lname, P.Prop_price, R.Reg_date ";
query += "from Property P inner join Agent A on A.Agent_ID = P.Agent_ID inner join Registration R on R.Property_ID = P.Property_ID ";
query += "inner join Customer C on C.Customer_ID = R.Customer_ID ";
query += "left join Transaction T on T.Property_ID = P.Property_ID";
}
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter mcmd = new MySqlDataAdapter();
MySqlDataReader reader;
mcmd.SelectCommand = cmd;
reader = cmd.ExecuteReader();
Manpropsearchdatagrid.Rows.Clear();
while (reader.Read())
{
this.Manpropsearchdatagrid.Rows.Add(
reader["Property_ID"].ToString(),
reader["Prop_type"].ToString(),
reader["Prop_area"].ToString(),
reader["Prop_Br"].ToString(),
reader["Prop_Ba"].ToString(),
reader["Prop_Yr"].ToString(),
reader["Prop_Loc"].ToString(),
reader["Prop_price"].ToString(),
reader["Transaction_ID"].ToString(),
reader["Customer_ID"].ToString(),
reader["Cust_fname"].ToString(),
reader["Cust_lname"].ToString(),
reader["Agent_ID"].ToString(),
reader["Agent_fname"].ToString(),
reader["Agent_lname"].ToString()
);
}
}
catch (Exception exer)
{
MessageBox.Show(exer.Message);
}
connection.Close();
}
