// PUT: api/Lesson/5
public HttpResponseMessage Put(int id, [FromBody] lesson value)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
lesson s = db.lessons.SingleOrDefault(b => b.id == id);
if (s != null)
{
s.id_plan = value.id_plan;
s.id_staff = value.id_staff;
s.name = value.name;
s.content = value.content;
s.time_start = value.time_start;
s.time_end = value.time_end;
return(Request.CreateResponse(HttpStatusCode.OK, new lessonDTO(s.id, Convert.ToInt64(s.id_plan), Convert.ToInt64(s.id_staff), s.name, s.content, s.time_start.ToString(), s.time_end.ToString())));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public lesson CreateLesson(lesson lesson)
{
_context.lessons.Add(lesson);
_context.SaveChanges();
return(lesson);
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "del")
{
using (var db = new CstwebEntities())
{
int id = Convert.ToInt32(e.CommandArgument);
var le1 = db.lesrelation.Where(a => a.lesson == id).ToList();
try
{
db.lesrelation.Remove(le1[0]);
db.SaveChanges();
}
catch { }
try
{
db.lesrelation.Remove(le1[1]);
db.SaveChanges();
}
catch { }
try
{
db.lesrelation.Remove(le1[2]);
db.SaveChanges();
}
catch { }
lesson les = db.lesson.FirstOrDefault(a => a.id == id);
db.lesson.Remove(les);
db.SaveChanges();
Response.Write("<script>alert('删除成功');window.location = 'lessons.aspx';</script>");
}
}
}
public HttpResponseMessage Get(int id)
{
List <student_lesson> student_Lessons = barkode_ProjectEntities.student_lesson.Where(x => x.student_id == id).ToList();
List <LessonSender> lessonSenders = new List <LessonSender>();
foreach (student_lesson st in student_Lessons)
{
lesson lesson = barkode_ProjectEntities.lesson.Where(x => x.lesson_id == st.lesson_id).FirstOrDefault();
LessonSender lessonSender = new LessonSender()
{
lesson_id = lesson.lesson_id,
lesson_expiration_time = lesson.lesson_expiration_time.ToString(),
lesson_name = lesson.lesson_name,
lesson_onset_time = lesson.lesson_onset_time.ToString()
};
lessonSenders.Add(lessonSender);
}
if (lessonSenders != null)
{
message = Request.CreateResponse(HttpStatusCode.OK, lessonSenders);
return(message);
}
message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Ders Bulunamadi");
return(message);
}
public int GetFirstExerciseNumberFromLesson(lesson lesson)
{
var listOfExercises = lesson.exercises.Select(ex => ex.exercise_number).ToList();
listOfExercises.Sort();
return(listOfExercises.FirstOrDefault());
}
protected void FindSession()
{
try
{
using (var db = new CstwebEntities())
{
lesson les = (lesson)Session["less"];
TxtLessonName.Text = les.classname;
TxtTeach.Text = les.teach.ToString();
TxtExp.Text = les.experiment.ToString();
TxtCredits.Text = les.credits.ToString();
DDLClass.SelectedValue = les.lesscla.ToString();
int id;
if (Session["First1"] == null)
{
Label1.Text = "0";
LinFirst1.Text = "先修课程1";
}
else
{
Label1.Text = Session["First1"].ToString();
id = Convert.ToInt32(Label1.Text);
LinFirst1.Text = db.lesson.First(a => a.id == id).classname.ToString();;
}
if (Session["First2"] == null)
{
LinFirst2.Text = "先修课程2";
Label2.Text = "0";
}
else
{
Label2.Text = Session["First2"].ToString();
id = Convert.ToInt32(Label2.Text);
LinFirst2.Text = db.lesson.First(a => a.id == id).classname.ToString();;
}
if (Session["First3"] == null)
{
LinFirst3.Text = "先修课程3";
Label3.Text = "0";
}
else
{
Label3.Text = Session["First3"].ToString();
id = Convert.ToInt32(Label3.Text);
LinFirst3.Text = db.lesson.First(a => a.id == id).classname.ToString();;
}
Session["FList"] = null;
Session["Less"] = null;
Session["First1"] = null;
Session["First2"] = null;
Session["First3"] = null;
}
}
catch
{
}
}
public ChooseExerciseWindow(user user, lesson lesson)
{
_lesson = lesson;
_user = user;
_exerciseService = new ExerciseService();
_lessonService = new LessonService();
InitializeComponent();
PrepareExercisesButtons(false);
}
/// <summary>
/// 查询，根据课程代码查详细信息
/// </summary>
/// <param name="Lesson"></param>
/// <returns></returns>
public DataTable GetSubjectDetail(lesson Lesson)
{
string QuerySql = "select * from lesson where lessonCode=@lessonCode";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@lessonCode", Lesson.LessonCode),
};
DataTable dt = DAO.databaseContorl.GetDataSet(QuerySql, parameters);
return(dt);
}
private JObject selectStart(Command value)
{
var lessonTDS = JsonConvert.DeserializeObject <LessonTimeAndDateSetter>(value.data.ToString());
lesson lesson = _db.getLesson(lessonTDS.id);
lesson.iddays = lessonTDS.day;
lesson.start = lessonTDS.startsAt;
lesson.idclassrooms = lessonTDS.classroom;
_db.updateLesson(lessonTDS.id, lesson);
return(JObject.Parse(JsonConvert.SerializeObject(lessonTDS)));
}
// GET: api/Lesson/5
public lessonDTO Get(int id)
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
lesson s = db.lessons.SingleOrDefault(x => x.id == id);
if (s != null)
{
return(new lessonDTO(s.id, Convert.ToInt64(s.id_plan), Convert.ToInt64(s.id_staff), s.name, s.content, s.time_start.ToString(), s.time_end.ToString()));
}
else
{
return(null);
}
}
}
protected void FindQuery()
{
try
{
int id = Convert.ToInt32(Request.QueryString["id"]);
Session["lessonID"] = id.ToString();
using (var db = new CstwebEntities())
{
lesson les = db.lesson.First(a => a.id == id);
TxtLessonName.Text = les.classname;
TxtTeach.Text = les.teach.ToString();
TxtExp.Text = les.experiment.ToString();
TxtCredits.Text = les.credits.ToString();
try
{
LblFilename.Text = les.lesfile;
}
catch { }
myEditor.InnerHtml = les.etc;
DDLClass.SelectedValue = les.lesclass.ToString();
var less = db.lesrelation.Where(a => a.lesson == id).ToList();
try
{
id = Convert.ToInt32(less[0].firstlesson);
Label1.Text = id.ToString();
LinFirst1.Text = db.lesson.First(a => a.id == id).classname;
try
{
id = Convert.ToInt32(less[1].firstlesson);
Label2.Text = id.ToString();
LinFirst2.Text = db.lesson.First(a => a.id == id).classname;
try
{
id = Convert.ToInt32(less[2].firstlesson);
Label3.Text = id.ToString();
LinFirst3.Text = db.lesson.First(a => a.id == id).classname;
}
catch { }
}
catch { }
}
catch
{
}
}
}
catch { }
}
public void CreateLessonsForNewUser(user newUser)
{
foreach (var lessonSetup in _lessonsSetupRepository.GetAllLessonsSetup())
{
var lesson = new lesson
{
user_id = newUser.id,
lesson_number = lessonSetup.lesson_number,
is_done = false
};
lesson = _lessonRepository.CreateLesson(lesson);
_exerciseService.CreateExercisesForNewLesson(lesson);
}
}
// POST: api/Lesson
public HttpResponseMessage Post([FromBody] lesson obj)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
db.lessons.Add(obj);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, obj));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public void CreateExercisesForNewLesson(lesson lesson)
{
int lessonSetupId = _lessonsSetupRepository.GetLessonSetupIdByLessonNumber(lesson.lesson_number);
foreach (var exerciseSetup in _exercisesSetupRepository.GetExercisesSetupByLessonSetupId(lessonSetupId))
{
var exercise = new exercis
{
exercise_number = exerciseSetup.exercise_number,
lesson_id = lesson.id,
is_done = false
};
_exerciseRepository.CreateExercise(exercise);
}
}
private void addSubject(Lesson it, string groupID)
{
lesson lesson = new lesson();
lesson.idlessons = Guid.NewGuid().ToString().Replace("-", "");
lesson.idteachers = it.teacher_id;
lesson.idsubjects = findSubjectID(it.name, it.type, it.duration);
lesson.idgroups = groupID;
try
{
_db.insertLesson(ref lesson);
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e);
}
}
// DELETE: api/Lesson/5
public HttpResponseMessage Delete(int id)
{
try
{
using (QLMamNonEntities db = new QLMamNonEntities())
{
lesson s = db.lessons.SingleOrDefault(x => x.id == id);
db.lessons.Remove(s);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public ActionResult Barcode(session session)
{
string text = RandomSerialGenerator.generator().ToString();
barcode barcode = new barcode();
session.session_content = text;
barcode.barcode_content = text;
session.session_onset_time = DateTime.Now;
session.session_expiration_time = DateTime.Now.AddMinutes(5);
lesson lesson = db.lesson.Where(x => x.lesson_id == session.lesson_id).FirstOrDefault();
session.lesson = lesson;
db.barcode.Add(barcode);
session.barcode = barcode;
db.session.Add(session);
db.SaveChanges();
return(RedirectToAction("index", "home", new { @text = text }));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
student Student = new student();
if (context.Session["id"] != null)
{
Student.ID = context.Session["id"].ToString();
string sql = "select lessonCode from lessonTable where stuId='" + Student.ID + "'";
databaseContorl dbs = new databaseContorl();
DataTable dt = dbs.GetDataAdapter(sql);
DataRow[] dr = dt.Select();
if (dt.Rows.Count > 0)
{
string Course = dr[0]["lessoncode"].ToString();
string[] everyCourse = Course.Split('@');
lesson Lesson = new lesson();
string strCourse = string.Empty;
stuMgr StuMgr = new stuMgr();
foreach (string course in everyCourse)
{
Lesson.LessonCode = course;
DataRow[] dataRows = StuMgr.GetSubjectDetail(Lesson).Select();
foreach (DataRow dar in dataRows)
{
strCourse += "<tr><td>" + dar["lessonName"] + "</td><td>" + dar["lessonTeam"] + "</td><td>" + dar["lessonTeacher"] + "</td><td>" + dar["lessonStartTime"] + "~" + dar["lessonEndTime"] + "</td><td>" + dar["lessonAddress"] + "</td>/tr>";
}
}
context.Response.Write(strCourse);
}
else
{
context.Response.Write("你还没有选课");
}
}
else
{
context.Response.Write("fail");
}
}
private List <List <TimeSuggestion> > getPossibleTimeSlots(List <List <TimeSlot> > combinedTimeSlots, lesson lesson)
{
var timeSuggestions = new List <List <TimeSuggestion> >();
var duration = lesson.subject.time.GetValueOrDefault();
foreach (var day in combinedTimeSlots)
{
var timeSuggestionForADay = new List <TimeSuggestion>();
for (var timeSlot = 0; timeSlot < (day.Count - duration); ++timeSlot)
{
bool aviable = true;
for (int currentTime = 0; currentTime < duration; currentTime++)
{
if (day.ElementAt(timeSlot + currentTime).Availability == Availability.NonAvailable)
{
aviable = false;
break;
}
}
if (aviable)
{
timeSuggestionForADay.Add(new TimeSuggestion {
startsAt = timeSlot, duration = duration, possibleClassrooms = new List <Classroom>()
});
}
}
timeSuggestions.Add(timeSuggestionForADay);
}
return(timeSuggestions);
}
public void tijiao()
{
for (int i = 0; i < Go.Count; i++)
{
for (int l = 0; l < Go.Count; l++)
{
if (i == l)
{
continue;
}
if (Go[i].transform.Find("星期").GetComponent <Dropdown>().value == Go[l].transform.Find("星期").GetComponent <Dropdown>().value &&
Go[i].transform.Find("天").GetComponent <Dropdown>().value == Go[l].transform.Find("天").GetComponent <Dropdown>().value)
{
tip.SetActive(true);
tip.transform.Find("Text").GetComponent <Text>().text = "上课时间冲突";
return;
}
}
}
for (int i = 0; i < 12; i++)
{
if (All.Classes[i].Academyindex == academyindex && All.Classes[i].Subjectindex == subjectindex)
{
index = i;
break;
}
}
lesson Le = new lesson();
All.classID++;
Le.ID = All.classID;
Le.name = Name.text;
Le.jieshu = int.Parse(jieshu.text);
Le.times = new List <string>();
if (Le.daytimes == null)
{
Le.daytimes = new List <int>();
}
if (Le.weektimes == null)
{
Le.weektimes = new List <int>();
}
for (int i = 0; i < Go.Count; i++)
{
Debug.Log(weektime[Go[i].transform.Find("星期").GetComponent <Dropdown>().value] + " " + daytime[Go[i].transform.Find("天").GetComponent <Dropdown>().value]);
Le.times.Add(weektime[Go[i].transform.Find("星期").GetComponent <Dropdown>().value] + " " + daytime[Go[i].transform.Find("天").GetComponent <Dropdown>().value]);
Le.daytimes.Add(Go[i].transform.Find("天").GetComponent <Dropdown>().value);
Le.weektimes.Add(Go[i].transform.Find("星期").GetComponent <Dropdown>().value);
foreach (string str in classtimes)
{
for (int j = 0; j < Le.daytimes.Count; j++)
{
if (str == ((Le.daytimes[j] + 1) * 10 + Le.weektimes[j]).ToString())
{
tip.SetActive(true);
tip.transform.Find("Text").GetComponent <Text>().text = "时间重复！";
return;
}
}
}
}
if (All.Classes[index].Lessons == null)
{
All.Classes[index].Lessons = new List <lesson>();
}
foreach (lesson Lesson in All.Classes[index].Lessons)
{
if (Lesson.name == Le.name)
{
tip.SetActive(true);
tip.transform.Find("Text").GetComponent <Text>().text = "课程名字重复！";
return;
}
}
for (int j = 0; j < Le.daytimes.Count; j++)
{
classtimes.Add(((Le.daytimes[j] + 1) * 10 + Le.weektimes[j]).ToString());
}
All.Classes[index].Lessons.Add(Le);
Debug.Log(All.Classes[index].Lessons.Count);
tip.SetActive(true);
tip.transform.Find("Text").GetComponent <Text>().text = "提交成功";
}
protected void Button1_Click(object sender, EventArgs e)
{
lesson Lesson = new lesson();
}
public IList <exercis> GetExercisesByUserSingleLesson(lesson lesson)
{
return(_exerciseRepository.GetExercisesByUserSingleLesson(lesson));
}
protected void SaveSession()
{
using (var db = new CstwebEntities())
{
lesson les = new lesson();
int temp;
double cr;
if (TxtLessonName.Text.Trim() != "") les.classname = TxtLessonName.Text.Trim();
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
try
{
if (TxtTeach.Text.Trim() != "")
{
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
}
}
catch { }
try
{
if (TxtExp.Text.Trim() != "")
{
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
}
}
catch { }
try
{
if (TxtCredits.Text.Trim() != "")
{
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
}
}
catch { }
try
{
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
if (tempstr.Trim() != "")
{
les.etc = tempstr;
}
}
catch { }
try
{
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
}
catch { }
Session["Less"] = les;
if (Label1.Text == "0") Session["First1"] = null;
else Session["First1"] = Label1.Text;
if (Label2.Text == "0") Session["First2"] = null;
else Session["First2"] = Label2.Text;
if (Label3.Text == "0") Session["First3"] = null;
else Session["First3"] = Label3.Text;
}
}
protected void BtnPost_Click(object sender, EventArgs e)
{
int temp;
double cr;
if (IsOK())
{
using (var db = new CstwebEntities())
{
if (Session["lessonID"].ToString() != "0")
{
try
{
temp = Convert.ToInt32(Session["lessonID"].ToString());
var del = db.lesrelation.Where(a => a.lesson == temp).ToList();
lesrelation les1;
try
{
les1 = del[0];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
try
{
les1 = del[1];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
try
{
les1 = del[2];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
lesson les = db.lesson.First(a => a.id == temp);
les.classname = TxtLessonName.Text.Trim();
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
temp = Convert.ToInt32(Session["lessonID"].ToString());
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
les.etc = tempstr.Trim();
les1 = new lesrelation();
les1.lesson = temp;
db.SaveChanges();
if (Label1.Text != "0")
{
temp = Convert.ToInt32(Label1.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label2.Text != "0")
{
temp = Convert.ToInt32(Label2.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label3.Text != "0")
{
temp = Convert.ToInt32(Label3.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
Session["FList"] = null;
Session["Less"] = null;
Session["First1"] = null;
Session["First2"] = null;
Session["First3"] = null;
Session["lessonID"] = null;
Response.Write("<script language=javascript>alert('修改成功');window.location = 'lessons.aspx';</script>");
}
catch
{
Response.Write("<script>alert('修改失败')</script>");
}
}
else
{
try
{
lesson les = new lesson();
lesrelation les1 = new lesrelation();
les.classname = TxtLessonName.Text.Trim();
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
temp = Convert.ToInt32(Session["lessonID"].ToString());
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
les.etc = tempstr.Trim();
db.lesson.Add(les);
db.SaveChanges();
temp = db.lesson.First(a => a.classname == TxtLessonName.Text.Trim()).id;
les1.lesson = temp;
if (Label1.Text != "0")
{
temp = Convert.ToInt32(Label1.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label2.Text != "0")
{
temp = Convert.ToInt32(Label2.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label3.Text != "0")
{
temp = Convert.ToInt32(Label3.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
Session["FList"] = null;
Session["Less"] = null;
Session["First1"] = null;
Session["First2"] = null;
Session["First3"] = null;
Session["lessonID"] = null;
Response.Write("<script language=javascript>alert('添加成功');window.location = 'lessons.aspx';</script>");
}
catch { Response.Write("<script>alert('添加失败')</script>"); }
}
}
}
}
protected void SaveSession()
{
using (var db = new CstwebEntities())
{
lesson les = new lesson();
int temp;
double cr;
if (TxtLessonName.Text.Trim() != "")
{
les.classname = TxtLessonName.Text.Trim();
}
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
try
{
if (TxtTeach.Text.Trim() != "")
{
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
}
}
catch { }
try
{
if (TxtExp.Text.Trim() != "")
{
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
}
}
catch { }
try
{
if (TxtCredits.Text.Trim() != "")
{
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
}
}
catch { }
try
{
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
if (tempstr.Trim() != "")
{
les.etc = tempstr;
}
}
catch { }
try
{
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
}
catch { }
Session["Less"] = les;
if (Label1.Text == "0")
{
Session["First1"] = null;
}
else
{
Session["First1"] = Label1.Text;
}
if (Label2.Text == "0")
{
Session["First2"] = null;
}
else
{
Session["First2"] = Label2.Text;
}
if (Label3.Text == "0")
{
Session["First3"] = null;
}
else
{
Session["First3"] = Label3.Text;
}
}
}
protected void BtnPost_Click(object sender, EventArgs e)
{
int temp;
double cr;
if (IsOK())
{
using (var db = new CstwebEntities())
{
if (Session["lessonID"].ToString() != "0")
{
try
{
temp = Convert.ToInt32(Session["lessonID"].ToString());
var del = db.lesrelation.Where(a => a.lesson == temp).ToList();
lesrelation les1;
try
{
les1 = del[0];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
try
{
les1 = del[1];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
try
{
les1 = del[2];
db.lesrelation.Remove(les1);
db.SaveChanges();
}
catch { }
lesson les = db.lesson.First(a => a.id == temp);
les.classname = TxtLessonName.Text.Trim();
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
temp = Convert.ToInt32(Session["lessonID"].ToString());
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
les.etc = tempstr.Trim();
les1 = new lesrelation();
les1.lesson = temp;
db.SaveChanges();
if (Label1.Text != "0")
{
temp = Convert.ToInt32(Label1.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label2.Text != "0")
{
temp = Convert.ToInt32(Label2.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label3.Text != "0")
{
temp = Convert.ToInt32(Label3.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
Session["FList"] = null;
Session["Less"] = null;
Session["First1"] = null;
Session["First2"] = null;
Session["First3"] = null;
Session["lessonID"] = null;
Response.Write("<script language=javascript>alert('修改成功');window.location = 'lessons.aspx';</script>");
}
catch
{
Response.Write("<script>alert('修改失败')</script>");
}
}
else
{
try
{
lesson les = new lesson();
lesrelation les1 = new lesrelation();
les.classname = TxtLessonName.Text.Trim();
cr = Convert.ToDouble(TxtCredits.Text.Trim());
les.credits = cr;
temp = Convert.ToInt32(TxtTeach.Text.Trim());
les.teach = temp;
temp = Convert.ToInt32(TxtExp.Text.Trim());
les.experiment = temp;
temp = Convert.ToInt32(DDLClass.SelectedValue);
les.lesscla = temp;
temp = Convert.ToInt32(Session["lessonID"].ToString());
if (LblFilename.Text != "")
{
les.lesfile = LblFilename.Text;
}
string tempstr = Server.HtmlDecode(myEditor.InnerHtml);
les.etc = tempstr.Trim();
db.lesson.Add(les);
db.SaveChanges();
temp = db.lesson.First(a => a.classname == TxtLessonName.Text.Trim()).id;
les1.lesson = temp;
if (Label1.Text != "0")
{
temp = Convert.ToInt32(Label1.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label2.Text != "0")
{
temp = Convert.ToInt32(Label2.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
if (Label3.Text != "0")
{
temp = Convert.ToInt32(Label3.Text);
les1.firstlesson = temp;
db.lesrelation.Add(les1);
db.SaveChanges();
}
Session["FList"] = null;
Session["Less"] = null;
Session["First1"] = null;
Session["First2"] = null;
Session["First3"] = null;
Session["lessonID"] = null;
Response.Write("<script language=javascript>alert('添加成功');window.location = 'lessons.aspx';</script>");
}
catch { Response.Write("<script>alert('添加失败')</script>"); }
}
}
}
}
private IEnumerable <List <TimeSuggestion> > GetTimeSlotsWithFreeClassooms(List <List <TimeSuggestion> > possibleTimeSlots, lesson lesson)
{
List <classroom> classrooms = new List <classroom>();
classrooms = _db.getAllClassRooms().Where(cr => cr.croomtype != null).Where(cr => cr.croomtype.idcroomtype == lesson.subject.type).ToList();
var classroomsTimeSlots = classrooms.Select(cr => new Pair(cr, GetLessonTimeSlotsForClassroom(cr))).ToList();
for (var day = 0; day < possibleTimeSlots.Count; ++day)
{
for (var timeSlot = 0; timeSlot < possibleTimeSlots.ElementAt(day).Count; timeSlot++)
{
foreach (var classroom in classroomsTimeSlots)
{
var cr = (classroom)classroom.First;
var crTimeSlots = (List <List <TimeSlot> >)classroom.Second;
var free = true;
for (var start = 0; start < lesson.subject.time.GetValueOrDefault(); ++start)
{
if (crTimeSlots.ElementAt(day).ElementAt(timeSlot + start).Availability ==
Availability.NonAvailable)
{
free = false;
}
}
if (free)
{
possibleTimeSlots.ElementAt(day).ElementAt(timeSlot).possibleClassrooms.Add(Converter.ConvertDbClassroomToClassroom(cr));
}
}
}
}
return(possibleTimeSlots.Select(day => day.Where(ts => ts.possibleClassrooms.Any()).ToList()));
}
public IList <exercis> GetExercisesByUserSingleLesson(lesson lesson)
{
return(_context.exercises.Where(ex => ex.lesson_id == lesson.id).ToList());
}
public IList <int> GetDoneExercisesNumbersByLesson(lesson lesson)
{
return(_exerciseRepository.GetDoneExercisesNumbersByLessonId(lesson.id));
}
