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