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