public void Post([FromBody] RestaurantPOS_OrderInfoKOT RestaurantPOS_OrderInfoKOT)
{
if (ModelState.IsValid)
{
RestaurantPOS_OrderInfoKOTRepsitory.Add(RestaurantPOS_OrderInfoKOT);
}
}
public void Put(int ID, [FromBody] RestaurantPOS_OrderInfoKOT RestaurantPOS_OrderInfoKOT)
{
RestaurantPOS_OrderInfoKOT.ID = ID;
if (ModelState.IsValid)
{
RestaurantPOS_OrderInfoKOTRepsitory.Update(RestaurantPOS_OrderInfoKOT);
}
}
public void Update(RestaurantPOS_OrderInfoKOT RestaurantPOS_OrderInfoKOT)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "UPDATE RestaurantPOS_OrderInfoKOT SET TicketNo=@TicketNo, BillDate=@BillDate, GrandTotal=@GrandTotal, TableNo=@TableNo, Operator=@Operator, GroupName=@GroupName, TicketNote=@TicketNote"
+ " WHERE ID = @ID";
dbConnection.Open();
dbConnection.Query(sQuery, RestaurantPOS_OrderInfoKOT);
}
}
public void Add(RestaurantPOS_OrderInfoKOT RestaurantPOS_OrderInfoKOT)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO RestaurantPOS_OrderInfoKOT(TicketNo, BillDate, GrandTotal, TableNo, Operator, GroupName, TicketNote )"
+ " VALUES( @TicketNo, @BillDate, @GrandTotal, @TableNo, @Operator, @GroupName, @TicketNote)";
dbConnection.Open();
dbConnection.Query(sQuery, RestaurantPOS_OrderInfoKOT);
}
}
