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