public CourseClass(int MealID, string Description, decimal Price, courses CourseNo)
{
this.MealID = MealID;
this.Description = Description;
this.Price = Price;
this.Course = CourseNo;
}
public async Task <IActionResult> Putcourses(int id, courses courses)
{
if (id != courses.CourseId)
{
return(BadRequest());
}
_context.Entry(courses).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!coursesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <courses> > Postcourses(courses courses)
{
_context.Courses.Add(courses);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getcourses", new { id = courses.CourseId }, courses));
}
public JsonResult AddCourse(FormCollection collection)
{
var teacherArr = JsonConvert.DeserializeObject <List <int> >(collection["teachers"]);
if (teacherArr.Count <= 0 || collection["name"] == null)
{
return(Json(new { status = "failed" }, JsonRequestBehavior.AllowGet));
}
courses newCourse = new courses {
name = collection["name"], description = collection["description"]
};
db.courses.Add(newCourse);
db.SaveChanges();
int courseId = db.courses.Max(a => a.id);
//here we take all the teachers assigned to this class form a list within the form and add them to the course
foreach (int i in teacherArr)
{
teachers neu = new teachers {
courseId = courseId, userId = i
};
db.teachers.Add(neu);
}
db.SaveChanges();
account firstTeach = db.account.Find(teacherArr[0]);
return(Json(new { status = "SuccessAdd", courseid = courseId, teacherImgPath = firstTeach.imagePath, courseName = newCourse.name, courseDesc = newCourse.description, teacherName = firstTeach.name }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCourseAsJSON(int?id)
{
//If we get sent a course id that doesn't excist we send a Json response saying that the request failed
if (id == null)
{
return(Json(new { status = "failed" }, JsonRequestBehavior.AllowGet));
}
//If how ever we get a valid id we gather all info about the course in question
int crsId = Convert.ToInt32(id);
courses crs = crsService.getSpecificCourse(crsId);
List <account> teachers = crsService.GetTeacherOfCourse(crsId);
List <account> allTeachers = crsService.GetTeachersNotInCourse(crsId);
Dictionary <int, string> teachersDict = new Dictionary <int, string>();
foreach (var teach in teachers)
{
teachersDict[teach.id] = teach.email;
}
Dictionary <int, string> allTeachersDict = new Dictionary <int, string>();
foreach (var teach in allTeachers)
{
allTeachersDict[teach.id] = teach.email;
}
var jsonstring = Json(new { name = crs.name, description = crs.description, teachers = JsonConvert.SerializeObject(teachersDict), allTeachers = JsonConvert.SerializeObject(allTeachersDict) }, JsonRequestBehavior.AllowGet);
return(jsonstring);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="effect"></param>
/// <returns></returns>
public BaseResult Update(courses courses)
{
result.code = 0;
if (courses.id != 0)
{
if (dalCourses.Update(courses) == 0)
{
result.code = -1;
result.msg = "修改失败";
}
else
{
}
}
else
{
if (dalCourses.Add(courses) == 0)
{
result.code = -1;
result.msg = "添加失败";
}
else
{
}
}
return(result);
}
public NewCourseList AddCourseItem(courses item)
{
this.Title = item.details;
this.Title = item.coursecode;
Items.Add(new NewCourseList(item));
return(Items.LastOrDefault());
}
public ActionResult DeleteConfirmed(int id)
{
courses courses = db.courses1.Find(id);
db.courses1.Remove(courses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="classes"></param>
/// <returns></returns>
public int Add(courses courses)
{
return((int)dbContext.Insert <courses>(() => new courses()
{
name = courses.name,
teachersid = courses.teachersid,
startweek = courses.startweek,
endweek = courses.endweek
}));
}
public ActionResult Edit([Bind(Include = "id,coursename,specialization,hod")] courses courses)
{
if (ModelState.IsValid)
{
db.Entry(courses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(courses));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="classes"></param>
/// <returns></returns>
public int Update(courses courses)
{
return(dbContext.Update <courses>(p => p.id == courses.id, p => new courses()
{
name = courses.name,
teachersid = courses.teachersid,
startweek = courses.startweek,
endweek = courses.endweek
}));
}
static void Main(string[] args)
{
Participant pobj = new Participant();
pobj.Getassignments();
pobj.Getdays();
pobj.GetTopics();
courses cobj = new courses();
cobj.seccourse();
}
public ActionResult Create([Bind(Include = "id,coursename,specialization,hod")] courses courses)
{
if (ModelState.IsValid)
{
db.courses1.Add(courses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(courses));
}
public ActionResult DeleteConfirmed(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
courses courses = db.courses.Find(id);
db.courses.Remove(courses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public CourseModel(courses courses)
{
sourcedId = courses.sourcedId;
status = courses.status;
dateLastModified = courses.dateLastModified;
title = courses.title;
schoolYear = JsonConvert.DeserializeObject <ParentModel>(courses.schoolYear);
courseCode = courses.courseCode;
grades = JsonConvert.DeserializeObject <List <string> >(courses.grades);
subjects = JsonConvert.DeserializeObject <List <string> >(courses.subjects);
org = JsonConvert.DeserializeObject <ParentModel>(courses.org);
}
// GET: courses/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
courses courses = db.courses1.Find(id);
if (courses == null)
{
return(HttpNotFound());
}
return(View(courses));
}
public String buycourse(courses course)
{
var courseid = course.Course_id;
var temp = courSer.GetModels(b => b.Course_id == courseid).FirstOrDefault();
if (temp == null)
{
courSer.Add(course);
return("购买成功");
}
else
{
return("请勿重复购买");
}
}
private bool check_course_selected(string html_in)
{
var match = Regex.Match(html_in, @"alert\('(.+?)'\);");
var suc = !match.Success;
if (suc)
{
//parsing course property
var ptr_course_table = "<fieldset><legend>已选课程</legend>(?<data>.*?)</fieldset>";
match = Regex.Match(html_in, ptr_course_table);
if (!match.Success)
{
return(true); //success, but no resson returned
}
var course_table_str = match.Result("${data}");
match = Regex.Match(course_table_str, "<tr(\\sclass=\"alt\")?>(?<data>.*?)</tr>");
string course_name = "", teacher_name = "";
Invoke(new ThreadStart(delegate { course_name = courseName.Text; teacher_name = teacher.Text; }));
while (match.Success)
{
var crs = new courses();
var sub_info = Regex.Match(match.Result("${data}"), "<td.*?>(?<data>.*?)</td>");
//sect 0 course name
crs.Name = sub_info.Result("${data}");
sub_info = sub_info.NextMatch();
//sect 1 teacher
crs.Teacher = sub_info.Result("${data}");
sub_info = sub_info.NextMatch();
if (crs.Name == course_name)
{
debug_output("选课成功");
return(true);
}
match = match.NextMatch();
}
debug_output("选课失败");
return(false);
}
else
{
debug_output("选课失败: " + match.Result("$1"));
}
return(suc);
}
public ActionResult Edit([Bind(Include = "id,name,description")] courses courses)
{
if (courses == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
db.Entry(courses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
account user = accountHelp.getCurrentUser(Session["User"].ToString());
int userId = user.id;
ViewBag.userName = user.name;
ViewBag.imagePath = user.imagePath;
return(View(courses));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("Index", "Home"));
}
courses courses = db.courses.Find(id);
if (courses == null)
{
return(HttpNotFound());
}
account user = accountHelp.getCurrentUser(Session["User"].ToString());
int userId = user.id;
ViewBag.userName = user.name;
ViewBag.imagePath = user.imagePath;
return(View(courses));
}
public void LoadDesserts()
{
string SQLconn = MainWindow.DBconnection;
string SQLcomm = string.Empty;
using (SqlConnection conn = new SqlConnection(SQLconn))
{
conn.Open();
SQLcomm = "SELECT MealID, Description, Price, CourseNo FROM Courses";
var command = new SqlCommand(SQLcomm, conn);
var reader = command.ExecuteReader();
while (reader.Read())
{
int ID = reader.GetInt32(0);
var Desc = reader.GetString(1);
decimal price = reader.GetDecimal(2);
courses course = (courses)reader.GetInt32(3);
CourseClass dessert = new CourseClass(ID, Desc, price, course);
DessertList.Add(dessert);
}
dataGriddg.IsReadOnly = true;
dataGriddg.ItemsSource = DessertList;
conn.Close();
}
}
//获取选课课表回调
private void get_public_course_callback(NetStream sender, object e)
{
var response_str = sender.ReadResponseString(Encoding.Default);
sender.Close();
//replacing crlf
response_str = response_str.Replace("\r", "").Replace("\n", "");
//解析上课时间
var time_ptr = "<select\\sname=\"ddl_sksj\"\\sonchange=\"__doPostBack\\('ddl_sksj',''\\)\"\\slanguage=\"javascript\"\\sid=\"ddl_sksj\">(?<data>.*?)</select>";
var time_ptr2 = "<option\\svalue=\"(?<value>[^\"]+)\">.*?</option>";
var time_spec_total = Regex.Match(response_str, time_ptr);
var time_list = new List <string>();
if (time_spec_total.Success)
{
Invoke(new ThreadStart(delegate
{
var match_string = time_spec_total.Result("${data}");
var time = Regex.Match(match_string, time_ptr2);
while (time.Success)
{
time_list.Add(time.Result("${value}"));
time = time.NextMatch();
}
}));
}
else
{
debug_output("获取选课失败，若重复出现，可重新启动程序重试");
debug_output("返回内容：" + response_str);
Thread.Sleep(3000);
get_public_course((bool)e);
}
//parsing __VIEWSTATE
var match = Regex.Match(response_str, "<input\\stype=\"hidden\"\\sname=\"__VIEWSTATE\"\\svalue=\"(?<value>[^\"]*?)\"\\s*/>");
if (match.Success)
{
__VIEWSTATE = match.Result("${value}");
}
//总课程数
match = Regex.Match(response_str, "<span\\sid=\"dpkcmcGrid_lblTotalRecords\">(?<record>\\d+)</span>");
if (match.Success)
{
total_records = int.Parse(match.Result("${record}"));
}
//解析选课的各个字段
course_list = new List <courses>();
var ptn_course_table = "<fieldset><legend>可选课程</legend>(?<data>.*?)</fieldset>";
var course_table_str = Regex.Match(response_str, ptn_course_table).Result("${data}");
match = Regex.Match(course_table_str, "<tr(\\sclass=\"alt\")?>(?<data>.*?)</tr>");
while (match.Success)
{
var crs = new courses();
var sub_info = Regex.Match(match.Result("${data}"), "<td.*?>(?<data>.*?)</td>");
//sect 0 <input id="kcmcGrid__ctl2_xk" type="checkbox" name="kcmcGrid:_ctl2:xk" />
var sub_info2 = Regex.Match(sub_info.Result("${data}"), "<input.*?name=\"(?<checkBox>.*?)\"\\s*/>");
crs.CheckBoxStr = sub_info2.Result("${checkBox}");
sub_info = sub_info.NextMatch();
//sect 1 course name
sub_info2 = Regex.Match(sub_info.Result("${data}"), "<a.*?>(?<name>.+?)</a>");
crs.Name = sub_info2.Result("${name}");
sub_info = sub_info.NextMatch();
//sect 2 code
crs.Code = sub_info.Result("${data}");
sub_info = sub_info.NextMatch();
//sect 3 teacher
sub_info2 = Regex.Match(sub_info.Result("${data}"), "<a.*?>(?<name>.+?)</a>");
crs.Teacher = sub_info2.Result("${name}");
sub_info = sub_info.NextMatch();
//sect 4 time
var sub_info3 = Regex.Match(sub_info.Value, "<td\\stitle=\"(?<time>.*?)\">.*?</td>");
crs.Time = sub_info3.Result("${time}");
match = match.NextMatch();
//todo: add more column
course_list.Add(crs);
}
if ((bool)e)
{
//获取完整的课表
get_public_course(false);
}
else
{
//更新UI
Invoke(new ThreadStart(delegate
{
courseName.Items.Clear();
foreach (var item in course_list)
{
courseName.Items.Add(item.Name);
}
goFuck.Enabled = true;
}));
debug_output("获取完成");
}
}
public JsonResult UpdateCourses(courses courses)
{
return(Json(bllCourses.Update(courses)));
}
public NewCourseList(courses item)
{
Item = item;
}
public ActionResult addCourse(courses c)
{
db.courses.Add(c);
db.SaveChanges();
return(RedirectToAction("admin"));
}
private void select_course_callback()
{
try
{
//init
string course_name = "", teacher_name = "", course_time = "";
Invoke(new ThreadStart(delegate
{
courseName.Enabled = false;
teacher.Enabled = false;
courseTime.Enabled = false;
course_name = courseName.Text;
teacher_name = teacher.Text;
course_time = courseTime.Text;
goFuck.Enabled = true;
goFuck.Text = "不干";
}));
while (course_list == null)
{
Thread.Sleep(100);
}
//getting course_name
courses course = course_list.Find((courses obj) =>
{
return(obj.Name == course_name && obj.Teacher == teacher_name && obj.Time == course_time);
});
if (!string.IsNullOrEmpty(course.CheckBoxStr))
{
//loop posting data
bool suc = false;
do
{
suc = submit_course_data(course.CheckBoxStr);
Thread.Sleep(3000);
} while (!suc);
}
else
{
debug_output("未找到相关课程，大概是个bug吧");
}
}
catch (ThreadAbortException) { }
catch (Exception ex)
{
debug_output(ex.ToString());
}
finally
{
//ended
Invoke(new ThreadStart(delegate
{
courseName.Enabled = true;
teacher.Enabled = true;
courseTime.Enabled = true;
goFuck.Text = "开干";
threadUsing = false;
}));
}
}
/*
* سلام. موضوع پروژه
* برنامه ای که اطلاعات تعدادی دانشجو را به همراه نمرات دانشجو از وردی دریافت میکند و امکانات زیر را فراهم میکند
* ۱. با در یافت ش. دانشجویی معدل دانشجو را نمایش میدهد
* ۲. اسم دانشجویانی کابیشترین و کمترین نمرات را داشته اند نماش میدهد
* ۳. برای هر دانسجو تعداد دروسی که مردود شده است را محاسبه کرده و نماش میدهد
* تاریخ تحویل ۲۱ تیر ماه
*/
static int Main(string[] args)
{
// help class
myService service = new myService();
test _test = new test();
// globle variable
List <students> _student = new List <students>();
List <courses> _course = new List <courses>();
List <selectCourses> _selectSourse = new List <selectCourses>();
// constructor variable
_student = _test.initial_students();
_course = _test.initial_courses();
_selectSourse = _test.initial_selectCourses();
// loop menu
while (true)
{
service.clearScrean();
service.showMenu();
string sel = Console.ReadLine();
switch (sel)
{
case "1":
{
students s = new students();
s.Add();
_student.Add(s);
}
break;
case "2":
{
courses c = new courses();
c.Add();
_course.Add(c);
}
break;
case "3":
{
selectCourses selectcourse = new selectCourses();
students student = new students();
courses course = new courses();
student = service.GetByNum(_student);
course = service.GetByNum(_course);
selectcourse.Add(student, course);
_selectSourse.Add(selectcourse);
}
break;
case "4":
{
students s = new students();
s = service.GetByNum(_student);
service.showAvgBynum(s, _selectSourse);
}
break;
case "5":
{
service.showMinMax(_student, _selectSourse);
}
break;
case "6":
{
service.showCountReject(_student, _selectSourse);
}
break;
case "7":
{
goto exit;
}
case "8":
{
service.ShowAll(_student);
}
break;
case "9":
{
service.ShowAll(_course);
}
break;
case "10":
{
service.ShowAll(_selectSourse);
}
break;
case "11":
{
service.showAvg(_student, _selectSourse);
}
break;
default:
break;
}
}
exit:
return(0);
}
