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");
}
private static List <KeyValuePair <String, Object> > getSQLParameters(SupplierUrlInfo supplierUrl, SupplierInfo supplier)
{
List <KeyValuePair <String, Object> > parameters = new List <KeyValuePair <String, Object> >()
{
new KeyValuePair <String, Object>("@Id", supplierUrl.Id),
new KeyValuePair <String, Object>("@ErrorMessage", supplier.ErrorMessage),
new KeyValuePair <String, Object>("@Status", supplier.Status)
};
return(parameters);
}
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>());
}
