public string DropCourse(string sno, string cno)
{
string result = null;
SelectCourseDBContext selectDbCourse = new SelectCourseDBContext();
SelectedCourse selectedCourse = new SelectedCourse();
SelectedCourseDBContext selectedDbCourse = new SelectedCourseDBContext();
var selectedResult = selectedDbCourse.SelectedCourses.Where(u => u.SNO == sno && u.CNO == cno).FirstOrDefault();
int id = selectedResult.ID;
var deleteResult = selectedDbCourse.SelectedCourses.First(u => u.ID == id);
selectedDbCourse.SelectedCourses.Remove(deleteResult);
var selectResult = selectDbCourse.SelectCourses.Where(u => u.CNO == cno).FirstOrDefault();
selectedDbCourse.SaveChanges();
selectResult.SELECTEDNUM--;
selectDbCourse.SaveChanges();
result = "退课成功!";
return(result);
}
public string StudentSelectCourse(string sno, string cno, string cname, string tname, string cdept, string credit, string time)
{
string result = null;
SelectCourseDBContext selectDbContext = new SelectCourseDBContext();
var message = selectDbContext.SelectCourses.Where(u => u.CNO == cno && u.CNAME == cname).FirstOrDefault();
SelectedCourseDBContext selectedDbContext = new SelectedCourseDBContext();
var isSelected = selectedDbContext.SelectedCourses.Where(u => u.CNO == cno && u.SNO == sno).FirstOrDefault();
var classTime = selectedDbContext.SelectedCourses.Where(u => u.SNO == sno).ToList();
if (message == null)
{
result = "该课程不存在，请核实该课程信息!";
}
else if (message.SELECTEDNUM == message.CAPACITY)
{
result = "该课程所选人数已达人数上限!";
}
else if (isSelected != null)
{
result = "您已经选过该课程!";
}
else if (classTime != null)
{
if (IsConflict(classTime, time))
{
result = "课时冲突";
}
else
{
SelectedCourse selectedCourse = new SelectedCourse()
{
SNO = sno, CNO = cno, CNAME = cname, CREDIT = Convert.ToInt32(credit), CDEPT = cdept, TNAME = tname, TIME = time, SEMESTER = "15-16春"
};
selectedDbContext.SelectedCourses.Add(selectedCourse);
selectedDbContext.SaveChanges();
message.SELECTEDNUM++;
selectDbContext.SaveChanges();
result = "选课成功!";
}
}
return(result);
}
