public IEnumerable<BillQuotationLight> GetBillQuotationByStatus(BILL_Status status)
{
var res = new List<BillQuotationLight>();
try
{
var list = billQuotationDAL.GetBillQuotation().Select(b => new BillQuotationLight(b)).Where(bq => bq.BillStatus.Status_Id == status.Status_Id);
if (list != null && list.Count() > 0)
res = list.ToList();
}
catch (Exception ex)
{
throw new Exception(" BillQuotationBLL >> GetBillQuotationByStatus :" + ex.Message);
}
return res;
}
public List<BillQuotationLight> SearchBillQuotation(string nomClient, string numFact, DateTime? dateDocument, BILL_Status status, int? MontantHTMin, int? MontantHTMax, bool? isBill)
{
var list = new List<BillQuotationLight>();
var noFilter = string.IsNullOrEmpty(nomClient) & string.IsNullOrEmpty(numFact) & dateDocument == null
& status == null & MontantHTMin == null & MontantHTMax == null & isBill == null;
if (noFilter)
list = billQuotationBLL.GetBillQuotation().ToList();
/*** Filtre client ***/
if (nomClient != null)
list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.Company.name == nomClient).ToList());
/*** Filtre numero ***/
if (numFact != null)
if (list.Count == 0)
{
var bill = billQuotationBLL.GetBillByNum(numFact);
if (bill != null)
list.Add(bill);
}
else
list.Where(b => b.NBill == numFact);
/*** Filtre status ***/
if (status != null)
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetBillQuotationByStatus(status));
else
list.Where(b => b.BillStatus.Status_Id == status.Status_Id);
/*** Filtre date du document ***/
if (dateDocument != null)
{
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.DateBillQuotation.Date == dateDocument.Value.Date).ToList());
else
list.Where(b => b.DateBillQuotation.Date == dateDocument.Value.Date);
}
/*** Filtre MontantHTMin ***/
if (MontantHTMin != null)
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.AmountDF >= MontantHTMin).ToList());
else
list.Where(b => b.AmountDF >= MontantHTMin);
/*** Filtre MontantHTMax ***/
if (MontantHTMax != null)
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.AmountDF <= MontantHTMax).ToList());
else
list.Where(b => b.AmountDF <= MontantHTMax);
///*** Filtre MontantTTCMin ***/
//if (MontantTTCMin != null)
// if (list.Count == 0)
// list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.AmountTTC > MontantTTCMin).ToList());
// else
// list.Where(b => b.AmountTTC > MontantTTCMin);
///*** Filtre MontantTTCMax ***/
//if (MontantTTCMax != null)
// if (list.Count == 0)
// list.AddRange(billQuotationBLL.GetBillQuotation().Where(b => b.AmountTTC < MontantTTCMax).ToList());
// else
// list.Where(b => b.AmountTTC < MontantTTCMax);
/*** Filtre isbill ***/
if (isBill != null)
if (Convert.ToBoolean(isBill))
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetBills().ToList());
else
list.Where(b => b.NBill == null);
else
if (list.Count == 0)
list.AddRange(billQuotationBLL.GetQuotations().ToList());
else
list.Where(b => b.NBill != null);
return list;
}
