/// <summary> /// Evaluates all students details and return them. /// </summary> /// <param name="details">contains student details</param> /// <returns>returns student information<</returns> public StudentsDetails GetStudentInfoInReverse(StudentsDetails details) { details.FullName = reverseString(details.FullName); details.EmailAddress = reverseString(details.EmailAddress); details.PhoneNumber = reverseString(details.PhoneNumber); details.Notes = reverseString(details.Notes); return(details); }
/// <summary> /// this action will validate parameters and /// if they are not valid then will send 400 Bad Request. /// Also, if we are receving empty string in any parameter then /// we do not send that parameter in response. /// </summary> /// <param name="details">contains student details</param> /// <returns>returns student information</returns> public IActionResult GetStudentDetailInReverse([FromForm] StudentsDetails details) { StudentsDetails students = new StudentsDetails(); StudentService.StudentService stdService = new StudentService.StudentService(); students = stdService.GetStudentInfoInReverse(details); return(Ok(students)); }
public List <StudentsDetails> ReadUploadedExcelTest(HttpPostedFile file) { var usersList = new List <StudentsDetails>(); using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; //json = new JavaScriptSerializer().Serialize(workSheet); for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { var user = new StudentsDetails(); // user.ClientId =Convert.ToInt32( workSheet.Cells[rowIterator, 1].Value.ToString()); user.Clients.ClientID = workSheet.Cells[rowIterator, 1].Value != null?Convert.ToInt32(workSheet.Cells[rowIterator, 1].Value.ToString()) : 0; //students persoal details user.StudPersonalDetails.Name = workSheet.Cells[rowIterator, 2].Value != null ? workSheet.Cells[rowIterator, 2].Value.ToString() : ""; user.StudPersonalDetails.MiddleName = workSheet.Cells[rowIterator, 3].Value != null ? workSheet.Cells[rowIterator, 3].Value.ToString() : ""; user.StudPersonalDetails.LastName = workSheet.Cells[rowIterator, 4].Value != null ? workSheet.Cells[rowIterator, 4].Value.ToString() : ""; user.StudPersonalDetails.FatherName = workSheet.Cells[rowIterator, 5].Value != null ? workSheet.Cells[rowIterator, 5].Value.ToString() : ""; user.StudPersonalDetails.MotherName = workSheet.Cells[rowIterator, 6].Value != null ? workSheet.Cells[rowIterator, 6].Value.ToString() : ""; user.StudPersonalDetails.DOB = workSheet.Cells[rowIterator, 7].Value != null ? workSheet.Cells[rowIterator, 7].Value.ToString() : "0000-00-00"; //students Contacts user.StudentContacts.Phone = workSheet.Cells[rowIterator, 8].Value != null ? workSheet.Cells[rowIterator, 8].Value.ToString() : "";; user.StudentContacts.AlternatePhone = workSheet.Cells[rowIterator, 9].Value != null ? workSheet.Cells[rowIterator, 9].Value.ToString() : "";; user.StudentContacts.Email = workSheet.Cells[rowIterator, 10].Value != null ? workSheet.Cells[rowIterator, 10].Value.ToString() : "";; //Students Address user.StudentAddress.Address1 = workSheet.Cells[rowIterator, 11].Value != null ? workSheet.Cells[rowIterator, 11].Value.ToString() : "";; user.StudentAddress.Address2 = workSheet.Cells[rowIterator, 12].Value != null ? workSheet.Cells[rowIterator, 12].Value.ToString() : "";; user.StudentAddress.City = workSheet.Cells[rowIterator, 13].Value != null ? workSheet.Cells[rowIterator, 13].Value.ToString() : "";; user.StudentAddress.State = workSheet.Cells[rowIterator, 14].Value != null ? workSheet.Cells[rowIterator, 14].Value.ToString() : "";; user.StudentAddress.PIN = workSheet.Cells[rowIterator, 15].Value != null?Convert.ToInt32(workSheet.Cells[rowIterator, 15].Value.ToString()) : 000000;; // course Details user.CourseDetails.CourseID = workSheet.Cells[rowIterator, 16].Value != null?Convert.ToInt32(workSheet.Cells[rowIterator, 16].Value.ToString()) : 00;; user.CourseDetails.CourseName = workSheet.Cells[rowIterator, 17].Value != null ? workSheet.Cells[rowIterator, 17].Value.ToString() : "";; usersList.Add(user); } } return(usersList); }