public JsonResult GetParticipantsTilesData()
{
var UserSession = (CustomerDetail)Session["ChitaleEmployee"];
NoActionModelTile objData = new NoActionModelTile();
objData = pr.GetNoActionParticipantsTilesData(UserSession.CustomerId, UserSession.CustomerType);
return(new JsonResult()
{
Data = objData, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue
});
}
public NoActionModelTile GetNoActionParticipantsTilesData(string CustomerId, string CustomerType)
{
NoActionModelTile objData = new NoActionModelTile();
using (var context = new ChitaleDBContext())
{
try
{
//if (CustomerType == "Sales Executive")
//{
// CustomerType = "SalesExecutive";
//}
//else if (CustomerType == "ASM (Sales Manager)")
//{
// CustomerType = "AreaSalesManager";
//}
//else if (CustomerType == "Sales Officer")
//{
// CustomerType = "SalesOfficer";
//}
//else if (CustomerType == "Sales Representative")
//{
// CustomerType = "SalesRepresentative";
//}
//else if (CustomerType == "State Head")
//{
// CustomerType = "StateHead";
//}
//else if (CustomerType == "Zonal Head")
//{
// CustomerType = "ZonalHead";
//}
//else if (CustomerType == "National Head")
//{
// CustomerType = "NationalHead";
//}
objData = context.Database.SqlQuery <NoActionModelTile>("Chitale_NoActionByParticipant1 @pi_Date, @pi_CustomerId, @pi_CustomerType",
new SqlParameter("@pi_Date", DateTime.Now.ToString("yyyy-MM-dd")),
new SqlParameter("@pi_CustomerId", CustomerId),
new SqlParameter("@pi_CustomerType", CustomerType)).FirstOrDefault <NoActionModelTile>();
}
catch (Exception ex)
{
newexception.AddException(ex);
}
}
return(objData);
}
public NoActionModelTile GetNoActionParticipantsTilesData(string CustomerId, string CustomerType)
{
NoActionModelTile objData = new NoActionModelTile();
using (var context = new ChitaleDBContext())
{
try
{
objData = context.Database.SqlQuery <NoActionModelTile>("Chitale_NoActionByParticipant1 @pi_Date, @pi_CustomerId, @pi_CustomerType",
new SqlParameter("@pi_Date", DateTime.Now.ToString("yyyy-MM-dd")),
new SqlParameter("@pi_CustomerId", CustomerId),
new SqlParameter("@pi_CustomerType", CustomerType)).FirstOrDefault <NoActionModelTile>();
}
catch (Exception ex)
{
newexception.AddException(ex);
}
}
return(objData);
}
