public void Post([FromBody] RestaurantPOS_BillingInfoHD RestaurantPOS_BillingInfoHD) { if (ModelState.IsValid) { RestaurantPOS_BillingInfoHDRepository.Add(RestaurantPOS_BillingInfoHD); } }
public void Put(int Id, [FromBody] RestaurantPOS_BillingInfoHD RestaurantPOS_BillingInfoHD) { RestaurantPOS_BillingInfoHD.Id = Id; if (ModelState.IsValid) { RestaurantPOS_BillingInfoHDRepository.Update(RestaurantPOS_BillingInfoHD); } }
public void Update(RestaurantPOS_BillingInfoHD RestaurantPOS_BillingInfoHD) { using (IDbConnection dbConnection = Connection) { string sQuery = " UPDATE RestaurantPOS_BillingInfoHD SET BillNo=@BillNo, BillDate=@BillDate,Operator=@Operator, HDDiscountPer=@HDDiscountPer,SubTotal=@SubTotal,HomeDeliveryCharges=@HomeDeliveryCharges, GrandTotal=@GrandTotal,CustomerName=@CustomerName, ContactNo=@ContactNo,Address=@Address ,Employee_ID=@Employee_ID, PaymentMode=@PaymentMode,BillNote=@BillNote,DiscountReason=@DiscountReason,Member_ID =@Member_ID" + " WHERE ID = @ID"; dbConnection.Open(); dbConnection.Query(sQuery, RestaurantPOS_BillingInfoHD); } }
public void Add(RestaurantPOS_BillingInfoHD RestaurantPOS_BillingInfoHD) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO RestaurantPOS_BillingInfoHD(BillNo, BillDate, Operator, HDDiscountPer, SubTotal, HomeDeliveryCharges, GrandTotal, CustomerName, ContactNo, Address, Employee_ID, PaymentMode, BillNote, DiscountReason, Member_ID)" + " VALUES( @BillNo, @BillDate,@Operator, @HDDiscountPer,@SubTotal,@HomeDeliveryCharges, @GrandTotal,@CustomerName, @ContactNo,@Address ,@Employee_ID, @PaymentMode,@BillNote,@DiscountReason,@Member_ID )"; dbConnection.Open(); dbConnection.Execute(sQuery, RestaurantPOS_BillingInfoHD); } }