コード例 #1
0
        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);
        }