public async Task <ActionResult> Login(LoginViewModel model)
{
if (ModelState.IsValid)
{
using (JournalContext db = new JournalContext())
{
User user = await db.Users /*.Include(u => u.UserRollId)*/.FirstOrDefaultAsync(u => u.Email == model.Email && u.Password == model.Password);
if (user == null)
{
ModelState.AddModelError("", "Неправильний логін або пароль");
}
else
{
ClaimsIdentity claim = new ClaimsIdentity("ApplicationCookie", ClaimsIdentity.DefaultNameClaimType, ClaimsIdentity.DefaultRoleClaimType);
claim.AddClaim(new Claim(ClaimTypes.NameIdentifier, user.ID.ToString(), ClaimValueTypes.String));
claim.AddClaim(new Claim(ClaimsIdentity.DefaultNameClaimType, user.Email, ClaimValueTypes.String));
claim.AddClaim(new Claim("http://schemas.microsoft.com/accesscontrolservice/2010/07/claims/identityprovider",
"OWIN Provider", ClaimValueTypes.String));
claim.AddClaim(new Claim(ClaimTypes.Role, user.UserRollID.ToString()));
// if (user.UserRollId != null)
// claim.AddClaim(new Claim(ClaimsIdentity.DefaultRoleClaimType, user.UserRollId.Name, ClaimValueTypes.String));
AuthenticationManager.SignOut();
AuthenticationManager.SignIn(new AuthenticationProperties
{
IsPersistent = true
}, claim);
return(RedirectToAction("Index", "Home"));
}
}
}
return(View(model));
}
public ActionResult Edit(Guid id)
{
using (JournalContext db = new JournalContext())
{
var StudentRole = Guid.Parse(Roles.Pupil);
ClassViewModels model = new ClassViewModels();
Class newClass = db.Classes.Find(id);
model.ID = newClass.ID;
model.Name = newClass.Name;
model.Year = newClass.Year;
model.SchoolID = newClass.SchoolID;
model.SelectedSchool = db.Schools.Where(c => c.ID == newClass.SchoolID).Select(x => x.ShortName).FirstOrDefault();
model.Users = db.Users.Where(c => c.UserRollID == StudentRole && c.SchoolID == model.SchoolID && c.ClassID == model.ID).Select(x => new SelectListItem()
{
Value = x.ID.ToString(), Text = x.FirstName + " " + x.LastName
}).ToList();
model.NewUsersList = db.Users.Where(c => c.UserRollID == StudentRole && c.SchoolID == model.SchoolID && c.ClassID == null).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.FirstName + " " + c.LastName
}).ToList();
if (model == null)
{
return(HttpNotFound());
}
return(View(model));
}
}
public static void SeedData(this IServiceScopeFactory scopeFactory, ILogger logger)
{
_logger = logger;
using (var serviceScope = scopeFactory.CreateScope())
{
var context = serviceScope.ServiceProvider.GetService <JournalContext>();
_userManager = serviceScope.ServiceProvider.GetService <UserManager <ApplicationUser> >();
_roleManager = serviceScope.ServiceProvider.GetService <RoleManager <JournalRole> >();
_logger.LogDebug("Starting database table data seeding.");
_context = context;
if (_context == null || _userManager == null)
{
throw new ArgumentNullException("Database or identity objects are not set");
}
if (_context.AllMigrationsApplied())
{
InitializeIdentity();
ApplyData(false);
}
else
{
_logger.LogDebug("Database migrations are not correctly applied.");
}
}
}
public ActionResult Index()
{
using (JournalContext db = new JournalContext())
{
return(View());
}
}
public ActionResult Edit(StudySubjectViewModel model)
{
var identity = (ClaimsIdentity)User.Identity;
var idString = identity.Claims.Where(c => c.Type == ClaimTypes.NameIdentifier)
.Select(c => c.Value).SingleOrDefault();
Guid UserId;
if (Guid.TryParse(idString, out UserId))
{
using (JournalContext db = new JournalContext())
{
User user = db.Users.Find(UserId);
var pupilRole = Guid.Parse(Roles.Pupil);
model.Users = db.Users.Where(c => c.UserRollID == pupilRole && c.SchoolID == user.SchoolID).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.FirstName + " " + c.LastName
}).ToList();
model.Subjects = db.Subjects.Where(c => c.Teacher.SchoolID == user.SchoolID).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.SubjectType.Name
}).ToList();
if (ModelState.IsValid)
{
StudySubject studySubject = db.StudySubject.Find(model.ID);
studySubject.UserID = Guid.Parse(model.SelectedUser);
studySubject.SubjectID = Guid.Parse(model.SelectedSubject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
}
return(RedirectToAction("Login"));
}
public AzureSQLJournalRepository(string dbConnectionString)
{
var optionsBuilder = new DbContextOptionsBuilder <JournalContext>();
optionsBuilder.UseSqlServer(dbConnectionString);
_context = new JournalContext(optionsBuilder.Options);
}
public void Configure(IApplicationBuilder app)
{
var serviceScopeFactory = app.ApplicationServices.GetRequiredService <IServiceScopeFactory>();
var loggerFactory = app.ApplicationServices.GetRequiredService <ILoggerFactory>();
using (var serviceScope = serviceScopeFactory.CreateScope())
{
var dbContext = serviceScope.ServiceProvider.GetService <JournalContext>();
// All contexts that share the same service provider will share the same InMemory database
var options = CreateNewContextOptions();
// Run the test against one instance of the context
using (var context = new JournalContext(options))
{
context.Database.Migrate();
serviceScopeFactory.SeedData(loggerFactory.CreateLogger("Seeding data"));
}
dbContext.Database.OpenConnection(); // see Resource #2 link why we do this
dbContext.Database.EnsureCreated();
// run Migrations
dbContext.Database.Migrate();
}
}
public ActionResult Create()
{
var identity = (ClaimsIdentity)User.Identity;
var idString = identity.Claims.Where(c => c.Type == ClaimTypes.NameIdentifier)
.Select(c => c.Value).SingleOrDefault();
Guid id;
if (Guid.TryParse(idString, out id))
{
using (JournalContext db = new JournalContext())
{
User user = db.Users.Find(id);
var pupilRole = Guid.Parse(Roles.Pupil);
StudySubjectViewModel studySubject = new StudySubjectViewModel();
studySubject.Users = db.Users.Where(c => c.UserRollID == pupilRole && c.SchoolID == user.SchoolID).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.FirstName + " " + c.LastName
}).ToList();
studySubject.Subjects = db.Subjects.Where(c => c.Teacher.SchoolID == user.SchoolID).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.SubjectType.Name
}).ToList();
return(View(studySubject));
}
}
return(RedirectToAction("Login"));
}
// GET: Subject
public ActionResult Index()
{
using (JournalContext db = new JournalContext())
{
return(View(db.SubjectTypes.ToList()));
}
}
// GET: Class
public ActionResult Index()
{
using (JournalContext db = new JournalContext())
{
var identity = (ClaimsIdentity)User.Identity;
var idString = identity.Claims.Where(c => c.Type == ClaimTypes.NameIdentifier)
.Select(c => c.Value).SingleOrDefault();
Guid id;
if (Guid.TryParse(idString, out id))
{
User user = db.Users.Find(id);
var newClassList = db.Classes.Where(c => c.SchoolID == user.SchoolID).Include(c => c.Users).Include(s => s.School).Select(s => new ClassViewModels()
{
ID = s.ID,
Name = s.Name,
Year = s.Year,
SelectedSchool = s.School.ShortName,
Users = s.Users.Select(c => new SelectListItem
{
Value = c.ID.ToString(),
Text = c.FirstName + " " + c.LastName
}
).ToList()
}).ToList();
return(View(newClassList));
}
return(RedirectToAction("Login"));
}
}
public ActionResult AccountInfo()
{
var identity = (ClaimsIdentity)User.Identity;
var idString = identity.Claims.Where(c => c.Type == ClaimTypes.NameIdentifier)
.Select(c => c.Value).SingleOrDefault();
Guid id;
if (Guid.TryParse(idString, out id))
{
using (JournalContext db = new JournalContext())
{
UserViewModels model = new UserViewModels();
User user = db.Users.Find(id);
model.ID = user.ID;
model.FirstName = user.FirstName;
model.LastName = user.LastName;
model.Age = user.Age;
model.UserRollID = user.UserRollID;
model.Email = user.Email;
model.Phone = user.Phone;
model.Password = user.Password;
model.ClassID = user.ClassID;
model.Degree = user.Degree;
model.Info = user.Info;
model.RegisterDate = user.RegisterDate;
model.UserRollSelected = db.UserRoles.Where(c => c.ID == model.UserRollID).Select(x => x.Name).FirstOrDefault();
model.ClassSelected = db.Classes.Where(c => c.ID == model.ClassID).Select(x => x.Name).FirstOrDefault();
return(View(model));
}
}
AuthenticationManager.SignOut();
return(View("LogIn"));
}
public void PersistOperation(OperationDTO operationDTO)
{
using (JournalContext db = new JournalContext())
{
db.OperationDTOes.Add(operationDTO);
db.SaveChanges();
}
}
public List <OperationDTO> GetOperationsById(string id)
{
using (JournalContext db = new JournalContext())
{
List <OperationDTO> operations = db.OperationDTOes.Where(obj => obj.Id == id).ToList <OperationDTO>();
return(operations);
}
}
public async Task <Activity> CreateActivity(Activity activity)
{
using (var context = new JournalContext())
{
context.Activity.Add(activity);
return(await context.SaveChangesAsync());
}
}
public Activity GetActivityByID(int activityId)
{
Activity activity = new Activity();
using (var context = new JournalContext())
{
activity = context.Activity.Where(a => a.ActivityID == activityId).FirstOrDefault();
}
return(activity);
}
public List <Activity> GetActivities()
{
List <Activity> activities = new List <Activity>();
using (var context = new JournalContext())
{
activities = context.Activity.ToList();
}
return(activities);
}
public ActionResult DeleteConfirm(SubjectViewModels model)
{
using (JournalContext db = new JournalContext())
{
Subject subject = db.Subjects.Find(model.ID);
db.Subjects.Remove(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(StudySubjectViewModel model)
{
using (JournalContext db = new JournalContext())
{
StudySubject studySubject = db.StudySubject.Find(model.ID);
db.StudySubject.Remove(studySubject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteConfirm(Guid id)
{
using (JournalContext db = new JournalContext())
{
SubjectType subjectType = db.SubjectTypes.Find(id);
db.SubjectTypes.Remove(subjectType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult UserRole(UserRole userRole)
{
using (JournalContext db = new JournalContext())
{
userRole.ID = Guid.NewGuid();
db.UserRoles.Add(userRole);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public static void SeedData(JournalContext context, ILogger logger)
{
if (_context == null)
{
throw new ArgumentNullException("Database context is not set");
}
_logger = logger;
_context = context;
ApplyData(true);
}
public ActionResult Details(Guid id)
{
using (JournalContext db = new JournalContext()) {
SubjectType subjectType = db.SubjectTypes.Find(id);
if (subjectType == null)
{
return(HttpNotFound());
}
return(View(subjectType));
}
}
static void Main(string[] args)
{
using (var context = new JournalContext())
{
var users = context.Users.ToList();
foreach (var user in users)
{
Console.WriteLine(user.FirstName + " " + user.LastName);
}
}
Console.ReadKey();
}
public ActionResult Edit(Guid id)
{
using (JournalContext db = new JournalContext())
{
School school = db.Schools.Find(id);
if (school == null)
{
return(HttpNotFound());
}
return(View(school));
}
}
public ActionResult Create()
{
using (JournalContext db = new JournalContext())
{
ClassViewModels model = new ClassViewModels();
model.Schools = db.Schools.Select(school => new SelectListItem()
{
Value = school.ID.ToString(), Text = school.ShortName
}).ToList();
return(View(model));
}
}
// GET: StudySubject/Details/5
public ActionResult Details(Guid id)
{
using (JournalContext db = new JournalContext())
{
StudySubject studySubject = db.StudySubject.Find(id);
StudySubjectViewModel model = new StudySubjectViewModel();
model.UserID = studySubject.UserID;
model.SelectedUser = db.Users.Where(c => c.ID == model.UserID).Select(c => c.FirstName + " " + c.LastName).FirstOrDefault();
model.SubjectID = studySubject.SubjectID;
model.SelectedSubject = db.Subjects.Where(c => c.ID == model.SubjectID).Include(c => c.SubjectType).Select(c => c.SubjectType.Name).FirstOrDefault();
return(View(model));
}
}
// GET: TeacherSubject/Details/5
public ActionResult Details(Guid id)
{
using (JournalContext db = new JournalContext())
{
Subject teacherSubject = db.Subjects.Find(id);
SubjectViewModels model = new SubjectViewModels();
model.TeacherID = teacherSubject.TeacherID;
model.SubjectTypeID = teacherSubject.SubjectTypeID;
model.SelectedTeacher = db.Users.Where(c => c.ID == model.TeacherID).Select(c => c.FirstName + " " + c.LastName).FirstOrDefault();
model.SelectedSubjectType = db.SubjectTypes.Where(c => c.ID == model.SubjectTypeID).Select(c => c.Name).FirstOrDefault();
return(View(model));
}
}
public ActionResult DeleteConfirmed(Guid id)
{
using (JournalContext db = new JournalContext())
{
Class newClass = db.Classes.Find(id);
var userToUpdateClass = db.Users.Where(c => c.ClassID == newClass.ID);
foreach (User user in userToUpdateClass)
{
user.ClassID = null;
}
db.Classes.Remove(newClass);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(ClassViewModels model)
{
using (JournalContext db = new JournalContext())
{
if (ModelState.IsValid)
{
Class newmodel = db.Classes.Find(model.ID);
newmodel.Name = model.Name;
newmodel.Year = model.Year;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
}
public ActionResult Create(StudySubjectViewModel model)
{
using (JournalContext db = new JournalContext())
{
if (ModelState.IsValid)
{
StudySubject studySubject = (StudySubject)model;
studySubject.ID = Guid.NewGuid();
db.StudySubject.Add(studySubject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(model));
}
