public ActionResult ExportCoursesDeadline(string check) { string searchCheck = check.Split('^')[0]; string Course_Name = check.Split('^')[1]; string Semester_ID = check.Split('^')[2]; Course_Name = Course_Name == "2" ? "" : Course_Name; Semester_ID = Semester_ID == "3" ? "" : Semester_ID; List <Cour_dealine> list = new List <Cour_dealine>(); if (searchCheck != "1") { list = unitOfWork.DeadLine.GetPageList(Course_Name, Semester_ID); } var myExport = new CSVExport(); foreach (var course in list) { myExport.AddRow(); myExport[""] = course.groupRowNo; myExport["Subject ID"] = course.Subject_ID; myExport["Course Name"] = course.Courses_Name; myExport["Deadline"] = course.deadlineString; myExport["Semester"] = course.Semester_Name; } return(File(myExport.ExportToBytes(), "text/csv", "Courses-Deadline.csv")); }
public ActionResult ExportCoursera(string check) { string searchCheck = check.Split('^')[0]; string Email = check.Split('^')[1]; string Semester_ID = check.Split('^')[2]; string Campus_ID = check.Split('^')[3]; var students = unitOfWork.Students.GetAll(); if (searchCheck != "1") { if (Email != "2") { students = students.Where(s => s.Email.Trim().ToUpper().Contains(Email.Trim().ToUpper())).ToList(); } if (Semester_ID != "3") { students = students.Where(s => s.Semester_ID.Trim() == Semester_ID.Trim()).ToList(); } if (Campus_ID != "4") { students = students.Where(s => s.Campus_ID.Trim() == Campus_ID.Trim()).ToList(); } } var myExport = new CSVExport(); foreach (var student in students) { myExport.AddRow(); myExport["Full Name"] = student.Full_Name; myExport["Email"] = student.Email; var subject = unitOfWork.SubjectStudent.getListSubject(student.Roll + "^" + student.Semester_ID).ToString(); myExport["External ID"] = subject + "@" + student.Campus_ID + "-" + student.Roll; } return(File(myExport.ExportToBytes(), "text/csv", "Coursera-Invitation.csv")); }
public ActionResult Export(string check) { string searchCheck = check.Split('^')[0]; string Email = check.Split('^')[1]; string Semester_ID = check.Split('^')[2]; string Campus_ID = check.Split('^')[3]; var students = unitOfWork.Students.GetAll(); if (searchCheck != "1") { if (Email != "2") { students = students.Where(s => s.Email.Trim().ToUpper().Contains(Email.Trim().ToUpper())).ToList(); } if (Semester_ID != "3") { students = students.Where(s => s.Semester_ID.Trim() == Semester_ID.Trim()).ToList(); } if (Campus_ID != "4") { students = students.Where(s => s.Campus_ID.Trim() == Campus_ID.Trim()).ToList(); } } var myExport = new CSVExport(); foreach (var student in students) { myExport.AddRow(); myExport["Roll Number"] = student.Roll; myExport["Full Name"] = student.Full_Name; myExport["Email"] = student.Email; } return(File(myExport.ExportToBytes(), "text/csv", "Student.csv")); }
public ActionResult Export() { var myExport = new CSVExport(); myExport.AddRow(); myExport["Roll Number"] = "SE0001"; myExport["Full Name"] = "Full name"; myExport["Email"] = "*****@*****.**"; myExport["Subject"] = "PMG201c"; myExport.AddRow(); myExport["Roll Number"] = "SE0002"; myExport["Full Name"] = "Full name"; myExport["Email"] = "*****@*****.**"; myExport["Subject"] = "PMG201c"; myExport.AddRow(); myExport["Roll Number"] = "SE0003"; myExport["Full Name"] = "Full name"; myExport["Email"] = "*****@*****.**"; myExport["Subject"] = "PMG201c"; return(File(myExport.ExportToBytes(), "text/csv", "StudentTemplate.csv")); }