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 }); }