public JsonResult GetDashboardSummeryData(string Flag) { DashboardParticipantsummary SummeryData = new DashboardParticipantsummary(); try { var UserSession = (CustomerDetail)Session["ChitaleUser"]; string IsBTD = "2"; if (Flag == "1") { IsBTD = "1"; } SummeryData = CDR.GetSummeryDetails(UserSession.CustomerId, UserSession.CustomerType, IsBTD); SummeryData.PurchaseOrderPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.OrderPointsPurchase)); SummeryData.SalesOrderPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.OrderPointsSale)); SummeryData.RedeemedPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.RedeemedPoints)); SummeryData.AddOnPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.AddOnPoints)); SummeryData.LostPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.LOP)); SummeryData.TotalPointsBalanceStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(SummeryData.BalancePoints)); } catch (Exception ex) { newexception.AddException(ex); } return(new JsonResult() { Data = SummeryData, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue }); }
public DashboardParticipantsummary GetSummeryDetails(string CustomerId, string CustomerType, string IsBTD) { DashboardParticipantsummary objDashboardsummary = new DashboardParticipantsummary(); List <TransactionMaster> objtransactionmaster = new List <TransactionMaster>(); using (var context = new ChitaleDBContext()) { objDashboardsummary = context.Database.SqlQuery <DashboardParticipantsummary>("sp_DashboardSeg_Participant @pi_CustomerId,@pi_CustomerType,@pi_Date,@pi_BTDType", new SqlParameter("@pi_CustomerId", CustomerId), new SqlParameter("@pi_CustomerType", CustomerType), new SqlParameter("@pi_Date", DateTime.Now.ToString("yyyy-MM-dd")), new SqlParameter("@pi_BTDType", IsBTD) ).FirstOrDefault <DashboardParticipantsummary>(); } return(objDashboardsummary); }