public JsonResult editParent(string id, string UserName, string Password, string LastName,
string FirstName, string Address, string Phone, string Email)
{
int X = Int32.Parse(id);
using (DnevnikEntities db = new DnevnikEntities())
{
Parent d = db.Parents.Find(X);
d.UserName = UserName;
d.Password = Crypto.HashPassword(Password);
d.LastName = LastName;
d.FirstName = FirstName;
d.Address = Address;
d.Phone = Phone;
d.Email = Email;
d.RoleId = 5;
db.Entry(d).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public static void DeleteGradesBySubject(int semester, int student_id, int subject_id)
{
List <int> f = new List <int>()
{
9, 10, 11, 12, 1, 21
};
List <int> s = new List <int>()
{
2, 3, 4, 5, 6, 22, 23
};
List <int> toCheck = new List <int>();
if (semester == 1)
{
toCheck = f;
}
else
{
toCheck = s;
}
using (var db = new DnevnikEntities())
{
//db.Database.ExecuteSqlCommand("DELETE FROM Grades WHERE Subject_id = @subject_id AND Student_id = @student_id",
// new SqlParameter("@subject_id", subject_id),
// new SqlParameter("@student_id", student_id));
db.Grades.RemoveRange(db.Grades
.Where(x =>
toCheck.Contains(x.Grade_month) &&
x.Subject_id == subject_id &&
x.Student_id == student_id));
db.SaveChanges();
}
}
public JsonResult addManyParents(string UserName, string Amount, string ClassId)
{
int x = Int32.Parse(Amount);
string uName = "";
int y = Int32.Parse(ClassId);
using (DnevnikEntities db = new DnevnikEntities())
{
Parent d = new Parent();
Pupil p = new Pupil();
for (int i = 1; i <= x; i++)
{
uName = UserName + i.ToString();
d.UserName = uName;
d.Password = Crypto.HashPassword("1111");
d.RoleId = 5;
p.Username = uName + "child";
p.Parent = d.Id;
p.Class = y;
p.RoleId = 6;
p.Password = Crypto.HashPassword("1111");
db.Pupils.Add(p);
db.Parents.Add(d);
db.SaveChanges();
ModelState.Clear();
}
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
internal static void RemoveAllAttendance()
{
var db = new DnevnikEntities();
db.Attendances.RemoveRange(db.Attendances.ToList());
db.SaveChanges();
db.Dispose();
}
internal static void DeleteAllGrades()
{
var db = new DnevnikEntities();
db.Grades.RemoveRange(db.Grades.ToList());
db.SaveChanges();
db.Dispose();
}
public static void DeleteTeacher(int id)
{
using (var db = new DnevnikEntities())
{
db.Teachers.Remove(db.Teachers.Where(t => t.Id == id).FirstOrDefault());
db.SaveChanges();
}
}
public static void DeleteSubject(int id)
{
using (var db = new DnevnikEntities())
{
db.Schedules.RemoveRange(db.Schedules.Where(s => s.Subject_id == id));
db.Grades.RemoveRange(db.Grades.Where(g => g.Subject_id == id));
db.Subjects.Remove(db.Subjects.Where(s => s.Id == id).FirstOrDefault());
db.SaveChanges();
}
}
public static void AddClass(Class c)
{
using (var db = new DnevnikEntities())
{
db.Classes.Add(c);
var entry = db.Entry(c);
entry.State = EntityState.Added;
db.SaveChanges();
}
}
public static void DeleteOldAttendance(DateTime date, int class_id)
{
using (var db = new DnevnikEntities())
{
db.Attendances
.RemoveRange(db.Attendances
.Where(a => a.Student.Class_id == class_id && a.Date1 == date)
.ToList());
db.SaveChanges();
}
}
public static void DeleteAllStudents()
{
GradesRepository.DeleteAllGrades();
AttendanceRepository.RemoveAllAttendance();
var db = new DnevnikEntities();
db.Students.RemoveRange(db.Students);
db.SaveChanges();
db.Dispose();
}
public static void AddTeacher(Teacher t)
{
t.Class_id = 1;
var db = new DnevnikEntities();
db.Teachers.Add(t);
var entry = db.Entry(t);
entry.State = EntityState.Added;
db.SaveChanges();
db.Dispose();
}
public JsonResult addDiary(string tId, string dDate, string sId, string hTS, string dTS, string mark, string subject)
{
int teacher = Int32.Parse(tId);
int student = int.Parse(sId);
decimal Mark = 0;
string attendance = " ";
int Subject = int.Parse(subject);
if (mark == "-")
{
attendance = "-";
}
else
{
Mark = decimal.Parse(mark);
attendance = "+";
}
DateTime?DDate = DateTime.Parse(dDate);
if (Request.IsAjaxRequest())
{
DnevnikEntities db = new DnevnikEntities();
var diary = ifExists(DDate, student, Subject);
if (diary == null)
{
Diary tt = new Diary();
tt.Attandance = attendance;
tt.DateOfIssue = DDate;
tt.Details = dTS;
tt.Homework = hTS;
tt.Mark = Mark;
tt.Pupil = student;
tt.Subject = Subject;
db.Diaries.Add(tt);
db.SaveChanges();
return(new JsonResult {
Data = "success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
else
{
return(new JsonResult {
Data = "exists", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
return(new JsonResult
{
Data = "error",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public static void ImportStudents(List <Student> students)
{
var db = new DnevnikEntities();
foreach (var stud in students)
{
db.Students.Add(stud);
db.Entry(stud).State = EntityState.Added;
}
db.SaveChanges();
db.Dispose();
}
public static void AddNewSchedule(List <Schedule> periods)
{
var db = new DnevnikEntities();
foreach (var p in periods)
{
db.Schedules.Add(p);
db.Entry(p).State = EntityState.Added;
}
db.SaveChanges();
db.Dispose();
}
public static void UpdateClasses(List <Class> c)
{
using (var db = new DnevnikEntities())
{
foreach (var item in c)
{
db.Classes.Add(item);
var entry = db.Entry(item);
entry.State = EntityState.Modified;
}
db.SaveChanges();
}
}
public JsonResult deleteClass(string id)
{
int X = Int32.Parse(id);
using (DnevnikEntities db = new DnevnikEntities())
{
Class d = db.Classes.Find(X);
db.Entry(d).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public static void UpdateTeachers(List <Teacher> teachers)
{
using (var db = new DnevnikEntities())
{
foreach (var item in teachers)
{
db.Teachers.Add(item);
var entry = db.Entry(item);
entry.State = EntityState.Modified;
entry.Property(e => e.IsAdmin).IsModified = false;
}
db.SaveChanges();
}
}
public static void AddSubject(string title, bool isZip)
{
using (var db = new DnevnikEntities())
{
Subject s = new Subject()
{
Title = title,
IsZip = isZip
};
db.Subjects.Add(s);
var entry = db.Entry(s);
entry.State = EntityState.Added;
db.SaveChanges();
}
}
public static void UpdateSubjects(List <Subject> subjects)
{
using (var db = new DnevnikEntities())
{
foreach (var sub in subjects)
{
if (sub.Title != null && sub.Title != String.Empty)
{
db.Subjects.Add(sub);
var entry = db.Entry(sub);
entry.State = EntityState.Modified;
}
}
db.SaveChanges();
}
}
public static void AddStudent(Student student, int class_id)
{
Student stud = new Student()
{
EGN = student.EGN,
Number = student.Number,
Name = student.Name,
Class_id = class_id
};
var db = new DnevnikEntities();
db.Students.Add(stud);
db.Entry(stud).State = EntityState.Added;
db.SaveChanges();
db.Dispose();
}
public static void SaveStudents(List <Student> students)
{
var db = new DnevnikEntities();
foreach (var s in students)
{
db.Students.Attach(s);
var entry = db.Entry(s);
entry.Property(e => e.Number).IsModified = true;
entry.Property(e => e.Name).IsModified = true;
entry.Property(e => e.Note).IsModified = true;
entry.Property(e => e.EGN).IsModified = true;
}
db.SaveChanges();
db.Dispose();
}
public static void DeleteStudent(int id, int class_id)
{
var db = new DnevnikEntities();
var student = db.Students.Where(s => s.Id == id && s.Class_id == class_id).FirstOrDefault();
if (student == null)
{
throw new ArgumentException();
}
db.Grades.RemoveRange(db.Grades.Where(g => g.Student_id == id));
db.Attendances.RemoveRange(db.Attendances.Where(a => a.Student_id == id).ToList());
db.Students.Remove(student);
//remove attendance records
db.SaveChanges();
db.Dispose();
}
public JsonResult addClass(string Name, string Level, string Teacher)
{
int lvl = Int32.Parse(Level);
int teach = Int32.Parse(Teacher);
using (DnevnikEntities db = new DnevnikEntities())
{
Class d = new Class();
d.Name = Name;
d.Level = lvl;
d.Teacher = teach;
db.Classes.Add(d);
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public JsonResult addSubject(string SubjectName, string Level)
{
int l = int.Parse(Level);
using (DnevnikEntities db = new DnevnikEntities())
{
Subject d = new Subject();
d.SubjectName = SubjectName;
d.Level = l;
db.Subjects.Add(d);
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public JsonResult editClass(string id, string Name, string Level, string Teacher)
{
int X = Int32.Parse(id);
int teach = Int32.Parse(Teacher);
int lvl = Int32.Parse(Level);
using (DnevnikEntities db = new DnevnikEntities())
{
Class d = db.Classes.Find(X);
d.Name = Name;
d.Level = lvl;
d.Teacher = teach;
db.Entry(d).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public JsonResult addManager(string UserName, string Password, string LastName,
string FirstName, string Address, string Phone, string Email)
{
using (DnevnikEntities db = new DnevnikEntities())
{
Director d = new Director();
d.UserName = UserName;
d.Password = Crypto.HashPassword(Password);
d.LastName = LastName;
d.FirstName = FirstName;
d.Address = Address;
d.Phone = Phone;
d.Email = Email;
db.Directors.Add(d);
db.SaveChanges();
ModelState.Clear();
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public JsonResult editSubject(string id, string SubjectName, string Level)
{
int X = Int32.Parse(id);
int level = int.Parse(Level);
using (DnevnikEntities db = new DnevnikEntities())
{
Subject d = new Subject();
d = db.Subjects.Find(X);
db.Subjects.Attach(d);
d.SubjectName = SubjectName;
d.Level = level;
db.Entry(d).Property(p => p.Level).IsModified = true;
db.Entry(d).Property(p => p.SubjectName).IsModified = true;
db.SaveChanges();
ModelState.Clear();
return(Json("", JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditFirstTime(HttpPostedFileBase ImageFile, Director d, string pass, string passConf)
{
if (ModelState.IsValid)
{
if (pass == passConf)
{
if (ImageFile != null)
{
string fileName = Path.GetFileNameWithoutExtension(ImageFile.FileName);
string fileExtension = Path.GetExtension(ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + fileExtension;
d.ImagePath = "~/image/directorPhoto/" + fileName;
fileName = Path.Combine(Server.MapPath("~/image/directorPhoto/"), fileName);
ImageFile.SaveAs(fileName);
}
var db = new DnevnikEntities();
db.Directors.Attach(d);
d.Password = Crypto.HashPassword(pass);
db.Entry(d).Property(p => p.Password).IsModified = true;
db.Entry(d).Property(p => p.LastName).IsModified = true;
db.Entry(d).Property(p => p.FirstName).IsModified = true;
db.Entry(d).Property(p => p.DoB).IsModified = true;
db.Entry(d).Property(p => p.Address).IsModified = true;
db.Entry(d).Property(p => p.Phone).IsModified = true;
db.Entry(d).Property(p => p.Email).IsModified = true;
db.Entry(d).Property(p => p.ImagePath).IsModified = true;
db.SaveChanges();
return(RedirectToAction("Index", new { id = d.Id }));
}
else
{
ViewBag.Pass = "******";
return(View());
}
}
return(View());
}
public JsonResult addManyTeachers(string UserName, string Amount)
{
int x = Int32.Parse(Amount);
string uName = "";
using (DnevnikEntities db = new DnevnikEntities())
{
Teacher d = new Teacher();
for (int i = 1; i <= x; i++)
{
uName = UserName + x.ToString();
d.UserName = uName;
d.Password = Crypto.HashPassword("12345");
d.RoleId = 4;
db.Teachers.Add(d);
db.SaveChanges();
ModelState.Clear();
}
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public JsonResult addManyClasses(string Name, string Amount)
{
int lvl = Int32.Parse(Amount);
using (DnevnikEntities db = new DnevnikEntities())
{
Class d = new Class();
for (int i = 1; i <= lvl; i++)
{
d.Name = Name;
d.Level = i;
db.Classes.Add(d);
db.SaveChanges();
ModelState.Clear();
}
return(Json(d, JsonRequestBehavior.AllowGet));
}
}