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