public ActionResult MemberWebPage() { var userDetails = (CustomerLoginDetail)Session["UserSession"]; MemberWebPage objMemberWebPage = new MemberWebPage(); objMemberWebPage = KR.GetMemberWebPageData(userDetails.GroupId, userDetails.connectionString); List <long> memberbasedataList = new List <long>(); memberbasedataList.Add(objMemberWebPage.TotalMember); memberbasedataList.Add(objMemberWebPage.ReferringBase); var lstMemberBaseData = string.Join(",", memberbasedataList); List <long> memberbaseProfileList = new List <long>(); memberbaseProfileList.Add(objMemberWebPage.TotalMember); memberbaseProfileList.Add(objMemberWebPage.NoofProfileUpdate); var lstMemberBaseProfileData = string.Join(",", memberbaseProfileList); List <long> memberbaseGiftList = new List <long>(); memberbaseGiftList.Add(objMemberWebPage.TotalMember); memberbaseGiftList.Add(objMemberWebPage.GiftPointsCount); var lstMemberBaseGiftData = string.Join(",", memberbaseGiftList); List <long> memberbaseGiftOptOutList = new List <long>(); memberbaseGiftOptOutList.Add(objMemberWebPage.ProgramOtpOut); memberbaseGiftOptOutList.Add(objMemberWebPage.PromoSMSOtpOut); var lstMemberBaseOptOutData = string.Join(",", memberbaseGiftOptOutList); List <string> referralnameList = new List <string>(); referralnameList.Add("'Issued'"); referralnameList.Add("'Redeemed'"); referralnameList.Add("'Expired'"); referralnameList.Add("'Unused'"); var lstreferralNames = string.Join(",", referralnameList); List <long> referraldataList = new List <long>(); referraldataList.Add(objMemberWebPage.ReferralPointsIssued); referraldataList.Add(objMemberWebPage.ReferralPointsRedeem); referraldataList.Add(objMemberWebPage.ReferralPointsExpired); referraldataList.Add(objMemberWebPage.ReferralPointsUnused); var lstreferraldata = string.Join(",", referraldataList); ViewBag.ReferralNames = lstreferralNames.Trim(); ViewBag.ReferralData = lstreferraldata.Trim(); ViewBag.MemberbaseProfileData = lstMemberBaseProfileData.Trim(); ViewBag.MemberbaseData = lstMemberBaseData.Trim(); ViewBag.MemberbaseGiftData = lstMemberBaseGiftData.Trim(); ViewBag.MemberbaseOptOutData = lstMemberBaseOptOutData.Trim(); return(View(objMemberWebPage)); }
public MemberWebPage GetMemberWebPageData(string GroupId, string connstr) { MemberWebPage objMemberWebPage = new MemberWebPage(); try { using (var context = new BOTSDBContext(connstr)) { objMemberWebPage = context.Database.SqlQuery <MemberWebPage>("sp_BOTS_MemberWebPage @pi_GroupId, @pi_Date, @pi_LoginId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()), new SqlParameter("@pi_LoginId", "")).FirstOrDefault <MemberWebPage>(); } } catch (Exception ex) { newexception.AddException(ex, GroupId); } return(objMemberWebPage); }