protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (DefaultConnectionEF db = new DefaultConnectionEF())
{
Courses objC = new Courses();
if (!String.IsNullOrEmpty(Request.QueryString["CourseID"]))
{
Int32 CourseID = Convert.ToInt32(Request.QueryString["CourseID"]);
objC = (from c in db.Courses
where c.CourseID == CourseID
select c).FirstOrDefault();
}
//populate the course from the input form
objC.Title = txtTitle.Text;
objC.Credits = Convert.ToInt32(txtCredits.Text);
objC.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);
if (String.IsNullOrEmpty(Request.QueryString["CourseID"]))
{
//add
db.Courses.Add(objC);
}
//save and redirect
db.SaveChanges();
Response.Redirect("courses.aspx");
}
}
public void LoadData(Courses course)
{
var register = (from r in CourseData.db.Registers
where r.Courses == course
select r);
this.CourseRegiserGrid.ItemsSource = register.ToList();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox2.Text == "")
{
return;
}
string[] arrcourse = TextBox2.Text.Split(',');
ASSEntities assen = new ASSEntities();
foreach(string course in arrcourse)
{
Courses c = new Courses();
c.CourseName = course;
assen.AddToCourses(c);
}
assen.SaveChanges();
}
protected void EditCourses_Click(object sender, EventArgs e)
{
DalOperationAboutCourses DalOperationAboutCourses = new DalOperationAboutCourses();
Courses Courses = new Courses();
Courses.preCourse = tex_preCourses.Text;
Courses.referenceBooks = text_ReferenceBooks.Text;
Courses.courseNo = hidencourseNo.Value.Trim();
Courses.termTag = Request["termtag"].Trim();
Courses.homePage = CommonUtility.JavascriptStringFilter(txtcourseurl.Text);
Courses.examineMethod = CommonUtility.JavascriptStringFilter(txtExamtype.Text.Trim());
Courses.courseAnswer = txtAnswer.Text.Trim();
Courses.classID = Server.UrlDecode(Request["classId"].Trim());
Courses.termTag = Request["termtag"].Trim();
DalOperationAboutCourses.UpdateCourses(Courses);
Javascript.RefreshParentWindow("修改成功!", "CInfoCourseInfos.aspx?courseNo=" + Courses.courseNo + "&classID="+Server.UrlEncode(Server.UrlDecode(Request["classID"].ToString().Trim()))+"&termtag="+Request["termtag"].Trim(), Page);
}
//add one Courses to database
public bool Add(Courses mcrs)
{
bool check;
var query = "INSERT into Courses VALUES(@C01, @C02, @C03, @C04)";
SqlCommand command = new SqlCommand(query, MyDB.GetConnection);
command.Parameters.Add("@C01", SqlDbType.NVarChar).Value = mcrs.C01_id;
command.Parameters.Add("@C02", SqlDbType.NVarChar).Value = mcrs.C02_name;
command.Parameters.Add("@C03", SqlDbType.Date).Value = mcrs.C03_datestart;
command.Parameters.Add("@C04", SqlDbType.Date).Value = mcrs.C04_dateend;
MyDB.openConection();
if (command.ExecuteNonQuery() == 1)
{
check = true;
}
else
{
check = false;
}
MyDB.closedConection();
return(check);
}
public ActionResult CreateCourses(Courses courses, HttpPostedFileBase resim)
{
var klasor = Server.MapPath("/Content/img/");
if (resim != null && resim.ContentLength != 0)
{
if (resim.ContentLength > 2 * 1024 * 1024)
{
ModelState.AddModelError(null, "Resim boyutu max 'MB olabilir.");
}
else
{
try
{
FileInfo fi = new FileInfo(resim.FileName);
var rastgele = Guid.NewGuid().ToString().Substring(0, 5);
var dosyaAdi = fi.Name + rastgele + fi.Extension;
resim.SaveAs(klasor + dosyaAdi);
courses.CoursesImage = dosyaAdi;
}
catch { }
}
if (ModelState.IsValid)
{
BaseRepository <Courses> rep = new BaseRepository <Courses>();
rep.Insert(courses);
}
}
return(View());
//BaseRepository<General> rep = new BaseRepository<General>();
//rep.Insert(general);
//return View();
}
private async Task ModeUpSelected(F.PatientSummary patientSummary)
{
//Load text correctly
if (patientSummary != null)
{
patientId.Text = $"({patientSummary.Id}) {patientSummary.LastName}, {patientSummary.FirstName}";
if (patientSummary.Id != AppComThread.Instance.GetValue(sc => sc.Patient?.Id))
{
//Close last patient
await AppComThread.Instance.ExecuteAsync((sc) =>
{
if (sc.Patient != null)
{
Debug.WriteLine($"Closing patient {sc.Patient.LastName}");
sc.ClosePatient();
}
});
//Mode up selected (if patient exists)
if (AppComThread.Instance.GetValue(sc => sc.SetPatient(patientSummary.Id)))
{
Courses.Clear();
var courseNames = AppComThread.Instance.GetValue(sc =>
{
return(sc.Patient.Courses.Select(c => c.Id).ToList());
});
courseNames.ForEach(Courses.Add);
SelectedCourse = Courses.FirstOrDefault();
OnPropertyChanged("Courses");
OnPropertyChanged("SelectedCourse");
OnPropertyChanged("Status");
}
}
}
}
/// <summary>
/// get method for update
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult EditCourse(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Courses courses = objEntities.Courses.Find(id);
var data = from d in objEntities.Courses
where d.CourseId == id
select d;
//var TEMPlIST = objEntities.Subjects.ToList();
CourseViewModel courseView = new CourseViewModel
{
CourseId = Convert.ToInt32(courses.CourseId),
CourseName = courses.CourseName
};
if (courses == null)
{
return(HttpNotFound());
}
return(View(courseView));
}
// GET: Admin/Edit/5
public ActionResult EditCourseTime(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseTimetable courseTimetable = db.CourseTimetables.SingleOrDefault(ct => ct.CourseTimetableId == id);
Courses courses = db.Courses.SingleOrDefault(c => c.CoursesID == courseTimetable.CoursesID);
if (courseTimetable == null)
{
return(HttpNotFound());
}
TimetableVM timetable = new TimetableVM
{
//CoursesID = courses.CoursesID,
CourseName = courses.CourseName,
//Programme = courses.Programme,
StartTime = courseTimetable.StartTime.ToString(),
EndTime = courseTimetable.EndTime.ToString(),
};
return(View(timetable));
}
private void listViewCourses_ItemCheck1(object sender, ItemCheckEventArgs e)
{
// if we have the lastItem set as checked, and it is different
// item than the one that fired the event, uncheck it
if (lastItemChecked != null && lastItemChecked.Checked &&
lastItemChecked != listViewCourses.Items[e.Index])
{
// uncheck the last item and store the new one
lastItemChecked.Checked = false;
}
// store current item
CoursesLabel.Text = listViewCourses.Items[e.Index].Text;
lastItemChecked = listViewCourses.Items[e.Index];
for (int i = 0; i < courses.Count; i++)
{
if (courses[i].CourseName == CoursesLabel.Text)
{
selectedCourse = courses[i];
Console.WriteLine("Selected Course: " + courses[i].CourseName);
}
}
}
public async Task <string> Update(int id, Courses course)
{
try
{
return(await Task.Run(() =>
{
using (SqlConnection conn = new SqlConnection(con.DatabaseConnection))
{
conn.Open();
return conn.ExecuteScalar <int>(Courses_Query.Update, new
{
pCourseCode = course.CourseCode,
pCourse = course.Course,
pUserId = course.UserID,
pId = id
}, commandTimeout: 0).ToString();
};
}));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Creates a course.
/// A course is uniquely identified by its number + the subject to which it belongs
/// </summary>
/// <param name="subject">The subject abbreviation for the department in which the course will be added</param>
/// <param name="number">The course number</param>
/// <param name="name">The course name</param>
/// <returns>A JSON object containing {success = true/false}.
/// false if the course already exists, true otherwise.</returns>
public IActionResult CreateCourse(string subject, int number, string name)
{
// work
var query =
from c in db.Courses
where c.Department == subject && c.Num == number.ToString()
select c;
if(query.ToList().Count() > 0)
{
return Json(new { success = false });
}
Courses co = new Courses();
co.Name = name;
co.Num = number.ToString();
co.Department = subject;
db.Courses.Add(co);
db.SaveChanges();
return Json(new { success = true });
}
public void ContinueAddingCourseOrNot()
{
string answer = CheckContinueOrNot();
while (answer.ToUpper() == "C")
{
Console.Clear();
Welcome();
Course c = new Course();
c.InitializeCourse();
Courses.Add(c);
c.PrintTheCourseEntry();
Console.WriteLine("\n\tPress C to Continue Adding : ");
Console.WriteLine("\tPress B to go Back to Menu : ");
Console.Write("\t : ");
answer = StringAnswer();
}
if (answer.ToUpper() == "B")
{
Console.Clear();
Welcome();
InsertMenu();
}
}
// GET: Currencies / Edit Course
// prop: id (currency id)
public ActionResult Course(int id)
{
if (id == 0)
{
return(View());
}
Courses course = new Courses
{
currency_id = id,
buy = 1,
sell = 1
};
CurrencyContext context = new CurrencyContext();
Courses courseData = context.Courses.FirstOrDefault(cur => cur.currency_id == id);
if (courseData != null)
{
course = courseData;
}
return(View(course));
}
public async Task <IActionResult> Store([FromForm] CourseRequest request)
{
try
{
if (_userRepository.LogCurrentUser().canCreate == false)
{
return(Unauthorized(_UnAuthorized));
}
Courses model = new Courses();
model.title = request.title;
model.description = request.description;
model.status = request.status;
model.isPublished = request.isPublished;
model.durationTime = request.durationTime;
model.durationType = request.durationType;
model.passingGrade = request.passingGrade;
model.capacity = request.capacity;
RequiredFields validation = new RequiredFields();
validation.Courses = model;
object validateFields = _validationService.ValidateRequest("Courses", validation);
if (JsonConvert.SerializeObject(validateFields).Length > 2)
{
return(BadRequest(validateFields));
}
var checkExists = _context.Courses.Where(x => x.title == request.title).Any();
if (checkExists == true)
{
return(BadRequest(new GenericResult {
Response = false, Message = request.title + " is already exists"
}));
}
var refCode = _encryptionService.GenerateRefCode();
model.code = refCode;
model.CourseLevel = request.CourseLevel;
model.CourseCategory = request.CourseCategory;
model.CourseType = request.CourseType;
model.CourseLanguage = request.CourseLanguage;
model.CourseTag = request.CourseTag;
model.createdAt = DateTime.Now;
if (request.featureImage != null)
{
if (request.featureImage.Length > 0)
{
Stream stream = request.featureImage.OpenReadStream();
var path = Path.Combine(_hostingEnvironment.WebRootPath, _fileDirectory.virtualDirectory);
string courseImageFolder = String.Format("{0}\\Content\\Images\\Course", path);
if (!Directory.Exists(courseImageFolder))
{
Directory.CreateDirectory(courseImageFolder);
}
var id = Guid.NewGuid();
var extension = Path.GetExtension(request.featureImage.FileName);
var fileName = id.ToString() + extension.ToString().ToLower();
using (var zipStream = new FileStream(Path.Combine(courseImageFolder, fileName), FileMode.Create, FileAccess.Write))
{
request.featureImage.CopyTo(zipStream);
}
model.featureImage = fileName;
}
}
if (request.featureVideo != null)
{
if (request.featureVideo.Length > 0)
{
Stream stream = request.featureVideo.OpenReadStream();
var path = Path.Combine(_hostingEnvironment.WebRootPath, _fileDirectory.virtualDirectory);
string courseVideoFolder = String.Format("{0}\\Content\\Video\\Course", path);
if (!Directory.Exists(courseVideoFolder))
{
Directory.CreateDirectory(courseVideoFolder);
}
var id = Guid.NewGuid();
var extension = Path.GetExtension(request.featureVideo.FileName);
var fileName = id.ToString() + extension.ToString().ToLower();
using (var zipStream = new FileStream(Path.Combine(courseVideoFolder, fileName), FileMode.Create, FileAccess.Write))
{
request.featureVideo.CopyTo(zipStream);
}
model.featureVideo = fileName;
}
}
_context.Courses.Add(model);
await _context.SaveChangesAsync();
for (int i = 0; request.RelatedCourse.Count() > i; i++)
{
CourseRelatedDetails crdModel = new CourseRelatedDetails();
crdModel.courseId = model.id;
crdModel.isPrerequisite = request.RelatedCourse[i].isPrerequisite;
_context.CourseRelated.Add(crdModel);
await _context.SaveChangesAsync();
CourseRelatedList crlModel = new CourseRelatedList();
crlModel.courseRelatedId = crdModel.id;
crlModel.courseId = request.RelatedCourse[i].relatedCourseId;
_context.CourseRelatedList.Add(crlModel);
await _context.SaveChangesAsync();
}
return(Ok(new GenericResult {
Response = true, Message = "Course " + request.title + " successfully created"
}));
} catch (Exception e) {
return(BadRequest(e));
}
}
// U public void Update(string id, Courses courseIn) => _courses.ReplaceOne(course => course.Id == id, courseIn);
public virtual bool IsEmpty()
{
return(!Courses.Any() &&
HealthRecords.All(h => h.IsEmpty()));
}
public void Insert(Courses courses)
{
_CourseList.Add(courses);
}
public async Task <ViewResult> DatabaseOperations()
{
Students student = new Students();
student.StudentId = 1;
student.StudentName = "Sutama";
dbContext.Add(student);
student = new Students();
student.StudentId = 2;
student.StudentName = "Shiva";
dbContext.Add(student);
student = new Students();
student.StudentId = 3;
student.StudentName = "Simon";
dbContext.Add(student);
student = new Students();
student.StudentId = 4;
student.StudentName = "Aurora";
dbContext.Add(student);
Courses course = new Courses();
course.CourseId = 1;
course.CourseName = "Distibuted Information System";
dbContext.Add(course);
course = new Courses();
course.CourseId = 2;
course.CourseName = "Database";
dbContext.Add(course);
course = new Courses();
course.CourseId = 3;
course.CourseName = "Distributed Management";
dbContext.Add(course);
course = new Courses();
course.CourseId = 4;
course.CourseName = "Advance System Analysis";
dbContext.Add(course);
course = new Courses();
course.CourseId = 5;
course.CourseName = "Data Mining";
dbContext.Add(course);
course = new Courses();
course.CourseId = 6;
course.CourseName = "Python Class";
dbContext.Add(course);
StudentCourseEnrollment sce = new StudentCourseEnrollment();
sce.StudentId = 1;
sce.CourseId = 1;
dbContext.Add(sce);
sce = new StudentCourseEnrollment();
sce.StudentId = 1;
sce.CourseId = 2;
dbContext.Add(sce);
sce = new StudentCourseEnrollment();
sce.StudentId = 1;
sce.CourseId = 3;
dbContext.Add(sce);
sce = new StudentCourseEnrollment();
sce.StudentId = 2;
sce.CourseId = 3;
dbContext.Add(sce);
sce = new StudentCourseEnrollment();
sce.StudentId = 2;
sce.CourseId = 4;
dbContext.Add(sce);
sce = new StudentCourseEnrollment();
sce.StudentId = 3;
sce.CourseId = 4;
dbContext.Add(sce);
dbContext.SaveChanges();
// READ operation
var list = dbContext.students
.Join(dbContext.studentCourseEnrollment,
c => c.StudentId,
p => p.StudentId,
(c, p) => new {
StudentName = c.StudentName
}).GroupBy(info => info.StudentName)
.Select(Group => new
{
StudentName = Group.Key,
Count = Group.Count()
}).OrderByDescending(x => x.Count).First();
ViewBag.StudentEnrolledForMaxCourses = list.StudentName + " has enrolled for the maximun nymber of courses";
var courses = dbContext.courses
.Join(dbContext.studentCourseEnrollment,
c => c.CourseId,
p => p.CourseId,
(c, p) => new {
CourseName = c.CourseName
}).GroupBy(info => info.CourseName)
.Select(Group => new
{
CourseName = Group.Key,
Count = Group.Count()
}).OrderByDescending(x => x.Count).First();
ViewBag.MaxEnrolledCourse = courses.CourseName + " has maximun enrollment";
var notEnrolledCourseList = dbContext.courses
.Join(dbContext.studentCourseEnrollment,
c => c.CourseId,
p => p.CourseId,
(c, p) => new {
CourseName = c.CourseName
}).GroupBy(info => info.CourseName)
.Select(Group => new
{
CourseName = Group.Key,
Count = Group.Count()
}).OrderBy(x => x.Count).First();
ViewBag.MinEnrolledCourse = notEnrolledCourseList.CourseName + " has minimun enrollment";
return(View());
}
public CoursesController(IStringLocalizer <SharedResource> localizer, WebApiClient <Course> service, WebApiClient <exam> exams, WebApiClient <Tutorial> tutorials, CourseTwoKeyApiClient <examCourse> examCourses, CourseTwoKeyApiClient <TutorialCourse> tutorialCourses, ILogger logger, Courses courses)
{
this.localizer = localizer;
this.service = service;
this.exams = exams;
this.tutorials = tutorials;
this.examCourses = examCourses;
this.tutorialCourses = tutorialCourses;
this.logger = logger;
this.uow = courses;
}
public void GetStudentsInClassMoreThanOneStudent()
{
var db = Utils.MakeMockDatabase();
var controller = MakeController(db);
uint cid = 101;
Courses newCourse = new Courses {
CatalogId = "12345",
Listing = "CS",
Name = "Algorithms",
Number = "3550"
};
db.Courses.Add(newCourse);
Classes newClass = new Classes {
CId = cid,
CatalogId = "12345",
SemesterYear = 2019,
SemesterSeason = "Spring",
Location = "On the moon",
StartTime = new TimeSpan(),
EndTime = new TimeSpan()
};
db.Classes.Add(newClass);
int numberOfStudents = 10;
for (int i = 0; i < numberOfStudents; i++)
{
string uid = "u000000" + i;
Students newStudent = new Students {
UId = uid,
Major = "CS",
FirstName = "Brian" + i,
LastName = "Landes" + i,
Dob = DateTime.Now,
};
db.Students.Add(newStudent);
Enroll(uid, cid, db);
}
db.SaveChanges();
var jsonResult = controller.GetStudentsInClass("CS", 3550, "Spring", 2019) as JsonResult;
Assert.Equal(numberOfStudents, (jsonResult.Value as dynamic).Length);
for (int i = 0; i < numberOfStudents; i++)
{
var oneStudent = Utils.JsonResultValueAtIndex(jsonResult, i);
Assert.True(Utils.HasField(oneStudent, "fname"));
Assert.True(Utils.HasField(oneStudent, "lname"));
Assert.True(Utils.HasField(oneStudent, "uid"));
Assert.True(Utils.HasField(oneStudent, "dob"));
Assert.True(Utils.HasField(oneStudent, "grade"));
Assert.False(Utils.HasField(oneStudent, "two heads"));
Assert.Equal("Brian" + i, Utils.GetValue <string>(oneStudent, "fname"));
Assert.Equal("Landes" + i, Utils.GetValue <string>(oneStudent, "lname"));
Assert.Equal("--", Utils.GetValue <string>(oneStudent, "grade"));
}
}
public IActionResult CopyCourse(long id, Courses request)
{
try
{
if (_userRepository.LogCurrentUser().canCreate == false)
{
return(Unauthorized(_UnAuthorized));
}
if (id == 0)
{
return(BadRequest(new RequestValidationModel {
Name = "Course", Parameter = "courseId", Message = "Please select course"
}));
}
else if (String.IsNullOrEmpty(request.title) == true)
{
return(BadRequest(new RequestValidationModel {
Name = "New Course Title", Parameter = "title", Message = "Please enter new course title"
}));
}
var model = _courseRepository.GetByIdCourseSimple(id);
var model2 = _courseRepository.GetByName(request.title);
if (model == null)
{
return(NotFound(_NotFound));
}
if (model2 != null)
{
return(BadRequest(new GenericResult {
Response = false, Message = "Course already exists"
}));
}
var refCode = _encryptionService.GenerateRefCode();
_courseRepository.DuplicateCourse(id, refCode, request.title);
var insertedCourse = _courseRepository.GetByCode(refCode);
_courseRepository.GetByCode(refCode);
_courseOutlineRepository.DuplicateByCourseId(id, insertedCourse.id);
_courseOutcomeRepository.DuplicateByCourseId(id, insertedCourse.id);
_courseAssessmentRepository.DuplicateByCourseId(id, insertedCourse.id);
_courseCompetenciesRepository.DuplicateByCourseId(id, insertedCourse.id);
_courseEvaluationRepository.DuplicateByCourseId(id, insertedCourse.id);
return(Ok(new GenericResult {
Response = true, Message = "Course has been successfully copied"
}));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
//constructor calling base class for common fields and implementing unique one
public Teacher(string Name, string Phone, string Email, bool IsTeacher, List<classItem> CoursesWith, Courses ApprovedCourses)
: base(Name, Phone, Email, IsTeacher, CoursesWith)
{
approvedCourses = ApprovedCourses;
}
public EditForm(string id)
{
crs = myCRS.GetID(id);
InitializeComponent();
}
public void AddCourse(Courses course)
{
this.Courses.Add(course);
}
public void GetStudentsInClassMoreThanOneStudentAndClasses()
{
var db = Utils.MakeMockDatabase();
var controller = MakeController(db);
Courses newCourse = new Courses {
CatalogId = "12345",
Listing = "CS",
Name = "Algorithms",
Number = "3550"
};
db.Courses.Add(newCourse);
int numberOfClasses = 6;
Dictionary <int, int> classesCount = new Dictionary <int, int>();
for (int i = 0; i < numberOfClasses; i++)
{
uint cid = 101 + (uint)i;
int year = 2000 + i;
Classes newClass = new Classes {
CId = cid,
CatalogId = "12345",
SemesterYear = (ushort)year,
SemesterSeason = "Spring",
Location = "On the moon",
StartTime = new TimeSpan(),
EndTime = new TimeSpan()
};
db.Classes.Add(newClass);
int numberOfStudents = 10 + i;
classesCount.Add(year, numberOfStudents);
for (int j = 0; j < numberOfStudents; j++)
{
string uid = "u00000" + i + j;
Students newStudent = new Students {
UId = uid,
Major = "CS",
FirstName = "Brian" + year + numberOfStudents,
LastName = "Landes" + year + numberOfStudents,
Dob = DateTime.Now,
};
db.Students.Add(newStudent);
Enroll(uid, cid, db);
}
}
db.SaveChanges();
foreach (var pair in classesCount)
{
int year = pair.Key;
int numberOfStudents = pair.Value;
var jsonResult = controller.GetStudentsInClass("CS", 3550, "Spring", year) as JsonResult;
Utils.AssertJsonResultIsArrayOfLength(jsonResult, numberOfStudents);
for (int i = 0; i < numberOfStudents; i++)
{
var oneStudent = Utils.JsonResultValueAtIndex(jsonResult, i);
Assert.True(Utils.HasField(oneStudent, "fname"));
Assert.True(Utils.HasField(oneStudent, "lname"));
Assert.True(Utils.HasField(oneStudent, "uid"));
Assert.True(Utils.HasField(oneStudent, "dob"));
Assert.True(Utils.HasField(oneStudent, "grade"));
Assert.False(Utils.HasField(oneStudent, "two heads"));
Assert.Equal("Brian" + year + numberOfStudents, Utils.GetValue <string>(oneStudent, "fname"));
Assert.Equal("Landes" + year + numberOfStudents, Utils.GetValue <string>(oneStudent, "lname"));
Assert.Equal("--", Utils.GetValue <string>(oneStudent, "grade"));
}
}
}
//Add Course
public void AddCourse(string rName, Teacher rTeacher, DateTime rStartDate, DateTime rEndDate, int rHours)
{
Courses.Add(new Course(rName, rTeacher, rStartDate, rEndDate, rHours));
SaveCourse();
}
public async virtual Task <IList <Course> > GetCoursesAsync()
{
return(await Courses
.AsNoTracking()
.ToListAsync());
}
//Remove Course
public void RemoveCourse(Course course)
{
Courses.Remove(course);
SaveCourse();
}
public void RemoveCourse(Courses course)
{
this.Courses.Remove(course);
}
//======================================method to add teacher==========================================
public static void AddTeacher()
{
string name;
string phone;
string email;
Courses approvedCourses = new Courses();
long check;
Console.Write("Enter Name\n");
name = Console.ReadLine();
Console.Write("Enter 10 digit Phone number\n");
string input = Console.ReadLine();
try
{
check = Convert.ToInt64(input);
}
catch
{
Console.WriteLine("Phone number must be 10 numerical digits");
return;
}
if (input.ToString().Length != 10)
{
Console.WriteLine("Phone number entered is not 10 digits, please try again");
return;
}
else
{
phone = input;
}
Console.Write("Enter Email address\n");
email = Console.ReadLine();
//display all course options
if (name == "" || email == "")
{
Console.WriteLine("One or more fields left empty, please try again");
return;
}
foreach (Cours c in dm.DBCourses)
{
Console.WriteLine("Course ID: {0}\tName: {1}", c.CourseID, c.CourseName);
}
//bool and while loop to keep adding courses until the user stops
bool keepAdding = true;
//loops through all courses comparing entered ID to courseIDs. If a match is found, bool is set to true and if statement is entered, assigning match
//to the list. After this is completed, ask user if they want to add more classes and loop again.
while (keepAdding)
{
Console.WriteLine("Enter ID of a course this teacher can teach");
//setting up tryparse for error checking
string answer = Console.ReadLine();
int id;
bool result = int.TryParse(answer, out id);
bool match = false;
Cours matchedCourse = null;
foreach (Cours c in dm.DBCourses)
{
if (id == c.CourseID)
{
match = true;
matchedCourse = c;
}
}
if (match == true)
{
//nested if statement checks for duplicates and writes and error message if found.
if (approvedCourses.Contains(matchedCourse))
{
Console.WriteLine("this course has already been added, you can't add it twice!");
}
else
{
approvedCourses.Add(matchedCourse);
Console.WriteLine("class successfully added");
}
}
else
{
Console.WriteLine("invalid class number entered");
return;
}
Console.WriteLine("Can this teacher teach another course?\n1...Yes\n2...No");
string anotherClass = Console.ReadLine();
switch (anotherClass)
{
case "1":
break;
case "2":
keepAdding = false;
break;
}
}
//once all classes are assigned, check for null, then create teacher with those classes
//and add him/her to list
if (approvedCourses.CourseCollection.Count != 0)
{
//create empty list of classes to be used when scheduling a class
List<classItem> classesWith = new List<classItem>();
//set bool value to true on all teachers
bool isTeacher = true;
Teacher t = new Teacher(name, phone, email, isTeacher, classesWith, approvedCourses);
if (people.Contains(t))
{
Console.WriteLine("The name, phone number, or email entered is already taken, please enter a new one");
return;
}
else
{
people.Add(t);
//bool used in scheduling a class for error checking
hasTeacher = true;
Console.WriteLine("{0} added Successfully!", t.Name);
}
}
else
{
Console.WriteLine("No courses were successfully added that this teacher can teach. Teacher was not added.");
}
}
public void AddCourse(Course course)
{
Courses.Add(course);
SaveCourse();
}
protected void Page_Load(object sender, EventArgs e)
{
//查看结课资料
if (!IsPostBack)
{
DalOperationAboutCourses doac = new DalOperationAboutCourses();
course = doac.GetCoursesByNo(courseNo, classID, termtag);
if (course == null)
{
course = new Courses { courseNo = courseNo, classID = classID, termTag = termtag };
}
ltlAttachments.Text = "该课程还没有上传期末资料归档！";
DalOperationAboutArchives doaa = new DalOperationAboutArchives();
if (doaa.IsExistArchivesBycourseNoCompatible(courseNo, classID, termtag) != 0)
{
string attachmentIds = doaa.FindArchivesByCourseNoCompatible(courseNo, classID, termtag).attachmentIds;
DalOperationAttachments attachment = new DalOperationAttachments();
string _attachmentIds = attachment.GetAttachmentsList(attachmentIds, ref iframeCount, false,string.Empty);
ltlAttachments.Text = _attachmentIds.Trim().Length == 0 ? "未上传资料" : _attachmentIds;
}
DataBindArchivesItems("教师");
DataBindArchivesItems("助教");
}
}
static void Main(string[] args)
{
Courses courses = new Courses();
// create our People SortedList!
People people = new People();
// create and initialize our person object
Person person = null;
string sAction = null;
while (sAction != "quit")
{
Console.WriteLine();
Console.Write("Add, Edit, Delete, List, Live, Quit => ");
sAction = Console.ReadLine().ToLower();
string email = null;
switch (sAction)
{
case "add":
person = null;
Console.Write("Person type (student/teacher) => ");
string sType = Console.ReadLine();
// create the person object depending on the type they selected
// note that an object of the Person class can point to either a Student or Teacher
if (sType.ToLower().StartsWith("s"))
{
person = new Student();
}
else
{
person = new Teacher();
}
// edit the new person
EditPerson(ref person);
// add the new person to the SortedList array using the email as index
// note that this uses the index property in the class which does additional exception handling
// to catch the case of a duplicated email index
people[person.email] = person;
// we could have done
// people.sortedList.Add(email, person);
// but then we would need to add the exception handling here
break;
case "edit":
Console.Write("Email of person to edit => ");
email = Console.ReadLine();
person = people[email];
// if this email was not found in the list, the get property operator returns null
// note that because we overloaded the == operator,
// we need to cast null as (object) to ensure that the signature does not match the existing overload
// otherwise it tries to treat null as a Person and raises an exception trying to access null.age
// test it yourself without the (object) cast!
if (person == (object)null)
{
Console.WriteLine("That email does not exist.");
}
else
{
// because there cannot be duplicates in the Sorted List
// remove the existing entry from the list
people.Remove(email);
// edit the selected person
EditPerson(ref person);
// re-add the updated person to the list
people[person.email] = person;
}
break;
case "delete":
Console.Write("Email of person to delete => ");
email = Console.ReadLine();
people.Remove(email);
break;
case "list":
int i = 0;
// list each person in the collection
// iterating through a Sorted List uses a special type called KeyValuePair
// each list entry has a Key and a Value
foreach (KeyValuePair <string, Person> thisEntry in people.sortedList)
{
// thisEntry.Key contains the email index
// and thisEntry.Value contains the Person object
// declare a Person reference variable to access all of the common fields of the derived classes
Person thisPerson = (Person)thisEntry.Value;
Console.Write($"{i + 1}: {thisPerson.email} | {thisPerson.name} | {thisPerson.age} | {thisPerson.LicenseId} | ");
if (thisPerson.GetType() == typeof(Student))
{
// gpa only belongs to Student, so we need a Student reference variable to output that
Student student = (Student)thisPerson;
Console.WriteLine($"{student.gpa}");
foreach (string courseCode in student.courseCode)
{
Course thisCourse = courses[courseCode];
if (thisCourse != null)
{
Console.Write(courseCode + " ");
Console.Write(thisCourse.Description + " ");
foreach (DayOfWeek date in thisCourse.schedule.daysOfWeek)
{
Console.Write(date.ToString() + " ");
}
Console.WriteLine($"{ thisCourse.schedule.startTime:hh:mmtt}");
}
}
}
if (thisPerson.GetType() == typeof(Teacher))
{
// specialty only belongs to Teacher, so we need a Teacher reference variable to output that
Teacher teacher = (Teacher)thisPerson;
Console.WriteLine($"{teacher.specialty}");
}
++i;
}
break;
case "live":
Console.Write("Email of person to live for a day => ");
email = Console.ReadLine();
person = people[email];
if (person != (object)null)
{
LiveADay(person);
}
break;
}
}
}
public static Courses CreateCourses(int courseID, string courseName)
{
Courses courses = new Courses();
courses.CourseID = courseID;
courses.CourseName = courseName;
return courses;
}
// GET: Lessons/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Lesson lesson = db.Lessons.Find(id);
if (lesson == null)
{
return(HttpNotFound());
}
#region Lesson Viewed
int lessonID = id.Value;
DateTime viewedDate = DateTime.Now;
string userID = User.Identity.GetUserId();
int lessID = lesson.LessonID;
var currentLessons = db.LessonViews.Where(lv => lv.LessonID == id && lv.UserID == userID);
if (currentLessons.Count() == 0)
{
LessonView lvCred = new LessonView();
lvCred.LessonID = lessID;
lvCred.DateViewed = viewedDate;
lvCred.UserID = userID;
db.LessonViews.Add(lvCred);
db.SaveChanges();
}
Courses tCourse = lesson.Course;
int tcID = lesson.CourseID;
int thisCount = tCourse.Lessons.Count();
//tCourse.Lessons.Count();
int thisCourseCount = (from x in db.LessonViews
where x.UserID == userID &&
x.Lessons.CourseID == tcID
select x).Count();
bool userCompletedAlready = db.CourseCompletions.Where(uc => uc.UserID == userID && uc.CourseID == tcID).Count() > 0;
if (!userCompletedAlready && thisCourseCount >= thisCount)
{
CourseCompletion cc = new CourseCompletion();
cc.UserID = userID;
cc.CourseID = tcID;
cc.DateCompleted = DateTime.Now;
db.CourseCompletions.Add(cc);
db.SaveChanges();
//current user details
var currentUserDeets = db.UserDetails.Where(ud => ud.UserID == userID).Single();;
//CourseCompletion cce = db.CourseCompletions.Where(x => x.CourseCompletionID == completeID).Single();
string body = $"{currentUserDeets.FirstName} {currentUserDeets.LastName} has completed course {cc.Course.CourseName} as of {cc.DateCompleted}.";
MailMessage mm = new MailMessage("*****@*****.**", "*****@*****.**", currentUserDeets.FirstName + " " + currentUserDeets.LastName + " has completed a course!", body);
SmtpClient client = new SmtpClient("mail.devmeister.net");
client.Credentials = new NetworkCredential("*****@*****.**", "Be@r8918$");
using (client)
{
client.Send(mm);
}
return(View(lesson));
}
//Be@r8918$
#endregion
return(View(lesson));
}
public static Courses CreateCourses(int ID)
{
Courses courses = new Courses();
courses.Id = ID;
return courses;
}
/// <summary>
/// Курсы, отсорированные по дате. Первый — самый ранний курс.
/// </summary>
public virtual IEnumerable <Course> GetOrderedCourses()
{
return(Courses.OrderBy(c => c));
}
public void AddToCourses(Courses courses)
{
base.AddObject("Courses", courses);
}
// C
public Courses Create(Courses course)
{
_courses.InsertOne(course);
return(course);
}
public int Add(Courses _Course)
{
string query = "Insert Into Courses(CourseCode,CourseName,CourseCredit,CourseDescription,DepartmentId,SemesterId,CourseAssigneTo,Assigne_Status) Values ('" + _Course.CourseCode + "','" + _Course.CourseName + "','" + Convert.ToDecimal(_Course.CourseCredit) + "','" + _Course.CourseDescription + "','" + Convert.ToInt32(_Course.DepartmentId) + "','" + Convert.ToInt32(_Course.SemesterId) + "','Not Assigned Yet','Not Assigned')";
return(_MainRepository.ExecuteNonQuery(query, _MainRepository.ConnectionString()));
}
public void Remove(Courses courseIn) => _courses.DeleteOne(course => course.Id == courseIn.Id);
public static ClientCourse GetClientCourseFromCourse(Courses course) {
return new ClientCourse { ID = course.CourseID, Name = course.CourseName, Description = course.CourseDescription };
}
