public DashboardDataDto MapToDashboardDataDto(SqlDataReader sqlDataReader)
{
DashboardDataDto dashboardDataDto = new DashboardDataDto();
if (sqlDataReader.Read())
{
dashboardDataDto.TotalCompanyCount = sqlDataReader["TotalCompanyCount"].ToInteger();
dashboardDataDto.TotalRequestCount = sqlDataReader["TotalRequestCount"].ToInteger();
dashboardDataDto.TotalBeuatyTipCount = sqlDataReader["TotalBeuatyTipCount"].ToInteger();
sqlDataReader.NextResult();
while (sqlDataReader.Read())
{
dashboardDataDto.RecentRequests.Add(CompanyRequestMapper.Instance.MapToCompanyRequestDto(sqlDataReader));
}
sqlDataReader.NextResult();
while (sqlDataReader.Read())
{
dashboardDataDto.RecentCompanies.Add(CompanyMappers.Instance.MapToCompanySummaryDto(sqlDataReader));
}
sqlDataReader.NextResult();
while (sqlDataReader.Read())
{
int companyId = sqlDataReader["CompanyId"].ToInteger();
CompanySummaryDto companyDto = dashboardDataDto.RecentCompanies.Where(item => item.Id == companyId).FirstOrDefault();
if (companyDto == null)
{
continue;
}
string imageType = sqlDataReader["ImageType"].ToString();
if (imageType == "Logo")
{
companyDto.Logo = CompanyLogoMappers.Instance.MapToCompanyLogoDto(sqlDataReader);
}
else
{
companyDto.Galleries.Add(CompanyLogoMappers.Instance.MapToCompanyLogoDto(sqlDataReader));
}
}
}
return(dashboardDataDto);
}
public Result <CompanySummaryDto> MapGetAppCompanies(SqlDataReader sqlDataReader)
{
Result <CompanySummaryDto> result = new Result <CompanySummaryDto>();
using (sqlDataReader)
{
if (sqlDataReader.Read())
{
result.TotalItems = sqlDataReader["TotalRows"].ToInteger();
}
sqlDataReader.NextResult();
while (sqlDataReader.Read())
{
result.Items.Add(MapCompanyAppToCompanySummaryDto(sqlDataReader));
}
sqlDataReader.NextResult();
while (sqlDataReader.Read())
{
int companyId = sqlDataReader["CompanyId"].ToInteger();
CompanySummaryDto companyDto = result.Items.Where(item => item.Id == companyId).FirstOrDefault();
if (companyDto == null)
{
continue;
}
string imageType = sqlDataReader["ImageType"].ToString();
if (imageType == "Logo")
{
companyDto.Logo = CompanyLogoMappers.Instance.MapToCompanyLogoDto(sqlDataReader);
}
else
{
companyDto.Galleries.Add(CompanyLogoMappers.Instance.MapToCompanyLogoDto(sqlDataReader));
}
}
}
return(result);
}
public CompanySummaryDto MapToCompanySummaryDto(SqlDataReader sqlDataReader)
{
CompanySummaryDto companyDto = new CompanySummaryDto();
companyDto.Id = sqlDataReader["Id"].ToInteger();
companyDto.Code = sqlDataReader["Code"].ToString();
companyDto.Name = sqlDataReader["Name"].ToString();
companyDto.MobileNumber = sqlDataReader["MobileNumber"].ToString();
companyDto.Description = sqlDataReader["Description"].ToString();
companyDto.OrganisationId = sqlDataReader["OrganisationId"].ToInteger();
companyDto.OrganisationId = sqlDataReader["OrganisationId"].ToInteger();
companyDto.CompanyTypeId = sqlDataReader["CompanyTypeId"].ToInteger();
companyDto.StatusId = sqlDataReader["StatusId"].ToInteger();
companyDto.EditUserId = sqlDataReader["EditUserId"].ToInteger();
companyDto.CreateUserId = sqlDataReader["CreateUserId"].ToInteger();
companyDto.EditDate = sqlDataReader["EditDate"].ToDateTime();
companyDto.CreateDate = sqlDataReader["CreateDate"].ToDateTime();
companyDto.EmailAddress = sqlDataReader["EmailAddress"].ToString();
companyDto.StatusName = sqlDataReader["StatusName"].ToString();
companyDto.StatusCode = sqlDataReader["StatusCode"].ToString();
companyDto.TotalProducts = sqlDataReader["TotalProducts"].ToInteger();
companyDto.TotalUsers = sqlDataReader["TotalUsers"].ToInteger();
companyDto.PhysicalAddressLine1 = sqlDataReader["PhysicalAddressLine1"].ToString();
companyDto.PhysicalAddressLine2 = sqlDataReader["PhysicalAddressLine2"].ToString();
companyDto.PhysicalAddressSuburb = sqlDataReader["PhysicalAddressSuburb"].ToString();
companyDto.PhysicalAddressCity = sqlDataReader["PhysicalAddressCity"].ToString();
companyDto.PhysicalAddressPostalCode = sqlDataReader["PhysicalAddressPostalCode"].ToString();
companyDto.PhysicalAddressLatitude = sqlDataReader["PhysicalAddressLatitude"].ToString();
companyDto.PhysicalAddressLongitude = sqlDataReader["PhysicalAddressLongitude"].ToString();
companyDto.RatingCount = sqlDataReader["RatingCount"].ToInteger();
companyDto.AvarageRating = sqlDataReader["AvarageRating"].ToDecimal();
companyDto.FeedbackCount = sqlDataReader["FeedbackCount"].ToInteger();
companyDto.CrudStatus = CrudStatus.UPDATE;
return(companyDto);
}
public CompanySummaryDto MapCompanyAppToCompanySummaryDto(SqlDataReader sqlDataReader)
{
CompanySummaryDto companyDto = new CompanySummaryDto();
companyDto.Id = sqlDataReader["Id"].ToInteger();
companyDto.Name = sqlDataReader["Name"].ToString();
companyDto.MobileNumber = sqlDataReader["MobileNumber"].ToString();
companyDto.Description = sqlDataReader["Description"].ToString();
companyDto.EmailAddress = sqlDataReader["EmailAddress"].ToString();
companyDto.PhysicalAddressLine1 = sqlDataReader["PhysicalAddressLine1"].ToString();
companyDto.PhysicalAddressLine2 = sqlDataReader["PhysicalAddressLine2"].ToString();
companyDto.PhysicalAddressSuburb = sqlDataReader["PhysicalAddressSuburb"].ToString();
companyDto.PhysicalAddressCity = sqlDataReader["PhysicalAddressCity"].ToString();
companyDto.PhysicalAddressPostalCode = sqlDataReader["PhysicalAddressPostalCode"].ToString();
companyDto.PhysicalAddressLatitude = sqlDataReader["PhysicalAddressLatitude"].ToString();
companyDto.PhysicalAddressLongitude = sqlDataReader["PhysicalAddressLongitude"].ToString();
companyDto.Distance = sqlDataReader["Distance"].ToInteger();
companyDto.HasPromotions = sqlDataReader["HasPromotions"].ToBoolean();
companyDto.RatingCount = sqlDataReader["RatingCount"].ToInteger();
companyDto.AvarageRating = sqlDataReader["AvarageRating"].ToDecimal();
companyDto.FeedbackCount = sqlDataReader["FeedbackCount"].ToInteger();
companyDto.CrudStatus = CrudStatus.UPDATE;
return(companyDto);
}
