public int AddBilling(Entity.BillingOperation billings)
{
String Query = "INSERT into Billing (BILLINGNO,TABLENO,CUSTOMERNAME,CONTACTNO,SUBTOTAL,SERVICETAX,VAT,DISCOUNT,TOTAL,BILLINGDATE)";
Query += "values ('" + billings.BillingNo + "','" + billings.TableNo + "','" + billings.CustomerName + "','" + billings.ContactNo + "','" + billings.SubTotal + "','" + billings.ServiceTax + "','" + billings.Vat + "','" + billings.Discount + "','" + billings.Total + "','" + billings.BillingDate + "')";
return(DataAccess.ExecuteQuery(Query));
}
public int Edit(Entity.BillingOperation order, String Id)
{
String Query = "Update Orders Set Quantity='" + order.Quantity + "',Price='" + order.OrderPrice + "' Where ORDERID='" + Id + "'";
return(DataAccess.ExecuteQuery(Query));
}
public int AddOrder(Entity.BillingOperation billings)
{
String Query = "INSERT into Orders (ORDERID, CATEGORYNAME, QUANTITY, PRICE) values ('" + billings.OrderId + "','" + billings.CategoryName + "','" + billings.Quantity + "','" + billings.OrderPrice + "')";
return(DataAccess.ExecuteQuery(Query));
}
