public ActionResult History() { var schooldata = context.ApplyColleges.Select(a => a).ToList(); ViewData["History"] = schooldata; List <ApplyCollege> history = new List <ApplyCollege>(); Student_Profile student = Session["StudentProfile"] as Student_Profile; var x = schooldata.Count(); for (int i = 0; i < x; i++) { if (schooldata.ElementAtOrDefault(i).StudentId == student.StudentId) { ApplyCollege his = new ApplyCollege(); his.ApplyCollegeId = schooldata.ElementAtOrDefault(i).ApplyCollegeId; his.StudentId = schooldata.ElementAtOrDefault(i).StudentId; his.SchoolName = schooldata.ElementAtOrDefault(i).SchoolName; his.CollegeEmail = schooldata.ElementAtOrDefault(i).CollegeEmail; his.CourseApplied = schooldata.ElementAtOrDefault(i).CourseApplied; his.Semester = schooldata.ElementAtOrDefault(i).Semester; his.DateApplied = schooldata.ElementAtOrDefault(i).DateApplied; history.Add(his); } } return(View(history)); }
public ActionResult ApplyCollege() { var schooldata = context.SchoolDatas.Select(a => a).ToList(); ViewData["SchoolName"] = schooldata; ApplyCollege data = new ApplyCollege(); Student_Profile student = Session["StudentProfile"] as Student_Profile; data.StudentId = student.StudentId; return(View(data)); }
public ActionResult ApplyCollege(ApplyCollege AppliedCollege, FormCollection form1) { AppliedCollege.DateApplied = DateTime.Now; context.Entry(AppliedCollege).State = System.Data.EntityState.Added; context.SaveChanges(); var Filepath = Server.MapPath("pdf") + "\\" + "First PDF document.pdf"; var Filepath2 = Server.MapPath("pdf") + "\\"; //Process for creating pdf Student_Profile student = Session["StudentProfile"] as Student_Profile; string[] filescollection = Directory.GetFiles(Filepath2, "First PDF document.pdf", SearchOption.AllDirectories); foreach (var item1 in filescollection) { System.IO.File.Delete(item1); } System.IO.FileStream fs = new FileStream(Filepath, FileMode.Create); var doc1 = new Document(); PdfWriter writer = PdfWriter.GetInstance(doc1, fs); doc1.Open(); doc1.Add(new Paragraph("STUDENT APPLICATION FORM ")); PdfPTable table = new PdfPTable(2); PdfPCell cell = new PdfPCell(new Phrase("Student Data")); cell.Colspan = 2; cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right table.AddCell(cell); table.AddCell("First Name"); table.AddCell(student.FirstName); table.AddCell(" Middle Name"); table.AddCell(student.MiddleName); table.AddCell("Last Name"); table.AddCell(student.LastName); table.AddCell("Phone Number"); table.AddCell(student.PhoneNumber); table.AddCell("DateofBirth "); table.AddCell(student.DateOfBirth.Value.ToShortDateString()); table.AddCell("Gender "); table.AddCell(student.Gender); table.AddCell("SSN"); table.AddCell(student.SSN); table.AddCell("Email"); table.AddCell(student.Email); table.AddCell("Country of Birth"); table.AddCell(student.CountryofBirth); PdfPCell cell1 = new PdfPCell(new Phrase("Address Informtion")); cell1.Colspan = 2; cell1.HorizontalAlignment = 1; table.AddCell(cell1); table.AddCell("Street Address"); table.AddCell(student.AddressStudents.ElementAtOrDefault(0).AptStreet); table.AddCell("City"); table.AddCell(student.AddressStudents.ElementAtOrDefault(0).City); table.AddCell("State"); table.AddCell(student.AddressStudents.ElementAtOrDefault(0).State); table.AddCell("ZipCode"); table.AddCell(student.AddressStudents.ElementAtOrDefault(0).ZipCode); table.AddCell("Country"); table.AddCell(student.AddressStudents.ElementAtOrDefault(0).Country); table.AddCell("Address Type"); var x = student.AddressStudents.ElementAtOrDefault(0).Type; if (x == "1") { table.AddCell("Permanent"); } else { table.AddCell("Temporary"); } PdfPCell cell2 = new PdfPCell(new Phrase("Citizenship Informtion")); cell2.Colspan = 2; cell2.HorizontalAlignment = 1; table.AddCell(cell2); table.AddCell("Country of Citizenship"); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).CountryOfCitizenship); table.AddCell("Ethnicity"); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).Ethnicity); table.AddCell("I20 required "); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).I20Required); table.AddCell("Visa Status "); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).VisaStatus); table.AddCell("Current Location "); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).CurrentLocation); table.AddCell("Vetran Status "); table.AddCell(student.CitizenShipInfoes.ElementAtOrDefault(0).VeteranStatus); PdfPCell cell3 = new PdfPCell(new Phrase("Information regarding course enrollement")); cell3.Colspan = 2; cell3.HorizontalAlignment = 1; table.AddCell(cell3); table.AddCell("Admission Type"); table.AddCell(student.AcademicInfoes.ElementAtOrDefault(0).AdmissionType); table.AddCell("Semester"); table.AddCell(student.AcademicInfoes.ElementAtOrDefault(0).Semester); table.AddCell("Application Year"); table.AddCell(student.AcademicInfoes.ElementAtOrDefault(0).ApplicationYear); table.AddCell("Major"); table.AddCell(student.AcademicInfoes.ElementAtOrDefault(0).Major); PdfPTable table4 = new PdfPTable(3); PdfPCell cell4 = new PdfPCell(new Phrase("Previous School information")); cell4.Colspan = 2; cell4.HorizontalAlignment = 1; table.AddCell(cell4); table.AddCell("Previous School Name"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).SchoolName); table.AddCell("Previous School Start Date"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).DateFrom.Value.ToShortDateString()); table.AddCell("Previous School End Date"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).DateTo.Value.ToShortDateString()); table.AddCell("Degree"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).DegreeName); table.AddCell("Major"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).Major); table.AddCell("School Address"); table.AddCell(student.PreviousSchoolInfoes.ElementAtOrDefault(0).Address); PdfPCell cell5 = new PdfPCell(new Phrase("Exam Information")); cell5.Colspan = 2; cell5.HorizontalAlignment = 1; table.AddCell(cell5); table.AddCell("GRE TAKEN ?"); var y = student.ExamInfoes.ElementAtOrDefault(0).ExamType; if (y == null) { table.AddCell("NO"); } else { table.AddCell("YES"); table.AddCell("GRE SCORE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(0).Score); table.AddCell("GRE DATE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(0).DateOfExam.Value.ToShortDateString()); } table.AddCell("TOEFL TAKEN ?"); var z = student.ExamInfoes.ElementAtOrDefault(1).ExamType; if (z == null) { table.AddCell("NO"); } else { table.AddCell("YES"); table.AddCell("TOEFL SCORE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(1).Score); table.AddCell("TOEFL DATE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(1).DateOfExam.Value.ToShortDateString()); } table.AddCell("IELTS TAKEN ?"); var p = student.ExamInfoes.ElementAtOrDefault(2).ExamType; if (p == null) { table.AddCell("NO"); } else { table.AddCell("YES"); table.AddCell("IELTS SCORE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(2).Score); table.AddCell("IELTS DATE"); table.AddCell(student.ExamInfoes.ElementAtOrDefault(2).DateOfExam.Value.ToShortDateString()); } PdfPCell cell6 = new PdfPCell(new Phrase("Work Experience")); cell6.Colspan = 2; cell6.HorizontalAlignment = 1; table.AddCell(cell6); table.AddCell("Work Experience"); var r = student.WorkInfoes.ElementAtOrDefault(0).CompanyName; if (r == null) { table.AddCell("NO"); } else { table.AddCell("YES"); table.AddCell("Company name"); table.AddCell(student.WorkInfoes.ElementAtOrDefault(0).CompanyName); table.AddCell("Start date"); table.AddCell(student.WorkInfoes.ElementAtOrDefault(0).FromDate.Value.ToShortDateString()); table.AddCell("End date"); table.AddCell(student.WorkInfoes.ElementAtOrDefault(0).ToDate.Value.ToShortDateString()); table.AddCell("Description"); table.AddCell(student.WorkInfoes.ElementAtOrDefault(0).Description); table.AddCell("Achievement"); table.AddCell(student.WorkInfoes.ElementAtOrDefault(0).Achievement); } doc1.Add(table); doc1.Close(); EmailHelper cs = new EmailHelper(); string result = cs.SendContactUsEmail(student.StudentId, 0, Filepath); //String Schoolemail = form1["CollegeEmail"].ToString(); //String Senderemail = "*****@*****.**"; return(RedirectToAction("StudentHomePage", new { str = "Your application has been submitted to" + AppliedCollege.SchoolName + " sucessfully!! " })); }