public async Task <IHttpActionResult> Post(EnrollmentDTO enrollmentDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState));//status code 400 } //var enrollment = new EnrollmentDTO //{ // EnrollmentID = enrollmentDTO.EnrollmentID, // CourseID = enrollmentDTO.CourseID, // StudentID = enrollmentDTO.StudentID, // Grade = enrollmentDTO.Grade //}; try { var enrollment = mapper.Map <Enrollment>(enrollmentDTO); enrollment = await enrollmentService.Insert(enrollment); return(Ok(enrollmentDTO));//status code 200 } catch (Exception ex) { return(InternalServerError(ex));//status code 500 } }
public List <EnrollmentDTO> GetStaleEnrollmentCases(Guid UserId) { try { List <EnrollmentDTO> oenrolllist = new List <EnrollmentDTO>(); db = new DatabaseEntities(); DateTime cudate = System.DateTime.Now.AddDays(-2); var Bankenrolls = (from be in db.BankEnrollments where be.UpdatedDate >= cudate && be.IsActive == true && be.ArchiveStatusCode != EMPConstants.Archive select be); var custList = Bankenrolls.Select(a => a.CustomerId).Distinct().ToList(); var Customers = (from cu in db.emp_CustomerInformation join cl in db.emp_CustomerLoginInformation on cu.Id equals cl.CustomerOfficeId where custList.Contains(cu.Id) select new { cu, cl }); foreach (var itm in Bankenrolls) { EnrollmentDTO oEnrolModel = new EnrollmentDTO(); var cust = Customers.Where(a => a.cu.Id == itm.CustomerId).FirstOrDefault(); oEnrolModel.MasterID = cust.cu.MasterIdentifier; oEnrolModel.UserID = cust.cl.EMPUserId.ToString(); if (cust.cu.ParentId != null) { oEnrolModel.ParentUserID = Customers.Where(a => a.cl.CustomerOfficeId == cust.cu.ParentId).Select(a => a.cl.CrossLinkUserId).FirstOrDefault(); } else { oEnrolModel.ParentUserID = ""; } oEnrolModel.CompanyName = cust.cu.CompanyName.ToString(); oEnrolModel.Efin = cust.cu.EFIN.ToString().PadLeft(6, '0'); oEnrolModel.AccountStatus = cust.cu.AccountStatus.ToString(); oEnrolModel.EROType = cust.cu.EROType.ToString(); oEnrolModel.CaseOrgin = string.Empty; oEnrolModel.Product = string.Empty; oEnrolModel.FuntionalArea = string.Empty; oEnrolModel.Module = string.Empty; oEnrolModel.Issue = string.Empty; oEnrolModel.Status = string.Empty; oEnrolModel.Casenumber = string.Empty; if (cust.cu.IsMSOUser == true) { oEnrolModel.MSOUser = "******"; } else { oEnrolModel.MSOUser = "******"; } oEnrolModel.DateTimeOpened = itm.CreatedDate == null ? string.Empty : Convert.ToDateTime(itm.CreatedDate).ToString("MM/dd/yyyy hh:mm tt"); oEnrolModel.DateTimeLastModified = itm.UpdatedDate == null ? string.Empty : Convert.ToDateTime(itm.UpdatedDate).ToString("MM/dd/yyyy hh:mm tt"); oenrolllist.Add(oEnrolModel); } return(oenrolllist.OrderBy(a => a.DateTimeLastModified).ToList()); } catch (Exception ex) { EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "ReportsService/GetStaleEnrollmentCases", UserId); return(new List <EnrollmentDTO>()); } }
/// <summary> /// This static void transform a student to a studentDTO for the ApiService /// </summary> /// <param name="student"></param> /// <returns>studentDTO</returns> public static StudentDTO TransformStudentToStudentDTO(Student student) { StudentDTO studentDto = new StudentDTO(); List <EnrollmentDTO> coursesList = new List <EnrollmentDTO>(); if (student.Enrollments != null) { foreach (Enrollment enrollment in student.Enrollments) { EnrollmentDTO course = new EnrollmentDTO(); course.courseId = enrollment.CourseID; coursesList.Add(course); } } studentDto.id = student.ID; studentDto.firstname = student.FirstMidName; studentDto.lastname = student.LastName; studentDto.enrollmentDate = student.EnrollmentDate.ToString("yyyy-MM-dd"); studentDto.enrollments = coursesList; return(studentDto); }
public async Task <IHttpActionResult> Put(EnrollmentDTO enrollmentDTO, int id) // object - cuerpo pero si es prmitivo por la url { if (!ModelState.IsValid) { return(BadRequest(ModelState)); // status code 400 } if (enrollmentDTO.EnrollmentID != id) { return(BadRequest()); } var flag = await enrollmentService.GetById(id); if (flag == null) { return(NotFound()); // status code 404 } try { var enrollment = mapper.Map <Enrollment>(enrollmentDTO); enrollment = await enrollmentService.Insert(enrollment); return(Ok(enrollment)); //Sastus code 200 //return Ok(courseDTO); //Sastus code 200 } catch (Exception ex) { return(InternalServerError(ex)); //Status code 500 } }
public async Task <IHttpActionResult> Post(EnrollmentDTO enrollmentDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); // status code 400 } //var course = new CourseDTO //{ // CourseId = courseDTO.CourseId, // Title = courseDTO.Title, // Credits = courseDTO.Credits //}; //Ctrl + K + S Redondear el codigo try { var enrollment = mapper.Map <Enrollment>(enrollmentDTO); //var course = mapper.Map<Course>(courseDTO); //course = await courseService.Insert(course); //return Ok(courseDTO); //Sastus code 400 enrollment = await enrollmentService.Insert(enrollment); return(Ok(enrollmentDTO)); //Sastus code 200 } catch (Exception ex) { return(InternalServerError(ex)); //Status code 500 } }
public EnrollmentDTO NewEnrollment() { var enrollment = new EnrollmentDTO { EnrollmentId = _enrollmentService.GetNewEnrollmentId() }; return(enrollment); }
public IActionResult EnrollStudent(EnrollmentDTO enrolment) { var db = new s16600Context(); //if (db.Studies.Count(s => s.Name == e.Studies) == 0) if (!db.Studies.Any(s => s.Name == enrolment.Studies)) { return(BadRequest("Brak takiego kierunku studiów")); } if (db.Student.Any(s => s.IndexNumber == enrolment.IndexNumber)) { return(BadRequest("Student o takim numerze indeksu już istnieje")); } var ids = db.Studies.Where(s => s.Name == enrolment.Studies).First().IdStudy; if (!db.Enrollment.Any(e => (e.Semester == 1) && (e.IdStudy == ids))) { var e = new Enrollment(); e.IdEnrollment = db.Enrollment.Max(e => e.IdEnrollment) + 1; e.Semester = 1; e.IdStudy = ids; e.StartDate = DateTime.Now; db.Enrollment.Add(e); db.SaveChanges(); //return Ok("Dodano rekrutację"); } var s = new Student(); s.IndexNumber = enrolment.IndexNumber; s.FirstName = enrolment.FirstName; s.LastName = enrolment.LastName; s.BirthDate = Convert.ToDateTime(enrolment.BirthDate); s.IdEnrollment = db.Enrollment.Where(e => (e.Semester == 1) && (e.IdStudy == ids)).First().IdEnrollment; db.Student.Add(s); db.SaveChanges(); return(Ok("Dodano studenta")); /* * { * "IndexNumber": "s12345", * "FirstName": "Andrzej", * "LastName": "Malewski", * "BirthDate": "30.03.1993", * "Studies": "IT" * }*/ }
public async Task <ActionResult> Create(EnrollmentDTO enrollmentDTO) { if (!ModelState.IsValid) { var enrollment = mapper.Map <Enrollment>(enrollmentDTO); await enrollmentService.Insert(enrollment); return(RedirectToAction(nameof(Index))); } return(View(enrollmentDTO)); }
public ActionResult MakeEnrollment(EnrollmentViewModel order) { try { var enrollmentDto = new EnrollmentDTO() /*PhoneId = order.PhoneId, Address = order.Address, PhoneNumber = order.PhoneNumber*/ } { ; //TODO добавить проверку на факт регистрации enrollmentService.MakeRegister(enrollmentDto); return(Content("<h2>Ваш заказ успешно оформлен</h2>")); }
public async Task <ActionResult> Create(EnrollmentDTO enrollmentDTO) { if (!ModelState.IsValid) { return(View(enrollmentDTO)); } var enrollment = _mapper.Map <Enrollment>(enrollmentDTO); await _enrollmentService.Insert(enrollment); var id = enrollment.EnrollmentID; return(RedirectToAction("Index")); }
public async Task <ActionResult> Create(EnrollmentDTO collection) { try { if (collection != null) { await enrollmentService.Insert(collection); } return(RedirectToAction(nameof(Index))); } catch (Exception ex) { throw ex; } }
// GET: Enrollment/Create public ActionResult Create() { EnrollmentDTO enrollment = new EnrollmentDTO(); enrollment.listStudent = studentService.GetAll().Select(x => new SelectListItem() { Value = x.ID.ToString(), Text = x.FirstMidName }).ToList(); enrollment.listCourse = courseService.GetAll().Select(x => new SelectListItem() { Value = x.CourseID.ToString(), Text = x.Title }).ToList(); return(View(enrollment)); }
public IActionResult AddEnrollment(EnrollmentDTO enrollmentDTO) { if (!ModelState.IsValid) { var state = ModelState; return(BadRequest()); } Enrollment enrollment = _dbService.EnrollStudent(enrollmentDTO); if (enrollment != null) { return(Created("api/students/" + enrollmentDTO.IndexNumber, enrollment)); } else { return(BadRequest()); } }
public IActionResult Update(string code, [FromBody] EnrollmentDTO value) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var repo = _unitOfWork.GetRepository <Enrollment>(); var newval = Mapper.Map <Enrollment>(value); newval.EnrollmentId = code; repo.Update(newval); repo.SaveChanges(); return(Ok(newval)); } catch (Exception e) { return(BadRequest(e)); } }
public EnrollmentDTO CreateEnrollment(EnrollmentDTO value, string token) { try { var repo = _unitOfWork.GetRepository <Enrollment>(); var newvalue = Mapper.Map <Enrollment>(value); newvalue.EnrollmentGUID = Guid.NewGuid(); if (newvalue.EnrollmentCode == null) { newvalue.EnrollmentCode = newvalue.EnrollmentId; } //newvalue.CreatedBy = _appUserService.GetUserId(token); newvalue.CreationDate = DateTime.Now; repo.Add(newvalue); repo.SaveChanges(); return(Mapper.Map <EnrollmentDTO>(newvalue)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IActionResult Post([FromBody] EnrollmentDTO value) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { //var idToken = HttpContext.GetTokenAsync(JwtBearerDefaults.AuthenticationScheme, "access_token"); //var token = idToken.Result; var enrollment = _enrollmentService.CreateEnrollment(value, ""); if (enrollment != null) { return(Ok(enrollment)); } return(BadRequest(new { message = "Cannot Create Enrollment" })); } catch (Exception e) { return(BadRequest(e)); } }
public void UpdateEnrollment(Enrollment enrollment, EnrollmentDTO enrollmentDTO) { UpdateHedwigIdEntityWithNavigationProperties <Enrollment, EnrollmentDTO, int>(enrollment, enrollmentDTO); }
public EnrollmentDTO EnrollStudent(EnrollStudentDTO enrollStudentDTO) { string connectionString = "Data Source=db-mssql;Initial Catalog=s17417;Integrated Security=True"; EnrollmentDTO enrollment; using (SqlConnection connection = new SqlConnection(connectionString)) using (SqlCommand command = new SqlCommand()) { int IdStudy; connection.Open(); var transaction = connection.BeginTransaction(); try { // enrollment = new EnrollmentDTO(); command.Connection = connection; command.Transaction = transaction; command.CommandText = "Select IdStudy from Studies where name=@Name"; command.Parameters.AddWithValue("Name", enrollStudentDTO.Studies); var reader = command.ExecuteReader(); reader.Read(); if (!reader.HasRows) { return(null); } IdStudy = reader.GetInt32(reader.GetOrdinal("IdStudy")); reader.Close(); /*enrollment.Semester = 1; * enrollment.IdEnrollment = 1; * enrollment.IdStudy = 1; * enrollment.StarDate = DateTime.Now.ToString(); * return enrollment;*/ command.CommandText = "Select * from Enrollment where Semester=1 AND IdStudy=" + IdStudy; reader = command.ExecuteReader(); reader.Read(); enrollment = new EnrollmentDTO(); if (reader.HasRows) { enrollment.IdEnrollment = reader.GetInt32(reader.GetOrdinal("IdEnrollment")); enrollment.Semester = reader.GetInt32(reader.GetOrdinal("Semester")); enrollment.StarDate = reader["StartDate"].ToString(); enrollment.IdStudy = reader.GetInt32(reader.GetOrdinal("IdEnrollment")); reader.Close(); } else { enrollment.IdStudy = IdStudy; enrollment.Semester = 1; enrollment.StarDate = DateTime.Now.ToString(); command.CommandText = "insert into Enrollment (idEnrollment, Semester,IdStudy,StartDate)" + "values((Select Max(IdEnrollment) + 1 from Enrollment)," + enrollment.Semester + "," + enrollment.IdStudy + "," + enrollment.StarDate + ")"; command.ExecuteNonQuery(); command.CommandText = "Select IdEnrollment,StartDate from Enrollment where " + enrollment.Semester + " AND IdStudy=" + enrollment.IdStudy; //reader = command.ExecuteReader(); reader.Read(); enrollment.IdEnrollment = reader.GetInt32(reader.GetOrdinal("IdEnrollment")); enrollment.StarDate = reader["StartDate"].ToString(); reader.Close(); } command.CommandText = "select 1 from Student where IndexNumber=@IndexNumber"; command.Parameters.AddWithValue("IndexNumber", enrollStudentDTO.IndexNumber); reader = command.ExecuteReader(); reader.Read(); if (reader.HasRows) { reader.Close(); transaction.Rollback(); return(null); } reader.Close(); command.CommandText = "Insert into Student(IndexNumber, FirstName, LastName, BirthDate, IdEnrollment)" + "values(@IndexNumber, @FirstName,@LastName,@BirthDate," + enrollment.IdEnrollment + ")"; command.Parameters.AddWithValue("FirstName", enrollStudentDTO.FirstName); command.Parameters.AddWithValue("LastName", enrollStudentDTO.LastName); command.Parameters.AddWithValue("BirthDate", enrollStudentDTO.BirthDate); command.ExecuteNonQuery(); } catch (SqlException e) { transaction.Rollback(); return(null); } transaction.Commit(); return(enrollment); } }
public Enrollment EnrollStudent(EnrollmentDTO enrollment) { using (SqlConnection connection = new SqlConnection(CONNECTION_STRING)) using (SqlCommand command = new SqlCommand()) { DateTime parsedDate = Convert.ToDateTime(enrollment.BirthDate); command.Connection = connection; connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); command.Transaction = transaction; //GET IDSTUDY if NOT present throw 404 command.CommandText = "SELECT IdStudy FROM Studies WHERE Name = @Name"; command.Parameters.AddWithValue("Name", enrollment.Studies); SqlDataReader dataReader = command.ExecuteReader(); //1.WORKFLOW 1 - IdStudy exists if (dataReader.Read()) { int idStudies = (int)dataReader["IdStudy"]; dataReader.Close(); //Czy istenieje IdEnrollment z idStudy i Semester 1 jesli nie to stworz enrollment command.CommandText = "SELECT IdEnrollment FROM Enrollment WHERE IdStudy = @IdStudy AND Semester = 1"; command.Parameters.AddWithValue("IdStudy", idStudies); dataReader = command.ExecuteReader(); //1.WORKFLOW 1.1 - IdEnrollment with IdStudy and Semester = 1 exists if (dataReader.Read()) { var idEnrollment = dataReader["IdEnrollment"]; dataReader.Close(); try { command.CommandText = "INSERT INTO Student(IndexNumber, FirstName, LastName, BirthDate, IdEnrollment) " + "VALUES(@IndexNumber, @FirstName, @LastName, @BirthDate, @IdEnrollment )"; command.Parameters.AddWithValue("IndexNumber", enrollment.IndexNumber); command.Parameters.AddWithValue("FirstName", enrollment.FirstName); command.Parameters.AddWithValue("LastName", enrollment.LastName); command.Parameters.AddWithValue("BirthDate", parsedDate); command.Parameters.AddWithValue("IdEnrollment", (int)idEnrollment); command.ExecuteNonQuery(); transaction.Commit(); command.CommandText = "SELECT e.Semester, s.Name, e.StartDate " + "FROM Enrollment e " + "INNER JOIN Studies s ON e.IdStudy = s.IdStudy " + "WHERE IdEnrollment = @IdEnrollemnt"; command.Parameters.AddWithValue("IdEnrollemnt", idEnrollment); dataReader = command.ExecuteReader(); if (dataReader.Read()) { int semester = Convert.ToInt32(dataReader["Semester"]); Study study = Study.newStudy(dataReader["Name"].ToString()); DateTime dateTime = Convert.ToDateTime(dataReader["StartDate"]); dataReader.Close(); return(Enrollment.newEnrollment(semester, study, dateTime)); } } catch (Exception ex) { transaction.Rollback(); Console.WriteLine("Duplicated Student ID" + ex); return(null); } } //1.WORKFLOW 1.2 - IdEnrollment with IdStudy and Semester = 1 does NOT exist else { //Workaround for unique id of enrollment command.CommandText = "SELECT MAX(IdEnrollment) as idEnrollment FROM Enrollment "; dataReader.Close(); dataReader = command.ExecuteReader(); if (dataReader.Read()) { int idNewEnrollment = (int)dataReader["idEnrollment"] + 1; dataReader.Close(); try { command.CommandText = "INSERT INTO Enrollment(IdEnrollment, Semester, IdStudy, StartDate) " + "VALUES(@IdEnrollment, 1, @IdStudy, GETDATE())"; command.Parameters.Clear(); command.Parameters.AddWithValue("IdStudy", idStudies); command.Parameters.AddWithValue("IdEnrollment", idNewEnrollment); command.ExecuteNonQuery(); transaction.Commit(); // Czy to nie jest zle jesli mam 2 x commit zamiast jednego przy calej operacji } catch (Exception ex) { Console.WriteLine("Error when creating Enrollment:" + ex); transaction.Rollback(); return(null); } try { SqlTransaction transactionStudent = connection.BeginTransaction(); command.Transaction = transactionStudent; command.CommandText = "INSERT INTO Student(IndexNumber, FirstName, LastName, BirthDate, IdEnrollment) " + "VALUES(@IndexNumber, @FirstName, @LastName, @BirthDate, @IdEnrollment )"; command.Parameters.Clear(); command.Parameters.AddWithValue("IndexNumber", enrollment.IndexNumber); command.Parameters.AddWithValue("FirstName", enrollment.FirstName); command.Parameters.AddWithValue("LastName", enrollment.LastName); command.Parameters.AddWithValue("BirthDate", parsedDate); command.Parameters.AddWithValue("IdEnrollment", idNewEnrollment); command.ExecuteNonQuery(); transactionStudent.Commit(); command.CommandText = "SELECT e.Semester, s.Name, e.StartDate " + "FROM Enrollment e " + "INNER JOIN Studies s ON e.IdStudy = s.IdStudy " + "WHERE IdEnrollment = @IdEnrollemnt"; command.Parameters.AddWithValue("IdEnrollemnt", idNewEnrollment); dataReader = command.ExecuteReader(); if (dataReader.Read()) { int semester = Convert.ToInt32(dataReader["Semester"]); Study study = Study.newStudy(dataReader["Name"].ToString()); DateTime dateTime = Convert.ToDateTime(dataReader["StartDate"]); dataReader.Close(); return(Enrollment.newEnrollment(semester, study, dateTime)); } } catch (Exception ex) { Console.WriteLine("Error when creating Student:" + ex); transaction.Rollback(); return(null); } } } return(null); } //2.WORKFLOW 2 - IdStudy does not exist else { Console.WriteLine("Nie znaleziono Studies o takim name" + enrollment.Studies); return(null); } } }
public bool MakeRegister(EnrollmentDTO enrollmentDto) { //TODO перезаполнить правильно return(false); }