public BILL_BillQuotationStatus CreateBillQuotationStatus(BILL_BillQuotationStatus billQuotationStatusToAdd) { using (SUPERPEntities context = new SUPERPEntities(false)) { var exist = context.BILL_BillQuotationStatus.SingleOrDefault(x => x.BillQuotation_Id == billQuotationStatusToAdd.BillQuotation_Id && x.BILL_Status.Status_Id == billQuotationStatusToAdd.BILL_Status.Status_Id); if (exist != null) return exist; else { var s = context.BILL_BillQuotationStatus.Add(billQuotationStatusToAdd); context.SaveChanges(); return s; } } }
/******************************/ /* 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 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; }
public BILL_BillQuotationStatus CreateBillQuotationStatus(BILL_BillQuotationStatus billQuotationStatusToAdd) { return DAL.CreateBillQuotationStatus(billQuotationStatusToAdd); }