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"));
}
}
