public List <StockCreationConsumedItem> ConsumedItemsGrid()
{
var ConsumedItems = new List <StockCreationConsumedItem>();
var b = new StockCreationConsumedItem();
ConsumedItems.Add(b);
return(ConsumedItems);
}
public int InsertConsumedItems(StockCreationConsumedItem model, IDbConnection connection, IDbTransaction txn)
{
string query = @"INSERT INTO StockCreationConsumedItems
(
StockCreationId,
ItemId,
Quantity,
Rate
)
VALUES
(
@StockCreationId,
@ItemId,
@Quantity,
@Rate
);
SELECT CAST(SCOPE_IDENTITY() AS INT)";
return(connection.Query <int>(query, model, txn).First());
}
