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