protected void add() { Invoice_Detail detials = new Invoice_Detail(); detials.Item_ID = Convert.ToInt32(DropDownListItem.SelectedValue); detials.Invoice_Id = Convert.ToInt32(Labelid.Text); detials.IsDisable = false; detials.Quantity = Convert.ToInt32(TextBoxquentity.Text); detials.Rectime = DateTime.Now; detials.Unit_Cost = Convert.ToDouble(textboxunticost.Text); detials.After_Disount_Price = Convert.ToDouble(TextBoxunitprice.Text); detials.Total_Cost = Convert.ToDouble(textboxunticost.Text) * Convert.ToInt32(TextBoxquentity.Text); detials.Total_Price = Convert.ToDouble(TextBoxunitprice.Text) * Convert.ToInt32(TextBoxquentity.Text); DB.Invoice_Details.InsertOnSubmit(detials); DB.SubmitChanges(); var invoice = DB.Invoices.Where(a => a.Invoice_Id.Equals(Labelid.Text)).SingleOrDefault(); invoice.Invoice_TotalCost = invoice.Invoice_TotalCost + detials.Total_Cost; invoice.Invoice_Price = invoice.Invoice_Price + detials.Total_Price; invoice.totalPrice = invoice.totalPrice + Convert.ToDecimal(detials.Total_Price); DB.Invoices.DefaultIfEmpty(invoice); DB.SubmitChanges(); databind(Labelid.Text); editinvoicemoney(Labelid.Text); }
public async Task <IActionResult> Edit(int id, [Bind("Invoice_Detail_Number,Invoice_Number,ProductId,Quantity,Total_Price")] Invoice_Detail invoice_Detail) { if (id != invoice_Detail.Invoice_Detail_Number) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(invoice_Detail); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Invoice_DetailExists(invoice_Detail.Invoice_Detail_Number)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(invoice_Detail)); }
public String ORDER(List <Models.Product> p, int id_user, string address)//IHttpActionResult GetProductLists() { Invoice i = new Invoice(); Invoice_Detail ivoiceD; decimal total = 0; try { i.Adress = address; i.id_user = id_user; i.invoice_date = DateTime.Now; int id_invoice = IM.ThemInvoiceReID(i); foreach (Models.Product item in p) { ivoiceD = new Invoice_Detail(); ivoiceD.id_product = item.id; ivoiceD.quantity = item.quantity; ivoiceD.id = id_invoice; //total += Convert.ToDecimal(item.salePrice * item.quantity); IdM.ThemInvoice_Detail(ivoiceD); } //i.total = total; total = IdM.TinhTongTienHoaDon(id_invoice); } catch (Exception e) { throw e; } return(Newtonsoft.Json.JsonConvert.SerializeObject(new Models.Invoice(i.id, i.invoice_date, i.Adress, 0, i.id_user, i.status, total))); }
public bool UpdateInvoice_Detail(int id_invoice, int id_product, int quantity) { Invoice_Detail Invoice_Detail = new Invoice_Detail(); Invoice_Detail.id = id_invoice; Invoice_Detail.id_product = id_product; Invoice_Detail.quantity = quantity; return(IdM.CapNhatInvoice_Detail(Invoice_Detail)); }
public bool ThemInvoice_Detail(Invoice_Detail invoice) { Product p = db.Products.Single(x => x.id == invoice.id_product); p.timesBooked++; PM.CapNhatProduct(p); db.Invoice_Details.InsertOnSubmit(invoice); db.SubmitChanges(); //TinhTongTienHoaDon(invoice.id); return(true); }
public async Task <IActionResult> Create([Bind("Invoice_Detail_Number,Invoice_Number,ProductId,Quantity,Total_Price")] Invoice_Detail invoice_Detail) { if (ModelState.IsValid) { _context.Add(invoice_Detail); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(invoice_Detail)); }
public bool InsertNewInvoice_Detail(int id_invoice, int id_product, int quantity) { try { Invoice_Detail Invoice_Detail = new Invoice_Detail(); Invoice_Detail.id = id_invoice; Invoice_Detail.id_product = id_product; Invoice_Detail.quantity = quantity; return(IdM.ThemInvoice_Detail(Invoice_Detail)); } catch { return(false); } }
public bool CapNhatInvoice_Detail(Invoice_Detail nv) { try { Invoice_Detail a = db.Invoice_Details.SingleOrDefault(x => x.id == nv.id && nv.id_product == x.id_product); a.quantity = nv.quantity; db.SubmitChanges(); } catch (Exception) { return(false); } TinhTongTienHoaDon(nv.id); return(true); }
private List <Invoice_Detail> Return_InvoiceDetails_ToList(InvoiceHeader_DataModel _invoiceHeader) { var result = new List <Invoice_Detail>(); IEnumerable <InvoiceDetail_DataModel> _invoiceDtlDataModel = performLookup.Return_ConsignmentInvoiceDetails_ToDataModel(_invoiceHeader.Consignment_Number, _invoiceHeader.Supplier_Invoice_No); if (_invoiceDtlDataModel != null) { foreach (InvoiceDetail_DataModel _invoiceDetail in _invoiceDtlDataModel) { Invoice_Detail _newDetail = viewModelAdapter.Map_InvoiceDetailDataModel_ToViewModel(_invoiceDetail); result.Add(_newDetail); } } return(result); }
public Invoice_Detail Map_InvoiceDetailDataModel_ToViewModel(InvoiceDetail_DataModel _invoiceDetail) { Invoice_Detail result = new Invoice_Detail() { Order_No = _invoiceDetail.Order_No, Lot_No = _invoiceDetail.Lot_No, Vat_A_Value = _invoiceDetail.Vat_A_Inv_Value, Vat_B_Value = _invoiceDetail.Vat_B_Inv_Value, Vat_C_Value = _invoiceDetail.Vat_C_Inv_Value, Vat_D_Value = _invoiceDetail.Vat_D_Inv_Value, Commodity_Code = _invoiceDetail.Commodity_Code, Country_Name = _invoiceDetail.Country_Name, Country_Code = _invoiceDetail.Country_Code, Commodity_Duty_Pct = _invoiceDetail.Duty_Per_Cent_Pcent, Supplier_Discount_Pct = _invoiceDetail.Discount_Pcent, Date_of_WRC = _invoiceDetail.Confirmed_Date, ETA_At_Port = _invoiceDetail.ETA_At_Port }; return(result); }
public Models.Invoice_Detail Lay1Invoice_Detail(int id, int id_product) { Invoice_Detail item = null; try { foreach (Invoice_Detail nv in ListInvoice_Details()) { if (nv.id == id && nv.id_product == id_product) { item = nv; break; } } //item = db.Invoice_Details.Single((x => x.id == id)); return(new Models.Invoice_Detail(item.id, item.id_product, item.quantity)); } catch (Exception e) { //throw e; return(null); } }
private decimal InvoiceDetailInsert() { LifeLineDbContext context = new LifeLineDbContext(); long _invoiceId = 0; long.TryParse(Convert.ToString(ViewState["Id"]), out _invoiceId); decimal totalAmount = 0; if (_invoiceId != 0) { DataTable dt = Create_DT(); if (dt.Rows.Count <= 0) { return(0); } var inv = context.Invoice_Detail.Where(x => x.invoiceId == _invoiceId); if (inv != null) { context.Invoice_Detail.Where(x => x.invoiceId == _invoiceId).ToList().ForEach(x => context.Invoice_Detail.DeleteObject(x)); context.SaveChanges(); } foreach (DataRow row in dt.Rows) { Invoice_Detail obj = new Invoice_Detail(); obj.invoiceId = _invoiceId; obj.loadingDate = Convert.ToString(row["LoadingDate"]) == string.Empty ? null : (DateTime?)DateTime.ParseExact(Convert.ToString(row["LoadingDate"]), "dd/MM/yyyy", CultureInfo.InvariantCulture); obj.unloadingDate = Convert.ToString(row["UnloadingDate"]) == string.Empty ? null : (DateTime?)DateTime.ParseExact(Convert.ToString(row["UnloadingDate"]), "dd/MM/yyyy", CultureInfo.InvariantCulture); decimal _freight = 0, _advance = 0, _balance = 0, _toPay = 0, _hamali = 0, _detention = 0, _otherCharge = 0, _netAmount = 0; if (decimal.TryParse(Convert.ToString(row["Freight"]), out _freight)) { obj.freight = _freight; } if (decimal.TryParse(Convert.ToString(row["Advance"]), out _advance)) { obj.advance = _advance; } if (decimal.TryParse(Convert.ToString(row["Balance"]), out _balance)) { obj.balance = _balance; } if (decimal.TryParse(Convert.ToString(row["ToPay"]), out _toPay)) { obj.toPay = _toPay; } if (decimal.TryParse(Convert.ToString(row["Hamali"]), out _hamali)) { obj.hamali = _hamali; } if (decimal.TryParse(Convert.ToString(row["Detention"]), out _detention)) { obj.detention = _detention; } if (decimal.TryParse(Convert.ToString(row["OtherCharge"]), out _otherCharge)) { obj.otherCharge = _otherCharge; } if (decimal.TryParse(Convert.ToString(row["NetAmount"]), out _netAmount)) { obj.netAmount = _netAmount; } totalAmount += _netAmount; context.AddToInvoice_Detail(obj); context.SaveChanges(); } } return(totalAmount); }