public void Update(int ID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); OpenRegister or = db.OpenRegisters.SingleOrDefault(x => x.ID == ID); or.StatusID = 4; db.SaveChanges(); }
public void Update(string username, string password) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Account acc = db.Accounts.SingleOrDefault(x => x.UserName == username); acc.PassWord = password; db.SaveChanges(); }
public void Delete(int classID, int studentID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); StudentDetail sd = db.StudentDetails.SingleOrDefault(x => x.StudentID == studentID && x.ClassID == classID); db.StudentDetails.Remove(sd); db.SaveChanges(); }
public void UpdateStatus(int ClassID, int StatusID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID); c.StatusID = StatusID; db.SaveChanges(); }
public void Delete(int ClassID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID); db.Classes.Remove(c); db.SaveChanges(); }
public void Insert(int ID, string name, string username) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Admin a = new Admin(); a.ID = ID; a.Name = name; a.UserName = username; db.Admins.Add(a); db.SaveChanges(); }
public void Insert(int classID, int studentID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); StudentDetail sd = new StudentDetail(); sd.ID = 0; sd.ClassID = classID; sd.StudentID = studentID; db.StudentDetails.Add(sd); db.SaveChanges(); }
public void Insert(string username, string password, int positionID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Account acc = new Account(); acc.UserName = username; acc.PassWord = password; acc.PositionID = positionID; db.Accounts.Add(acc); db.SaveChanges(); }
public void Update(int ClassID, int subjectID, int dayID, int timeID, int roomID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID); c.SubjectID = subjectID; c.DayID = dayID; c.TimeID = timeID; c.RoomID = roomID; db.SaveChanges(); }
public void Insert() { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); OpenRegister or = new OpenRegister(); DateTime dt = DateTime.Now; or.StatusID = 3; or.ID = GetNextID(); or.DayStart = dt; or.DayEndClassRegister = dt.AddDays(7); or.DayEnd = dt.AddDays(14); db.OpenRegisters.Add(or); db.SaveChanges(); }
public void Insert(string name, string gender, string country, int branchID, DateTime birth, string phone, string username) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Teacher t = new Teacher(); t.Name = name; t.ID = GetNextID(); t.Gender = gender; t.Country = country; t.BranchID = branchID; t.Birth = birth; t.Phone = phone; t.UserName = username; db.Teachers.Add(t); db.SaveChanges(); }
public void Insert(string name, DateTime birth, string gender, string country, string address, string username, int courseID, int branchID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Student s = new Student(); s.ID = GetNextID(); s.Birth = birth; s.Gender = gender; s.Country = country; s.Address = address; s.UserName = username; s.CourseID = courseID; s.BranchID = branchID; s.Name = name; db.Students.Add(s); db.SaveChanges(); }
public string ReceiveClass(int ClassID, string username, int dayID, int timeID) { if (CheckSameSchedule(new ModifyTeacher().GetTeacherByUsername(username).ID, dayID, timeID)) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID); c.TeacherID = new ModifyTeacher().GetTeacherByUsername(username).ID; c.StatusID = 3; c.DayStart = c.DayStart.Value.AddDays(21); c.DayEnd = c.DayEnd.Value.AddDays(91); db.SaveChanges(); return("true"); } else { return("Lớp muốn nhận trùng ngày và giờ dạy"); } }
public void InsertForClassRe(int classTypeID, int subjectID, int dayID, int timeID, int roomID, int branchID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = new Class(); c.ID = GetNextID(); c.ClassTypeID = classTypeID; c.CourseID = 0; c.BranchID = branchID; c.SubjectID = subjectID; c.DayID = dayID; c.TimeID = timeID; c.RoomID = roomID; c.TeacherID = 0; c.StatusID = 1; c.NumberOfStudent = 0; c.DayStart = DateTime.Now; c.DayEnd = DateTime.Now; db.Classes.Add(c); db.SaveChanges(); }
public void Insert(int classTypeID, int subjectID, int dayID, int timeID, int roomID, int branchID, string username, int statusID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); Class c = new Class(); c.ID = GetNextID(); c.ClassTypeID = classTypeID; c.CourseID = GetCourseID(subjectID, branchID); c.BranchID = branchID; c.SubjectID = subjectID; c.DayID = dayID; c.TimeID = timeID; c.RoomID = roomID; c.TeacherID = new ModifyTeacher().GetTeacherByUsername(username).ID; c.StatusID = statusID; c.NumberOfStudent = 0; c.DayStart = new ModifyOpenRegister().GetDayStartByStatusID(3).AddDays(21); c.DayEnd = new ModifyOpenRegister().GetDayStartByStatusID(3).AddDays(126); db.Classes.Add(c); db.SaveChanges(); }