public DashboardMemberWebPage GetDashboardMemberWebPageData(string GroupId, string profileFlag, string connstr)
{
DashboardMemberWebPage dashboardMemberWebPage = new DashboardMemberWebPage();
using (var context = new BOTSDBContext(connstr))
{
dashboardMemberWebPage = context.Database.SqlQuery <DashboardMemberWebPage>("sp_BOTS_DashboardMemberWebPage @pi_GroupId, @pi_Date, @pi_Flag", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_Flag", profileFlag)).FirstOrDefault <DashboardMemberWebPage>();
}
return(dashboardMemberWebPage);
}
public object GetMemberWebPageResult(string GroupId, string profileFlag)
{
if (User.Identity.IsAuthenticated)
{
List <long> dataList = new List <long>();
// var userDetails = (CustomerLoginDetail)Session["UserSession"];
string connectionString = CR.GetCustomerConnString(GroupId);
try
{
DashboardMemberWebPage dataMemberWebPage = new DashboardMemberWebPage();
dataMemberWebPage = DR.GetDashboardMemberWebPageData(GroupId, profileFlag, connectionString);
dataList.Add(dataMemberWebPage.MemberBase);
dataList.Add(dataMemberWebPage.ReferringBase);
dataList.Add(dataMemberWebPage.ReferralGenerated);
dataList.Add(dataMemberWebPage.ReferralTransacted);
dataList.Add(dataMemberWebPage.ReferralTxnCount);
dataList.Add(dataMemberWebPage.BusinessGenerated);
dataList.Add(dataMemberWebPage.ProfileUpdatedCount);
if (dataMemberWebPage.MWPStatus == "No")
{
dataMemberWebPage.MWPStatusCode = 1;
}
else
{
dataMemberWebPage.MWPStatusCode = 0;
}
dataList.Add(dataMemberWebPage.MWPStatusCode);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new { Data = dataList, MaxJsonLength = Int32.MaxValue });
}
return("Invalid Token or Expired");
}
public JsonResult GetMemberWebPageResult(string profileFlag)
{
List <long> dataList = new List <long>();
var userDetails = (CustomerLoginDetail)Session["UserSession"];
try
{
DashboardMemberWebPage dataMemberWebPage = new DashboardMemberWebPage();
dataMemberWebPage = DR.GetDashboardMemberWebPageData(userDetails.GroupId, profileFlag, userDetails.connectionString);
dataList.Add(dataMemberWebPage.MemberBase);
dataList.Add(dataMemberWebPage.ReferringBase);
dataList.Add(dataMemberWebPage.ReferralGenerated);
dataList.Add(dataMemberWebPage.ReferralTransacted);
dataList.Add(dataMemberWebPage.ReferralTxnCount);
dataList.Add(dataMemberWebPage.BusinessGenerated);
dataList.Add(dataMemberWebPage.ProfileUpdatedCount);
if (dataMemberWebPage.MWPStatus == "No")
{
dataMemberWebPage.MWPStatusCode = 1;
}
else
{
dataMemberWebPage.MWPStatusCode = 0;
}
dataList.Add(dataMemberWebPage.MWPStatusCode);
}
catch (Exception ex)
{
newexception.AddException(ex, userDetails.GroupId);
}
return(new JsonResult()
{
Data = dataList, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}