public JsonResult GetBulkUploadResult()
{
List <object> dataList = new List <object>();
var userDetails = (CustomerLoginDetail)Session["UserSession"];
try
{
DashboardBulkUpload objDashboardBulkUpload = new DashboardBulkUpload();
objDashboardBulkUpload = DR.GetDashboardBulkUpload(userDetails.GroupId, userDetails.connectionString);
if (objDashboardBulkUpload != null)
{
dataList.Add(objDashboardBulkUpload.TotalUpload);
dataList.Add(objDashboardBulkUpload.UniqueTransacted);
dataList.Add(objDashboardBulkUpload.TransactedCount);
dataList.Add(objDashboardBulkUpload.BusinessGenerated);
dataList.Add(objDashboardBulkUpload.PieChartYellow);
dataList.Add(objDashboardBulkUpload.PieChartGreen);
}
}
catch (Exception ex)
{
newexception.AddException(ex, userDetails.GroupId);
}
return(new JsonResult()
{
Data = dataList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public DashboardBulkUpload GetDashboardBulkUpload(string GroupId, string connstr)
{
DashboardBulkUpload objDashboardBulkUpload = new DashboardBulkUpload();
using (var context = new BOTSDBContext(connstr))
{
objDashboardBulkUpload = context.Database.SqlQuery <DashboardBulkUpload>("sp_BOTS_DashboardBulkUpload @pi_GroupId, @pi_Date, @pi_LoginId", new SqlParameter("@pi_GroupId", GroupId),
new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()),
new SqlParameter("@pi_LoginId", "")).FirstOrDefault <DashboardBulkUpload>();
}
return(objDashboardBulkUpload);
}
public JsonResult GetBulkUploadResult(string GroupId)
{
List <object> dataList = new List <object>();
DashboardBulkUpload objDashboardBulkUpload = new DashboardBulkUpload();
string connectionString = CR.GetCustomerConnString(GroupId);
try
{
objDashboardBulkUpload = DR.GetDashboardBulkUpload(GroupId, connectionString);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new JsonResult()
{
Data = objDashboardBulkUpload, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public Object GetBulkUploadResult(string GroupId)
{
if (User.Identity.IsAuthenticated)
{
List <object> dataList = new List <object>();
DashboardBulkUpload objDashboardBulkUpload = new DashboardBulkUpload();
string connectionString = CR.GetCustomerConnString(GroupId);
try
{
objDashboardBulkUpload = DR.GetDashboardBulkUpload(GroupId, connectionString);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new { Data = objDashboardBulkUpload, MaxJsonLength = Int32.MaxValue });
}
return("Invalid Token or Expired");
}
