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