public CampaignTiles GetCampaignTilesData(string GroupId, string connstr)
{
CampaignTiles objCampaignTiles = new CampaignTiles();
try
{
using (var context = new BOTSDBContext(connstr))
{
objCampaignTiles = context.Database.SqlQuery <CampaignTiles>("sp_BOTS_CampaignMeasurement @pi_GroupId, @pi_Date, @pi_LoginId ",
new SqlParameter("@pi_GroupId", GroupId),
new SqlParameter("@pi_Date", DateTime.Now.ToShortDateString()),
new SqlParameter("@pi_LoginId", "")).FirstOrDefault <CampaignTiles>();
}
}
catch (Exception ex)
{
newexception.AddException(ex, GroupId);
}
return(objCampaignTiles);
}
public ActionResult Campaign()
{
CampaignTiles objCampaignTiles = new CampaignTiles();
var userDetails = (CustomerLoginDetail)Session["UserSession"];
objCampaignTiles = CMPR.GetCampaignTilesData(userDetails.GroupId, userDetails.connectionString);
List <SelectListItem> MonthList = new List <SelectListItem>();
for (int i = 0; i < 12; i++)
{
MonthList.Add(new SelectListItem
{
Text = Convert.ToString(DateTime.Now.AddMonths(i).ToString("MMM")),
Value = Convert.ToString(DateTime.Now.AddMonths(i).Month)
});
}
List <SelectListItem> YearList = new List <SelectListItem>();
int year = DateTime.Now.Year;
objCampaignTiles.year = DateTime.Now.Year;
objCampaignTiles.month = DateTime.Now.Month;
for (int i = -5; i <= 9; i++)
{
YearList.Add(new SelectListItem
{
Text = Convert.ToString(DateTime.Now.AddYears(i).Year.ToString()),
Value = Convert.ToString(year + i)
});
}
objCampaignTiles.lstMonth = MonthList;
objCampaignTiles.lstYear = YearList;
return(View(objCampaignTiles));
}
