private void enrollHelaRegular() { EnrollmentTable enrollmentTable = new EnrollmentTable(); PaymentTable paymentTable = new PaymentTable(); EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.name = dogModelOdin.name + " (owned by " + clientModelJames.displayName + ") in " + programModelRegular1.name; enrollmentModel.clientId = clientIdJames; enrollmentModel.dogId = dogIdHela; enrollmentModel.programId = programIdRegular1; enrollmentModel.paymentMethod = PaymentConstants.PAYMENT_PER_CLASS; enrollmentModel.joinDate = DateTime.Now.AddDays(-19); enrollmentModel.inviteIssued = true; int enrollmentId = enrollmentTable.create(enrollmentModel); PaymentModel paymentModel1 = new PaymentModel(); paymentModel1.enrollmentId = enrollmentId; paymentModel1.paymentType = PaymentTypeConstants.DEPOSIT; paymentModel1.paymentAmountDue = programVarietyModelRegular.depositAmount; paymentModel1.paymentAmountDueDate = DateTime.Now.AddDays(-19); paymentModel1.paymentRecieved = true; paymentModel1.paymentRecievedDate = DateTime.Now.AddDays(-19); paymentModel1.recieptIssued = true; paymentTable.create(paymentModel1); PaymentModel paymentModel2 = new PaymentModel(); paymentModel2.enrollmentId = enrollmentId; paymentModel2.paymentType = PaymentTypeConstants.INSTALLMENT; paymentModel2.paymentAmountDue = 39.00; paymentModel2.paymentAmountDueDate = DateTime.Now.AddDays(+14); paymentModel2.paymentRecieved = false; //paymentModel2.paymentRecievedDate = DateTime.Now.AddDays(+); paymentModel2.recieptIssued = false; paymentTable.create(paymentModel2); PaymentModel paymentModel3 = new PaymentModel(); paymentModel3.enrollmentId = enrollmentId; paymentModel3.paymentType = PaymentTypeConstants.INSTALLMENT; paymentModel3.paymentAmountDue = 39.00; paymentModel3.paymentAmountDueDate = DateTime.Now.AddDays(+28); paymentModel3.paymentRecieved = false; //paymentModel2.paymentRecievedDate = DateTime.Now.AddDays(+); paymentModel3.recieptIssued = false; paymentTable.create(paymentModel3); PaymentModel paymentModel4 = new PaymentModel(); paymentModel4.enrollmentId = enrollmentId; paymentModel4.paymentType = PaymentTypeConstants.INSTALLMENT; paymentModel4.paymentAmountDue = 39.00; paymentModel4.paymentAmountDueDate = DateTime.Now.AddDays(+42); paymentModel4.paymentRecieved = false; //paymentModel4.paymentRecievedDate = DateTime.Now.AddDays(+); paymentModel4.recieptIssued = false; paymentTable.create(paymentModel4); }
private void btnNew_Click(object sender, EventArgs e) { //make sure the model has no old information in it selectedEnrollment = new EnrollmentModel(); enableInputs(); ClearInputs(); }
private void btnDelete_Click(object sender, EventArgs e) { //If this is 0 then there is nothing to show. The model is blank if (selectedEnrollment.id == 0) { return; } //Don't let them delete it by accident DialogResult result = MessageBox.Show( "Wow!! Wait...are you sure?\n\nNote: All future payment records associated with this enrollment will be deleted", "Important Question", MessageBoxButtons.YesNo); //Abort!! if (result == DialogResult.No) { return; } //Delete the reord from the table and update the ListView try { new EnrollmentTable().delete(selectedEnrollment.id); //reset everything ClearInputs(); RefreshList(); selectedEnrollment = new EnrollmentModel(); } catch (Exception ex) { new ExceptionMessageGenerator().generateMessage(ex.Message); } }
public ActionResult Index() { var thisWeekLunches = LunchRepository.GetLunchesForThisWeek().ToList(); var user = UserRepository.GetUserByName(User.Identity.Name); if (user == null) { return(RedirectToAction("LogOff", "Account")); } var model = new EnrollmentModel() { MyLunches = new HashSet <Guid>(user.Enrollments.Select(e => e.EnrolledForLunchId)), Lunches = thisWeekLunches }; var userRatings = MealRepository.GetUserRatings(user.Id); var meals = MealRepository.GetAll(); var ratingModel = new RatingModel() { Meals = meals, UserRatings = userRatings.ToDictionary(m => m.RatedMealId, m => m.Rating) }; model.RatingModel = ratingModel; return(View(model)); }
public void Read_CreatedAndRead1Record_CorrectValues() { //Assemble EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.programId = programId; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; enrollmentModel.paymentMethod = 2; enrollmentModel.name = "Advanced"; enrollmentModel.joinDate = DateTime.Now; enrollmentModel.inviteIssued = true; EnrollmentTable enrollmentTable = new EnrollmentTable(); //Act int enrollmentID = enrollmentTable.create(enrollmentModel); EnrollmentModel actual = enrollmentTable.read(enrollmentID); //Assert Assert.AreEqual(enrollmentModel.programId, actual.programId); Assert.AreEqual(enrollmentModel.clientId, actual.clientId); Assert.AreEqual(enrollmentModel.dogId, actual.dogId); Assert.AreEqual(enrollmentModel.programId, actual.programId); Assert.AreEqual(enrollmentModel.name, actual.name); Assert.AreEqual(enrollmentModel.joinDate.DayOfYear, actual.joinDate.DayOfYear); Assert.AreEqual(enrollmentModel.inviteIssued, actual.inviteIssued); }
public ActionResult EnrollUser(EnrollmentModel model) { if ((model.StartDate != null) && (model.EndDate != null) && (model.StartDate.Value.CompareTo(model.EndDate) > 0)) { ModelState.AddModelError("EndDate", "Start date must preceed end date."); return(View("Index", model)); } var course = this.Data.Courses.GetById(model.CourseId); var user = this.Data.Users.All().FirstOrDefault(u => u.Id == model.Id); var courseInstance = new CourseInstance() { User = user, Course = course, Mark = null, StartDate = model.StartDate, EndDate = model.EndDate }; this.Data.CourseInstances.Add(courseInstance); this.Data.SaveChanges(); model.Message = "User enrolled"; return(View("Index", model)); }
public void Update_CreatedUpdateAndRead1Record_UpdatedValues() { //Assemble EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.programId = programId; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; EnrollmentTable enrollmentTable = new EnrollmentTable(); int enrollmentID = enrollmentTable.create(enrollmentModel); enrollmentModel.id = enrollmentID; enrollmentModel.programId = programId; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; //Act enrollmentTable.update(enrollmentModel); EnrollmentModel actual = enrollmentTable.read(enrollmentID); //Assert Assert.AreEqual(enrollmentModel.programId, actual.programId); Assert.AreEqual(enrollmentModel.clientId, actual.clientId); Assert.AreEqual(enrollmentModel.dogId, actual.dogId); Assert.AreEqual(enrollmentModel.programId, actual.programId); }
public ActionResult DeleteConfirmed(int id) { EnrollmentModel enrollmentModel = db.Enrollment.Find(id); db.Enrollment.Remove(enrollmentModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult Post(EnrollmentModel model) { repository.Insert(new Enrollment() { Subject = repositorySubject.GetById(model.SubjectId), Student = repositoryStudent.GetById(model.StudentId) }); repository.Commit(); return(Ok()); }
public ActionResult GetUserList(int id) { //var course = this.Data.Courses.All(new string[] { "Users", "Certificates" }).FirstOrDefault(c => c.Id == id); /*var course = from user in this.Data.Users.All() * from courseInstance in user.Courses * select new * { * Username = user.UserName, * courseInstance = courseInstance.Course.Title * }; * var zd = course.ToList();*/ var courseInstances = this.Data.Courses.All(new string[] { "CourseInstances", "CourseInstances.User" }).FirstOrDefault(c => c.Id == id).CourseInstances; var enrolledUsers = new List <string>(); foreach (var course in courseInstances) { if (course.IsActive) { enrolledUsers.Add(course.User.Id); } } var eligibleUsers = Data.Users.All().ToList(); eligibleUsers = eligibleUsers.Where(u => !enrolledUsers.Contains(u.Id)).ToList(); if (eligibleUsers == null) { return(View("Error")); } var userList = new List <UserEnrollModel>(); foreach (var user in eligibleUsers) { userList.Add(new UserEnrollModel() { Id = user.Id, Username = user.UserName }); } var model = new EnrollmentModel(); model.CourseId = id; model.Users = userList; model.Id = ""; /*var context = new DataContext(); * var eligibleUsers = context.Users.ToList();*/ return(PartialView("_UserEnrollment", model)); }
public async Task Add(EnrollmentModel enrollment) { if (enrollments.Where(x => x.StudentyId == enrollment.StudentyId && x.CourseId == enrollment.CourseId).Count() == 0) { await Task.Run(() => { enrollment.Id = enrollments.Count; enrollment.Id++; enrollments.Add(enrollment); }); } }
public IHttpActionResult Put(EnrollmentModel model) { var enrollment = repository.GetById(model.Id); enrollment.Score = model.Score; repository.Update(enrollment); repository.Commit(); return(Ok()); }
public void ReadAll_Create3Records_CountIs3() { //Assemble EnrollmentModel enrollmentModel1 = new EnrollmentModel(); enrollmentModel1.programId = programId; enrollmentModel1.programId = programId; enrollmentModel1.clientId = clientId; enrollmentModel1.dogId = dogId; enrollmentModel1.programId = programId; enrollmentModel1.paymentMethod = 1; enrollmentModel1.name = "Advanced"; enrollmentModel1.joinDate = DateTime.Now; enrollmentModel1.inviteIssued = true; EnrollmentModel enrollmentModel2 = new EnrollmentModel(); enrollmentModel2.programId = programId; enrollmentModel2.programId = programId; enrollmentModel2.clientId = clientId; enrollmentModel2.dogId = dogId; enrollmentModel2.programId = programId; enrollmentModel2.paymentMethod = 2; enrollmentModel2.name = "Advanced"; enrollmentModel2.joinDate = DateTime.Now; enrollmentModel2.inviteIssued = true; EnrollmentModel enrollmentModel3 = new EnrollmentModel(); enrollmentModel3.programId = programId; enrollmentModel3.programId = programId; enrollmentModel3.clientId = clientId; enrollmentModel3.dogId = dogId; enrollmentModel3.programId = programId; enrollmentModel3.paymentMethod = 1; enrollmentModel3.name = "Regular"; enrollmentModel3.joinDate = DateTime.Now; enrollmentModel3.inviteIssued = true; EnrollmentTable enrollmentTable = new EnrollmentTable(); int expected = 3; //Act int enrollmentID1 = enrollmentTable.create(enrollmentModel1); int enrollmentID2 = enrollmentTable.create(enrollmentModel2); int enrollmentID3 = enrollmentTable.create(enrollmentModel3); List <EnrollmentModel> actual = enrollmentTable.readAll(); //Assert Assert.AreEqual(expected, actual.Count); }
public void Update(EnrollmentModel model) { if (model == null) { return; } var entity = _mapper.Map <EnrollmentModel, Enrollment>(model); _context.Enrollments.Update(entity); _context.SaveChanges(); }
public void ReadAll_Create3Records_3DifferentRecords() { //Assemble EnrollmentModel enrollmentModel1 = new EnrollmentModel(); enrollmentModel1.programId = programId; enrollmentModel1.programId = programId; enrollmentModel1.clientId = clientId; enrollmentModel1.dogId = dogId; enrollmentModel1.programId = programId; EnrollmentModel enrollmentModel2 = new EnrollmentModel(); enrollmentModel2.programId = programId; enrollmentModel2.programId = programId; enrollmentModel2.clientId = clientId; enrollmentModel2.dogId = dogId; enrollmentModel2.programId = programId; EnrollmentModel enrollmentModel3 = new EnrollmentModel(); enrollmentModel3.programId = programId; enrollmentModel3.programId = programId; enrollmentModel3.clientId = clientId; enrollmentModel3.dogId = dogId; enrollmentModel3.programId = programId; EnrollmentTable enrollmentTable = new EnrollmentTable(); //Act int enrollmentID1 = enrollmentTable.create(enrollmentModel1); int enrollmentID2 = enrollmentTable.create(enrollmentModel2); int enrollmentID3 = enrollmentTable.create(enrollmentModel3); List <EnrollmentModel> actual = enrollmentTable.readAll(); //Assert Assert.AreEqual(enrollmentID1, enrollmentID1); Assert.AreEqual(enrollmentModel1.programId, actual[0].programId); Assert.AreEqual(enrollmentModel1.clientId, actual[0].clientId); Assert.AreEqual(enrollmentModel1.dogId, actual[0].dogId); Assert.AreEqual(enrollmentModel1.programId, actual[0].programId); Assert.AreEqual(enrollmentID2, enrollmentID2); Assert.AreEqual(enrollmentModel2.programId, actual[1].programId); Assert.AreEqual(enrollmentModel2.clientId, actual[1].clientId); Assert.AreEqual(enrollmentModel2.dogId, actual[1].dogId); Assert.AreEqual(enrollmentModel2.programId, actual[1].programId); Assert.AreEqual(enrollmentID3, enrollmentID3); Assert.AreEqual(enrollmentModel3.programId, actual[2].programId); Assert.AreEqual(enrollmentModel3.clientId, actual[2].clientId); Assert.AreEqual(enrollmentModel3.dogId, actual[2].dogId); Assert.AreEqual(enrollmentModel3.programId, actual[2].programId); }
private static void PropertiesMapperExample(SchoolContext ctx) { var enrollments = ctx.Enrollments.ToList(); EnrollmentModel enrollmentModel = Mapper.From(enrollments[0]).To <EnrollmentModel>(); Console.WriteLine(enrollmentModel); var enrollmentModels = enrollments.Map().To <EnrollmentModel>().ToList(); Console.WriteLine(GetResultsString("Enrollments", enrollmentModels)); }
public ActionResult Edit([Bind(Include = "ID,CourseID,StudentID,Grade")] EnrollmentModel enrollmentModel) { if (ModelState.IsValid) { db.Entry(enrollmentModel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Course, "ID", "Title", enrollmentModel.CourseID); ViewBag.StudentID = new SelectList(db.student, "ID", "Lastname", enrollmentModel.StudentID); return(View(enrollmentModel)); }
public void CreateNewEnrollment() { try { SelectedEnrollment = new EnrollmentModel(); UpdateAppStatus("New enrollment created."); } catch (Exception ex) { UpdateAppStatus(ex.Message); } }
// GET: Enrollment/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EnrollmentModel enrollmentModel = db.Enrollment.Find(id); if (enrollmentModel == null) { return(HttpNotFound()); } return(View(enrollmentModel)); }
private void lsvEnrollment_SelectedIndexChanged_1(object sender, EventArgs e) { try { //get the details of the ListView row - make sure to cast it selectedEnrollment = (EnrollmentModel)lsvEnrollment.SelectedItems[0].Tag; //fill the input fields PopulateInputs(); } catch (Exception ex) { String message = new ExceptionMessageGenerator().generateMessage(ex.Message); } }
// GET: Enrollment/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EnrollmentModel enrollmentModel = db.Enrollment.Find(id); if (enrollmentModel == null) { return(HttpNotFound()); } ViewBag.CourseID = new SelectList(db.Course, "ID", "Title", enrollmentModel.CourseID); ViewBag.StudentID = new SelectList(db.student, "ID", "Lastname", enrollmentModel.StudentID); return(View(enrollmentModel)); }
internal Enrollment(Api api, EnrollmentModel model) { _api = api; Id = model.Id; CourseId = model.CourseId; SisCourseId = model.SisCourseId; CourseIntegrationId = model.CourseIntegrationId; CourseSectionId = model.CourseSectionId; SectionIntegrationId = model.SectionIntegrationId; SisAccountId = model.SisAccountId; SisSectionId = model.SisSectionId; SisUserId = model.SisUserId; EnrollmentState = model.EnrollmentState; LimitPrivilegesToCourseSection = model.LimitPrivilegesToCourseSection; SisImportId = model.SisImportId; RootAccountId = model.RootAccountId; Type = model.Type; UserId = model.UserId; AssociatedUserId = model.AssociatedUserId; Role = model.Role; RoleId = model.RoleId; CreatedAt = model.CreatedAt; UpdatedAt = model.UpdatedAt; StartAt = model.StartAt; EndAt = model.EndAt; LastActivityAt = model.LastActivityAt; LastAttendedAt = model.LastAttendedAt; TotalActivityTime = model.TotalActivityTime; HtmlUrl = model.HtmlUrl; Grades = model.Grades.ConvertIfNotNull(m => new Grade(api, m)); User = model.User.ConvertIfNotNull(m => new UserDisplay(api, m)); OverrideGrade = model.OverrideGrade; OverrideScore = model.OverrideScore; UnpostedCurrentGrade = model.UnpostedCurrentGrade; UnpostedFinalGrade = model.UnpostedFinalGrade; UnpostedCurrentScore = model.UnpostedCurrentScore; UnpostedFinalScore = model.UnpostedFinalScore; HasGradingPeriods = model.HasGradingPeriods; TotalsForAllGradingPeriodsOption = model.TotalsForAllGradingPeriodsOption; CurrentGradingPeriodTitle = model.CurrentGradingPeriodTitle; CurrentGradingPeriodId = model.CurrentGradingPeriodId; CurrentPeriodOverrideGrade = model.CurrentPeriodOverrideGrade; CurrentPeriodOverrideScore = model.CurrentPeriodOverrideScore; CurrentPeriodUnpostedFinalScore = model.CurrentPeriodUnpostedFinalScore; CurrentPeriodUnpostedCurrentGrade = model.CurrentPeriodUnpostedCurrentGrade; CurrentPeriodUnpostedFinalGrade = model.CurrentPeriodUnpostedFinalGrade; }
public void Upsert(EnrollmentModel enrollmentModel) { var sql = "Enrollments_Upsert"; var userId = System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString(); var dataTable = new DataTable(); dataTable.Columns.Add("EnrollmentId", typeof(int)); dataTable.Columns.Add("StudentId", typeof(int)); dataTable.Columns.Add("CourseId", typeof(int)); dataTable.Rows.Add(enrollmentModel.EnrollmentId, enrollmentModel.StudentId, enrollmentModel.CourseId); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Execute(sql, new { @EnrollmentType = dataTable.AsTableValuedParameter("EnrollmentType"), @UserId = userId }, commandType: CommandType.StoredProcedure); } }
public void Count_Created1Record_1() { //Assemble EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.programId = programId; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; int expected = 1; EnrollmentTable enrollmentTable = new EnrollmentTable(); //Act int enrollmentID = enrollmentTable.create(enrollmentModel); int actual = enrollmentTable.count(); //Assert Assert.AreEqual(expected, actual); }
public JsonResult EnrollCourse([FromBody] EnrollmentModel enrollmentModel) { try { return(Json(EnrollmentService.AddEnrollment(new Input <EnrollmentModel> { OperationBy = "System", Arguments = new EnrollmentModel { CourseId = enrollmentModel.CourseId, StudentId = enrollmentModel.StudentId } }))); } catch (Exception exception) { return(Json(OutputResult.FailOutputResult(exception.Message))); } }
public void Upsert(EnrollmentModel enrollmentModel) { var sql = "Enrollment_Upsert"; //Windows username var userId = System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString(); //Szerintem nem kell a ToString() //Az SQL Serveren tarolt stored procedure User defined Table tipust fogad. Adattablaban adjuk at neki. var dataTable = new DataTable(); dataTable.Columns.Add("EnrollmentId", typeof(int)); dataTable.Columns.Add("StudentId", typeof(int)); dataTable.Columns.Add("CourseId", typeof(int)); dataTable.Rows.Add(enrollmentModel.EnrollmentId, enrollmentModel.StudentId, enrollmentModel.CourseId); using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Execute(sql, new { @EnrollmentType = dataTable.AsTableValuedParameter("EnrollmentType"), @UserId = userId }, commandType: CommandType.StoredProcedure); } }
public void Create_ValidData_EnrollmentIDReturned() { //Assemble EnrollmentModel enrollmentModel = new EnrollmentModel(); enrollmentModel.programId = programId; enrollmentModel.clientId = clientId; enrollmentModel.dogId = dogId; enrollmentModel.programId = programId; //If created will be greater than 0, but we don't know exactly what it will be because deleting all records doesnt set the ID counter back to 0 int notCreated = 0; EnrollmentTable enrollmentTable = new EnrollmentTable(); //Act int actual = enrollmentTable.create(enrollmentModel); //Assert Assert.AreNotEqual(notCreated, actual); }
public MainViewModel() { SelectedEnrollment = new EnrollmentModel(); try { _enrollmentCommand = new EnrollmentCommand(_connectionString); Enrollments.AddRange(_enrollmentCommand.GetList()); StudentCommand studentCommand = new StudentCommand(_connectionString); Students.AddRange(studentCommand.GetList()); CourseCommand courseCommand = new CourseCommand(_connectionString); Courses.AddRange(courseCommand.GetList()); } catch (Exception ex) { UpdateAppStatus(ex.Message); } }
public HttpResponseMessage DeleteEnrollment(EnrollmentModel enrollmentModel) { var voiceItWrapper = new VoiceItWrapper(); if (enrollmentModel.UserDetails == null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "User details not supplied")); } var result = voiceItWrapper.deleteEnrollment(enrollmentModel.UserDetails.UserId, enrollmentModel.UserDetails.Password, enrollmentModel.EnrollmentId); if (string.IsNullOrEmpty(result)) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "The server did not respond back with a result")); } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public async Task <IActionResult> EnrollStudent(EnrollmentModel model) { var enrollment = new EnrollmentDto() { Birthdate = model.Birthdate, Email = model.Email, Studies = model.Studies, FirstName = model.FirstName, IndexNumber = model.IndexNumber, LastName = model.LastName }; var result = await _enrollmentsService.EnrollStudent(enrollment); if (result.studiesExists is false) { return(BadRequest("Studies does not exist")); } return(Ok()); }