Esempio n. 1
0
 public void Post([FromBody] RestaurantPOS_OrderedProductBillTA RestaurantPOS_OrderedProductBillTA)
 {
     if (ModelState.IsValid)
     {
         RestaurantPOS_OrderedProductBillTARepository.Add(RestaurantPOS_OrderedProductBillTA);
     }
 }
Esempio n. 2
0
        public void Put(int OP_ID, [FromBody] RestaurantPOS_OrderedProductBillTA RestaurantPOS_OrderedProductBillTA)
        {
            RestaurantPOS_OrderedProductBillTA.OP_ID = OP_ID;

            if (ModelState.IsValid)
            {
                RestaurantPOS_OrderedProductBillTARepository.Update(RestaurantPOS_OrderedProductBillTA);
            }
        }
Esempio n. 3
0
 public void Update(RestaurantPOS_OrderedProductBillTA RestaurantPOS_OrderedProductBillTA)
 {
     using (IDbConnection dbConnection = Connection)
     {
         string sQuery = "UPDATE RestaurantPOS_OrderedProductBillTA SET  BillID=@BillID, Dish=@Dish, Rate=@Rate, Quantity=@Quantity, Amount=@Amount, VATPer=@VATPer, VATAmount=@VATAmount,STPer=@STPer,STAmount=@STAmount,SCPer=@SCPer,SCAmount=@SCAmount,DiscountPer=@DiscountPer,DiscountAmount=@DiscountAmount,TotalAmount=@TotalAmount,Notes=@Notes"
                         + " WHERE OP_ID = @OP_ID";
         dbConnection.Open();
         dbConnection.Query(sQuery, RestaurantPOS_OrderedProductBillTA);
     }
 }
Esempio n. 4
0
 public void Add(RestaurantPOS_OrderedProductBillTA RestaurantPOS_OrderedProductBillTA)
 {
     using (IDbConnection dbConnection = Connection)
     {
         string sQuery = " INSERT INTO RestaurantPOS_OrderedProductBillTA(BillID, Dish, Rate, Quantity, Amount, VATPer, VATAmount, STPer, STAmount, SCPer, SCAmount, DiscountPer, DiscountAmount, TotalAmount, Notes )"
                         + " VALUES(@BillID, @Dish, @Rate, @Quantity, @Amount, @VATPer, @VATAmount,@STPer,@STAmount,@SCPer,@SCAmount,@DiscountPer,@DiscountAmount,@TotalAmount,@Notes)";
         dbConnection.Open();
         dbConnection.Query(sQuery, RestaurantPOS_OrderedProductBillTA);
     }
 }