public DataTypeViewModel(SubjectsViewModel svm, string title, bool isIncluded)
{
_svm = svm;
_inlTitle = title;
_inlIsIncluded = isIncluded;
}
async Task FetchData()
{
ViewModel = new SubjectsViewModel();
ViewModel.Subjects = new List <Subject>();
var response = await _subjectData.SubjectsAsync();
if (response.Count > 0)
{
ViewModel.Subjects = response;
}
}
public ActionResult Create([Bind(Include = "Subject_Code,DescriptiveTitle,Stream_Code")] SubjectsViewModel subjectsViewModel)
{
if (ModelState.IsValid)
{
subjectbl.AddSubject(subjectsViewModel);
return(RedirectToAction("Index"));
}
ViewBag.Stream_Code = new SelectList(db.StreamTables, "Stream_Code", "Description", subjectsViewModel.Stream_Code);
return(View(subjectsViewModel));
}
public void AddSubject(SubjectsViewModel model)
{
var newsubject = new Subjects
{
Subject_Code = model.Subject_Code,
DescriptiveTitle = model.DescriptiveTitle,
Stream_Code = model.Stream_Code
};
uow.Repository <Subjects>().Insert(newsubject);
uow.Save();
}
public GroupViewModel(SubjectsViewModel svm, String studyGroup, ComputeGroup computeGroup)
{
_svm = svm;
_inlStudyGroup = studyGroup;
if (computeGroup == ComputeGroup.GroupOne)
_inlExperimentGroup = "Group 1";
else if (computeGroup == ComputeGroup.GroupTwo)
_inlExperimentGroup = "Group 2";
else
_inlExperimentGroup = "None";
}
public IActionResult Index()
{
IEnumerable <IdNameViewModel> subjects = this.subjectsService.GetAll();
string username = "******";
DateTime timeNow = DateTime.UtcNow;
SubjectsViewModel subjectsViewModel = new SubjectsViewModel();
subjectsViewModel.Subjects = subjects;
subjectsViewModel.Username = username;
subjectsViewModel.TimeNow = timeNow;
return(this.View(subjectsViewModel));
}
private void MainPage_Loading(FrameworkElement sender, object args)
{
this.MainPageViewModel = new MainPageViewModel {
};
this.StudentsViewModel = new StudentsViewModel {
};
this.SubjectsViewModel = new SubjectsViewModel {
};
this.MainPageViewModel.Students = AppData.Students;
this.MainPageViewModel.Subjects = AppData.Subjects;
this.StudentsViewModel.Students = AppData.Students;
this.SubjectsViewModel.Subjects = AppData.Subjects;
}
public ActionResult UpdateSubjects(SubjectsViewModel vm)
{
try
{
if (vm.Subjects != null)
{
SubjectsRepository.UpdateSubjects(vm.Subjects);
TempData["success"] = "1";
}
}
catch (Exception ex)
{
TempData["success"] = "0";
}
return(RedirectToAction("Show"));
}
public ActionResult AddSubject(SubjectsViewModel vm)
{
string title = vm.Title;
try
{
if (title != null && title != string.Empty)
{
SubjectsRepository.AddSubject(title, vm.IsZip);
TempData["subjectAdded"] = "1";
}
}
catch (Exception ex)
{
TempData["subjectAdded"] = "0";
}
return(RedirectToAction("Show"));
}
public override void Execute(object parameter)
{
List <SubjectModel> subjectModels = DataProvider.GetSubjects();
EnumerationUtil.Enumerate(subjectModels);
SubjectsViewModel subjectsViewModel = new SubjectsViewModel();
subjectsViewModel.AllSubjects = subjectModels;
SubjectsControl subjectsControl = new SubjectsControl();
subjectsControl.DataContext = subjectsViewModel;
subjectsViewModel.Subjects = new ObservableCollection <SubjectModel>(subjectModels);
MainWindow mainWindow = (MainWindow)mainViewModel.Window;
mainWindow.GrdCenter.Children.Clear();
mainWindow.GrdCenter.Children.Add(subjectsControl);
}
public async Task <IActionResult> Subjects(string subjectName, int page = 1, SortState sortOrder = SortState.SubjectAsc)
{
int pageSize = 5;
//фильтрация
IQueryable <Subject> subjects = db.Subjects;
if (!String.IsNullOrEmpty(subjectName))
{
subjects = subjects.Where(p => p.Name.Contains(subjectName));
}
// сортировка
switch (sortOrder)
{
case SortState.SubjectDesc:
subjects = subjects.OrderByDescending(s => s.Name);
break;
default:
subjects = subjects.OrderBy(s => s.Name);
break;
}
// пагинация
var count = await subjects.CountAsync();
var items = await subjects.Skip((page - 1) *pageSize).Take(pageSize).ToListAsync();
PageViewModel pageViewModel = new PageViewModel(count, page, pageSize);
SubjectsViewModel viewModel = new SubjectsViewModel
{
PageViewModel = pageViewModel,
SortViewModel = new SortViewModel(sortOrder),
FilterSubjectsViewModel = new FilterSubjectsViewModel(subjectName),
Subjects = items
};
return(View(viewModel));
}
public ActionResult Edit(SubjectsViewModel subjectsViewModel)
{
if (!ModelState.IsValid)
{
ViewBag.Type = "edit";
return(View(subjectsViewModel));
}
try
{
Subjects subjectFromRepo = subjectService.FindById(subjectsViewModel.subject.id_subject);
subjectFromRepo.id_user = Convert.ToInt32(subjectsViewModel.SelectedUser);
subjectFromRepo.subject_name = subjectsViewModel.subject.subject_name;
if (subjectsViewModel.SelectedGroups == null || subjectsViewModel.SelectedGroups.Length == 0)
{
foreach (Groups group in subjectFromRepo.Groups.ToList())
{
subjectFromRepo.Groups.Remove(group);
}
}
else
{
subjectFromRepo.Groups.Clear();
foreach (string value in subjectsViewModel.SelectedGroups.ToList())
{
Groups group = groupsService.FindById(Convert.ToInt32(value));
subjectFromRepo.Groups.Add(group);
}
}
subjectService.Edit(subjectFromRepo);
TempData["Status"] = "success";
TempData["Msg"] = "Aktualizacja przemdiotu przebiegła pomyślnie!";
}
catch (Exception e)
{
TempData["Status"] = "invalid";
TempData["Msg"] = "Nie udało się zaktualizować przedmiotu!";
}
return(RedirectToAction("List"));
}
public ActionResult Edit(int id)
{
ViewBag.Type = "edit";
if (id == null)
{
throw new SubjectNotFoundException();
}
Subjects subject = null;
try
{
ViewBag.Teachers = new SelectList(usersService.FindAllTeachers(), "id_user", "full_name");
ViewBag.Groups = new SelectList(groupsService.FindAll, "id_group", "full_name");
subject = subjectService.FindById(id);
List <string> selectedGroups = new List <string>();
foreach (Groups group in subject.Groups)
{
selectedGroups.Add(Convert.ToString(group.id_group));
}
SubjectsViewModel viewModel = new SubjectsViewModel();
viewModel.subject = subject;
viewModel.SelectedUser = Convert.ToString(subject.id_user);
viewModel.SelectedGroups = selectedGroups.ToArray();
return(View(viewModel));
}
catch (SubjectNotFoundException ex)
{
TempData["Status"] = "invalid";
TempData["Msg"] = "Nie znaleziono przedmiotu!";
return(RedirectToAction("List"));
}
}
public SubjectsView()
{
InitializeComponent();
SubjectsVM = new SubjectsViewModel();
this.DataContext = SubjectsVM;
}
public ActionResult Index()
{
try
{
List <UserTicketGeneration> userTicketGeneration = new List <UserTicketGeneration>();
List <AssigneeTicket> assigneeTicket = new List <AssigneeTicket>();
userTicketGeneration = _db.UserTicketGeneration.ToList();
assigneeTicket = (from u in userTicketGeneration
join at in _db.AssigneeTicket.AsNoTracking()
on u.Id equals at.UserTicketGenerationId
select at).ToList();
var ticketsGrid = (from u in userTicketGeneration
join at in _db.AssigneeTicket.AsNoTracking()
on u.Id equals at.UserTicketGenerationId
select new
{
ticketId = u.Id,
ticketSubject = at.ticketSubject,
ticketType = at.ticketType,
ticketAssignee = HelperExtensions.GetUserNamebyID(u.UserId),
ticketStatus = at.Status?.statusName,
createdDate = u.createdDate,
openTime = DateTimeExtension.ConvertDateIntoString(u.createdDate),
resolveTime = DateTimeExtension.ConvertDateIntoString(at.closesCreatedDate),
inProgressTime = DateTimeExtension.ConvertDateIntoString(at.inProgressCreatedDate),
priority = at.ticketPriority,
createdBy = HelperExtensions.GetUserNamebyID(u.createdBy)
}.ToExpando());
var nonactivetickets = _db.UserTicketGeneration.Where(p => p.Status.statusName == ETicketStatus.OPEN).Select(p => p).ToList();
ViewBag.pendingactive = nonactivetickets;
// Dough Chart
ViewBag.OpenTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.OPEN).Count();
ViewBag.totalInProgressTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.IN_PROGRESS).Count();
ViewBag.totalResolveTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.RESOLVED).Count();
ViewBag.totalUnResovleTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.UNRESOLVED).Count();
// All Tickets
ViewBag.ticketGrid = ticketsGrid;
ViewBag.UserTicketGeneration = userTicketGeneration;
ViewBag.totalUserTicketGeneration = userTicketGeneration.Count();
ViewBag.assigneeTicket = assigneeTicket;
ViewBag.totalAssigneeTicket = assigneeTicket.Count();
// Charts Data
ViewBag.totalgenratedticketsbyweek = GetTotalgeneratedTickets(userTicketGeneration);
ViewBag.totalResoloveticketsbyweek = GetTotalResoloveTickets(userTicketGeneration);
ViewBag.totalOverDueticketsbyweek = GetTotalOverDueTickets(userTicketGeneration);
ViewBag.TotalOpenTickets = GetTotalOpenTickets(_db.UserTicketGeneration.ToList());
ViewBag.TotalActiveTickets = GetTotalActiveTickets(userTicketGeneration);
//Tickets
ViewBag.CardOpenTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.OPEN).Select(p => p);
ViewBag.CardInProgressTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.IN_PROGRESS).Select(p => p);
ViewBag.CardResolveTickets = userTicketGeneration.Where(x => x.Status?.statusName == ETicketStatus.RESOLVED).Select(p => p);
//Highest time to resolve ticket
var resolvetimeDouble = _db.AssigneeTicket.ToList().Count() > 0 ? _db.AssigneeTicket.ToList().Select(p => p.closeResoloutionTime): null;
var highest = resolvetimeDouble != null?resolvetimeDouble.Max() : 0;
TimeSpan highestTime = TimeSpan.FromMinutes(highest);
int?hdd = highestTime != null ? highestTime.Days : (int?)null;
int?hhh = highestTime != null ? highestTime.Hours : (int?)null;
int?hmm = highestTime != null ? highestTime.Minutes : (int?)null;
int?hss = highestTime != null ? highestTime.Seconds : (int?)null;
ViewBag.hdays = hdd;
ViewBag.hhours = hhh;
ViewBag.hminutes = hmm;
ViewBag.hseconds = hss;
//Average Time to resolve a ticket
var avgminutesdouble = resolvetimeDouble != null?resolvetimeDouble.Average(p => p) : 0;
TimeSpan averagetime = TimeSpan.FromMinutes(avgminutesdouble);
int? avgdd = averagetime != null ? averagetime.Days : (int?)null;
int? avghh = averagetime != null ? averagetime.Hours : (int?)null;
int? avgmm = averagetime != null ? averagetime.Minutes : (int?)null;
int? avgss = averagetime != null ? averagetime.Seconds : (int?)null;
ViewBag.avgdays = avgdd;
ViewBag.avghours = avghh;
ViewBag.avgminutes = avgmm;
ViewBag.avgseconds = avgss;
//Average time in Progress
var Progress = _db.AssigneeTicket.ToList().Count() > 0 ? _db.AssigneeTicket.ToList().Select(p => p.inProgressWaitTime):null;
var AvginProgressdoubles = Progress != null?Progress.Average(p => p) : 0;
TimeSpan averageinprogresstime = TimeSpan.FromMinutes(AvginProgressdoubles);
int? pavgdd = averageinprogresstime != null ? averageinprogresstime.Days : (int?)null;
int? pavghh = averageinprogresstime != null ? averageinprogresstime.Hours : (int?)null;
int? pavgmm = averageinprogresstime != null ? averageinprogresstime.Minutes : (int?)null;
int? pavgss = averageinprogresstime != null ? averageinprogresstime.Seconds : (int?)null;
ViewBag.waitingavgdays = pavgdd;
ViewBag.waitingavghours = pavghh;
ViewBag.waitingavgminutes = pavgmm;
ViewBag.waitingavgseconds = pavgss;
//highest time in Progress
var HighProgressdoubles = Progress != null?Progress.Max() : 0;
TimeSpan Highinprogresstime = TimeSpan.FromMinutes(HighProgressdoubles);
int? hwdd = Highinprogresstime != null ? Highinprogresstime.Days : (int?)null;
int? hwhh = Highinprogresstime != null ? Highinprogresstime.Hours : (int?)null;
int? hwmm = Highinprogresstime != null ? Highinprogresstime.Minutes : (int?)null;
int? hwss = Highinprogresstime != null ? Highinprogresstime.Seconds : (int?)null;
ViewBag.waitinghdays = hwdd;
ViewBag.waitinghhours = hwhh;
ViewBag.waitinghminutes = hwmm;
ViewBag.waitinghseconds = hwss;
// all tickets generated with Subject
var subjectlabels = _db.TicketGeneration.Select(p => p).ToList();
List <SubjectsViewModel> s = new List <SubjectsViewModel>();
foreach (var item in subjectlabels)
{
var res = _db.UserTicketGeneration.Where(p => p.TicketGeneration.subjectName == item.subjectName).Count();
SubjectsViewModel c = new SubjectsViewModel();
c.SubjectName = item.subjectName;
c.Count = res;
s.Add(c);
}
ViewBag.subjects = s;
List <SubjectsViewModel> s1 = new List <SubjectsViewModel>();
// all tickets generated with Resolution
var resolutionlabels = _db.ticketResolution.Select(p => p).ToList();
foreach (var item in resolutionlabels)
{
var res = _db.AssigneeTicket.Where(p => p.TicketResolutionId == item.id).Count();
SubjectsViewModel c = new SubjectsViewModel();
c.SubjectName = item.resolutionName;
c.Count = res;
s1.Add(c);
}
ViewBag.resolution = s1;
}
catch (Exception ex)
{
TempData.Remove("AlertMessage");
TempData.Add("AlertMessage", new AlertModel(ex.Message + "---------" + ex.StackTrace, AlertType.Error));
AlertModel ar = (AlertModel)TempData["AlertMessage"];
Session.Add("Alert", ar);
HelperExtensions.LogError(User.Identity.GetUserName(), User.Identity.GetUserId(), ex.Message, ex.StackTrace);
return(RedirectToAction("exception", "Error"));
}
return(View());
}
public SaveSubjectCommand(SubjectsViewModel viewmodel) : base(viewmodel)
{
}
public SubjectsView()
{
InitializeComponent();
DataContext = new SubjectsViewModel();
}
public SubjectsPage()
{
BindingContext = new SubjectsViewModel(this);
InitializeComponent();
}
public void UpdateSubject(SubjectsViewModel model)
{
throw new NotImplementedException();
}
private void OnOpenSubjectCommandExecute()
{
var subjectsVM = new SubjectsViewModel();
uiVisualizerService.ShowAsync(subjectsVM);
}
public ExcelExportSubjectCommand(SubjectsViewModel viewModel) : base(viewModel)
{
}
public BaseSubjectCommand(SubjectsViewModel viewModel)
{
this.viewModel = viewModel;
}
public RejectSubjectCommand(SubjectsViewModel viewmodel) : base(viewmodel)
{
}
public DeleteSubjectCommand(SubjectsViewModel viewmodel) : base(viewmodel)
{
}
