public void Put(int id, [FromBody] Temp_Stock Tem)
{
Tem.Id = id;
if (ModelState.IsValid)
{
Temp_StockRepository.Update(Tem);
}
}
public void Update(Temp_Stock Tem)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = " UPDATE Temp_Stock SET ProductID = @ProductID,"
+ "Warehouse=@Warehouse,Qty = @Qty,"
+ "HasExpiryDate=@HasExpiryDate "
+ " WHERE ExpiryDate=@ExpiryDate ";
dbConnection.Open();
dbConnection.Execute(sQuery, Tem);
}
}
