public IHttpActionResult PostStudentDetails(StudentManagementModel StudentDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } StudentManagementModel StudentManagmentModel = new StudentManagementModel(); if (StudentDetails.StudentID == null) { var dateAndTime = DateTime.Now; if (StudentDetails.CreatedDate == null) { StudentDetails.CreatedDate = dateAndTime.Date; } StudentDetails.LastUpdatedDate = dateAndTime.Date; } else { var dateAndTime = DateTime.Now; StudentDetails.LastUpdatedDate = dateAndTime.Date; } var studentId = db.UpsertStudentCoursevOne(StudentDetails.StudentID, StudentDetails.Name, StudentDetails.Age, StudentDetails.Sex, StudentDetails.ParentName, StudentDetails.MobileNumber, StudentDetails.Addres, StudentDetails.RegistrationFees, StudentDetails.TuitionFees, StudentDetails.ImageLocation, StudentDetails.CreatedDate, StudentDetails.LastUpdatedDate, StudentDetails.DeletedDate, StudentDetails.AdmissionNumber, StudentDetails.Courses, this.ConstructCourseXML(StudentDetails.StudentCourse)).ToList(); StudentDetails.StudentID = studentId.Select(i => i.Value).First(); return(CreatedAtRoute("UpsertStudentDetails", new { id = StudentManagmentModel.StudentID }, StudentDetails)); }
public HttpResponseMessage GetAllStudents(string name = "") { var students = db.GetStudentsvOne().ToList(); List <StudentManagementModel> StudentManagmentModelList = new List <StudentManagementModel>(); if (students.Any()) { foreach (var student in students) { StudentManagementModel studentManagementModel = new StudentManagementModel(); studentManagementModel.Addres = student.Addres; studentManagementModel.Age = student.Age; studentManagementModel.MobileNumber = student.MobileNumber; studentManagementModel.Name = student.Name; studentManagementModel.ParentName = student.ParentName; studentManagementModel.RegistrationFees = student.RegistrationFees; studentManagementModel.Sex = student.Sex; studentManagementModel.StudentID = student.StudentID; studentManagementModel.AdmissionNumber = student.AdmissionNumber; studentManagementModel.CreatedDate = student.CreatedDate; studentManagementModel.Courses = student.Courses; studentManagementModel.TuitionFees = student.TuitionFees; studentManagementModel.ImageLocation = student.ImageLocation; StudentManagmentModelList.Add(studentManagementModel); } if (!string.IsNullOrEmpty(name)) { var result = StudentManagmentModelList.Where(x => x.Name.StartsWith(name, StringComparison.InvariantCultureIgnoreCase)).Select(x => x).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateResponse(HttpStatusCode.OK, StudentManagmentModelList)); } } else { return(Request.CreateResponse(HttpStatusCode.NoContent)); } }
public HttpResponseMessage GetStudentDetails(int id) { StudentManagementModel StudentManagmentModel = new StudentManagementModel(); var studentDetails = db.GetStudentCoursevOne(id).ToList(); if (studentDetails.Count != 0) { var deletedDate = studentDetails.Select(x => x.DeletedDate).First(); if (deletedDate == null) { StudentManagmentModel.StudentID = studentDetails.Select(x => x.StudentID).First(); StudentManagmentModel.Name = studentDetails.Select(x => x.Name).First(); StudentManagmentModel.Age = studentDetails.Select(x => x.Age).First(); StudentManagmentModel.Sex = studentDetails.Select(x => x.Sex).First(); StudentManagmentModel.ParentName = studentDetails.Select(x => x.ParentName).First(); StudentManagmentModel.MobileNumber = studentDetails.Select(x => x.MobileNumber).First(); StudentManagmentModel.Addres = studentDetails.Select(x => x.Addres).First(); StudentManagmentModel.RegistrationFees = studentDetails.Select(x => x.RegistrationFees).First(); StudentManagmentModel.TuitionFees = studentDetails.Select(x => x.TuitionFees).First(); StudentManagmentModel.ImageLocation = studentDetails.Select(x => x.ImageLocation).First(); StudentManagmentModel.ImageLocation = studentDetails.Select(x => x.ImageLocation).First(); StudentManagmentModel.CreatedDate = studentDetails.Select(x => x.CreatedDate).First(); StudentManagmentModel.LastUpdatedDate = studentDetails.Select(x => x.LastUpdatedDate).First(); StudentManagmentModel.DeletedDate = studentDetails.Select(x => x.DeletedDate).First(); StudentManagmentModel.AdmissionNumber = studentDetails.Select(x => x.AdmissionNumber).First(); StudentManagmentModel.Courses = studentDetails.Select(x => x.Courses).First(); List <string> studentCourses = new List <string>(); foreach (var studItem in studentDetails) { studentCourses.Add(studItem.CourseName); } StudentManagmentModel.StudentCourse = studentCourses; return(Request.CreateResponse(HttpStatusCode.OK, StudentManagmentModel)); } } return(Request.CreateResponse(HttpStatusCode.NoContent, StudentManagmentModel)); }