public PreferredSuburbViewModel(string ContractorId)
{
try
{
DAL dal = new DAL();
// we will pass sql to the database
//DataTable dtfieldNames = dal.Read("select bit_skill.Skill_Id,bit_skill.Skill_Type from bit_contractor_skill,bit_skill WHERE bit_contractor_skill.Skill_Id = bit_skill.Skill_Id and Contractor_Id = 2");
//MessageBox.Show(ContractorId.ToString());
DataTable dtfieldNames = dal.Read("SELECT suburb Row, suburb FROM bit_contractor_preferred_suburb where Contractor_Id = " + ContractorId);
PassedContractorId = Convert.ToInt32(ContractorId);
//MessageBox.Show(dtfieldNames.Rows.Count.ToString());
// Add a message to the combobox for the user to select an Client
DataRow dtfieldNames1;
//This is not putting our DataRow into the DataTable. Its just 'copying' the schema of the table to our row.
// dtfieldNames1 = dtfieldNames.NewRow();
// dtfieldNames1["Row"] = "0";
// dtfieldNames1["suburb"] = "-- Select a Suburb--"; // Here We're 'inserting' the message into that column of the row
// dtfieldNames.Rows.InsertAt(dtfieldNames1, 0);
preferredSuburbColRows = dtfieldNames;
foreach (DataRow dr in dtfieldNames.Rows)
{
PreferredSuburb suburb = new PreferredSuburb(dr);
AvailableSuburbCollection.Add(suburb);
}
}
catch (Exception ex)
{
MessageBox.Show("Could not Load Contractor Suburb", "Loading Suburb" + ex.Message);
}
LoadSuburbList();
}
private void LoadSuburbList()
{
try
{
DAL dal = new DAL();
// we will pass sql to the database
DataTable dtfieldNames = dal.Read("Select distinct suburb Row, suburb from postcodes_geo where suburb not in (select suburb from bit_contractor_preferred_suburb where contractor_id = " + PassedContractorId + ") order by suburb");
// Add a message to the combobox for the user to select an Client
DataRow dtfieldNames1;
//This is not putting our DataRow into the DataTable. Its just 'copying' the schema of the table to our row.
// dtfieldNames1 = dtfieldNames.NewRow();
// dtfieldNames1["Row"] = "0";
// dtfieldNames1["suburb"] = "-- Select A Suburb --"; // Here We're 'inserting' the message into that column of the row
// dtfieldNames.Rows.InsertAt(dtfieldNames1,0);
// MessageBox.Show("DisplayMember", +dtfieldNames.D)
suburbColRows = dtfieldNames;
foreach (DataRow dr in dtfieldNames.Rows)
{
PreferredSuburb suburb = new PreferredSuburb(dr);
AvailableSuburbCollection.Add(suburb);
}
}
catch (Exception ex)
{
MessageBox.Show("Could not Load Suburb", "Loading Suburb" + ex.Message);
}
}