public JsonResult GetRankData() { DashboardRank rankData = new DashboardRank(); try { var UserSession = (CustomerDetail)Session["ChitaleUser"]; rankData = CDR.GetRankData(UserSession.CustomerId, UserSession.CustomerType); rankData.RankPointsStr = String.Format(new CultureInfo("en-IN", false), "{0:n}", Convert.ToDecimal(rankData.RankPoints)); UserSession.CurrentRank = Convert.ToString(rankData.CurrentRank); Session["ChitaleUser"] = UserSession; ViewBag.schoolName = rankData.CurrentRank; } catch (Exception ex) { newexception.AddException(ex); } return(new JsonResult() { Data = rankData, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue }); }
public DashboardRank GetRankData(string CustomerId, string CustomerType) { DashboardRank objRank = new DashboardRank(); DataSet retVal = new DataSet(); //SqlConnection sqlConn = new SqlConnection("Data Source=DESKTOP-JOLRHRS\\SQLEXPRESS;Initial Catalog=ChitaleLive;Integrated Security=True"); SqlConnection sqlConn = new SqlConnection("Data Source=3.110.77.122;Initial Catalog=ChitaleUAT;user id = sa; password=BO%Admin#LY!4@"); SqlCommand cmdReport = new SqlCommand("sp_Dashboard", sqlConn); SqlDataAdapter daReport = new SqlDataAdapter(cmdReport); using (cmdReport) { SqlParameter param1 = new SqlParameter("pi_CustomerId", CustomerId); SqlParameter param2 = new SqlParameter("pi_CustomerType", CustomerType); SqlParameter param3 = new SqlParameter("pi_Datetime", DateTime.Now.ToString("dd-MM-yyyy")); SqlParameter param4 = new SqlParameter("pi_Year", DateTime.Now.Year); cmdReport.CommandType = CommandType.StoredProcedure; cmdReport.Parameters.Add(param1); cmdReport.Parameters.Add(param2); cmdReport.Parameters.Add(param3); cmdReport.Parameters.Add(param4); daReport.Fill(retVal); DataTable dt = retVal.Tables[1]; objRank.CurrentRank = Convert.ToInt32(dt.Rows[0]["Rank"]); objRank.LastMonthRank = Convert.ToInt32(dt.Rows[0]["LastMonthRank"]); if (!string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["RankNoPenaltyPoints"]))) { objRank.RankPoints = Convert.ToDecimal(dt.Rows[0]["RankNoPenaltyPoints"]); } else { objRank.RankPoints = 0; } objRank.LostRank = Convert.ToInt32(dt.Rows[0]["RankNoPenalty"]); } return(objRank); }