protected void AddCourse(int sid)
{
var student = new StudentDAO();
var course = new CourseDAO();
sid = int.Parse(userinput_StudentID_Text.Text);
var data = new DataService();
List <CourseDAO> c = data.GetCourses().Where(x => x.Id == int.Parse(opencourses.SelectedValue)).ToList();
//sid, c[0].Id, c[0].CourseNumber, c[0].StartTime
data.InsertEnrollment(new StudentDAO()
{
Id = sid
}, new CourseDAO()
{
Id = c[0].Id, CourseNumber = c[0].CourseNumber, StartTime = c[0].StartTime
});
GetCoursesByStudentID(sid);
}
public object Modify(Course info)
{
try
{
ValidateTeacher(info);
ValidateMaxTeacherCourses(info);
// ValidateNoDuplicates(info, false);
var model = info.Map();
using (var dao = new CourseDAO())
{
return(dao.Modify(model));
}
}
catch (Exception)
{
throw;
}
}
public void DropClass(object sender, EventArgs e)
{
var sid = int.Parse(studentid_text.Text);
var courseName = schedule.SelectedItem.ToString();
var data = new DataService();
StudentDAO student = new StudentDAO()
{
id = sid
};
CourseDAO course = new CourseDAO()
{
name = courseName
};
data.dropCourseFromStudent(student, course);
schedule.Items.Clear();
schedule.Visible = false;
deletebutton.Visible = false;
}
/// <summary>
/// Rejects all selected requests
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnReject_Click(object sender, EventArgs e)
{
List <int> selectedIDs = GetSelectedIDs();
RegistrationRequestDAO requestDAO = new RegistrationRequestDAO(
ConfigurationManager.ConnectionStrings["flexiLearn"].ConnectionString);
CourseDAO courseDAO = new CourseDAO(
ConfigurationManager.ConnectionStrings["flexiLearn"].ConnectionString);
foreach (int id in selectedIDs)
{
RegistrationRequest request = requestDAO.SearchByRegistrationID(id);
request.RegistrationStatus = Status.REJECTED;
requestDAO.ModifyStatus(request);
}
allRequests = requestDAO.ReadAll();
GVRegistrationRequests.DataSource = allRequests;
GVRegistrationRequests.DataBind();
}
public void ValidateMaxTeacherCourses(Course info)
{
using (var dao = new TeacherDAO())
{
var query = dao.Query(e => true);
var qTeacher = query.Where(e => e.ID == info.Teacher.ID).First().Map();
if (!qTeacher.HasPlaza)
{
using (var coursedao = new CourseDAO())
{
var coursequery = coursedao.Query(e => true);
var qCourse = coursequery.Where(e => e.IDPROFESOR == info.Teacher.ID).ToArray();
if (qCourse.Length >= Common.Constants.Constants.MAX_TEACHER_CURSOS)
{
throw new Exception(Common.Constants.Messages.PROFESOR_MAXIMO_MATERIAS);
}
}
}
}
}
public void AddCourse(object sender, EventArgs e)
{
var data = new DataService();
CourseDAO course = new CourseDAO();
course.name = coursename_textbox.Text;
course.number = int.Parse(coursenumber_textbox.Text);
course.maxStudents = int.Parse(coursemax_textbox.Text);
course.StartClassTime = TimeSpan.Parse(starttime_textbox.Text);
course.EndClassTime = TimeSpan.Parse(endtime_textbox.Text);
data.AddCourse(course);
coursename_textbox.Text = string.Empty;
coursenumber_textbox.Text = string.Empty;
coursemax_textbox.Text = string.Empty;
starttime_textbox.Text = string.Empty;
endtime_textbox.Text = string.Empty;
addcoursefields.Visible = false;
addremovecourse_listbox.Items.Clear();
addremovecourse_div.Visible = false;
}
public List <Course> Get(string text)
{
using (var dao = new CourseDAO())
{
var query = dao.Query(e => true);
if (!string.IsNullOrWhiteSpace(text))
{
query = query.Where(e => e.NOMBRE.Contains(text));
}
var courses = query.ToArray();
var coursesLe = courses.Length;
using (var teadao = new TeacherDAO())
{
var ids = courses.Select(e => e.IDPROFESOR).Distinct();
var teachers = teadao.Query(e => ids.Contains(e.ID)).ToArray();
return(courses.Select(e => e.Map(teachers)).ToList());
}
}
}
public JsonResult Detail(string id)
{
var model = new CourseDAO().getdetail(id).Select(x => new
{
IDCOURSE = x.ID,
NAMECOURSE = x.NAME,
DESCRIPTION = x.DESCRIPTION,
SEMESTER = (x.SEMESTER == null) ? null : (new SEMESTER
{
ID = (x.SEMESTER.ID == null) ? null : (x.SEMESTER.ID),
TITLE = (x.SEMESTER.TITLE == null) ? null : (x.SEMESTER.TITLE)
}),
SUBJECT = (x.SUBJECT == null) ? null : (new SUBJECT
{
ID = x.SUBJECT.ID,
NAME = x.SUBJECT.NAME
}),
TEACH = (x.TEACH == null) ? null : (new TEACH
{
C_USER = (x.TEACH.C_USER == null) ? null : (new C_USER
{
ID = (x.TEACH.C_USER.ID == null) ? null : (x.TEACH.C_USER.ID),
FIRST_NAME = (x.TEACH.C_USER.FIRST_NAME == null) ? null : (x.TEACH.C_USER.FIRST_NAME),
LAST_NAME = (x.TEACH.C_USER.LAST_NAME == null) ? null : (x.TEACH.C_USER.LAST_NAME),
MIDDLE_NAME = (x.TEACH.C_USER.MIDDLE_NAME == null) ? null : (x.TEACH.C_USER.MIDDLE_NAME),
FACULTY = (x.TEACH.C_USER.FACULTY == null) ? null : (new FACULTY
{
ID = (x.TEACH.C_USER.FACULTY.ID == null) ? null : (x.TEACH.C_USER.FACULTY.ID),
NAME = (x.TEACH.C_USER.FACULTY.NAME == null) ? null : (x.TEACH.C_USER.FACULTY.NAME)
})
})
})
});
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Subjects(string semester_id) //= "JZDN2020112521542821")
{
//**************************Test*******************************************
//User user = new User();
//user.id = "JZDN2020112521542805";
//user.name = "A";
//Session.Add(CommonConstants.USER_SESSION, user);
//******************Test**************************************************
CommonFunc comf = new CommonFunc();
string user_id = comf.GetIdUserBySession();
if (semester_id == null)
{
semester_id = comf.GetIdSemesterBySession();
}
CourseDAO courseDAO = new CourseDAO();
var listCourse = courseDAO.GetCourseByTeacherAndSemester(user_id, semester_id);
return(View(listCourse));
}
public void Test_CancelCourse()
{
var service = new DataService();
var person = service.GetPerson(5);
var course = new CourseDAO()
{
Title = "TS-001", Department = "Testing", Professor = person, StartTime = 20, EndTime = 21, Capacity = 1, Credit = 1, Active = true
};
var actual = false;
if (service.AddCourse(course))
{
foreach (var item in service.GetCourses())
{
if (item.Title == course.Title && item.Department == course.Department && item.Professor.Id == course.Professor.Id && item.StartTime == course.StartTime && item.EndTime == course.EndTime)
{
actual = service.CancelCourse(item);
}
}
}
Assert.True(actual);
}
public JsonResult CourseInSemester(string id = "20211")
{
var model = new CourseDAO().courseinsemester(id).Select(x => new {
ID = x.ID,
NAME = x.NAME,
DESCRIPTION = x.DESCRIPTION,
TEACH = (x.TEACH == null) ? null : (new TEACH
{
C_USER = (x.TEACH.C_USER == null) ? null : (new C_USER
{
ID = (x.TEACH.C_USER.ID == null) ? null : (x.TEACH.C_USER.ID),
FIRST_NAME = (x.TEACH.C_USER.FIRST_NAME == null) ? null : (x.TEACH.C_USER.FIRST_NAME),
LAST_NAME = (x.TEACH.C_USER.LAST_NAME == null) ? null : (x.TEACH.C_USER.LAST_NAME),
MIDDLE_NAME = (x.TEACH.C_USER.MIDDLE_NAME == null) ? null : (x.TEACH.C_USER.MIDDLE_NAME),
})
}),
});
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
public static bool Update(Course item)
{
return(CourseDAO.Update(item));
}
public bool dropCourseFromStudent(StudentDAO student, CourseDAO course)
{
return(studentstuff.dropCourse(StudentMapper.MapToStudent(student), CourseMapper.MapToCourse(course)));
}
public bool AddCourse(CourseDAO course)
{
var c = CourseMapper.MapToCourse(course);
return(InsertData.InsertCourse(c));
}
public void CourseInsert(Course c)
{
CourseDAO cDAO = new CourseDAO();
cDAO.Insert(c);
}
public static bool Delete(Guid id)
{
return(CourseDAO.Delete(id));
}
public bool InsertEnrollment(StudentDAO student, CourseDAO course)
{
return(rsc.InsertEnrollment(student, course));
}
public static List <Course> List(Course filters = null, Func <Database.CourseData, object> sort = null)
{
return(CourseDAO.List(filters, sort));
}
public bool ModifyCourse(CourseDAO course, int newCapacity, int newStart, int newEnd)
{
var c = CourseMapper.MapToCourse(course);
return(db.ModifyCourse(c, newCapacity, newStart, newEnd));
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text != "" ||
dtStartDate.EditValue != null ||
dtEndDate.EditValue != null)
{
DataConnect.Course entity = new DataConnect.Course();
entity.Name = txtName.Text;
entity.StartDate = DateTime.Parse(dtStartDate.EditValue.ToString());
entity.EndDate = DateTime.Parse(dtEndDate.EditValue.ToString());
entity.Status = chbStatus.Checked == true ? true : false;
if (Function == 1)
{
int result = new CourseDAO().Insert(entity);
if (result > 0)
{
DataConnect.Semester se1 = new DataConnect.Semester();
se1.Name = txtKy1.Text;
se1.CourseID = result;
se1.StartDate = DateTime.Parse(dtKy1StartDate.EditValue.ToString());
se1.EndDate = DateTime.Parse(dtKy1EndDate.EditValue.ToString());
se1.Status = entity.Status;
DataConnect.Semester se2 = new DataConnect.Semester();
se2.Name = txtKy2.Text;
se2.CourseID = result;
se2.StartDate = DateTime.Parse(dtKy2StartDate.EditValue.ToString());
se2.EndDate = DateTime.Parse(dtKy2EndDate.EditValue.ToString());
se2.Status = entity.Status;
if (new SemesterDAO().Insert(se1) == true && new SemesterDAO().Insert(se2) == true)
{
DialogResult = DialogResult.OK;
this.Close();
}
}
}
else if (Function == 2)
{
entity.CourseID = course.CourseID;
if (new CourseDAO().Edit(entity) == true)
{
DataConnect.Semester se1 = new SemesterDAO().ListByCourseID(entity.CourseID)[0];
se1.Name = txtKy1.Text;
se1.CourseID = entity.CourseID;
se1.StartDate = DateTime.Parse(dtKy1StartDate.EditValue.ToString());
se1.EndDate = DateTime.Parse(dtKy1EndDate.EditValue.ToString());
se1.Status = entity.Status;
DataConnect.Semester se2 = new SemesterDAO().ListByCourseID(entity.CourseID)[1];
se2.Name = txtKy2.Text;
se2.CourseID = entity.CourseID;
se2.StartDate = DateTime.Parse(dtKy2StartDate.EditValue.ToString());
se2.EndDate = DateTime.Parse(dtKy2EndDate.EditValue.ToString());
se2.Status = entity.Status;
if (new SemesterDAO().Edit(se1) == true && new SemesterDAO().Edit(se2) == true)
{
DialogResult = DialogResult.OK;
this.Close();
}
}
else
{
}
}
}
else
{
MessageBox.Show("Mời bạn nhập đầy đủ thông tin", "Thông báo");
}
}
public bool CartCourse(CourseDAO course, PersonDAO person)
{
return(rsc.CartCourse(course, person));
}
public bool RegisterCourse(CourseDAO course, PersonDAO person)
{
return(rsc.RegisterCourse(course, person));
}
public bool AddCourse(CourseDAO course)
{
return(rsc.AddCourse(course));
}
public bool DeleteCourseEnrollment(StudentDAO student, CourseDAO course)
{
return(rsc.DeleteEnrollment(student, course));
}
public bool DropCourse(CourseDAO course, PersonDAO person)
{
return(rsc.DropCourse(course, person));
}
public bool InsertCourse(CourseDAO course)
{
return(rsc.InsertCourse(course));
}
public void DeleteCourse(int id)
{
CourseDAO course = new CourseDAO();
course.Delete(id);
}
public bool CancelCourse(CourseDAO course)
{
return(rsc.CancelCourse(course));
}
public bool CancelCourse(CourseDAO course)
{
var c = CourseMapper.MapToCourse(course);
return(db.CancelCourse(c));
}
public bool ModifyCourse(CourseDAO course, int newCapacity, int newStart, int newEnd)
{
return(rsc.ModifyCourse(course, newCapacity, newStart, newEnd));
}
