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