public static int DeleteCustomerCoordinates(string custNum)
{
CustomerCoordinatesModel data = new CustomerCoordinatesModel
{
CustNum = custNum
};
string sql = @"DELETE
FROM dbo.Customers_Coordinates
WHERE CustNum = @CustNum;";
return(SQLDataAccess.DeleteDataDatawarehouse(sql, data));
}
public static int DeleteExclusionItem(string itemCode)
{
ExclusionItemModel data = new ExclusionItemModel
{
ItemCode = itemCode
};
string sql = @"DELETE
FROM dbo.ExclusionItems
WHERE ItemCode = @ItemCode;";
return(SQLDataAccess.DeleteDataDatawarehouse(sql, data));
}
