public void Post([FromBody] RestaurantPOS_BillingInfoEB RestaurantPOS_BillingInfoEB) { if (ModelState.IsValid) { RestaurantPOS_BillingInfoEBRepository.Add(RestaurantPOS_BillingInfoEB); } }
public void Put(int id, [FromBody] RestaurantPOS_BillingInfoEB RestaurantPOS_BillingInfoEB) { RestaurantPOS_BillingInfoEB.Id = id; if (ModelState.IsValid) { RestaurantPOS_BillingInfoEBRepository.Update(RestaurantPOS_BillingInfoEB); } }
public void Update(RestaurantPOS_BillingInfoEB RestaurantPOS_BillingInfoEB) { using (IDbConnection dbConnection = Connection) { string sQuery = "UPDATE RestaurantPOS_BillingInfoEB SET BillNo=@BillNo, BillDate=@BillDate, EBDiscountPer=@EBDiscountPer, GrandTotal=@GrandTotal, Cash=@Cash, Change=@Change, Operator=@Operator,PaymentMode=@PaymentMode,BillNote=@BillNote,ExchangeRate=@ExchangeRate,CurrencyCode=@CurrencyCode,EB_Status=@EB_Status,DiscountReason=@DiscountReason,Member_ID=@Member_ID" + " WHERE ID = @ID"; dbConnection.Open(); dbConnection.Query(sQuery, RestaurantPOS_BillingInfoEB); } }
public void Add(RestaurantPOS_BillingInfoEB Recipe_Join) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO RestaurantPOS_BillingInfoEB(Id, BillNo, BillDate, EBDiscountPer, GrandTotal, Cash, Change, Operator,PaymentMode,BillNote,ExchangeRate,CurrencyCode,EB_Status,DiscountReason,Member_ID )" + " VALUES(@Id, @BillNo, @BillDate, @EBDiscountPer, @GrandTotal, @Cash, @Change, @Operator,@PaymentMode,@BillNote,@ExchangeRate,@CurrencyCode,@EB_Status,@DiscountReason,@Member_ID )"; dbConnection.Open(); dbConnection.Execute(sQuery, Recipe_Join); } }