// GET: Analytics
public ActionResult Index()
{
//int user_id = 2;
user user = (user)Session[ECGlobalConstants.CurrentUserMarcker];
if (user == null || user.id == 0)
{
return(RedirectToAction("Index", "Account"));
}
#region EC-CC Viewbag
ViewBag.is_cc = is_cc;
string cc_ext = "";
if (is_cc)
{
cc_ext = "_cc";
}
ViewBag.cc_extension = cc_ext;
#endregion
int user_id = user.id;
ViewBag.user_id = user_id;
UserModel um = new UserModel(user_id);
ViewBag.um = um;
int[] _today_spanshot = glb.AnalyticsByDate(null, null, um._user.company_id, um._user.id);
ViewBag._today_spanshot = _today_spanshot;
company company_item = db.company.Where(item => (item.id == um._user.company_id)).FirstOrDefault();
if (company_item != null)
{
ViewBag.step1_delay = company_item.step1_delay;
ViewBag.step2_delay = company_item.step2_delay;
ViewBag.step3_delay = company_item.step3_delay;
ViewBag.step4_delay = company_item.step4_delay;
}
DateTime _month_end_date = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddDays(-1);
int[] _month_end_spanshot = glb.AnalyticsByDate(null, _month_end_date, um._user.company_id, um._user.id);
ViewBag._month_end_spanshot = _month_end_spanshot;
string _today = DateTimeHelper.ConvertDateToLongMonthString(DateTime.Today);
ViewBag._today = _today;
// DataTable dtSecondaryTypes = glb.SecondaryTypesByDate( um._user.company_id, um._user.id);
// DataTable dtCompanyRelationships = glb.RelationshipToCompanyByDate( um._user.company_id, um._user.id);
// ViewBag._dtSecondaryTypes = dtSecondaryTypes;
// ViewBag._dtCompanyRelationships = dtCompanyRelationships;
//int[] _company_average_days = glb.AverageStageDays(um._user.company_id, um._user.id);
//int[] _average_stage_days = new int[] { _company_average_days[0] - 2, _company_average_days[1] - 3, _company_average_days[2] - 5, _company_average_days[3] - 5, _company_average_days[4] - 7 };
//ViewBag._company_average_days = _company_average_days;
//ViewBag._average_stage_days = _average_stage_days;
// DataTable dtCompanyLocationReport = glb.CompanyLocationReport(um._user.company_id, um._user.id);
//ViewBag._dtCompanyLocationReport = glb.ConvertDataTabletoString(dtCompanyLocationReport);
// DataTable dtCompanyDepartmentReport = glb.CompanyDepartmentReport( um._user.company_id, um._user.id);
//ViewBag._dtCompanyDepartmentReport = glb.ConvertDataTabletoString(dtCompanyDepartmentReport);
//DataTable dtAnalyticsTimeline = glb.AnalyticsTimeline(um._user.company_id, um._user.id);
//ViewBag._dtAnalyticsTimeline = glb.ConvertDataTabletoString(dtAnalyticsTimeline);
GlobalFunctions f = new GlobalFunctions();
List <Tuple <string, string> > temp_tuple = f.DepartmentsListDistinct(user.company_id, user.id);
ViewBag.dropDownFirst = temp_tuple;
temp_tuple = f.LocationsListDistinct(user.company_id, user.id);
ViewBag.dropDownSecond = temp_tuple;
temp_tuple = f.SecondaryTypesListDistinct(user.company_id, user.id);
ViewBag.dropDownThird = temp_tuple;
temp_tuple = f.RelationTypesListDistinct(user.company_id, user.id);
ViewBag.dropDownFourth = temp_tuple;
return(View());
}
