//create a SalePerson object based on the data reader private static SalePerson createSalePerson(IDataReader dbReader) { SalePerson salePerson = new SalePerson(); salePerson.Id = Convert.ToInt32(dbReader["id"].ToString()); salePerson.LastName = dbReader["lastName"].ToString(); salePerson.FirstName = dbReader["firstName"].ToString(); salePerson.UserName = dbReader["userName"].ToString(); salePerson.Pass = dbReader["pass"].ToString(); salePerson.Email = dbReader["email"].ToString(); salePerson.PhoneNo = Convert.ToInt32(dbReader["phoneNo"].ToString()); return salePerson; }
//All district Sales Persons public List<SalePerson> getDistrictSalePersons(int districtId) { List<SalePerson> returnList = new List<SalePerson>(); dbCmd = new SqlCommand(); string sqlQuery = "SELECT SalesPerson.id, SalesPerson.lastName, SalesPerson.firstName, SalesPerson.userName, SalesPerson.pass, SalesPerson.email, SalesPerson.phoneNo FROM SalesPerson JOIN AssignedSalePerson ON SalesPerson.id = AssignedSalePerson.salePersonId JOIN District ON AssignedSalePerson.districtId = District.districtId WHERE District.districtId = @districtId "; dbCmd = DbConnection.GetDbCommand(sqlQuery); parmDistrictId.Value = districtId; dbCmd.Parameters.Add(parmDistrictId); IDataReader dbReader; dbReader = dbCmd.ExecuteReader(); while (dbReader.Read()) { SalePerson salesPerson = new SalePerson(); salesPerson.Id = Convert.ToInt32(dbReader["id"].ToString()); salesPerson.LastName = dbReader["lastName"].ToString(); salesPerson.FirstName = dbReader["firstName"].ToString(); salesPerson.UserName = dbReader["userName"].ToString(); salesPerson.Pass = dbReader["pass"].ToString(); salesPerson.Email = dbReader["email"].ToString(); salesPerson.PhoneNo = Convert.ToInt32(dbReader["phoneNo"].ToString()); returnList.Add(salesPerson); } dbCmd.Parameters.Clear(); DbConnection.Close(); return returnList; }