Esempio n. 1
0
        internal static bool UpdateKeyWordDetailAfter(string connString, KeyWordDetailInfo keyWordDetail)
        {
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.UpdateKeyWordDetailAfter]", parameters: keyWordDetail.SQLParametersAfter);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id > 0);
        }
Esempio n. 2
0
        internal static bool UpdateSearchHistory(string connString, KeyWordInfo keyWord)
        {
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.UpdateSearchHistory]", parameters: keyWord.SQLParametersForHistory);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id > 0);
        }
Esempio n. 3
0
        internal static Int32 UpdateProductCategory(String connString, SupplierCategoryInfo category)
        {
            DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateProductCategory]", parameters: category.SQLParameters);

            SQLResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();
            return(SQLResultStatus.Id);
        }
Esempio n. 4
0
        internal static bool UpdateEmail(string connString, EmailInfo email)
        {
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.UpdateEmailSent]", parameters: email.SQLParameters);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id > 0);
        }
Esempio n. 5
0
        internal static Boolean AddHotel(String connString, HotelInfo hotel)
        {
            DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[DL.UpdateHotel]", parameters: hotel.SQLParameters);

            SQLResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();
            return(SQLResultStatus.Id > 0);
        }
Esempio n. 6
0
        internal static int UpdateSeller(string connString, SellerInfo seller)
        {
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AZ.UpdateSeller]", parameters: seller.SQLParameters);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id);
        }
Esempio n. 7
0
        internal static Boolean UpdateProduct(string connString, ProductInfo product)
        {
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AZ.UpdateProduct]", parameters: product.SQLParameters);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id > 0);
        }
Esempio n. 8
0
        internal static bool UpdateSupplierCategoryStatus(string connString, SupplierCategoryInfo category)
        {
            Boolean success = false;
            List <KeyValuePair <String, Object> > parameters = getSQLParametersStatus(category);
            DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateCategoryStatus]", parameters: parameters);

            SQLResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();
            success         = !StatusExtension.HasError;
            return(success);
        }
Esempio n. 9
0
        internal static Int32 UpdateSupplierCategory(String connString, SupplierCategoryInfo supplierCategory)
        {
            if (String.IsNullOrEmpty(supplierCategory.Url))
            {
                SQLResultStatus.Status = "***";
            }
            DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplierCategory]", parameters: supplierCategory.SQLParameters);

            SQLResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();
            return(SQLResultStatus.Id);
        }
Esempio n. 10
0
        internal static bool UpdateVedCodeCrossLink(string connString, KeyWordInfo keyWord, Dictionary <String, String> veds)
        {
            List <KeyValuePair <String, Object> > parameters = new List <KeyValuePair <String, Object> >()
            {
                new KeyValuePair <String, Object>("@KeyWord", keyWord.KeyWordToSearch),
                new KeyValuePair <String, Object>("@DetailId", -1),
                new KeyValuePair <String, Object>("@Veds", KeyWordDetailInfo.GetVedsDataTable(veds))
            };
            DataTable           dataTable       = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.UpdateVedCodeCrossLink]", parameters: parameters);
            SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst <SQLResultStatusInfo>();

            return(sqlResultStatus.Id > 0);
        }