public IEnumerable <Test> DisplayAvailableTestDetails(FilterPanel filterPanel)
{
using (AssessmentDbContext AssessmentDBContext = new AssessmentDbContext())
{
if (HttpContext.Current.User.IsInRole("Student"))
{
User currentUser = AssessmentDBContext.Users.FirstOrDefault(user => user.Name == userName);
IEnumerable <Test> tests = AssessmentDBContext.Tests.Where(test => test.Grade == currentUser.UserGrade && test.Status.Equals("Accepted") && test.Subject.Equals(filterPanel.SubjectId) && test.TestName.Contains(filterPanel.SearchBy) || filterPanel.SearchBy == null || filterPanel.SubjectId == 0).ToList();
return(tests);
}
else if (HttpContext.Current.User.IsInRole("Principal"))
{
IEnumerable <Test> tests = AssessmentDBContext.Tests.Where(test => test.Subject.Equals(filterPanel.SubjectId) && test.Grade.Equals(filterPanel.GradeId) && test.TestName.Contains(filterPanel.SearchBy) || filterPanel.SearchBy == null || filterPanel.SubjectId == 0).ToList();
return(tests);
}
else if (HttpContext.Current.User.IsInRole("Teacher"))
{
IEnumerable <Test> tests = AssessmentDBContext.Tests.Where(test => test.Subject.Equals(filterPanel.SubjectId) && test.Grade.Equals(filterPanel.GradeId) && test.TestName.Contains(filterPanel.SearchBy) || filterPanel.SearchBy == null && filterPanel.GradeId == 0 || filterPanel.SubjectId == 0).ToList();
return(tests);
}
else
{
return(AssessmentDBContext.Tests.ToList());
}
}
}
public void UpdateRejectStatus(int testId)
{
using (AssessmentDbContext AssessmentDBContext = new AssessmentDbContext())
{
Test test = AssessmentDBContext.Tests.Find(testId);
test.Status = "Rejected";
AssessmentDBContext.SaveChanges();
}
}
public IEnumerable <ResultViewModel> StudentScore(int userId, int testId)
{
using (AssessmentDbContext assessmentDbContext = new AssessmentDbContext())
{
SqlParameter UserId = new SqlParameter("@UserId", userId);
SqlParameter TestId = new SqlParameter("@TestId", testId);
var result = assessmentDbContext.Database.SqlQuery <ResultViewModel>("calculation @UserId ,@TestId", UserId, TestId).ToList();
return(result);
}
}
public IEnumerable <ResultViewModel> CalculateScore(ResultViewModel resultViewModel)
{
using (AssessmentDbContext AssessmentDBContext = new AssessmentDbContext())
{
User currentUser = AssessmentDBContext.Users.FirstOrDefault(user => user.Name == userName);
SqlParameter userId = new SqlParameter("@UserId", currentUser.UserId);
var resultViewModels = AssessmentDBContext.Database.SqlQuery <ResultViewModel>("SP_CalculateScore @UserId", userId).ToList();
return(resultViewModels);
}
}
public bool VerifyPasscode(int passcode)
{
using (AssessmentDbContext AssessmentDBContext = new AssessmentDbContext())
{
Test verifiedTest = AssessmentDBContext.Tests.Where(test => test.Passcode == passcode).FirstOrDefault();
if (verifiedTest != null)
{
return(true);
}
else
{
return(false);
}
}
}
public IEnumerable <ResultViewModel> DisplayScoresTeacher(int grade)
{
using (AssessmentDbContext assessmentDbContext = new AssessmentDbContext())
{
if (grade == 0)
{
var result = assessmentDbContext.Database.SqlQuery <ResultViewModel>("DefaultScores").ToList();
return(result);
}
else
{
SqlParameter Grade = new SqlParameter("@Grade", grade);
var resultViewModels = assessmentDbContext.Database.SqlQuery <ResultViewModel>("Allscores @Grade", Grade).ToList();
foreach (var r in resultViewModels)
{
var stu = assessmentDbContext.Users.Where(user => user.UserId == r.UserId).FirstOrDefault();
r.StudentName = stu.Name;
}
return(resultViewModels);
}
}
}
public TestRepository()
{
db = new AssessmentDbContext();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
// Check the database (new'ing doesn't actually touch the DB yet though)
using (var ctx = new AssessmentDbContext())
{
// Make sure it's created. On initial creation, we'll also seed it
if (ctx.Database.EnsureCreated())
{
foreach (var p in (new MockPersonRepository()).GetAll())
{
var newPerson = new Person
{
// Skip ID since it's identity column
FirstName = p.FirstName,
LastName = p.LastName,
DateOfBirth = p.DateOfBirth,
DateOfDeath = p.DateOfDeath,
Street1 = p.Street1,
Street2 = p.Street2,
City = p.City,
State = p.State,
PostalCode = p.PostalCode,
Interests = p.Interests,
AvatarUrl = p.AvatarUrl
};
ctx.Add(newPerson);
}
ctx.SaveChanges();
}
}
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
if (!env.IsDevelopment())
{
app.UseSpaStaticFiles();
}
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller}/{action=Index}/{id?}");
});
app.UseSpa(spa =>
{
spa.Options.SourcePath = "ClientApp";
if (env.IsDevelopment())
{
spa.UseAngularCliServer(npmScript: "start");
}
});
}
public BookService(AssessmentDbContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
}
public UserRepository()
{
db = new AssessmentDbContext();
}
public PersonRepository(AssessmentDbContext db)
{
this._db = db;
}
public QuestionRepository()
{
db = new AssessmentDbContext();
}
public AccountControllerTest()
{
this.userRepository = new UserRepository();
this.testRepository = new TestRepository();
this.db = new AssessmentDbContext();
}
public HomeController(AssessmentDbContext assessmentContext)
{
this.assessmentContext = assessmentContext;
}
