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 void unlockorder(string userid, string centerid, string moduleid)
{
eTrackingAccessLayer objOrders = new eTrackingAccessLayer();
try
{
DataTable dt = objOrders.unlockorder(userid, centerid, moduleid).Tables[0];
}
catch (Exception ex)
{
}
}
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);
}
public JsonResult etrackingFiltersData(string xmlData)
{
List <ControlData> lst = new List <ControlData>();
eTrackingAccessLayer objOrders = new eTrackingAccessLayer();
try
{
DataTable dt = objOrders.eTrackingFiltersData(xmlData).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
ControlData p = new ControlData();
p.value = Convert.ToString(dr[0]);
p.key = Convert.ToString(dr[1]);
lst.Add(p);
}
}
}
catch (Exception ex)
{
}
return(Json(lst));
}
