public List <ClientBusiness> GetBusinessDetails(int clientId)
{
List <ClientBusiness> cbObj = new List <ClientBusiness>();
StringBuilder sb = new StringBuilder("SELECT B.ClientBusinessDetailId, B.ClientId,B.BusinessCategoryTypeId,B.BusinessSubCategoryType,B.PayPeriodTypeId,B.BusinessHours,B.IsPremiumCustomer,");
sb.Append("B.NegotiatedPrice,B.IsBulkDataReceived,B.IsMobileNumberToBePublicAccess,B.LocationLongitude,B.LocationLattitude,B.CreatedDate,");
sb.Append("B.IsActive,B.BusinessDescription,B.BusinessGalleryPath,B.BusinessWebSite,B.BusinessLogoPath,B.BusinessSubCategoryNativeType,");
sb.Append("BG.GalleryId, BG.ImageName, BG.UploadedDate FROM ClientBusinessDetails B LEFT OUTER JOIN ClientBusinessGallery BG ON ");
sb.Append("B.ClientBusinessDetailId=BG.ClientBusinessDetailId WHERE B.ClientId=@ClientId");
if (clientDA.GetFullBusinessData(clientId, sb.ToString(), cbObj))
{
return(cbObj);
}
else
{
return(null);
}
}
