public void GetBusinessDetails(int businessId, ref ClientBusiness cbObj)
{
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.ClientBusinessDetailId=@BusinessId");
try
{
clientDA.GetSpecificBusinessData(businessId, sb.ToString(), ref cbObj);
}
catch (Exception ex)
{
throw ex;
}
}