internal static Boolean UpdateSettingPostStatus(string connString, SettingsInfo setting)
{
List <KeyValuePair <String, Object> > parameters = getSQLParametersPostStatus(setting);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSettingPostStatus]", parameters: parameters);
return(!StatusExtension.HasError);
}
internal static bool UpdateSupplierUrlStatus(string connString, SupplierUrlInfo supplierUrl, SupplierInfo supplier)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(supplierUrl, supplier);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplierUrlStatus]", parameters: parameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>().Code == "S");
}
internal static Boolean UpdateSettingStatus(String connString, SettingsInfo setting, String errorMessage)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(setting, errorMessage);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSettingStatus]", parameters: parameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>().Code == "S");
}
/// <summary>
/// OK
/// </summary>
/// <param name="connString"></param>
/// <param name="count"></param>
/// <returns></returns>
internal static List <SupplierInfo> GetSuppliersToPost(String connString, Int32 count)
{
List <KeyValuePair <String, Object> > parameters = getSQLParametersSuppliersToPost(count);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetSuppliersToPost]", parameters: parameters);
return(Utilities.DataExtension.Serialize <SupplierInfo>(dataTable));
}
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 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 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 DataTable GetSupplierList(String connString, Int32 count)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(count);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetWebPageLinks]", parameters: parameters);
return(dataTable);
}
internal static WebsiteInfo GetWebsite(String connString, String code)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(code);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetWebsite]", parameters: parameters);
return(dataTable.SerializeFirst <WebsiteInfo>());
}
//internal static Boolean UpdateSupplierByBusinessCardsSent(String connString, List<BusinessCardInfo> cards)
//{
// Boolean success = false;
// foreach (BusinessCardInfo card in cards)
// {
// List<KeyValuePair<String, Object>> parameters = getSQLParameters(card, true);
// DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateBusinessCard]", parameters: parameters);
// card.Result = dataTable.SerializeFirst<SQLResultStatusInfo>();
// success = !StatusExtension.HasError;
// }
// return success;
//}
//private static List<KeyValuePair<String, Object>> getSQLParametersSent(BusinessCardInfo card)
//{
// List<KeyValuePair<String, Object>> parameters = new List<KeyValuePair<String, Object>>() {
// new KeyValuePair<String, Object>("@CompanyName",card.CompanyName),
// new KeyValuePair<String, Object>("@ConnectDate",card.ConnectedDate),
// new KeyValuePair<String, Object>("@ContactName",card.ContactName),
// new KeyValuePair<String, Object>("@Account",card.Account),
// new KeyValuePair<String, Object>("@ConnectStatus",card.ConnectStatus),
// new KeyValuePair<String, Object>("@InteractionStatus",card.InteractionStatus)
// };
// return parameters;
//}
internal static DataTable UpdateSetting(string connString, SettingsInfo setting)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(setting);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSetting]", parameters: parameters);
return(dataTable);
}
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 List <SupplierCategoryInfo> GetCategoryList(String connString, String code)
{
List <KeyValuePair <String, Object> > parameters = getSQLParametersForCategoryList(code);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetCategory]", parameters: parameters);
return(Utilities.DataExtension.Serialize <SupplierCategoryInfo>(dataTable));
}
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 SQLResultStatusInfo UpdateSupplierURL(String connString, String url, String status, String errorMessage, SupplierCategoryInfo category)
{
List <KeyValuePair <String, Object> > parameters = getSQLParametersStatus(url, status, errorMessage, category);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplierURL]", parameters: parameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>());
}
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 SQLResultStatusInfo UpdateEmail(String connString, String email, DateTime lastEmailRetrived)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(email, lastEmailRetrived);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSettingLastEmailRetrived]", parameters: parameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>());
}
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 DataTable GetSettingList(String connString, Int32 count, String flag)
{
List <KeyValuePair <String, Object> > parameters = getSQLParameters(flag, count);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetEmailToPost]", parameters: parameters);
return(dataTable);
}
internal static bool UpdateSupplier(String connString, SupplierInfo supplier)
{
//List<KeyValuePair<String, Object>> parameters = getSQLParameters(supplier);
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplier]", parameters: supplier.SQLParameters);
supplier.Result = dataTable.SerializeFirst <SQLResultStatusInfo>();
return(!StatusExtension.HasError);
}
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 UpdateBusinessCards(string connString, List <BusinessCardInfo> cards)
{
Boolean success = false;
foreach (BusinessCardInfo card in cards)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateBusinessCard]", parameters: card.SQLParameters);
card.Result = dataTable.SerializeFirst <SQLResultStatusInfo>();
success = !StatusExtension.HasError;
}
return(success);
}
internal static bool UpdateSuppliers(string connString, List <SupplierInfo> suppliers)
{
Boolean success = false;
foreach (SupplierInfo supplier in suppliers)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplier]", parameters: supplier.SQLParameters);
supplier.Result = dataTable.SerializeFirst <SQLResultStatusInfo>();
success = !StatusExtension.HasError;
}
return(success);
}
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);
}
internal static List <EmailInfo> GetEmails(string connString, String code)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.GetEmail]", parameters: getParameters(code));
return(dataTable.Serialize <EmailInfo>());
}
internal static DataTable GetSupplierMetadata(string connString)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.GetSupplierMetadata]");
return(dataTable);
}
//internal static bool UpdateKeyWord(string connString, KeyWordInfo keyWord)
//{
// DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.UpdateKeyWord]", parameters: keyWord.SQLParameters);
// SQLResultStatusInfo sqlResultStatus = dataTable.SerializeFirst<SQLResultStatusInfo>();
// return sqlResultStatus.Id > 0;
//}
internal static List <KeyWordDetailInfo> GetKeyWordDetails(string connString)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[GG.GetKeyWordDetail]", parameters: null);
return(dataTable.Serialize <KeyWordDetailInfo>());
}
internal static List <SettingsInfo> GetSettings(string connString)
{
DataTable dataTable = SQLExtension.GetDataTableFromCommand(connString: connString, command: "SELECT * FROM [qwi].[AB.vSettings] ORDER BY [Email]");
return(dataTable.Serialize <SettingsInfo>());
}
internal static SQLResultStatusInfo UpdateWebsite(String connString, WebsiteInfo website)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[UpdateWebsite]", parameters: website.SQLParameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>());
}
internal static SQLResultStatusInfo UpdateSupplierURL(string connString, SupplierUrlInfo supplierUrl)
{
DataTable dataTable = SQLExtension.GetDataTableFromStoredProcedure(connString: connString, storedProcedureName: "[qwi].[AB.UpdateSupplierURLMetadata]", parameters: supplierUrl.SQLParameters);
return(dataTable.SerializeFirst <SQLResultStatusInfo>());
}
