public bool SaveBusinessDetails(ClientBusiness clientBixObj) { bool returnFlag = default(bool); try { StringBuilder insertQuery = new StringBuilder("INSERT INTO [dbo].[ClientBusinessDetails]([ClientId],[BusinessCategoryTypeId],[BusinessSubCategoryType],[PayPeriodTypeId],[BusinessHours],[IsPremiumCustomer],[NegotiatedPrice],[IsBulkDataReceived],[IsMobileNumberToBePublicAccess],[LocationLongitude],[LocationLattitude],[CreatedDate],[IsActive],[BusinessDescription],[BusinessGalleryPath],[BusinessWebSite],[BusinessLogoPath],[BusinessSubCategoryNativeType])"); insertQuery.Append("VALUES(@ClientId,@BusinessCategoryTypeId,@BusinessSubCategoryType,@PayPeriodTypeId,@BusinessHours,@IsPremiumCustomer,@NegotiatedPrice,@IsBulkDataReceived,@IsMobileNumberToBePublicAccess,@LocationLongitude,@LocationLattitude,@CreatedDate,@IsActive,@BusinessDescription,@BusinessGalleryPath,@BusinessWebSite,@BusinessLogoPath,@BusinessSubCategoryNativeType);"); insertQuery.Append("SELECT CAST(scope_identity() AS int);"); clientBixObj.BizId = clientDA.AddClientBizDetails(clientBixObj, insertQuery.ToString()); returnFlag = (clientBixObj.BizId > 0) ? true : false; } catch (Exception ex) { throw ex; } return(returnFlag); }