public void Post([FromBody] Temp_Stock_Store Tems)
{
if (ModelState.IsValid)
{
Temp_Stock_StoreRepository.Add(Tems);
}
}
public void Put(int id, [FromBody] Temp_Stock_Store Tems)
{
Tems.Id = id;
if (ModelState.IsValid)
{
Temp_Stock_StoreRepository.Update(Tems);
}
}
public void Update(Temp_Stock_Store TemS)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = " UPDATE Temp_Stock_Store SET Dish = @Dish,Qty = @Qty"
+ " WHERE Id=@Id";
dbConnection.Open();
dbConnection.Query(sQuery, TemS);
}
}
public void Add(Temp_Stock_Store TemS)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO Temp_Stock_Store (Dish , Qty)"
+ " VALUES(@Dish, @Qty)";
dbConnection.Open();
dbConnection.Execute(sQuery, TemS);
}
}
