public List <StockCreationFinishedGood> FinishedGoodsGrid()
{
var FinishedGoods = new List <StockCreationFinishedGood>();
var a = new StockCreationFinishedGood();
FinishedGoods.Add(a);
return(FinishedGoods);
}
public int InsertFinishedGoods(StockCreationFinishedGood model, IDbConnection connection, IDbTransaction txn)
{
string query = @"INSERT INTO StockCreationFinishedGoods
(
StockCreationId,
ItemId,
Quantity,
Rate
)
VALUES
(
@StockCreationId,
@ItemId,
@Quantity,
@Rate
);
SELECT CAST(SCOPE_IDENTITY() AS INT)";
return(connection.Query <int>(query, model, txn).First());
}
