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