public async void DeleteAssigment_CalledAndRoleIsNotAdmin_ReturnsBadRequestWithError()
{
IUnitOfWork _unitOfWork = Substitute.For <IUnitOfWork>();
ICookieManager _cookieManager = Substitute.For <ICookieManager>();
var context = Substitute.For <HttpContext>();
long testId = 1;
var testAssigment = new Assigment();
string error = "Only Admins can delete assigments.";
_cookieManager.GetRoleFromToken(Arg.Any <string>()).Returns(Role.Student.ToString());
_unitOfWork.Assigments.GetById(Arg.Any <long>()).Returns(testAssigment);
var assigmentsController = new AssigmentsController(_unitOfWork, _cookieManager);
assigmentsController.ControllerContext = new ControllerContext()
{
HttpContext = context
};
var result = await assigmentsController.DeleteAssigment(testId);
var badRequestObjectResult = Assert.IsType <BadRequestObjectResult>(result);
var returnValue = Assert.IsType <string>(badRequestObjectResult.Value);
Assert.Equal(error, returnValue);
}
public async void DeleteAssigment_CalledWithinvalidId_ReturnsNotFoundWithId()
{
IUnitOfWork _unitOfWork = Substitute.For <IUnitOfWork>();
ICookieManager _cookieManager = Substitute.For <ICookieManager>();
var context = Substitute.For <HttpContext>();
long testId = default;
Assigment nullAssigment = null;
_cookieManager.GetRoleFromToken(Arg.Any <string>()).Returns(Role.Admin.ToString());
_unitOfWork.Assigments.GetById(Arg.Any <long>()).Returns(nullAssigment);
var assigmentsController = new AssigmentsController(_unitOfWork, _cookieManager);
assigmentsController.ControllerContext = new ControllerContext()
{
HttpContext = context
};
var result = await assigmentsController.DeleteAssigment(testId);
var notFoundObjetResult = Assert.IsType <NotFoundObjectResult>(result);
var returnValue = Assert.IsType <long>(notFoundObjetResult.Value);
Assert.Equal(testId, returnValue);
}
public void AllowsToAssignValueToStringLikeInArray()
{
var runtime = new Runtime(new Processors());
runtime.StartRootScope(new Compilation("testScope"));
//// set 1 on position 0
var assignEmptyTable =
new Assigment(null,
new VariableName(null, "testString"),
new ValueString(null, new String("some long string")));
//// set 1 on position 0
var sut =
new Assigment(null,
new ValueTable(null,
new VariablePointer("testString"),
new ValueNumber(new Number(32))),
new ValueNumber(new Number('X')));
assignEmptyTable.Execute(runtime);
Assert.Empty(runtime.Errors);
sut.Execute(runtime);
var value = runtime.GetVariable("testString").Get(runtime) as String;
runtime.EndRootScope();
Assert.Empty(runtime.Errors);
Assert.Equal("some long string X", value?.Value);
}
public Either <string, AssigmentView> CreateAssigment(AssigmentView assigmentView)
{
try
{
var assigmentExists = _dbContext.Assigments.Exists(t => t.Name.Equals(assigmentView.Name));
if (assigmentExists)
{
return(string.Format("Assigment with name: {0} already exists", assigmentView.Name));
}
var assigment = new Assigment()
{
Name = assigmentView.Name,
Description = assigmentView.Description,
Email = assigmentView.Email,
CopyEmail = assigmentView.CopyEmail
};
_dbContext.Assigments.Add(assigment);
_dbContext.SaveChanges();
assigmentView.Id = assigment.Id;
return(assigmentView);
}
catch (Exception ex)
{
_logger.LogError("can't create assigment with name: {0} : {1}", assigmentView.Name, ex);
return(string.Format("can't create assigment with name: {0}", assigmentView.Name));
}
}
public async void DeleteAssigment_CalledWithValidId_ReturnsOk()
{
IUnitOfWork _unitOfWork = Substitute.For <IUnitOfWork>();
ICookieManager _cookieManager = Substitute.For <ICookieManager>();
var context = Substitute.For <HttpContext>();
long testId = 1;
var testAssgiment = new Assigment();
_cookieManager.GetRoleFromToken(Arg.Any <string>()).Returns(Role.Admin.ToString());
_unitOfWork.Assigments.GetById(Arg.Any <long>()).Returns(testAssgiment);
var assigmentsController = new AssigmentsController(_unitOfWork, _cookieManager);
assigmentsController.ControllerContext = new ControllerContext()
{
HttpContext = context
};
var result = await assigmentsController.DeleteAssigment(testId);
var okResult = Assert.IsType <OkResult>(result);
Assert.Equal(200, okResult.StatusCode);
}
public async Task AddAssigmentAsync(ClaimsPrincipal principal, Assigment assigment)
{
var userProfile = GetUserProfile(principal);
userProfile.Assigments.Add(assigment);
await UpdateSaveAsync(userProfile);
}
public void AllowsToAssignValueWhenTableIsEmpty()
{
var runtime = new Runtime(new Processors());
runtime.StartRootScope(new Compilation("testScope"));
//// set 1 on position 0
var assignEmptyTable =
new Assigment(null,
new VariableName(null, "testArray"),
new DeclareTable(null));
//// set 1 on position 0
var sut =
new Assigment(null,
new ValueTable(null,
new VariablePointer("testArray"),
new ValueNumber(new Number(0))),
new ValueNumber(new Number(1)));
assignEmptyTable.Execute(runtime);
Assert.Empty(runtime.Errors);
sut.Execute(runtime);
runtime.EndRootScope();
Assert.Empty(runtime.Errors);
}
// --------------------------------------------------------------------------------------------------------
private static IEnumerable <Assigment> BuildAssigmentList(Assigment assigment)
{
return(new List <Assigment>()
{
assigment
});
}
public async Task <IActionResult> Edit(string id, [Bind("AssigmentId,UserProfileId,Network,Type,Format,ShortDescription,DetailedDescription,MaxBudget,Deadline")] Assigment assigment)
{
if (id != assigment.AssigmentId || !_userProfileManager.IsUserHasAssigments(User, assigment))
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
await _assigmentsManager.UpdateAsync(assigment);
}
catch (DbUpdateConcurrencyException)
{
if (!_assigmentsManager.IsAssigmentExists(assigment.AssigmentId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(UserAssigments)));
}
return(View(assigment));
}
// 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 ViewResult Cv(int id)
{
CvViewModel CompleteCv = new CvViewModel();
Assigment assigment = new Assigment();
Assigment focusassingment = new Assigment();
Employee employee = new Employee();
Expertise expertise = new Expertise();
Middleware middelware = new Middleware();
Training training = new Training();
Trade trade = new Trade();
Technique tech = new Technique();
var emp = EmployeeService.Get(id);
CompleteCv.Employee = employee.GetEmployeeView(emp);
CompleteCv.Expertises = expertise.GetExpertiseView(id);
CompleteCv.Middlewares = middelware.GetMiddlewareView(id);
CompleteCv.Techniques = tech.GetTechniqueView(id);
CompleteCv.Trades = trade.GetTradeView(id);
CompleteCv.DegreeTraining = training.GetDegreeTrainingView(id);
CompleteCv.Trainings = training.GetTrainingView(id);
CompleteCv.Assigments = assigment.GetAllNonFocusAssignments(id);
CompleteCv.FocusAssigments = focusassingment.GetAllFocusAssignments(id);
return(View(CompleteCv));
}
public ActionResult CreateByEmployee(int employeeid, string uppdrag, string roll, string tid, string beskrivning, string teknik, string focus)
{
Assigment assignment = new Assigment(employeeid, uppdrag, roll, tid, beskrivning, teknik, check(focus));
AssignmentService.Add(assignment);
return(RedirectToAction("Cv", "Home", new { id = employeeid }));
}
public ActionResult DeleteByEmployee(int id)
{
Assigment assignment = AssignmentService.Get(id);
AssignmentService.Delete(assignment);
return(RedirectToAction("Cv", "Home", new { id = assignment.Employeeid }));
}
public ActionResult DeleteConfirmed(int id)
{
Assigment assigment = db.assigments.Find(id);
db.assigments.Remove(assigment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Delete(Assigment assigment)
{
using var context = new SqlLiteContext();
var entity = context.Assigments.Remove(assigment);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
public static void Update(Assigment assigment)
{
using var context = new SqlLiteContext();
var entity = context.Assigments.Update(assigment);
entity.State = EntityState.Modified;
context.SaveChanges();
}
public static void Add(Assigment assignment)
{
using (var context = new SqlLiteContext())
{
var entity = context.Assigments.Add(assignment);
entity.State = EntityState.Added;
context.SaveChanges();
}
}
public async Task <IActionResult> Create([Bind("AssigmentId,UserProfileId,Network,Type,Format,ShortDescription,DetailedDescription,MaxBudget,Deadline")] Assigment assigment)
{
if (ModelState.IsValid)
{
assigment.UserProfileId = _userProfileManager.GetUserProfileId(User);
await _assigmentsManager.CreateAsync(assigment);
return(RedirectToAction(nameof(UserAssigments)));
}
return(View(assigment));
}
public ActionResult pacientEdit([Bind(Include = "ID,comments,medicine,cancelDate,actual,weight,dose,inADay")] Assigment assigment)
{
if (ModelState.IsValid)
{
db.Entry(assigment).State = EntityState.Modified;
db.SaveChanges();
return(pacientDetails(assigment.ID));
//return (new AssigmentsController()).pacientDetails(assigment.ID);
}
return(PartialView(assigment));
}
public void AllowsToReadValue()
{
var runtime = new Runtime(new Processors());
runtime.StartRootScope(new Compilation("testScope"));
var assignEmptyTable =
new Assigment(null,
new VariableName(null, "testString"),
new DeclareTable(null));
assignEmptyTable.Execute(runtime);
Assert.Empty(runtime.Errors);
for (int k = 0; k < 1024 * 10; k++)
{
var setArrayElementValue =
new Assigment(null,
new ValueTable(null,
new VariablePointer("testString"),
new ValueNumber(new Number(k))),
new ValueNumber(new Number(k)));
setArrayElementValue.Execute(runtime);
}
Assert.Empty(runtime.Errors);
//// read some element in table
var getNthValue =
new Assigment(
null,
new VariableName(null, "tempNthValue"),
new ValueTable(null,
new VariablePointer("testString"),
new ValueNumber(new Number(10)))
);
getNthValue.Execute(runtime);
Assert.Empty(runtime.Errors);
var value = runtime.GetVariable("tempNthValue").Get(runtime) as Number;
Assert.Empty(runtime.Errors);
runtime.EndRootScope();
Assert.Empty(runtime.Errors);
Assert.Equal(10, value?.Value);
}
// GET: Assigments/Details/5
public ActionResult pacientDetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assigment assigment = db.assigments.Include(p => p.type).Where(p => p.ID == id).First();
if (assigment == null)
{
return(HttpNotFound());
}
return(PartialView("~/views/Assigments/pacientDetails.cshtml", assigment));
}
public ActionResult UpdateByEmployee(int employeeid, int id, string uppdrag, string roll, string tid, string beskrivning, string teknik, string focus)
{
Assigment assignment = AssignmentService.Get(id);
assignment.Roll = roll;
assignment.Uppdrag = uppdrag;
assignment.Tid = tid;
assignment.Beskrivning = beskrivning;
assignment.Teknik = teknik;
assignment.Focus = check(focus);
AssignmentService.Update(assignment);
return(RedirectToAction("Cv", "Home", new { id = employeeid }));
}
// GET: Assigments/Delete/5
public ActionResult pacientDelete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assigment assigment = db.assigments.Find(id);
if (assigment == null)
{
return(HttpNotFound());
}
//Debut Debut = db.anamneses.Find(id);
db.assigments.Remove(assigment);
db.SaveChanges();
//return View(Debut);
return(PartialView());
}
/// <summary>
/// Methods to ii.See the dates of submission of the Assignments per Course
/// </summary>
public void AssigmnetPerStudent(int ID)
{
Auth.sqlConnection.Open();
SqlCommand AssigmnetPerCourse = new SqlCommand($"SELECT DISTINCT id,Title,SubmissionDate,isSubmitted,Description FROM User_Assigments,Assigments WHERE UserID = '{ID}'", Auth.sqlConnection);
SqlDataReader ReaderAssigmnetPerCourse = AssigmnetPerCourse.ExecuteReader();
List <Assigment> assigments = new List <Assigment>();
while (ReaderAssigmnetPerCourse.Read())
{
// Create each assigment object
Assigment assigment = new Assigment
{
id = ReaderAssigmnetPerCourse.GetInt32(0),
Title = ReaderAssigmnetPerCourse.GetString(1),
SubmitionDate = ReaderAssigmnetPerCourse.GetDateTime(2),
IsSubmitted = ReaderAssigmnetPerCourse.GetBoolean(3),
Description = ReaderAssigmnetPerCourse.GetString(4)
};
assigments.Add(assigment);
// Print each assigment object
foreach (Assigment a in assigments)
{
//if (a.IsSubmitted)
//{
// SqlCommand AssigmnetMark = new SqlCommand($"SELECT OralMark,TotalMark FROM Assigments WHERE id = '{a.id}'", Auth.sqlConnection);
// SqlDataReader ReaderAssigmnetMark = AssigmnetMark.ExecuteReader();
// a.OralMark = ReaderAssigmnetMark.GetInt32(0);
// a.TotalMark = ReaderAssigmnetMark.GetInt32(1);
// Console.WriteLine($"Assigmnet id: {a.id} - Assigmnet Title: {a.Title} - Oral Mark is: {a.OralMark} - Total Mark is: {a.TotalMark}");
//}
//else
//Console.WriteLine($"Assigmnet id: {a.id} - Assigmnet Title: {a.Title} - Assigmnet Submission Date is: {a.SubmitionDate}");
Console.WriteLine($"Assigmnet id: {a.id} - Assigmnet Title: {a.Title} - Assigmnet Description: {a.Description} - Assigmnet Submission Date is: {a.SubmitionDate}");
Console.ReadKey();
}
}
ReaderAssigmnetPerCourse.Close();
Auth.sqlConnection.Close();
}
public ActionResult pacientCancel(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Assigment assigment = db.assigments.Find(id);
if (assigment == null)
{
return(HttpNotFound());
}
//Debut Debut = db.anamneses.Find(id);
assigment.actual = 1;
assigment.cancelDate = DateTime.Today;
db.SaveChanges();
//return View(Debut);
return(PartialView());
}
// GET: Assigments/Edit/5
public async Task <IActionResult> Edit(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());
}
List <Employee> employees = EmployeeService.GetAll();
var items = new List <SelectItem>();
foreach (Employee c in employees)
{
SelectItem item = new SelectItem {
Key = c.EmployeeId.ToString(), Value = c.EmployeeName, Selected = assigment.Employeeid
};
items.Add(item);
}
AssignmentViewModel avm = new AssignmentViewModel
{
Id = assigment.Id,
Employee = EmployeeService.Get(assigment.Employeeid),
Employees = items,
Beskrivning = assigment.Beskrivning,
Roll = assigment.Roll,
Teknik = assigment.Teknik,
Tid = assigment.Tid,
Uppdrag = assigment.Uppdrag,
Focus = assigment.Focus
};
return(View(avm));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Employee,EmployeeId,Uppdrag,Tid,Roll,Beskrivning,Teknik,Focus")] AssignmentViewModel assigmentviewmodel)
{
if (id != assigmentviewmodel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
Assigment assignment = AssignmentService.Get(assigmentviewmodel.Id);
assignment.Id = assigmentviewmodel.Id;
assignment.Employeeid = assigmentviewmodel.Employee.EmployeeId;
assignment.Beskrivning = assigmentviewmodel.Beskrivning;
assignment.Focus = assigmentviewmodel.Focus;
assignment.Uppdrag = assigmentviewmodel.Uppdrag;
assignment.Roll = assigmentviewmodel.Roll;
assignment.Teknik = assigmentviewmodel.Teknik;
assignment.Tid = assigmentviewmodel.Tid;
var context = new SqlLiteContext();
context.Update(assignment);
await context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AssigmentExists(assigmentviewmodel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View());
}
public async Task <IActionResult> AddAssigment([FromBody] AssigmentViewModel assigment)
{
if (assigment == null)
{
return(BadRequest("Assigment cannot be null."));
}
var Module = await _unitOfWork.Modules.GetById(assigment.ModuleId);
if (Module != null)
{
var Assigment = new Assigment {
Title = assigment.Title, Description = assigment.Description, Url = assigment.Url, Module = Module
};
_unitOfWork.Assigments.Add(Assigment);
await _unitOfWork.Complete();
return(Ok());
}
return(NotFound(assigment.ModuleId));
}
// GET: Employees/Details/5
public async Task <IActionResult> Details(int id)
{
if (id == null)
{
return(NotFound());
}
var context = new SqlLiteContext();
Employee employee = await context.Employees
.FirstOrDefaultAsync(m => m.EmployeeId == id);
if (employee == null)
{
return(NotFound());
}
CvViewModel CompleteCv = new CvViewModel();
Assigment assigment = new Assigment();
Assigment focusassingment = new Assigment();
Expertise expertise = new Expertise();
Middleware middelware = new Middleware();
Training training = new Training();
Trade trade = new Trade();
Technique tech = new Technique();
CompleteCv.Employee = employee.GetEmployeeView(employee);
CompleteCv.Expertises = expertise.GetExpertiseView(id);
CompleteCv.Middlewares = middelware.GetMiddlewareView(id);
CompleteCv.Techniques = tech.GetTechniqueView(id);
CompleteCv.Trades = trade.GetTradeView(id);
CompleteCv.DegreeTraining = training.GetDegreeTrainingView(id);
CompleteCv.Trainings = training.GetTrainingView(id);
CompleteCv.Assigments = assigment.GetAllNonFocusAssignments(id);
CompleteCv.FocusAssigments = focusassingment.GetAllFocusAssignments(id);
return(View(CompleteCv));
}
public async Task <ActionResult <Assigment> > PostCourse(Assigment assigment)
{
assigment.CreationDate = DateTime.Now;
assigment.DueDate = DateTime.Now.AddDays(7);
_context.Assigments.Add(assigment);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (AssigmentExists(assigment.AssigmentId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetAssigments", new { id = assigment.AssigmentId }, assigment));
}
