public static int checkpasses(IEnumerable <Account> model, String login, String password, String at) { foreach (var m in model) { if (m.Login.Equals(login) && m.Password.Equals(password) && m.Account_Type.ToString().Equals(at)) { using (MojDziennikEntities db = new MojDziennikEntities()) { PersonAccount.instance.Name = login; PersonAccount.instance.AuthenticationType = at; PersonAccount.instance.accountId = m.Account_Id; PersonAccount.instance.IsAuthenticated = true; if (at == "Opiekun") { PersonAccount.instance.legalGuardianLog = true; PersonAccount.instance.AuthenticationType = "Uczen"; PersonAccount.instance.accountId = db.Legal_Guardian.Where(a => a.Account_Id == PersonAccount.instance.accountId).ToList().FirstOrDefault().Pupil.ToList().FirstOrDefault().Account_Id; } switch (m.Account_Type.ToString()) { case "Nauczyciel": return(1); case "Uczen": case "Opiekun": return(2); default: return(3); } } } } return(0); }
public static Employee GetEmployeeFromAccountId() { MojDziennikEntities db = new MojDziennikEntities(); int accountid = PersonAccount.getInstance().accountId; var account = db.Account.Where(a => a.Account_Id == accountid).FirstOrDefault(); //var temp = account return(account.Employee.ElementAt(0)); }
public static Legal_Guardian GetLegal_GuardianFromAccountId() { MojDziennikEntities db = new MojDziennikEntities(); int accid = PersonAccount.getInstance().accountId; Account account = db.Account.Where(a => a.Account_Id == accid).FirstOrDefault(); if (account == null) { return(new Legal_Guardian()); } return(account.Legal_Guardian.ElementAt(0)); }
public static Pupil GetPupilFromAccountId() { MojDziennikEntities db = new MojDziennikEntities(); int accid = PersonAccount.getInstance().accountId; Account account = db.Account.Where(a => a.Account_Id == accid).FirstOrDefault(); if (account == null) { return(new Pupil()); } return(account.Pupil.ElementAt(0)); }
public ActionResult LoginName() { using (MojDziennikEntities db = new MojDziennikEntities()) { PersonAccount person = PersonAccount.getInstance(); if (person.legalGuardianLog) { return(PartialView("_LoginPartial", db.Legal_Guardian.Where(a => a.Pupil.ToList().FirstOrDefault().Account_Id == person.accountId).ToList().FirstOrDefault())); } return(PartialView("_LoginPartial", Person.GetPerson())); } }
public ActionResult DeleteConfirmed(int id) { Account account; using (var mydb = new MojDziennikEntities()) { account = mydb.Account.Find(id); LogManager.createlog("delete", account.ToString()); } account = db.Account.Find(id); db.Account.Remove(account); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Subject_Id,Subject_Name")] Subject subject) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Subject.Find(subject.Subject_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(subject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(subject)); }
public ActionResult Edit([Bind(Include = "Account_Id,Login,Password,Account_Type")] Account account) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Account.Find(account.Account_Id).ToString(); } if (ModelState.IsValid) { LogManager.createlog("Edit", accountTemp); db.Entry(account).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(account)); }
public ActionResult Edit([Bind(Include = "Class_Room_Number,Employee_Id,Size,Subject_Id,Equipment_Description")] Class_Room class_Room) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Class_Room.Find(class_Room.Class_Room_Number).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(class_Room).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_ID", "First_Name", class_Room.Employee_Id); return(View(class_Room)); }
public ActionResult Edit([Bind(Include = "Employee_ID,First_Name,Middle_Name,Surname,Pesel_Number,Telefon_Number,Account_Id,Hire_Date,Birth_Date,Adress")] Employee employee) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Employee.Find(employee.Employee_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Account_Id = new SelectList(db.Account, "Account_Id", "Login", employee.Account_Id); return(View(employee)); }
public ActionResult Edit([Bind(Include = "Legal_Guardian_Id,First_Name,Middle_Name,Surname,Telefon_Number,Account_Id,Adress")] Legal_Guardian legal_Guardian) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Legal_Guardian.Find(legal_Guardian.Legal_Guardian_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(legal_Guardian).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Account_Id = new SelectList(db.Account, "Account_Id", "Login", legal_Guardian.Account_Id); return(View(legal_Guardian)); }
public ActionResult Edit([Bind(Include = "Event_Id,Employee_Id,Start_Time,Duration_In_Days,Describe,Account_Group")] Event @event) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Event.Find(@event.Event_Id).ToString(); } LogManager.createlog("Edit", accountTemp.ToString()); if (ModelState.IsValid) { db.Entry(@event).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_Id", "First_Name", @event.Employee_Id); return(View(@event)); }
public ActionResult Edit([Bind(Include = "Note_Id,Pupil_Id,Employee_Id,Note_Date,Positve,Describe")] Note note) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Note.Find(note.Note_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(note).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_ID", "First_Name", note.Employee_Id); ViewBag.Pupil_Id = new SelectList(db.Pupil, "Pupil_Id", "First_Name", note.Pupil_Id); return View(note); }
public ActionResult Edit([Bind(Include = "Class_Number,Profile,Employee_Id")] School_Class school_Class) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.School_Class.Find(school_Class.Class_Number).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(school_Class).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_ID", "First_Name", school_Class.Employee_Id); ViewBag.Class_Number = new SelectList(db.Lesson, "Class_Number", "Subject_Name", school_Class.Class_Number); return(View(school_Class)); }
public ActionResult Edit([Bind(Include = "Pupil_Id,First_Name,Middle_Name,Surname,Pesel_Number,Legal_Guardian_Id,Birth_Date,School_Id_Card_Number,Account_Id,Class_Number")] Pupil pupil) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Pupil.Find(pupil.Pupil_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(pupil).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Account_Id = new SelectList(db.Account, "Account_Id", "Login", pupil.Account_Id); ViewBag.Legal_Guardian_Id = new SelectList(db.Legal_Guardian, "Legal_Guardian_Id", "First_Name", pupil.Legal_Guardian_Id); ViewBag.Class_Number = new SelectList(db.School_Class, "Class_Number", "Profile", pupil.Class_Number); return(View(pupil)); }
public ActionResult Edit([Bind(Include = "Mark_Id,Value,Weight,Pupil_Id,Employee_Id,Subject_Id,Describe,Mark_Date")] Mark mark) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Mark.Find(mark.Mark_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(mark).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_ID", "First_Name", mark.Employee_Id); ViewBag.Subject_Id = new SelectList(db.Subject, "Subject_Id", "Subject_Name", mark.Subject_Id); ViewBag.Pupil_Id = new SelectList(db.Pupil, "Pupil_Id", "First_Name", mark.Pupil_Id); return(View(mark)); }
public ActionResult Edit([Bind(Include = "Lesson_Id,Class_Number,Subject_Id,Employee_Id,Day_Of_Week,Start_Time,Class_Room_Number")] Lesson lesson) { String accountTemp = ""; using (MojDziennikEntities tempdb = new MojDziennikEntities()) { accountTemp = tempdb.Lesson.Find(lesson.Lesson_Id).ToString(); } LogManager.createlog("Edit", accountTemp); if (ModelState.IsValid) { db.Entry(lesson).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Class_Room_Number = new SelectList(db.Class_Room, "Class_Room_Number", "Class_Room_Number", lesson.Class_Room_Number); ViewBag.Employee_Id = new SelectList(db.Employee, "Employee_ID", "First_Name", lesson.Employee_Id); ViewBag.Class_Number = new SelectList(db.School_Class, "Class_Number", "Profile", lesson.Class_Number); ViewBag.Subject_Id = new SelectList(db.Subject, "Subject_Id", "Subject_Name", lesson.Subject_Id); return(View(lesson)); }