public ActionResult Index(Ericsson5gXMLSearch form) { using (var dbContext = new DatabaseContext()) { // var mst = dbContext.ericsson_5gmaster.AsQueryable(); var dtl = dbContext.ericsson_5gdetail.AsQueryable(); if (form.ToDate != null) { dtl = dtl.Where(t => t.CreatedDate <= form.ToDate.Value); } if (form.FromDate != null) { dtl = dtl.Where(t => t.CreatedDate >= form.FromDate.Value); } if (form.MOClass != null) { dtl = dtl.Where(t => t.MOClass.Contains(form.MOClass)); } if (form.ManagedElement != null) { dtl = dtl.Where(t => t.ManagedElement.Contains(form.ManagedElement)); } if (form.counter != null) { dtl = dtl.Where(t => t.counter.Contains(form.counter)); } var filterd = dtl.ToList().Take(5000); ViewBag.map = filterd; p_ericsson_5gdetail = dtl.ToList(); } return(View(form)); }
public FileResult ExportCSV(Ericsson5gXMLSearch form) { using (var dbContext = new DatabaseContext()) { var dtl = dbContext.ericsson_5gdetail.AsQueryable(); if (form.ToDate != null) { dtl = dtl.Where(t => t.CreatedDate <= form.ToDate.Value); } if (form.FromDate != null) { dtl = dtl.Where(t => t.CreatedDate >= form.FromDate.Value); } if (form.MOClass != null) { dtl = dtl.Where(t => t.MOClass.Contains(form.MOClass)); } if (form.ManagedElement != null) { dtl = dtl.Where(t => t.ManagedElement.Contains(form.ManagedElement)); } if (form.counter != null) { dtl = dtl.Where(t => t.counter.Contains(form.counter)); } List <object> ericsson_5gdetail = (from ericsson in dtl.ToList().Take(5000) select new[] { ericsson.MOClass.ToString(), ericsson.MOClassValue, ericsson.JobID, ericsson.ManagedElement, ericsson.Equipment, ericsson.MOClass1, ericsson.MOClass2, ericsson.counter, ericsson.CellName, ericsson.CounterValue, }).ToList <object>(); ericsson_5gdetail.Insert(0, new string[10] { "MOClass", "MOClassValue", "JobID", "ManagedElement", "Equipment", "MOClass1", "MOClass2", "counter", "CellName", "CounterValue" }); StringBuilder sb = new StringBuilder(); for (int i = 0; i < ericsson_5gdetail.Count; i++) { string[] ericsson_dtl = (string[])ericsson_5gdetail[i]; for (int j = 0; j < ericsson_dtl.Length; j++) { //Append data with separator. sb.Append(ericsson_dtl[j] + ','); } //Append new line character. sb.Append("\r\n"); } Ericsson5gXMLSearch ercs = new Ericsson5gXMLSearch(); return(File(Encoding.UTF8.GetBytes(sb.ToString()), "text/csv", "Ericsson.csv")); } }