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