public static int InsertExclusionItem(string itemCode)
{
ExclusionItemModel data = new ExclusionItemModel
{
ItemCode = itemCode
};
string sql = @"INSERT INTO dbo.ExclusionItems (ItemCode)
VALUES (@ItemCode);";
return(SQLDataAccess.InsertDataDatawarehouse(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));
}
public static int UpdateExclusionItem(string itemCode, string itemDesc)
{
ExclusionItemModel data = new ExclusionItemModel
{
ItemCode = itemCode,
ItemDesc = itemDesc
};
string sql = @"UPDATE dbo.ExclusionItems
SET ItemDesc = @ItemDesc
WHERE ItemCode = @ItemCode;";
return(SQLDataAccess.UpdateDataDatawarehouse(sql, data));
}
