private void ResetProperty_Click(object sender, EventArgs e)
{
Agent_sproperty_agent.Clear();
Agent_sproperty_ID.Clear();
Agent_sproperty_custIDFN.Clear();
Agent_sproperty_type.ResetText();
Agent_sproperty_livarea.Clear();
Agent_sproperty_be.ResetText();
Agent_sproperty_ba.ResetText();
Agent_sproperty_year.Clear();
Agent_sproperty_loc.Clear();
Agent_sproperty_price.Clear();
issold.Checked = false;
datesold.Clear();
propsearchdatagrid.Rows.Clear();
}
private void propsearchdatagridcell(object sender, DataGridViewCellEventArgs e)
{
/////////////////just to clean the form
Agent_sproperty_agent.Clear();
Agent_sproperty_ID.Clear();
Agent_sproperty_custIDFN.Clear();
Agent_sproperty_type.ResetText();
Agent_sproperty_livarea.Clear();
Agent_sproperty_be.ResetText();
Agent_sproperty_ba.ResetText();
Agent_sproperty_year.Clear();
Agent_sproperty_loc.Clear();
Agent_sproperty_price.Clear();
issold.Checked = false;
datesold.Clear();
/////////////// end of clean form
///start populating here
try
{
if (e.RowIndex >= 0)
{
Agent_sproperty_ID.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyID"].Value.ToString();
string custidfn = "ID: " + propsearchdatagrid.Rows[e.RowIndex].Cells["outputcustomerID"].Value.ToString() + " Name: "
+ propsearchdatagrid.Rows[e.RowIndex].Cells["CustomerFN"].Value.ToString() + " "
+ propsearchdatagrid.Rows[e.RowIndex].Cells["CustomerLN"].Value.ToString();
Agent_sproperty_custIDFN.Text = custidfn;
Agent_sproperty_type.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyType"].Value.ToString();
Agent_sproperty_livarea.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyArea"].Value.ToString();
Agent_sproperty_be.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyBedrooms"].Value.ToString();
Agent_sproperty_ba.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyBathrooms"].Value.ToString();
Agent_sproperty_year.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyYear"].Value.ToString();
Agent_sproperty_loc.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyLocation"].Value.ToString();
Agent_sproperty_price.Text = propsearchdatagrid.Rows[e.RowIndex].Cells["PropertyPrice"].Value.ToString();
string agentidfirstlastname = "ID: " + propsearchdatagrid.Rows[e.RowIndex].Cells["outputAgentID"].Value.ToString() + " Name: "
+ propsearchdatagrid.Rows[e.RowIndex].Cells["AgentFN"].Value.ToString() + " "
+ propsearchdatagrid.Rows[e.RowIndex].Cells["AgentLN"].Value.ToString();
Agent_sproperty_agent.Text = agentidfirstlastname;
// end of populating
//start filling sold status and date
if (String.IsNullOrEmpty(propsearchdatagrid.Rows[e.RowIndex].Cells["TransactionID"].Value.ToString()))
{
issold.Checked = false;
datesold.Clear();
}
else
{
issold.Checked = true;
string query = "select Trans_date from Transaction where Transaction_ID = \"" + propsearchdatagrid.Rows[e.RowIndex].Cells["TransactionID"].Value.ToString() + "\"";
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter mcmd = new MySqlDataAdapter();
MySqlDataReader reader;
mcmd.SelectCommand = cmd;
reader = cmd.ExecuteReader();
if (reader.Read())
{
datesold.Text = ((DateTime)reader["Trans_date"]).ToString("d");
}
}
catch
{
MessageBox.Show("Error Occured!");
}
connection.Close();
}
}
}
catch
{
}
//end of filling sold status and date
}
////////////////////////// Property TAB //////////////////////////////////////////////////////
private void Searchproperty_Click(object sender, EventArgs e)
{
int searchparamcount = 0;
string query = "Select P.*, A.Agent_fname , A.Agent_lname, C.Customer_ID, C.Cust_fname, C.Cust_lname ";
query += "from Property P inner join Agent A on A.Agent_ID = P.Agent_ID ";
query += "inner join Registration R on R.Property_ID = P.Property_ID inner join Customer C on C.Customer_ID = R.Customer_ID where ";
if (!String.IsNullOrEmpty(Agent_sproperty_ID.Text))
{
query += "Property_ID =" + "\"" + Agent_sproperty_ID.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_type.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_type =" + "\"" + Agent_sproperty_type.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_livarea.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_area =" + "\"" + Agent_sproperty_livarea.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_be.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Br =" + "\"" + Agent_sproperty_be.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_ba.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Ba =" + "\"" + Agent_sproperty_ba.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_year.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Yr =" + "\"" + Agent_sproperty_year.Text.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_loc.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_Loc =" + "\"" + Agent_sproperty_loc.ToString() + "\"";
searchparamcount++;
}
if (!String.IsNullOrEmpty(Agent_sproperty_price.Text))
{
if (searchparamcount > 0)
{
query += " and ";
}
query += "Prop_price =" + "\"" + Agent_sproperty_price.ToString() + "\"";
searchparamcount++;
}
if (searchparamcount == 0)
{
query = "Select P.*,T.Transaction_ID ,A.Agent_fname , A.Agent_lname, C.Customer_ID, C.Cust_fname, C.Cust_lname ";
query += "from Property P inner join Agent A on A.Agent_ID = P.Agent_ID ";
query += "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";
}
//end validation + query composing
try
{
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter mcmd = new MySqlDataAdapter();
MySqlDataReader reader;
mcmd.SelectCommand = cmd;
reader = cmd.ExecuteReader();
propsearchdatagrid.Rows.Clear();
while (reader.Read())
{
this.propsearchdatagrid.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
{
MessageBox.Show("Insert less parameters for more results");
}
connection.Close();
}