public LineCompleted(BILL_LineBillQuotation line) { base.BILL_BillQuotation = line.BILL_BillQuotation; base.BILL_Product = line.BILL_Product; base.BillQuotation_Id = line.BillQuotation_Id; base.DateLine = line.DateLine; base.LineBillQuotation_Id = line.LineBillQuotation_Id; base.Product_Id = line.Product_Id; base.Quantite = line.Quantite; if (line.BILL_Product != null) { var tva = line.BILL_Product.BILL_Vat; var unitPrice = line.BILL_Product.Price; AmountHT = unitPrice * Quantite; if (tva != null) AmountTTC = Convert.ToDouble((AmountHT * tva.Rate) + AmountHT); else AmountTTC = AmountHT; } }
public LineExtended(BILL_LineBillQuotation line, bool included) : base(line) { Included = included; }
public bool CreateBillQuotation(BillQuotationComplete billQuotationComplete) { var res = true; try { BILL_BillQuotation bill = new BILL_BillQuotation { AmountDF = billQuotationComplete.AmountDF, BILL_Transmitter = billQuotationComplete.BILL_Transmitter, Company = billQuotationComplete.Company, DateBillQuotation = billQuotationComplete.DateBillQuotation, NBill = billQuotationComplete.NBill, Vat = billQuotationComplete.Vat, Company_Id = billQuotationComplete.Company_Id, Transmitter_Id = billQuotationComplete.Transmitter_Id }; //bill = billQuotationBLL.CreateBillQutotation(bill); var status = new BILL_BillQuotationStatus { BILL_BillQuotation = bill, BillQuotation_Id = bill.BillQuotation_Id, DateAdvancement = DateTime.Now, Status_Id = billQuotationComplete.BillStatus.Status_Id }; bqsBLL.CreateBillQuotationStatus(status); billQuotationBLL.SetNumFacture(); if (billQuotationComplete.lines == null) return res; var listLine = new List<BILL_LineBillQuotation>(); foreach (var line in billQuotationComplete.lines) { var l = new BILL_LineBillQuotation { BILL_BillQuotation = bill, BILL_Product = line.BILL_Product, BillQuotation_Id = bill.BillQuotation_Id, DateLine = line.DateLine, LineBillQuotation_Id = line.LineBillQuotation_Id, Product_Id = line.Product_Id, Quantite = line.Quantite }; listLine.Add(l); } lineBLL.CreateLineBillQuotation(listLine); } catch (Exception) { res = false; } return res; }
/******************************/ /* MODIFICATION FACTURE */ /******************************/ public bool ModifyBillQuotation(BillQuotationComplete billQuotationComplete) { var res = true; try { /*** Modification de la facture/devis ***/ BILL_BillQuotation bill = new BILL_BillQuotation { BillQuotation_Id = billQuotationComplete.BillQuotation_Id, AmountDF = billQuotationComplete.AmountDF, BILL_Transmitter = billQuotationComplete.BILL_Transmitter, Company = billQuotationComplete.Company, DateBillQuotation = billQuotationComplete.DateBillQuotation, NBill = billQuotationComplete.NBill, Vat = billQuotationComplete.Vat, Company_Id = billQuotationComplete.Company_Id, Transmitter_Id = billQuotationComplete.Transmitter_Id }; var billEdit = billQuotationBLL.EditBillQuotation(bill); /*** Modification du status ***/ var status = new BILL_BillQuotationStatus { BillQuotation_Id = bill.BillQuotation_Id, DateAdvancement = DateTime.Now, Status_Id = billQuotationComplete.BillStatus.Status_Id }; //bqsBLL.CreateBillQuotationStatus(status); /*** Modification des lignes de facture ***/ var lineBDD = lineBLL.GetLineBillQuotation(billQuotationComplete.BillQuotation_Id); var lineModif = billQuotationComplete.BILL_LineBillQuotation; var listLineAModifie = new List<BILL_LineBillQuotation>(); var listLineAAjoute = new List<BILL_LineBillQuotation>(); /* TODO: METTRE A JOUR LES LIGNES FACTURES */ foreach (var line in lineModif) { if (line != null) { var l = new BILL_LineBillQuotation { BillQuotation_Id = bill.BillQuotation_Id, DateLine = line.DateLine, LineBillQuotation_Id = line.LineBillQuotation_Id, Product_Id = line.Product_Id, Quantite = line.Quantite }; var lineExist = lineBDD.SingleOrDefault(x => x.LineBillQuotation_Id == line.LineBillQuotation_Id); if (lineExist != null && lineExist.LineBillQuotation_Id != 0) { listLineAModifie.Add(l); lineBDD.Remove(l); } else { listLineAAjoute.Add(l); lineBDD.Remove(l); } } } lineBLL.CreateLineBillQuotation(listLineAAjoute); lineBLL.EditLineBillQuotation(listLineAModifie); lineBLL.DeleteLineBillQuotation(lineBDD); } catch (Exception) { res = false; } return res; }
public List<LineExtended> GetAllLines(long billQuotation_id) { var listLineExtended = lineBLL.GetLineBillQuotation(billQuotation_id).Select(l => new LineExtended(l, true)).ToList(); var listProductNotIncluded = productBLL.getListProductIncludedOrNot(billQuotation_id).Where(p => !p.included); foreach (var p in listProductNotIncluded) { var product = new ProductExtended(p, billQuotation_id); var line = new BILL_LineBillQuotation { BILL_Product = productBLL.GetProductByID(product.Product_Id), Quantite = 0, BillQuotation_Id = billQuotation_id }; listLineExtended.Add(new LineExtended(line, false)); } return listLineExtended; }