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