private void UpdateCurs(string cursNume, Teacher t1, string numevechi1)
{
using (var context = new EducatieIncluzivaDBContext())
{
Course curs = (from p in context.Courses
where p.ProfesorId == t1.UserId && p.Nume.Equals(numevechi1)
select p).FirstOrDefault();
if (curs != null)
{
curs.Nume = cursNume;
DbEntityEntry <Course> entry = context.Entry(curs);
entry.State = EntityState.Modified;
context.SaveChanges();
}
else
{
Course cur = new Course();
cur.Nume = cursNume;
cur.ProfesorId = t1.UserId;
context.Courses.Add(cur);
context.SaveChanges();
}
}
}
public ActionResult RegisterElevi(ElevRegisterModel model)
{
if (ModelState.IsValid)
{
ResourcesRepository rr = new ResourcesRepository();
HighSchool hs = rr.GetHighSchoolByName(model.ScoalaDeProvenienta);
Student elev = new Student(model.Parola, model.Nume, model.Prenume, model.Mail, hs);
//User user = new User(model.Parola, model.Nume, model.Prenume, model.Mail);
using (var db = new EducatieIncluzivaDBContext())
{
//db.Useri.Add(user);
db.Entry(hs).State = EntityState.Unchanged;
db.Students.Add(elev);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
FormsAuthentication.SetAuthCookie(model.Mail, false /* createPersistentCookie */);
return(RedirectToAction("Index", "Home"));
}
}
// If we got this far, something failed, redisplay form
return(View());
}
public void UpdateTeacher(string mail, string imageUrl)
{
using (var context = new EducatieIncluzivaDBContext())
{
var teacher = this.GetProfesoriByMail(mail);
teacher.ImageUrl = imageUrl;
context.Teachers.Attach(teacher);
context.Entry(teacher).State = EntityState.Modified;
context.SaveChanges();
}
}
public void UpdateTeacher(string nume, string prenume,
string mail, string bio,
string numevechi1, string numevechi2, string c1, string c2)
{
using (var context = new EducatieIncluzivaDBContext())
{
// get the teacher
var theUser = this.GetProfesoriByMail(mail);
//update general info about the teacher
theUser.Description = bio;
theUser.Mail = mail;
theUser.Nume = nume;
theUser.Prenume = prenume;
/* Course cur = new Course();
* cur.Nume = c1;
* Course cur2 = new Course();
* cur2.Nume = c2;
*
* cur.ProfesorId = theUser.UserId;
* cur2.ProfesorId = theUser.UserId;
*
* //if the teacher already has some courses
* if (theUser.Materii != null)
* {
* if (!theUser.Materii.Contains(cur))
* {
* context.Courses.Add(cur);
* }
* if (!theUser.Materii.Contains(cur2))
* {
* context.Courses.Add(cur2);
* }
* }
* else
* {
* context.Courses.Add(cur);
* context.Courses.Add(cur2);
*
* }
*/
UpdateCurs(c1, theUser, numevechi1);
UpdateCurs(c2, theUser, numevechi2);
DbEntityEntry <Teacher> entry = context.Entry(theUser);
entry.State = EntityState.Modified;
context.SaveChanges();
}
}
public void UpdateUser(string parola, string nume, string prenume, string mail,
HighSchool scoalaDeProvenienta)
{
using (var context = new EducatieIncluzivaDBContext())
{
var theUser = this.GetUserByMail(mail);
theUser.Parola = parola == null ? theUser.Parola : parola;
theUser.Nume = nume == null ? theUser.Nume : nume;
theUser.Prenume = prenume == null ? theUser.Prenume : prenume;
theUser.Mail = mail == null ? theUser.Mail : mail;
theUser.ScoalaDeProvenienta = (scoalaDeProvenienta == theUser.ScoalaDeProvenienta) ? theUser.ScoalaDeProvenienta : scoalaDeProvenienta;
context.Users.Attach(theUser);
context.Entry(theUser).State = EntityState.Modified;
context.SaveChanges();
}
}
public void UpdateTeacher(string nume, string prenume,
string mail, string bio,
string numevechi1, string numevechi2, string numevechi3, string c2, string c1, string c3)
{
using (var context = new EducatieIncluzivaDBContext())
{
// get the teacher
var theUser = this.GetProfesoriByMail(mail);
//update general info about the teacher
theUser.Description = bio;
theUser.Mail = mail;
theUser.Nume = nume;
theUser.Prenume = prenume;
UpdateCurs(c1, theUser, numevechi1);
UpdateCurs(c2, theUser, numevechi2);
UpdateCurs(c3, theUser, numevechi3);
DbEntityEntry <Teacher> entry = context.Entry(theUser);
entry.State = EntityState.Modified;
context.SaveChanges();
}
}
public ActionResult AddLesson(HttpPostedFileBase file, string mail, string materie)
{
var rr = new ResourcesRepository();
// Verify that the user selected a file
if (file != null && file.ContentLength > 0)
{
ViewData["fileUp"] = null;
// extract only the fielname
var fileName = Path.GetFileName(file.FileName);
// store the file inside ~/App_Data/uploads folder
var subPath = "~/App_Data/uploads/" + mail;
bool IsExists = System.IO.Directory.Exists(Server.MapPath(subPath));
if (!IsExists)
{
System.IO.Directory.CreateDirectory(Server.MapPath(subPath));
}
var subPath2 = "~/App_Data/uploads/" + mail + "/" + materie;
bool IsExists2 = System.IO.Directory.Exists(Server.MapPath(subPath2));
if (!IsExists2)
{
System.IO.Directory.CreateDirectory(Server.MapPath(subPath2));
}
var path = Path.Combine(Server.MapPath("~/App_Data/uploads/"), mail + "/", materie, fileName);
file.SaveAs(path);
using (var db = new EducatieIncluzivaDBContext())
{
var myTeacher = db.Teachers.SingleOrDefault(item => item.Mail == mail);
var curs = from p in db.Courses
where p.Nume.Equals(materie) && p.ProfesorId == myTeacher.UserId
select p;
/* Course cur = new Course();
* cur.Nume = materie;
* cur.ProfesorId = myTeacher.UserId;
*/
Lesson l = new Lesson();
l.ProfesorOwner = myTeacher;
l.ProfesorOwnerId = myTeacher.UserId;
l.Titlu = fileName;
foreach (var c in curs)
{
c.Lectii.Add(l);
break;
}
/* if (myTeacher.Materii != null)
* {
* if (myTeacher.Materii.Contains(cur))
* {
* db.Lessons.Add(l);
* }
* else
* {
* Console.WriteLine("Nu exista");
* }
* }
* else
* {
* Console.WriteLine("e NULL");
* }
* /*
* if (myTeacher.Materii[0].Nume.Equals(materie))
* {
* nr = 0;
* }
* else if (myTeacher.Materii[1].Nume.Equals(materie))
* {
* nr = 1;
* }
* else
* {
* nr = 2;
* }
* myTeacher.Materii[nr].Lectii.Add(l);
*/
DbEntityEntry <Teacher> entry = db.Entry(myTeacher);
entry.State = EntityState.Modified;
db.SaveChanges();
ViewData["fileUp"] = "incarcat";
ViewData["materie"] = materie;
}
}
var model = rr.GetUserByMail(mail);
// redirect back to the index action to show the form once again
return(View("../../Views/AddLesson/AddLesson", model));
}