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