public ActionResult Search(InvoiceSearchForm form) { List <Invoice> invoices = invoiceProvider.SearchInvoice(form); List <InvoiceApiPoco> retour = new List <InvoiceApiPoco>(); invoices.ForEach(x => retour.Add(new InvoiceApiPoco(x))); return(Json(retour, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(InvoiceSearchForm form) { List <Invoice> result = new List <Invoice>(); // if (form.ActiveSearch) result = invoiceProvider.SearchInvoice(form); ViewBag.contactform = form; ViewBag.InvoiceSearchForm = form; return(View(result)); }
public INVOICE.InvoiceResults SearchInvoice(InvoiceSearchForm form) { // string sql = "SELECT * FROM invoices where 1=1"; Dictionary <string, object> ins = new Dictionary <string, object>(); if (form == null) { form = new InvoiceSearchForm(); } List <string> wheres = new List <string>(); try { if (!string.IsNullOrWhiteSpace(form.CustomerRef)) { ins.Add("CustomerRef", form.CustomerRef); wheres.Add(" CustomerRef=@CustomerRef"); } if (!string.IsNullOrWhiteSpace(form.InvoiceTitle)) { ins.Add("InvoiceTitle", form.InvoiceTitle); wheres.Add(" InvoiceTitle=@InvoiceTitle"); } if (!string.IsNullOrWhiteSpace(form.InvoiceType)) { ins.Add("InvoiceType", form.InvoiceType); wheres.Add(" InvoiceType=@InvoiceType"); } if (!string.IsNullOrWhiteSpace(form.ProviderRef)) { ins.Add("ProviderRef", form.ProviderRef); wheres.Add(" ProviderRef=@ProviderRef"); } if (!string.IsNullOrWhiteSpace(form.RefInvoice)) { ins.Add("RefInvoice", form.RefInvoice); wheres.Add(" RefInvoice=@RefInvoice"); } //if (form.DateAcq.HasValue) {ins.Add("DateAcq", form.DateAcq.Value); wheres.Add(" and InvoiceTitle=@InvoiceTitle"); } //if (form.DateCreate.HasValue) {ins.Add("DateCreate", form.DateCreate.Value); wheres.Add(" and InvoiceTitle=@InvoiceTitle"); } if (form.DateInvoice.HasValue) { ins.Add("DateInvoice", form.DateInvoice.Value); wheres.Add(" DateInvoice=@DateInvoice"); } //if (form.DatePaid.HasValue) {ins.Add("DatePaid", form.DatePaid.Value); wheres.Add(" and InvoiceTitle=@InvoiceTitle"); } //if (form.DateSend.HasValue) { ins.Add("DateSend", form.DateSend.Value); wheres.Add(" and InvoiceTitle=@InvoiceTitle"); } //if (form.DateValidate.HasValue) { ins.Add("DateValidate", form.DateValidate.Value); wheres.Add( " and InvoiceTitle=@InvoiceTitle"); } string sql = " FROM invoices "; if (wheres.Count > 0) { sql += string.Join(" AND ", wheres.ToArray()); } InvoiceResults retour = new InvoiceResults(); int nb = Convert.ToInt32(this.Connector.QueryScalar("SELECT COUNT(*) as nb " + sql, ins)); retour.TotalCountResults = nb; System.Data.DataTable ret = this.Connector.Query("SELECT * " + sql, ins); retour.LoadFromDataTable(ret); return(retour); } catch (Exception ex) { throw new Exception("SearchInvoice " + ex.Message, ex); } }