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);
}
