/*Name of Function : <<getAsnList>> Author :<<Prasanna>> * Date of Creation <<07-12-2020>> * Purpose : <<function is used to get getAsnList>> * Review Date :<<>> Reviewed By :<<>>*/ public List <ASNShipmentHeader> getAsnList(ASNfilters ASNfilters) { List <ASNShipmentHeader> asnList = new List <ASNShipmentHeader>(); try { using (YSCMEntities Context = new YSCMEntities()) { Context.Configuration.ProxyCreationEnabled = false; var query = default(string); if (ASNfilters.ReportType == "Insurance") { query = "select * from ASNShipmentHeader asn inner join InvoiceDetails inv on inv.ASNId=asn.ASNId where ( Deleteflag=0 or Deleteflag is null)"; } else { query = "select * from ASNShipmentHeader asn where ( Deleteflag=0 or Deleteflag is null)"; } if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "CreatedDate") { query += " and asn.CreatedDate <= '" + ASNfilters.ToDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "CreatedDate") { query += " and asn.CreatedDate >= '" + ASNfilters.FromDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "InvoiceDate") { query += " and asn.InvoiceDate <= '" + ASNfilters.ToDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "InvoiceDate") { query += " and asn.InvoiceDate >= '" + ASNfilters.FromDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.ToDate) && ASNfilters.Type == "ShippingDate") { query += " and asn.ShippingDate <= '" + ASNfilters.ToDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.FromDate) && ASNfilters.Type == "ShippingDate") { query += " and asn.ShippingDate >= '" + ASNfilters.FromDate + "'"; } if (!string.IsNullOrEmpty(ASNfilters.Vendorid)) { query += " and asn.VendorId = '" + ASNfilters.Vendorid + "'"; } if (!string.IsNullOrEmpty(ASNfilters.InvoiceNo)) { query += " and asn.InvoiceNo = '" + ASNfilters.InvoiceNo + "'"; } if (!string.IsNullOrEmpty(ASNfilters.VendorName)) { query += " and asn.VendorName like'%" + ASNfilters.VendorName + "%'"; } if (!string.IsNullOrEmpty(ASNfilters.ASNNo)) { query += " and asn.ASNNo = '" + ASNfilters.ASNNo + "'"; } if (!string.IsNullOrEmpty(ASNfilters.PONo)) { query += " and asn.PONos = '" + ASNfilters.PONo + "'"; } query += " order by asn.ASNId desc "; asnList = Context.ASNShipmentHeaders.SqlQuery(query).ToList <ASNShipmentHeader>(); } } catch (Exception ex) { log.ErrorMessage("ASNDA", "getAsnList", ex.Message + "; " + ex.StackTrace.ToString()); } return(asnList); }
public IHttpActionResult getAsnList(ASNfilters ASNfilters) { return(Ok(_asnBusinessAccess.getAsnList(ASNfilters))); }
public List <RemoteASNShipmentHeader> getAsnList(ASNfilters ASNfilters) { return(_asnDataAcess.getAsnList(ASNfilters)); }