public HttpResponseMessage InsertBillItem([FromBody] Bill_Item bill)
{
conn.Open();
NpgsqlCommand cmd = new NpgsqlCommand(
"INSERT INTO Bill(idbill,idsupply,quantity)" +
"VALUES(:idbill,:idsupply,:quantity)", conn);
cmd.Parameters.AddWithValue("idbill", bill.idbill);
cmd.Parameters.AddWithValue("idsupply", bill.idsupply);
cmd.Parameters.AddWithValue("quantity", bill.quantity);
cmd.Prepare();
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
conn.Close();
return(this.Request.CreateResponse(HttpStatusCode.OK, "Inserted"));
}
public static Tbl_Bill_Item MapFrom(this Bill_Item bill_Item, long?billId)
{
return(new Tbl_Bill_Item
{
Id = bill_Item.Id,
Bill_Id = billId > 0 ? billId : bill_Item.Bill_Id,
ItemId = bill_Item.ItemId,
Name = bill_Item.Name,
Quantity = bill_Item.Quantity,
Price = bill_Item.Price,
TaxId = bill_Item.TaxId,
Tax = bill_Item.Tax,
Created_At = bill_Item.Id < 0 ? DateTime.Now : default(DateTime?),
Updated_At = bill_Item.Id > 0 ? DateTime.Now : default(DateTime?),
});
}
public void AddBillItem(int billid, int ticketid)
{
var billItem = from bill in db.Bills where bill.Bill_Id == billid select bill.Bill_Id;
var ticketItem = from ticket in db.Tickets where ticket.Ticket_Id == ticketid select ticket.Ticket_Id;
if (billItem != null && ticketItem != null)
{
var item = new Bill_Item
{
Bill_Id = billItem.First(),
Ticket_Id = ticketItem.First()
};
db.Bill_Items.InsertOnSubmit(item);
db.SubmitChanges();
}
}
public void AddBillItem()
{
var item = new Bill_Item();
}
