public DashboardMemberSegment GetDashboardMemberSegmentData(string GroupId, string OutletId, string connstr)
{
DashboardMemberSegment dashboardMemberSegment = new DashboardMemberSegment();
using (var context = new BOTSDBContext(connstr))
{
dashboardMemberSegment = context.Database.SqlQuery <DashboardMemberSegment>("sp_BOTS_DashboardMemberSegment @pi_GroupId, @pi_Date, @pi_OutletId", new SqlParameter("@pi_GroupId", GroupId), new SqlParameter("@pi_Date", DateTime.Now.ToString("yyyy-MM-dd")), new SqlParameter("@pi_OutletId", OutletId)).FirstOrDefault <DashboardMemberSegment>();
DateTime?FromDate;
if (!string.IsNullOrEmpty(OutletId))
{
OutletId = OutletId + "01";
FromDate = context.TransactionMasters.Where(x => x.CounterId == OutletId).OrderBy(y => y.Datetime).Select(z => z.Datetime).FirstOrDefault();
}
else
{
FromDate = context.TransactionMasters.OrderBy(y => y.Datetime).Select(z => z.Datetime).FirstOrDefault();
}
if (FromDate.HasValue)
{
dashboardMemberSegment.FromDate = FromDate.Value.ToString("MM-dd-yyyy");
dashboardMemberSegment.ToDate = DateTime.Now.ToString("MM-dd-yyyy");
}
}
return(dashboardMemberSegment);
}
public JsonResult GetMemberSegmentResult(string OutletId)
{
List <object> lstData = new List <object>();
List <long> dataList = new List <long>();
var userDetails = (CustomerLoginDetail)Session["UserSession"];
try
{
List <string> lstDates = new List <string>();
DashboardMemberSegment dataMemberSegment = new DashboardMemberSegment();
dataMemberSegment = DR.GetDashboardMemberSegmentData(userDetails.GroupId, OutletId, userDetails.connectionString);
dataList.Add(dataMemberSegment.NoofMember_Total);
dataList.Add(dataMemberSegment.NoofMember_Repeat);
dataList.Add(dataMemberSegment.NoofMember_NeverRedeem);
dataList.Add(dataMemberSegment.NoofMember_RecentlyEnrolled);
dataList.Add(dataMemberSegment.NoofMember_OnlyOnce);
lstDates.Add(dataMemberSegment.FromDate);
lstDates.Add(dataMemberSegment.ToDate);
lstData.Add(dataList);
lstData.Add(lstDates);
}
catch (Exception ex)
{
newexception.AddException(ex, userDetails.GroupId);
}
//lstMember = RR.GetMemberList(SearchText);
return(new JsonResult()
{
Data = lstData, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public JsonResult GetMemberSegmentResult(string GroupId, string OutletId)
{
List <object> lstData = new List <object>();
List <long> dataList = new List <long>();
DashboardMemberSegment dataMemberSegment = new DashboardMemberSegment();
try
{
List <string> lstDates = new List <string>();
string connectionString = CR.GetCustomerConnString(GroupId);
dataMemberSegment = DR.GetDashboardMemberSegmentData(GroupId, OutletId, connectionString);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new JsonResult()
{
Data = dataMemberSegment, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public Object GetMemberSegmentResult(string GroupId, string OutletId)
{
if (User.Identity.IsAuthenticated)
{
List <object> lstData = new List <object>();
List <long> dataList = new List <long>();
DashboardMemberSegment dataMemberSegment = new DashboardMemberSegment();
try
{
List <string> lstDates = new List <string>();
string connectionString = CR.GetCustomerConnString(GroupId);
dataMemberSegment = DR.GetDashboardMemberSegmentData(GroupId, OutletId, connectionString);
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(new { Data = dataMemberSegment, MaxJsonLength = Int32.MaxValue });
}
return("Invalid Token or Expired");
}