public ActionResult Empty() { //DateTime start = Convert.ToDateTime("9/5/2016"); //DateTime end = Convert.ToDateTime("9/11/2016"); //DateTime start = db.Semesters.Where(s => s.flag == true).Select(s => s.SemesterStartDate).Single(); //DateTime end = db.Semesters.Where(s => s.flag == true).Select(s => s.SemesterEndDate).Single(); DateTime today = DateTime.Now; int currentDayOfWeek = (int)today.DayOfWeek; DateTime sunday = today.AddDays(-currentDayOfWeek); DateTime monday = sunday.AddDays(1); //DateTime mon = monday.Date.ToString("dd/MM/YYYY"); if (currentDayOfWeek == 0) { monday = monday.AddDays(-7); } var dates = Enumerable.Range(0, 7).Select(days => monday.AddDays(days)).ToList(); DateTime start = dates[0].Date; DateTime end = dates[6].Date; ViewBag.dates = dates; ReportsVM vm = new ReportsVM(); vm.emptyroomscount = db.Database.SqlQuery <EmptyRoomsCountByDay_Result>("EmptyRoomsCountByDay @startdate, @enddate", new SqlParameter("@startdate", start), new SqlParameter("@enddate", end)).ToList(); return(View(vm)); }
public ActionResult GenerateReport(FormCollection form) { //if(ModelState.IsValid) //{ List <Orderd> sales = new List <Orderd>(); int range = 0; string period = form["Range"].ToString(); string business = form["BusinessName"].ToString(); ReportsVM rvm = new ReportsVM(); rvm.BusinessName = business; rvm.Range = period; Session["rvm"] = rvm; switch (period) { case "Week": range = 7; break; case "Month": range = 30; break; default: range = 365; break; } foreach (var s in db.Orderss) { if (business.Equals(s.BusName, StringComparison.OrdinalIgnoreCase)) { if (DateTime.Now.Subtract(s.OrderDate).Days <= range) { sales.Add(s); } } } //int hours = range * 24; //TimeSpan time = new TimeSpan(hours, 0, 0); //foreach(var s in sales) //{ // SalesReport r = new SalesReport(); // } Session["list"] = sales; return(RedirectToAction("Report")); //} //ViewBag.BusinessName = new SelectList(db.Users, "businessname", "businessname"); //return View(report); }
public ActionResult GetReport() { ReportsVM report = new ReportsVM(); ViewBag.BusinessName = new SelectList(db.Users, "businessname", "businessname"); return(View(report)); }
public ReportsVM GetEventReports(int eventId) { ReportsVM reports = new ReportsVM(); reports.EventReports = new EventReportVM(); reports.TicketReports = new List <TicketReportVM>(); using (var db = new TagsDataModel()) { var eventInfo = (from eventInf in db.TAGS_EVENTS where eventInf.EVENT_ID == eventId select eventInf).FirstOrDefault(); reports.EVENT_DATE = eventInfo.EVENT_DATE; reports.EVENT_ID = eventInfo.EVENT_ID; reports.EVENT_LOCATION = eventInfo.EVENT_LOCATION; reports.EVENT_NAME = eventInfo.EVENT_NAME; reports.IS_TICKETED_EVENT = eventInfo.IS_TICKETED_EVENT; if (eventInfo.IS_TICKETED_EVENT == false) { var MemberEventTotalCount = (from tickEve in db.MEMBER_EVENT_CHECKINS where tickEve.EVENT_ID == eventId select tickEve).Count(); var MemberEventCheckInCount = (from tickEve in db.MEMBER_EVENT_CHECKINS where tickEve.EVENT_ID == eventId && tickEve.IS_CHECKEDIN == true select tickEve).Count(); var MemberEventPaidCount = (from tickEve in db.MEMBER_EVENT_CHECKINS where tickEve.EVENT_ID == eventId && tickEve.IS_PAID == true select tickEve).Count(); reports.EventReports.checkIns = MemberEventCheckInCount; reports.EventReports.isPaids = MemberEventPaidCount; reports.EventReports.registrations = MemberEventTotalCount; } else if (eventInfo.IS_TICKETED_EVENT == true) { var TicketTypes = (from tick in db.TICKETED_CHECKINS where tick.EVENT_ID == eventId select new { tickType = tick.TICKET_TYPE }).ToList().Distinct(); foreach (var ticketType in TicketTypes) { var count = (from tick in db.TICKETED_CHECKINS where tick.EVENT_ID == eventId && tick.TICKET_TYPE == ticketType.tickType && tick.STATION_1 == true select tick).Count(); TicketReportVM tickReport = new TicketReportVM(); tickReport.checkIns = count; tickReport.TicketType = ticketType.tickType; reports.TicketReports.Add(tickReport); } } } return(reports); }
public ActionResult Current() { ReportsVM vm = new ReportsVM(); DateTime today = DateTime.Now; int currentDayOfWeek = (int)today.DayOfWeek; DateTime sunday = today.AddDays(-currentDayOfWeek); DateTime monday = sunday.AddDays(1); //DateTime mon = monday.Date.ToString("dd/MM/YYYY"); if (currentDayOfWeek == 0) { monday = monday.AddDays(-7); } var dates = Enumerable.Range(0, 7).Select(days => monday.AddDays(days)).ToList(); DateTime start = dates[0].Date; DateTime end = dates[6].Date; var hour = today.Hour; ViewBag.today = today.Date.ToString("dd/MMMM"); if (hour >= 0 && hour <= 10 || hour >= 22 && hour <= 23) { vm.currentclasses = db.Database.SqlQuery <CurrentClasses_Result>("CurrentClasses @dayid, @slottypeid, @currdate, @startdate, @enddate", new SqlParameter("@dayid", currentDayOfWeek), new SqlParameter("@slottypeid", 1), new SqlParameter("@currdate", today), new SqlParameter("@startdate", start), new SqlParameter("@enddate", end)).ToList(); } else if (hour >= 11 && hour <= 14) { vm.currentclasses = db.Database.SqlQuery <CurrentClasses_Result>("CurrentClasses @dayid, @slottypeid, @currdate, @startdate, @enddate", new SqlParameter("@dayid", currentDayOfWeek), new SqlParameter("@slottypeid", 2), new SqlParameter("@currdate", today), new SqlParameter("@startdate", start), new SqlParameter("@enddate", end)).ToList(); } else if (hour >= 15 && hour <= 17) { vm.currentclasses = db.Database.SqlQuery <CurrentClasses_Result>("CurrentClasses @dayid, @slottypeid, @currdate, @startdate, @enddate", new SqlParameter("@dayid", currentDayOfWeek), new SqlParameter("@slottypeid", 3), new SqlParameter("@currdate", today), new SqlParameter("@startdate", start), new SqlParameter("@enddate", end)).ToList(); } else if (hour >= 18 && hour <= 21) { vm.currentclasses = db.Database.SqlQuery <CurrentClasses_Result>("CurrentClasses @dayid, @slottypeid, @currdate, @startdate, @enddate", new SqlParameter("@dayid", currentDayOfWeek), new SqlParameter("@slottypeid", 4), new SqlParameter("@currdate", today), new SqlParameter("@startdate", start), new SqlParameter("@enddate", end)).ToList(); } return(View(vm)); }
public ActionResult GenerateReport() { ReportsVM report = new ReportsVM(); //ViewBag.BusinessName = new SelectList(db.Users, "businessname", "businessname"); var users = new List <string>(); var Query = from q in db.Users where q.businessname != "Employee" && q.businessname != "Admin" && q.businessname != null orderby q.businessname select q.businessname; users.AddRange(Query.Distinct()); ViewBag.BusinessName = new SelectList(users); return(View(report)); }
public ActionResult Report() { ReportsVM vm = (ReportsVM)Session["rvm"]; ViewBag.Business = vm.BusinessName; List <Orderd> para = (List <Orderd>)Session["list"]; List <Orderd> report = new List <Orderd>(); foreach (var o in para) { report.Add(o); } return(View(report)); }
public ActionResult PlanesdeAccion() { var model = new ReportsVM(); var planes = db.Planes.Where(p => p.Eliminado != true).OrderByDescending(p => p.anio).ToList(); List <SelectListItem> PlanesList = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "Todos" }, }; foreach (Planes plan in planes) { PlanesList.Add(new SelectListItem() { Value = plan.IdPlan.ToString(), Text = plan.NombrePlan }); } var auditorias = db.Auditorias.Where(a => a.Elimanado != true && a.IdPlan == model.idPlan).OrderBy(a => a.FechaInicio).ToList(); List <SelectListItem> auditoriasList = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "Todas" }, }; foreach (Auditorias auditoria in auditorias) { auditoriasList.Add(new SelectListItem() { Value = auditoria.IdAuditoria.ToString(), Text = auditoria.Auditoria }); } ViewBag.TypesList = PlanesList; ViewBag.SubTypesList = auditoriasList; return(View(model)); }
public ActionResult EstadoPlanEjecutivo() { var model = new ReportsVM(); var planes = db.Planes.Where(p => p.Eliminado != true).OrderByDescending(p => p.anio).ToList(); List <SelectListItem> PlanesList = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "Todos" }, }; foreach (Planes plan in planes) { PlanesList.Add(new SelectListItem() { Value = plan.IdPlan.ToString(), Text = plan.NombrePlan }); } ViewBag.TypesList = PlanesList; return(View(model)); }
// GET: Reports public ActionResult Index(int?classId, int?student, int?teacher, DateTime?date, Status?status) { ReportsVM vm = new ReportsVM(); vm.Teachers = _ReportsRepo.GetAllTeachers(); vm.Students = _ReportsRepo.GetAllStudents(); vm.Classes = _ReportsRepo.GetAllClasses(); vm.Attendances = new List <BCAttendance>(); if (classId.HasValue || student.HasValue || teacher.HasValue || date.HasValue || status.HasValue) { vm.Attendances = _ReportsRepo.GetReport(classId, student, teacher, date, status).OrderBy(a => a.Date).OrderBy(a => a.StudentClass.Student.FirstName).ToList(); vm.ClassId = classId.Value; vm.Student = student.Value; vm.Teacher = teacher.Value; vm.Status = status.Value; if (date != null) { vm.Date = date.Value; } } return(View(vm)); }
private void ReportsShow() { // Old /*ReportsViewModel reportsViewModel = new ReportsViewModel(); * reportsViewModel.Description = "Отчеты"; * var reportsView = new AltaArchive.view.ReportsView(); * reportsViewModel.View = reportsView; * * Workspace.This.Panels.Add(reportsViewModel); * Workspace.This.ActiveDocument = reportsViewModel;*/ // New solid project ReportsVM reportsVM = new ReportsVM(); reportsVM.Description = "Отчеты"; var reportsView = new AltaReportsUI.view.ReportsView(); reportsVM.View = reportsView; Workspace.This.Panels.Add(reportsVM); Workspace.This.ActiveDocument = reportsVM; }
public Reports() { InitializeComponent(); BindingContext = new ReportsVM(); }