public ActionResult Edit(StudentDepartmentViewModel student)
{
var studentFromDb = db.Students.FirstOrDefault(x => x.StudentID == student.StudentID);
var deptFromDB = db.Departments.Where(d => d.DepartmentID == student.DepartmentID).FirstOrDefault();
try
{
if (!ModelState.IsValid)
{
var viewModel = new StudentDepartmentViewModel
{
StudentID = student.StudentID,
StudentFirstName = student.StudentFirstName,
StudentLastName = student.StudentLastName,
StudentEmail = student.StudentEmail,
StudentAge = student.StudentAge,
StudentGender = student.StudentGender,
DepartmentID = deptFromDB.DepartmentID,
DepartmentName = deptFromDB.DepartmentName,
Location = deptFromDB.Location
};
//Student exists in the datdabase.
studentFromDb.StudentFirstName = viewModel.StudentFirstName;
studentFromDb.StudentLastName = viewModel.StudentLastName;
studentFromDb.StudentEmail = viewModel.StudentEmail;
studentFromDb.StudentAge = viewModel.StudentAge;
studentFromDb.StudentGender = viewModel.StudentGender;
studentFromDb.DepartmentID = viewModel.DepartmentID;
db.Entry(studentFromDb).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw e;
}
catch (Exception e)
{
Console.WriteLine(e);
throw e;
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create(StudentDepartmentViewModel studentDepartmentViewModel, IFormFile photoFile)
{
studentDepartmentViewModel.Student.Department = studentDepartmentViewModel.Department;
if (studentDepartmentViewModel.Student != null)
{
var students = StudentDBContext.Students.ToList();
if (photoFile != null)
{
string dirPath = Path.Combine(_hostingEnvironment.WebRootPath, @"uploads\");
var fileName = Guid.NewGuid().ToString().Replace("-", "") + "_" + photoFile.FileName;
using (var fileStream = new FileStream(dirPath + fileName, FileMode.Create))
{
await photoFile.CopyToAsync(fileStream);
}
studentDepartmentViewModel.Student.ImageUrl = fileName;
}
StudentDBContext.Students.Add(studentDepartmentViewModel.Student);
StudentDBContext.SaveChanges();
return(View("Index", students));
}
else
{
return(NotFound());
}
}
public IActionResult Create()
{
StudentDepartmentViewModel mode = new StudentDepartmentViewModel();
mode.Departments = StudentDBContext.Departments.ToList();
return(View(mode));
}
public StudentDepartmentViewModel GetStudentInfoById(StudentResult studentResult)
{
Command.CommandText = @"select s.Id as StudentId,s.Name as StudentName,s.Email as StudentEmail,s.DepartmentId as DepartmentId,s.RegistrationNo,d.Name as DepartmentName from Student s inner join Department d on s.DepartmentId=d.Id where s.Id='" + studentResult.StudentId + "'";
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
StudentDepartmentViewModel sdv = null;
if (reader.HasRows)
{
while (reader.Read())
{
sdv = new StudentDepartmentViewModel()
{
StudentId = (int)reader["StudentId"],
StudentName = reader["StudentName"].ToString(),
StudentEmail = reader["StudentEmail"].ToString(),
DepartmentId = (int)reader["DepartmentId"],
DepartmentName = reader["DepartmentName"].ToString(),
RegistrationNo = reader["RegistrationNo"].ToString()
};
}
}
reader.Close();
Connection.Close();
return(sdv);
}
//[HttpPost,ActionName("Delete")]
// public ActionResult Delete(int id)
// {
// Student student = db.Students.Find(id);
// db.Students.Remove(student);
// db.SaveChanges();
// return Json("Successfully Deleted");
// }
public ActionResult Create()
{
var department = db.Departments.ToList();
var viewModel = new StudentDepartmentViewModel
{
Department = department
};
return(View(viewModel));
}
public IActionResult Edit(int id)
{
Student student = StudentDBContext.Students.Where(stu => stu.Id == id).FirstOrDefault();
StudentDepartmentViewModel studentDepartmentViewModel = new StudentDepartmentViewModel();
studentDepartmentViewModel.Student = student;
studentDepartmentViewModel.Departments = StudentDBContext.Departments.ToList();
if (student != null)
{
return(View(studentDepartmentViewModel));
}
else
{
return(NotFound());
}
}
public ActionResult Details(int ID)
{
var std = db.Students.Where(s => s.StudentID == ID).FirstOrDefault();
var dept = db.Departments.Where(d => d.DepartmentID == std.DepartmentID).FirstOrDefault();
var viewModel = new StudentDepartmentViewModel
{
StudentID = std.StudentID,
StudentFirstName = std.StudentFirstName,
StudentLastName = std.StudentLastName,
StudentAge = std.StudentAge,
StudentEmail = std.StudentEmail,
StudentGender = std.StudentGender,
DepartmentID = std.DepartmentID.GetValueOrDefault(),
DepartmentName = (dept.DepartmentName != null) ? dept.DepartmentName : "N/A",
Location = (dept.Location != null) ? dept.Location : "N/A"
};
return(View(viewModel));
}
public ActionResult Create(Student std)
{
if (!ModelState.IsValid)
{
var viewModel = new StudentDepartmentViewModel
{
StudentID = std.StudentID,
StudentFirstName = std.StudentFirstName,
StudentLastName = std.StudentLastName,
StudentAge = std.StudentAge,
StudentEmail = std.StudentEmail,
StudentGender = std.StudentGender,
DepartmentID = std.DepartmentID.GetValueOrDefault(),
Department = db.Departments.ToList()
};
return(View("Create", viewModel));
}
db.Students.Add(std);
db.SaveChanges();
var changedDB = db.Students.ToList();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Edit(StudentDepartmentViewModel studentDepartmentViewModel, int id, IFormFile photoFile)
{
var currentUser = StudentDBContext.Students.Where(x => x.Id == id).FirstOrDefault();
currentUser.Department = studentDepartmentViewModel.Department;
currentUser.Name = studentDepartmentViewModel.Student.Name;
currentUser.StuID = studentDepartmentViewModel.Student.StuID;
currentUser.Description = studentDepartmentViewModel.Student.Description;
if (studentDepartmentViewModel.Student != null)
{
var students = StudentDBContext.Students.ToList();
if (photoFile != null)
{
string dirPath = Path.Combine(_hostingEnvironment.WebRootPath, @"uploads\");
var fileName = Guid.NewGuid().ToString().Replace("-", "") + "_" + photoFile.FileName;
using (var fileStream = new FileStream(dirPath + fileName, FileMode.Create))
{
await photoFile.CopyToAsync(fileStream);
}
currentUser.ImageUrl = fileName;
}
StudentDBContext.Update(currentUser);
StudentDBContext.SaveChanges();
return(View("Index", students));
}
else
{
return(NotFound());
}
}
public ActionResult MakePDF(StudentResult studentResult)
{
StudentDepartmentViewModel st = _studentManager.GetStudentInfoById(studentResult);
string regNo = st.RegistrationNo;
string name = st.StudentName;
string email = st.StudentEmail;
string department = st.DepartmentName;
using (MemoryStream ms = new MemoryStream())
{
List <StudentResultViewModel> studentResultViewModels = _studentManager.GetStudentResult(studentResult);
PdfPTable table = new PdfPTable(3);
table.WidthPercentage = 100.0f;
table.AddCell("Course Code");
table.AddCell("Name");
table.AddCell("Grade");
foreach (var viewResult in studentResultViewModels)
{
table.AddCell(viewResult.CourseCode);
table.AddCell(viewResult.CourseName);
table.AddCell(viewResult.GradeName);
}
Document doc = new Document(PageSize.A4, 30f, 30f, 10f, 10f);
iTextSharp.text.Font NormalFont = FontFactory.GetFont("Arial", 20, BaseColor.BLUE);
iTextSharp.text.Font HeaderFont = FontFactory.GetFont("tahoma", 23, BaseColor.ORANGE);
iTextSharp.text.Font InfoFont = FontFactory.GetFont("myriadPro", 14, BaseColor.GRAY);
iTextSharp.text.Font tableHeader = FontFactory.GetFont("arial", 16, BaseColor.BLACK);
PdfWriter writer = PdfWriter.GetInstance(doc, ms);
doc.Open();
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph("University Course and Result Management System", HeaderFont));
doc.Add(new Paragraph(" Student Result", HeaderFont));
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph("Student Information", NormalFont));
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph("Name : " + name, InfoFont));
doc.Add(new Paragraph("Registration No : " + regNo, InfoFont));
doc.Add(new Paragraph("Department : " + department, InfoFont));
doc.Add(new Paragraph("Email : " + email, InfoFont));
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph("Result of all Courses", tableHeader));
doc.Add(new Paragraph(" "));
doc.Add(table);
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph(" "));
doc.Add(new Paragraph(" Prepared By DotNet Learners Team"));
doc.Close();
byte[] bytes = ms.ToArray();
ms.Close();
//Response.Clear();
//Response.ContentType = "application/pdf";
//Response.AddHeader("Content-Disposition", "attachment; filename=Employee.pdf");
//Response.ContentType = "application/pdf";
//Response.Buffer = true;
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
//Response.BinaryWrite(bytes);
//Response.End();
//Response.Close();
return(File(bytes, "application/pdf", "'" + name + "'.pdf"));
}
}
public JsonResult GetStudentById(Student student)
{
StudentDepartmentViewModel st = _studentManager.GetStudentById(student);
return(Json(st, JsonRequestBehavior.AllowGet));
}
