public List <AssignmentViewModel> GetAssignmentsInCourse(int courseID)
{
var allAssignments = from assignments in _db.assignments
where assignments.CourseId.Equals(courseID)
select assignments;
if (allAssignments == null)
{
throw new ArgumentNullException();
}
var assignmentViewModelList = new List <AssignmentViewModel>();
foreach (var assignment in allAssignments)
{
var newViewModel = new AssignmentViewModel
{
Id = assignment.Id,
Title = assignment.Title,
CourseId = assignment.CourseId,
Description = assignment.Description,
Milestones = _assignmentMilestoneService.GetMilestoneInAssignment(assignment.Id),
TimeEnds = (DateTime)assignment.TimeEnds
};
var milestoneViewList = _assignmentMilestoneService.GetMilestoneInAssignment(assignment.Id);
newViewModel.Milestones = milestoneViewList;
assignmentViewModelList.Add(newViewModel);
}
return(assignmentViewModelList);
}
public AssignmentViewModel GetSingleAssignmentsInCourse(int courseID, int assignmentId)
{
var theAssignment = (from assignments in _db.assignments
where assignments.CourseId.Equals(courseID) && assignments.Id.Equals(assignmentId)
select assignments).SingleOrDefault();
if (theAssignment == null)
{
throw new ArgumentNullException();
}
var newViewModel = new AssignmentViewModel
{
Id = theAssignment.Id,
Title = theAssignment.Title,
CourseId = theAssignment.CourseId,
Milestones = _assignmentMilestoneService.GetMilestoneInAssignment(theAssignment.Id)
};
var milestoneViewList = _assignmentMilestoneService.GetMilestoneInAssignment(theAssignment.Id);
newViewModel.Milestones = milestoneViewList;
return(newViewModel);
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assignment assignment = db.Assignments.Find(id);
if (assignment == null)
{
return(HttpNotFound());
}
AssignmentViewModel model = new AssignmentViewModel
{
Id = assignment.AssignmentId,
LMInspectId = assignment.LMInspectId,
PCId = assignment.PCId,
ProbationaryColleague = assignment.ProbationaryColleague.FullName,
LMAssignId = assignment.LMAssignId, // Include Ids in get as well as the properties. include hidden id in view
LMAssigned = assignment.LMAssigned.FullName,
AssignmentDate = assignment.AssignmentDate,
AssignmentStatus = assignment.AssignmentStatus,
HRAssignId = assignment.HRAssignId,
HRAssigns = assignment.HRAssigns.FullName,
AssignmentInspectionDate = assignment.AssignmentInspectionDate,
DepartmentId = assignment.DepartmentId,
Department = assignment.Department.DepartmentName,
};
return(View(model));
}
// GET: Assignment/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assignment assignment = db.Assignments.Find(id);
if (assignment == null)
{
return(HttpNotFound());
}
var model = new AssignmentViewModel
{
Id = assignment.AssignmentId,
ProbationaryColleague = assignment.ProbationaryColleague.FullName,
LMAssigned = assignment.LMAssigned.FullName,
Department = assignment.Department.DepartmentName,
AssignmentDate = assignment.AssignmentDate,
HRAssigns = assignment.HRAssigns.FullName,
//AssignmentInspectionDate = assignment.AssignmentInspectionDate,
AssignmentStatus = assignment.AssignmentStatus,
};
return(View(model));
}
public ActionResult Create(AssignmentViewModel model)
{
if (ModelState.IsValid)
{
var assignment = new Assignment
{
AssignmentId = model.Id,
PCId = model.PCId,
DepartmentId = model.DepartmentId,
LMAssignId = model.LMAssignId,
HRAssignId = User.Identity.IsAuthenticated ? User.Identity.GetUserId <int>() : db.Users.First().Id,
//HRAssignId = model.HRAssignId,
AssignmentDate = DateTime.Today,
AssignmentStatus = Assignment.AssignStatus.Pending,
};
db.Assignments.Add(assignment);
db.SaveChanges();
//Utilities.SendEmail("*****@*****.**", "*****@*****.**", "New Assignment - Probationary Colleague", "A probationary colleague has been assigned to you. Kindly visit the Probation Management site in order to review this assignment.");
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName");
ViewBag.PCId = new SelectList(db.ProbationaryColleagues.ToList(), "Id", "FullName");
ViewBag.LMAssignId = new SelectList(db.Colleagues.ToList(), "Id", "FullName");
return(RedirectToAction("Index"));
}
else
{
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName");
ViewBag.PCId = new SelectList(db.ProbationaryColleagues.ToList(), "Id", "FullName");
ViewBag.LMAssignId = new SelectList(db.Colleagues.ToList(), "Id", "FullName");
return(View(model));
}
}
public ActionResult Inspect(int id, AssignmentViewModel model)
{
if (ModelState.IsValid)
{
var assignment = db.Assignments.Find(id);
if (assignment != null)
{
assignment.AssignmentId = model.Id;
assignment.LMInspectId = model.LMInspectId;
assignment.LMAssignId = model.LMAssignId;
assignment.AssignmentDate = model.AssignmentDate;
assignment.AssignmentStatus = model.AssignmentStatus;
assignment.PCId = model.PCId;
assignment.HRAssignId = model.HRAssignId;
assignment.DepartmentId = model.DepartmentId;
}
db.Entry(assignment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public AssignmentListViewModel PrepareAssignmentListViewModel(List <Assignment> assignments = null)
{
if (assignments == null)
{
throw new ArgumentNullException(nameof(assignments));
}
var assignmentListViewModel = new AssignmentListViewModel();
foreach (var assignment in assignments)
{
var model = new AssignmentViewModel
{
Id = assignment.Id,
Name = assignment.Name,
Description = assignment.Description,
Status = assignment.Status,
CreatedOn = assignment.CreatedOn.ToString(),
ExigencyId = assignment.ExigencyId,
ExigencyDefinition = assignment.Exigency.Definition
};
assignmentListViewModel.AssignmemtsViewModel.Add(model);
}
return(assignmentListViewModel);
}
public ContentController(SignatureController controller)
{
this.controller = controller;
assignmentViewModel = ServiceContainer.Resolve <AssignmentViewModel> ();
Title = "Add Signature";
}
// GET: Create
public ActionResult Create(int id, bool isCard)
{
var userId = User.Identity.GetUserId();
var deckService = new DeckService(userId);
var cardService = new CardService();
if (isCard)
{
var allDecks = deckService.GetDecks();
var card = cardService.GetCardById(id);
var cardToDeck = new AssignmentViewModel(isCard)
{
CardId = id,
CardName = card.Name,
DeckList = allDecks
};
return(View(cardToDeck));
}
var allCards = cardService.GetCards();
var deck = deckService.GetDeckById(id);
var deckToCard = new AssignmentViewModel(isCard)
{
DeckId = id,
DeckName = deck.Name,
CardList = allCards
};
return(View(deckToCard));
}
public AssignmentsPage()
{
this.InitializeComponent();
DataContext =
assignmentViewModel = ServiceContainer.Resolve <AssignmentViewModel> ();
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null && e.Parameter.GetType() == typeof(UserViewModel))
{
UserModel = (UserViewModel)e.Parameter;
}
else
{
UserModel = new UserViewModel();
//测试用，之后应该删除
//await UserModel.logIn("15331060", "123456");
//await UserModel.init();
}
AssignmentModel = new AssignmentViewModel();
this.InitializeComponent();
if (UserModel.CurrentUser == null || !UserModel.CurrentUser.isAdmin())
{
}
//显示用户个人信息
if (UserModel.CurrentUser != null)
{
username.Text = UserModel.CurrentUser.Username;
mail.Text = UserModel.CurrentUser.getEmail();
nickname.Text = UserModel.CurrentUser.Nickname;
string uid = this.UserModel.CurrentUser.getId();
string imageUri = "http://www.sugerpocket.cn:3005/api/user/avatar?uid=" + uid;
ava.ImageSource = new BitmapImage(new Uri(imageUri));
}
}
// gets the assignment with the given ID, its projects, and the course the assignment belongs to
public AssignmentViewModel GetAssignmentByID(int assignmentID)
{
var assignment = _db.Assignments.SingleOrDefault(x => x.ID == assignmentID);
if (assignment == null)
{
throw new ArgumentNullException();
}
var course = _db.Courses.SingleOrDefault(x => x.ID == assignment.CourseID);
var projects = _db.Projects.Where(x => x.AssignmentID == assignmentID).ToList();
var viewModel = new AssignmentViewModel
{
ID = assignment.ID,
AssignmentName = assignment.AssignmentName,
Course = course,
CourseID = assignment.CourseID,
Deadline = assignment.Deadline,
Projects = projects,
};
return(viewModel);
}
public void addAssignment(AssignmentViewModel newAssignment)
{
using (var context = new dbContext())
{
assignment model = new assignment
{
name = newAssignment.Name,
maxSubmisions = newAssignment.MaxSubmissions,
groupSize = newAssignment.GroupSize,
startDate = newAssignment.AssignmentStart,
endDate = newAssignment.AssignmentEnd,
courseID = newAssignment.CourseID
};
context.assignments.Add(model);
context.SaveChanges();
assignmentPart modelPart = new assignmentPart
{
descriptoin = newAssignment.Description,
solutionFile = newAssignment.SolutionFile,
assignmentID = model.ID
};
context.assignmentParts.Add(modelPart);
context.SaveChanges();
}
}
public ActionResult Assignments()
{
List <AssignmentViewModel> theList = new List <AssignmentViewModel>();
var result = _db.Assignments.ToList();
foreach (var item in result)
{
AssignmentViewModel assignmentViewModel = new AssignmentViewModel();
assignmentViewModel.ID = item.ID;
assignmentViewModel.Title = item.Title;
assignmentViewModel.CourseID = item.CourseID;
assignmentViewModel.DueDate = item.DueDate;
assignmentViewModel.CourseName = _db.Courses
.Where(x => x.ID == item.CourseID)
.Select(x => x.Name).SingleOrDefault();
assignmentViewModel.MilestonesTitles = _db.Milestones.Where(X => X.AssignmentID == item.ID)
.Select(x => x.Title).ToList();
assignmentViewModel.MilestonesPercentages = _db.Milestones.Where(x => x.AssignmentID == item.ID)
.Select(x => x.Percentage).ToList();
theList.Add(assignmentViewModel);
}
return(View(theList));
}
public AssignmentsController(IntPtr handle) : base(handle)
{
assignmentViewModel = ServiceContainer.Resolve <AssignmentViewModel>();
assignmentViewModel.HoursChanged += OnHoursChanged;;
assignmentViewModel.RecordingChanged += OnRecordingChanged;
}
//
// GET: /Assignment/
public ActionResult Index()
{
//ViewBag.StdGroup1 = "I am Batman";
List <Assignment> assignments = new List <Assignment>();
assignments.AddRange(service.GetAll());
var model = new AssignmentListViewModel();
model.Header = "Our Assignments List";
foreach (var entity in assignments)
{
var assignmentModel = new AssignmentViewModel()
{
Id = entity.Id,
Title = entity.Title,
Description = entity.Description,
CreatedAt = entity.CreatedAt,
UpdatedAt = entity.UpdatedAt,
IsDone = entity.IsDone
};
model.Assignments.Add(assignmentModel);
}
return(View(model));
}
public static ResponResultViewModel is_delete(AssignmentViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_assignment asn = db.t_assignment.Where(o => o.id == entity.id).FirstOrDefault();
if (asn != null)
{
asn.is_delete = true;
asn.deleted_by = 1;
asn.deleted_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public AssignmentViewModel getAssignmentGrade(int userId, int assignmentId)
{
//Sæki öll gögn í verkefna töfluna
var assignment = (from assign in _db.Assignment
join userAssignment in _db.UserAssignment on assign.assignmentId equals userAssignment.assignmentId
where assign.assignmentId == assignmentId && userAssignment.userId == userId
select new { assign, userAssignment }).SingleOrDefault();
UserAssignment userAssign = null;
if (assignment.assign.gradePublished == 1)
{
userAssign = new UserAssignment
{
userAssignmentId = assignment.userAssignment.userAssignmentId,
userId = assignment.userAssignment.userId,
userGroupId = assignment.userAssignment.userGroupId,
grade = assignment.userAssignment.grade,
gradeComment = assignment.userAssignment.gradeComment
};
}
//Bý til nýtt AssingmentViewModel og set listann inn í það
AssignmentViewModel viewModel = new AssignmentViewModel
{
UserAssignment = userAssign
};
//Returna viewModelinu með listanum
return(viewModel);
}
public static AssignmentViewModel GetAssignment(int id)
{
AssignmentViewModel result = new AssignmentViewModel();
using (var db = new MinProContext())
{
result = (from c in db.t_assignment
join d in db.t_biodata on
c.biodata_id equals d.id
select new AssignmentViewModel
{
id = c.id,
bio_name = d.name,
biodata_id = c.biodata_id,
title = c.title,
start_date = c.start_date,
end_date = c.end_date,
description = c.description,
realization_date = c.realization_date,
notes = c.notes,
is_hold = c.is_hold,
is_done = c.is_done,
is_delete = c.is_delete,
}).FirstOrDefault();
if (result == null)
{
result = new AssignmentViewModel();
}
}
return(result);
}
public ActionResult AddMilestone(int assignmentID)
{
AssignmentViewModel model = new AssignmentViewModel();
model.ID = assignmentID;
return(View(model));
}
private void GradeGrid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
if (isAssignmentColumn(e.ColumnIndex))
{
object rawValue = e.FormattedValue;
int newValue = 0;
if (rawValue == null || // Null value means the value was deleted in which case zero will be entered for the grade.
(rawValue.GetType() == typeof(String) && //Otherwise the value should be a string
(String.IsNullOrWhiteSpace((String)rawValue) || //An empty string should have zero entered for the grade.
int.TryParse((String)rawValue, out newValue)))) //Otherwise convert the string to an int and use that as the grade
{
StudentViewModel student = (StudentViewModel)this.Rows[e.RowIndex].DataBoundItem;
AssignmentViewModel assignment = (AssignmentViewModel)this.Columns[e.ColumnIndex].Tag;
if (assignment.Grades.ContainsKey(student.Id))
{
assignment.Grades[student.Id].Points = newValue;
}
else
{
GradeViewModel grade = new GradeViewModel()
{
StudentId = student.Id, Points = newValue
};
assignment.Grades.Add(student.Id, grade);
}
}
}
}
private void GradeGrid_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (isAssignmentColumn(e.ColumnIndex))
{
StudentViewModel student = (StudentViewModel)this.Rows[e.RowIndex].DataBoundItem;
AssignmentViewModel assignment = (AssignmentViewModel)this.Columns[e.ColumnIndex].Tag;
if (assignment.Grades.ContainsKey(student.Id))
{
if (this[e.ColumnIndex, e.RowIndex].IsInEditMode)
{
this.Columns[e.ColumnIndex].DefaultCellStyle.Format = "";
e.Value = assignment.Grades[student.Id].Points;
}
else
{
this.Columns[e.ColumnIndex].DefaultCellStyle.Format = "P";
double gradePercentage = assignment.CalculateGradePercentage(student);
e.Value = gradePercentage;
e.CellStyle.BackColor = GradeColorCode.getColor(gradePercentage);
}
}
}
else if (this.Columns["totalGradeColumn"].Index == e.ColumnIndex)
{
StudentViewModel student = (StudentViewModel)this.Rows[e.RowIndex].DataBoundItem;
double gradePercentage = Course.CalculateGradePercentage(student);
e.Value = gradePercentage;
e.CellStyle.BackColor = GradeColorCode.getColor(gradePercentage);
}
}
// GET: Assigments
public IActionResult Index()
{
List <AssignmentViewModel> AssignmentViewModels = new List <AssignmentViewModel>();
List <Assigment> targetData = AssignmentService.GetEvery();
if (targetData != null)
{
foreach (Assigment target in targetData)
{
Employee employee = EmployeeService.Get(target.Employeeid);
AssignmentViewModel avm = new AssignmentViewModel
{
Id = target.Id,
Employee = employee,
Beskrivning = target.Beskrivning,
Roll = target.Roll,
Teknik = target.Teknik,
Tid = target.Tid,
Uppdrag = target.Uppdrag,
Focus = target.Focus
};
if (employee == null)
{
Employee temp = new Employee();
temp.EmployeeId = 0;
temp.EmployeeName = "INTE KOPPLAD TILL NÅGON ANSTÄLLD";
avm.Employee = temp;
}
AssignmentViewModels.Add(avm);
}
}
var sortedlist = AssignmentViewModels.OrderBy(foo => foo.Employee.EmployeeName).ToList();
return(View(sortedlist));
}
// GET: Assigments/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
AssignmentViewModel assignmentviewmodel = new AssignmentViewModel();
var context = new SqlLiteContext();
Assigment assigment = await context.Assigments
.FirstOrDefaultAsync(m => m.Id == id);
if (assigment == null)
{
return(NotFound());
}
AssignmentViewModel avm = new AssignmentViewModel
{
Id = assigment.Id,
Employee = EmployeeService.Get(assigment.Employeeid),
Beskrivning = assigment.Beskrivning,
Roll = assigment.Roll,
Teknik = assigment.Teknik,
Tid = assigment.Tid,
Uppdrag = assigment.Uppdrag,
Focus = assigment.Focus
};
return(View(avm));
}
public AssignmentViewModel editAssignment(AssignmentViewModel assignmentToChange)
{
// Sæki færsluna sem á að breyta í gagnagrunninn
var query = (from assignment in _db.Assignment
where assignment.assignmentId == assignmentToChange.AssignmentId
select assignment).SingleOrDefault();
// Set inn breyttu upplýsingarnar
query.courseId = assignmentToChange.CourseId;
query.assignmentName = assignmentToChange.AssignmentName;
query.assignmentDescription = assignmentToChange.AssignmentDescription;
query.assignmentFile = assignmentToChange.AssignmentFile;
query.weight = assignmentToChange.Weight;
query.maxSubmission = assignmentToChange.MaxSubmission;
query.assignDate = assignmentToChange.AssignDate;
query.dueDate = assignmentToChange.DueDate;
query.gradePublished = assignmentToChange.GradePublished;
//Vista breytingar í gagnagrunn
try
{
_db.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
// TODO
}
return(assignmentToChange);
}
public Boolean addAssignment(AssignmentViewModel assignmentToAdd)
{
var newAssignment = new Assignment();
//setja propery-in
newAssignment.courseId = assignmentToAdd.CourseId;
newAssignment.assignmentName = assignmentToAdd.AssignmentName;
newAssignment.assignmentDescription = assignmentToAdd.AssignmentDescription;
newAssignment.assignmentFile = assignmentToAdd.AssignmentFile;
newAssignment.weight = assignmentToAdd.Weight;
newAssignment.maxSubmission = assignmentToAdd.MaxSubmission;
newAssignment.assignDate = assignmentToAdd.AssignDate;
newAssignment.dueDate = assignmentToAdd.DueDate;
newAssignment.gradePublished = assignmentToAdd.GradePublished;
//Todo setja inn öll property
try
{
//Vista ofan í gagnagrunn
_db.Assignment.Add(newAssignment);
_db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
private void ParticipationList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string name = ParticipationList.SelectedItem.ToString();
AssignmentViewModel AVM = new AssignmentViewModel();
SchoolCourseViewModel SCM = new SchoolCourseViewModel();
foreach (AssignmentViewModel task in currentAssignments)
{
if (task.Name.Equals(name))
{
AVM = task;
}
}
foreach (SchoolCourseViewModel course in currentCourses)
{
if (course.Id == AVM.Course_Id)
{
SCM = course;
}
}
assignment.OpenTab(AVM, SCM);
assignment.Show();
}
public AddSignatureFlyoutPanel()
{
this.InitializeComponent();
DataContext =
assignmentViewModel = ServiceContainer.Resolve <AssignmentViewModel> ();
}
public AssignmentViewModel GetAssignmentByID(int assignmentID)
{
var assignment = _db.Assignments.SingleOrDefault(x => x.ID == assignmentID);
if (assignment == null)
{
//TODO: kasta villu!
}
var milestones = _db.Milestones
.Where(x => x.AssignmentID == assignmentID)
.Select(x => new AssignementMilestoneViewModel
{
Title = x.Title
})
.ToList();
var viewModel = new AssignmentViewModel
{
Title = assignment.Title,
Milestones = milestones
};
return(viewModel);
}
// GET: Assignment/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assignment assignment = _repository.GetAssignmentById(id);
if (assignment == null)
{
return(HttpNotFound());
}
Slot slot = _repository.GetSlotById(assignment.SlotId);
TaskType taskType = _repository.GetTaskTypeById(assignment.TaskTypeId);
Person person = _repository.GetPersonById(assignment.PersonId);
AssignmentViewModel assignmentViewModel = new AssignmentViewModel()
{
AssignmentDetail = assignment,
SlotSelected = slot == null ? "" : slot.Name,
TaskTypeSelected = taskType == null ? "" : taskType.Name,
PersonSelected = person == null ? "" : person.Name,
};
return(View(assignmentViewModel));
}
public Assignment(AssignmentViewModel assignmentVM)
{
this.Id = assignmentVM.Id;
this.Name = assignmentVM.Name;
this.AssignmentDate = assignmentVM.AssignmentDate;
this.DueDate = assignmentVM.DueDate;
this.Points = assignmentVM.Points;
Grades = new List<Grade>(assignmentVM.Grades.Count);
foreach (GradeViewModel _grade in assignmentVM.Grades.Values)
{
Grades.Add(new Grade(_grade));
}
}
public virtual ActionResult EditAssignment(
[DataSourceRequest] DataSourceRequest request,
AssignmentViewModel task)
{
if (this.ModelState.IsValid)
{
var taskDb = this.subTaskService.GetById(task.Id);
taskDb.PercentComplete = task.PercentComplete / 100;
this.subTaskService.UpdateProgress(taskDb);
if (task.PercentComplete == 100)
{
this.messageService.SendSystemMessage(
this.UserProfile.Id,
taskDb.Project.LeadId,
SystemMessageType.TaskComplete,
taskDb.Project.Id,
taskDb.Id);
}
}
return this.Json(request);
}
