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();
}
