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