public JsonResult GetSearchClientData(string xmlData) { DataTable dt = new DataTable(); List <List <string> > listarray = new List <List <string> >(); eTrackingAccessLayer objprovinvoice = new eTrackingAccessLayer(); try { DataSet ds = objprovinvoice.DisplayEtrackingData(xmlData); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; } List <String> columnlist = (from dc in dt.Columns.Cast <DataColumn>() select dc.ColumnName).ToList(); listarray.Add(columnlist); foreach (DataRow dr in dt.Rows) { List <String> jst = dr.ItemArray.Select(o => o.ToString()).ToList(); listarray.Add(jst); } } catch (Exception ex) { } var jsonResult = Json(listarray); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
public JsonResult ShowEtrackingData(string xmlData) { DataTable dt = new DataTable(); List <List <string> > listarray = new List <List <string> >(); eTrackingAccessLayer objprovinvoice = new eTrackingAccessLayer(); try { DataSet ds = objprovinvoice.DisplayEtrackingData(xmlData); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; } if (dt.Columns.Count > 2) { DataRow dtDr = dt.NewRow(); dtDr[20] = dt.Compute("Sum(PreVatAmount)", "").ToString(); dtDr[21] = dt.Compute("Sum(VatAmount)", "").ToString(); dtDr[22] = dt.Compute("Sum(NetAmount)", "").ToString(); dt.Rows.Add(dtDr); } List <String> columnlist = (from dc in dt.Columns.Cast <DataColumn>() select dc.ColumnName).ToList(); listarray.Add(columnlist); foreach (DataRow dr in dt.Rows) { List <String> jst = dr.ItemArray.Select(o => o.ToString()).ToList(); listarray.Add(jst); } } catch (Exception ex) { } var jsonResult = Json(listarray); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }