public SalesPersonDTO GetOneSalesPersonByID(int businessEntityID) { SalesPersonDTO dto = new SalesPersonDTO(); DataTable dt = _SqlDa.GetDataTable(string.Format("select * from v_SalesPersons where BusinessEntityID={0}", businessEntityID.ToString()), "SalesPerson"); if (dt.Rows.Count == 1) { DataRow dr = dt.Rows[0]; LoadRowIntoDto(ref dto, dr); } return dto; }
public List<SalesPersonDTO> GetSalesPersons() { List<SalesPersonDTO> dtos = new List<SalesPersonDTO>(); DataTable dt = _SqlDa.GetDataTable("select * from v_SalesPersons order by BusinessEntityID", "SalesPersons"); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { SalesPersonDTO dto = new SalesPersonDTO(); LoadRowIntoDto(ref dto, dr); dtos.Add(dto); } } return dtos; }
//load one data row into EmployeeDTO object private void LoadRowIntoDto(ref SalesPersonDTO dto, DataRow dr) { dto.ID = RowFieldLoader.GetInt(dr, "BusinessEntityID"); dto.FirstName = RowFieldLoader.GetString(dr, "FirstName"); dto.MiddleName = RowFieldLoader.GetString(dr, "MiddleName"); dto.LastName = RowFieldLoader.GetString(dr, "LastName"); dto.BirthDate = RowFieldLoader.GetDateTime(dr, "BirthDate"); dto.Gender = RowFieldLoader.GetString(dr, "Gender"); if (dto.Gender == "M") dto.Gender = "Male"; else dto.Gender = "Female"; dto.JobTitle = RowFieldLoader.GetString(dr, "JobTitle"); dto.PhoneNumber = RowFieldLoader.GetString(dr, "PhoneNumber"); dto.PhoneNumberType = RowFieldLoader.GetString(dr, "PhoneNumberType"); dto.EmailAddress = RowFieldLoader.GetString(dr, "EmailAddress"); dto.EmailPromotion = RowFieldLoader.GetBoolean(dr, "EmailPromotion"); dto.AddressLine1 = RowFieldLoader.GetString(dr, "AddressLine1"); dto.AddressLine2 = RowFieldLoader.GetString(dr, "AddressLine2"); dto.City = RowFieldLoader.GetString(dr, "City"); dto.StateProvinceName = RowFieldLoader.GetString(dr, "StateProvinceName"); dto.PostalCode = RowFieldLoader.GetString(dr, "PostalCode"); dto.CountryRegionName = RowFieldLoader.GetString(dr, "CountryRegionName"); //sales person's properties dto.TerritoryName = RowFieldLoader.GetString(dr, "TerritoryName"); dto.TerritoryGroup = RowFieldLoader.GetString(dr, "TerritoryGroup"); dto.SalesQuota = RowFieldLoader.GetDecimal(dr, "SalesQuota"); dto.SalesYTD = RowFieldLoader.GetDecimal(dr, "SalesYTD"); dto.SalesLastYear = RowFieldLoader.GetDecimal(dr, "SalesLastYear"); if (_objOrderBL == null) _objOrderBL = new OrderBL(ref _SqlDa); dto.SalesOrders = _objOrderBL.GetOrdersBySalesPersonID(dto.ID); }