public JsonResult GetRedemptionResult(string type)
{
var userDetails = (CustomerLoginDetail)Session["UserSession"];
List <object> dataList = new List <object>();
try
{
DashboardRedemption objDashboardRedemption = new DashboardRedemption();
objDashboardRedemption = DR.GetDashboardRedemption(userDetails.GroupId, type, userDetails.connectionString);
dataList.Add(objDashboardRedemption.RedeemedMembers);
dataList.Add(objDashboardRedemption.RedemptionTxnCount);
dataList.Add(objDashboardRedemption.RedeemedPoints);
dataList.Add(objDashboardRedemption.PointsValueRs);
dataList.Add(objDashboardRedemption.BusinessGenerated);
dataList.Add(objDashboardRedemption.RedeemToInvoice);
var remaining = 100 - objDashboardRedemption.PieChartGreenRedemptionRate;
dataList.Add(remaining);
dataList.Add(objDashboardRedemption.PieChartGreenRedemptionRate);
var remaining1 = 100 - objDashboardRedemption.PieChartGreenUniqueMember;
dataList.Add(remaining1);
dataList.Add(objDashboardRedemption.PieChartGreenUniqueMember);
}
catch (Exception ex)
{
newexception.AddException(ex, userDetails.GroupId);
}
return(new JsonResult()
{
Data = dataList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public DashboardRedemption GetDashboardRedemption(string GroupId, string Type, string connstr)
{
DashboardRedemption objDashboardRedemption = new DashboardRedemption();
using (var context = new BOTSDBContext(connstr))
{
objDashboardRedemption = context.Database.SqlQuery <DashboardRedemption>("sp_BOTS_DashboardRedemption @pi_GroupId, @pi_Date, @pi_LoginId, @pi_Type", new SqlParameter("@pi_GroupId", GroupId),
new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()),
new SqlParameter("@pi_LoginId", ""),
new SqlParameter("@pi_Type", Type)).FirstOrDefault <DashboardRedemption>();
}
return(objDashboardRedemption);
}
public object GetRedemptionResult(string GroupId)
{
if (User.Identity.IsAuthenticated)
{
DashboardRedemption objDashboardRedemption = new DashboardRedemption();
string connectionString = CR.GetCustomerConnString(GroupId);
List <object> dataList = new List <object>();
try
{
objDashboardRedemption = DR.GetDashboardRedemption(GroupId, "1", connectionString);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new { Data = objDashboardRedemption, MaxJsonLength = Int32.MaxValue });
}
return("Invalid Token or Expired");
}
