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());
}
