public bool AddLesson(AddCourse addCourse)
{
string sql = "insert into AddCourse(Course_Id,Course,Department) values('" +
Convert.ToInt32(addCourse.Course_Id) + "','" + addCourse.Course + "','" + addCourse.Department + "')";
return(db.ExecSql(sql));
}
public async Task AddCourse(AddCourse addCourse)
{
var newCourse = new Course()
{
UserId = addCourse.UserId,
Title = addCourse.Title,
Description = addCourse.Description,
PlaceId = addCourse.PlaceId,
SubjectId = addCourse.SubjectId,
Time = addCourse.Time,
};
_dbContext.Courses.Add(newCourse);
await _dbContext.SaveChangesAsync();
var result = new CourseListItem()
{
CreationTime = newCourse.CreationTime,
Title = newCourse.Title,
Description = newCourse.Description,
Id = newCourse.Id,
Creator = (await _dbContext.Users.FirstOrDefaultAsync(x => x.Id == newCourse.UserId)).Name,
Time = newCourse.Time,
PlaceName = (await _dbContext.Places.FirstOrDefaultAsync(x => x.Id == newCourse.PlaceId)).Name,
SubjectName = (await _dbContext.Subjects.FirstOrDefaultAsync(x => x.Id == newCourse.SubjectId)).Title
};
await _hubContext.Clients.All.SendAsync("AddCourse", result);
return;
}
public IActionResult Create(CreateCourseViewModel viewModel, [FromServices] AddCourse command)
{
if (ModelState.IsValid)
{
//if course already exist return error
try
{
queryDb.Courses.Where(c => c.CourseId == viewModel.CourseId).Single();
ModelState.AddModelError(String.Empty, "A course with that Id already exists");
return(RedirectToAction("Index", "Course"));
}
catch (Exception)
{
command.CourseId = viewModel.CourseId;
command.Name = viewModel.Name;
command.InstructorId = viewModel.InstructorId;
command.Run();
if (command.status)
{
return(RedirectToAction("Index", "Course"));
}
else
{
return(RedirectToAction("Error", "Course"));
}
}
}
//Something bad happened if we got to here
return(View(viewModel));
}
public void Handle(AddCourse message)
{
var item = _repository.GetById(message.CourseId);
item.CheckIn();
_repository.Save(item, message.OriginalVersion);
}
public void AddCourse()
{
AddCourse courses = new AddCourse(Courseslist.Add);
courses(Coursenames);
}
// GET: Suggestion/Delete/5
public ActionResult Delete(AddCourse IdDel)
{
var d = db.AddCourses.Where(x => x.id == IdDel.id).FirstOrDefault();
db.AddCourses.Remove(d);
db.SaveChanges();
return(RedirectToAction("AllDetail"));
}
public ActionResult Create([Bind(Exclude = "id")] AddCourse tech)
{
if (!ModelState.IsValid)
{
return(View());
}
db.AddCourses.Add(tech);
db.SaveChanges();
//Response.Redirect("StudentAdmission",true);
return(RedirectToAction("AllDetail"));
}
public ActionResult Edit(AddCourse IdEdit)
{
var orignalRecord = (from m in db.AddCourses where m.id == IdEdit.id select m).First();
if (!ModelState.IsValid)
{
return(View(orignalRecord));
}
db.Entry(orignalRecord).CurrentValues.SetValues(IdEdit);
db.SaveChanges();
return(RedirectToAction("AllDetail"));
}
public ActionResult InsertCourse(AddCourse addCourse)
{
try
{
Course course = mapper.Map <Course>(addCourse);
repository.Add(course);
return(Ok());
}
catch (Exception)
{
return(BadRequest());
}
}
public void DisplayCourses()
{
AddCourse course1 = new AddCourse(Console.WriteLine);
Console.ForegroundColor = ConsoleColor.Magenta;
course1(" \n **List of courses** \n" );
foreach (string c in Courseslist)
{
Console.ForegroundColor = ConsoleColor.Cyan;
course1(" " +i+ ". "+c);
i++;
}
course1("");
}
public ActionResult Add()
{
var departments = db.Departments.ToList();
var classes = db.Classes.ToList();
var days = db.Days.ToList();
AddCourse dev = new AddCourse()
{
Departments = departments,
Classes = classes,
Days = days
};
return(View(dev));
}
public IActionResult CreateCourse([FromBody] AddCourse courses)
{
Courses course = new Courses();
if (ModelState.IsValid)
{
course = _service.CreateCourse(courses);
}
else
{
return(BadRequest());
}
var location = Url.Link("GetCourseByID", new { id = course.ID });
return(Created(location, course));
}
private void btnAdd_Click(object sender, EventArgs e)
{
Course course = new Course()
{
name = tbCourseName.Text,
courseCode = tbCourseCode.Text,
schoolYear = Int32.Parse(tbSchoolYear.Text),
blockPeriod = Int32.Parse(tbBlockPeriod.Text),
credits = Int32.Parse(tbCredits.Text)
};
AddCourse addCourse = new AddCourse();
if (!addCourse.addCourse(course))
{
MessageBox.Show("Something went wrong please try again!", "Error", MessageBoxButtons.OK);
}
form.refreshListview();
}
public IActionResult Create(AddCourse model)
{
if (ModelState.IsValid)
{
var course = new Courses()
{
CourseName = model.CourseName,
StartDay = model.StartDay,
FinishDay = model.FinishDay
};
var courseId = courseRepository.CreateCourse(course);
if (courseId > 0)
{
return(RedirectToAction("Index", "Course"));
}
ModelState.AddModelError("", "System error, please try again later!");
}
var courseView = new AddCourse();
return(View(courseView));
}
/// <summary>
/// Creates a new course
/// </summary>
/// <param name="course">Instance of AddCourse that keeps the courses value</param>
/// <returns>Returns the new course if we can save changes to database, else we throw
/// FailedToSaveToDatabaseException()
public Courses CreateCourse(AddCourse course)
{
var newCourse = new Entities.Courses {
TemplateID = course.TemplateID,
StartDate = course.StartDate,
EndDate = course.EndDate,
Semester = course.Semester,
MaxStudents = course.MaxStudents
};
_db.Courses.Add(newCourse);
try
{
_db.SaveChanges();
}
catch (System.Exception)
{
throw new FailedToSaveToDatabaseException();
}
return(newCourse);
}
public ActionResult <Course> Post([FromBody] AddCourse addCourse)
{
var course = DbContext.Courses.FirstOrDefault(c => c.Code == addCourse.Code);
if (course != null)
{
return(BadRequest("There is already a course with that code in the records."));
}
else
{
var courseToAdd = new Course
{
Title = addCourse.Title,
Code = addCourse.Code,
DateCreated = DateTime.Now,
LastUpdatedOn = DateTime.Now
};
var courseAdded = DbContext.Courses.Add(courseToAdd).Entity;
DbContext.SaveChanges();
return(courseAdded);
}
}
private void btn_readySelCoursesList_Click(object sender, EventArgs e)
{
AddCourse courses = new AddCourse();
courses.ShowDialog();
}
public bool UpdateLesson(int oldCourse_Id, string oldCourse, string oldDepartment, AddCourse add)
{
return(addDal.UpdateLesson(oldCourse_Id, oldCourse, oldDepartment, add));
}
public bool AddLesson(AddCourse addCourse)
{
return(addDal.AddLesson(addCourse));
}
private void addCourseButton_Click(object sender, EventArgs e)
{
AddCourse addcourse = new AddCourse();
addcourse.Show();
}
public void Test_AddCourse_Method()
{
AddCourse ad = new AddCourse();
Assert.IsTrue(ad.IsUnitTest);
}
public ActionResult AddCourse(AddCourse form)
{
return(View((object)WebApplication3.Models.AdminDbConnectionClass.addCourse(form)));
}
public override void Save()
{
List <AttendInfo> insertList = new List <AttendInfo>(); //新增清單
List <AttendInfo> updateList = new List <AttendInfo>(); //更新清單
List <AttendInfo> deleteList = new List <AttendInfo>(); //刪除清單
GetList(insertList, updateList, deleteList);
try
{
List <string> synclist = new List <string>();
DSXmlHelper helper = new DSXmlHelper("InsertSCAttend");
foreach (AttendInfo each in insertList)
{
XmlElement attend = helper.AddElement("Attend");
DSXmlHelper.AppendChild(attend, "<RefStudentID>" + each.RefStudentID.ToString() + "</RefStudentID>");
DSXmlHelper.AppendChild(attend, "<RefCourseID>" + RunningID + "</RefCourseID>");
DSXmlHelper.AppendChild(attend, "<IsRequired>" + each.IsRequired + "</IsRequired>");
DSXmlHelper.AppendChild(attend, "<RequiredBy>" + each.RequiredBy + "</RequiredBy>");
//DSXmlHelper.AppendChild(attend, "<GradeYear>" + each.GradeYear + "</GradeYear>");
helper.AddElement(".", attend);
}
if (insertList.Count > 0)
{
DSXmlHelper insertResult = AddCourse.AttendCourse(helper).GetContent();
foreach (XmlElement each in insertResult.GetElements("NewID"))
{
synclist.Add(each.InnerText);
}
}
helper = new DSXmlHelper("UpdateSCAttend");
foreach (AttendInfo each in updateList)
{
XmlElement attend = helper.AddElement("Attend");
DSXmlHelper.AppendChild(attend, "<ID>" + each.Identity + "</ID>");
DSXmlHelper.AppendChild(attend, "<IsRequired>" + each.IsRequired + "</IsRequired>");
DSXmlHelper.AppendChild(attend, "<RequiredBy>" + each.RequiredBy + "</RequiredBy>");
synclist.Add(each.Identity.ToString());
helper.AddElement(".", attend);
}
if (updateList.Count > 0)
{
EditCourse.UpdateAttend(helper);
}
helper = new DSXmlHelper("DeleteSCAttendRequest");
foreach (AttendInfo each in deleteList)
{
XmlElement attend = helper.AddElement("Attend");
DSXmlHelper.AppendChild(attend, "<ID>" + each.Identity + "</ID>");
synclist.Add(each.Identity.ToString());
helper.AddElement(".", attend);
}
if (deleteList.Count > 0)
{
EditCourse.DeleteAttend(helper);
}
#region Log
StringBuilder desc = new StringBuilder("");
desc.AppendLine("課程名稱：" + Course.Instance.Items[RunningID].Name);
if (insertList.Count > 0)
{
desc.AppendLine("加入修課學生：");
}
foreach (AttendInfo info in insertList)
{
desc.AppendLine("- " + info.Class + " " + info.StudentNumber + " " + info.StudentName + " ");
}
if (deleteList.Count > 0)
{
desc.AppendLine("移除課程修課學生：");
}
foreach (AttendInfo info in deleteList)
{
desc.AppendLine("- " + info.Class + " " + info.StudentNumber + " " + info.StudentName + " ");
}
if (updateList.Count > 0)
{
desc.AppendLine("課程修課學生修課資訊調整：");
}
foreach (AttendInfo info in updateList)
{
desc.AppendLine("- " + info.Class + " " + info.StudentNumber + " " + info.StudentName + " ");
}
//CurrentUser.Instance.AppLog.Write(EntityType.Course, "修改課程修課學生", RunningID, desc.ToString(), "課程", "");
FISCA.LogAgent.ApplicationLog.Log("課程基本資料", "修改課程修課學生", desc.ToString());
#endregion
//SCAttend.Instance.SyncDataBackground(synclist);
LoadContent(RunningID);
}
catch (Exception ex)
{
MsgBox.Show("儲存失敗：" + ex.Message);
}
}
public bool UpdateLesson(int oldCourse_Id, string oldCourse, string oldDepartment, AddCourse add)
{
try
{
string sql = "update AddCourse set Course_Id='" + add.Course_Id + "',Course='" + add.Course + "',Department='" + add.Department + "' where Course_Id='" + oldCourse_Id + "'AND Course='" + oldCourse + "'AND Department='" + oldDepartment + "'";
return(db.ExecSql(sql));
}
catch
{
return(false);
}
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
switch (this.treeView1.SelectedNode.Text)
{
case "查看学生信息":
SelectStuInfo selectStuInfo = new SelectStuInfo();
selectStuInfo.TopLevel = false;
selectStuInfo.FormBorderStyle = FormBorderStyle.None;
selectStuInfo.WindowState = FormWindowState.Maximized;
panel.Controls.Add(selectStuInfo);
selectStuInfo.Show();
break;
case "添加学生信息":
AddStuInfo addStuInfo = new AddStuInfo();
addStuInfo.TopLevel = false;
addStuInfo.FormBorderStyle = FormBorderStyle.None;
addStuInfo.WindowState = FormWindowState.Maximized;
panel.Controls.Add(addStuInfo);
addStuInfo.Show();
break;
case "查看教师信息":
if (admin)
{
SelectTeaInfo selectTeaInfo = new SelectTeaInfo();
selectTeaInfo.TopLevel = false;
selectTeaInfo.FormBorderStyle = FormBorderStyle.None;
selectTeaInfo.WindowState = FormWindowState.Maximized;
panel.Controls.Add(selectTeaInfo);
selectTeaInfo.Show();
}
else
{
MessageBox.Show("你不是管理员，无法使用本模块");
}
break;
case "添加教师信息":
if (admin)
{
AddTeaInfo addTeaInfo = new AddTeaInfo();
addTeaInfo.TopLevel = false;
addTeaInfo.FormBorderStyle = FormBorderStyle.None;
addTeaInfo.WindowState = FormWindowState.Maximized;
panel.Controls.Add(addTeaInfo);
addTeaInfo.Show();
}
else
{
MessageBox.Show("你不是管理员，无法使用本模块");
}
break;
case "开设课程":
AddCourse addClass = new AddCourse();
addClass.TopLevel = false;
addClass.FormBorderStyle = FormBorderStyle.None;
addClass.WindowState = FormWindowState.Maximized;
panel.Controls.Add(addClass);
addClass.Show();
break;
case "查询课程":
SelectCourse selectClass = new SelectCourse();
selectClass.TopLevel = false;
selectClass.FormBorderStyle = FormBorderStyle.None;
selectClass.WindowState = FormWindowState.Maximized;
panel.Controls.Add(selectClass);
selectClass.Show();
break;
case "查询成绩":
SelectStuScore selectStuScore = new SelectStuScore();
selectStuScore.TopLevel = false;
selectStuScore.FormBorderStyle = FormBorderStyle.None;
selectStuScore.WindowState = FormWindowState.Maximized;
panel.Controls.Add(selectStuScore);
selectStuScore.Show();
break;
case "添加修改成绩":
AddStuScore addStuScore = new AddStuScore();
addStuScore.TopLevel = false;
addStuScore.FormBorderStyle = FormBorderStyle.None;
addStuScore.WindowState = FormWindowState.Maximized;
panel.Controls.Add(addStuScore);
addStuScore.Show();
break;
case "修改密码":
UpdataPasswd updatePasswd = new UpdataPasswd();
updatePasswd.TopLevel = false;
updatePasswd.FormBorderStyle = FormBorderStyle.None;
updatePasswd.WindowState = FormWindowState.Maximized;
panel.Controls.Add(updatePasswd);
updatePasswd.Show();
break;
case "退出系统":
Application.Exit();
break;
}
}
public RedirectToRouteResult AddCourse(AddCourse model)
{
return(this.RedirectToAction(c => c.Details(model.Id)));
}
private void addCourseToolStripMenuItem_Click(object sender, EventArgs e)
{
AddCourse course = new AddCourse();
course.Visible = true;
}