protected void btnUpdate_Click(object sender, EventArgs e)
{
int teacherID = Convert.ToInt32(lblTID.Text);
ctx = new TeacherInformationDataContext();
TeacherInformation teacher = new TeacherInformation();
teacher = ctx.TeacherInformations.Single(x => x.TeacherID == teacherID);
teacher.TeacherName = txtName.Text;
teacher.Email = txtEmail.Text;
teacher.Phone = txtMobile.Text;
teacher.DOB = Convert.ToDateTime(txtDOB.Text);
teacher.Course = ddlCourse.SelectedValue;
teacher.Address = txtAddress.Text;
ctx.SubmitChanges();
ShowAlert("Data Updated Successfully!!");
this.DataLoad();
ClearData();
//=============
}
public async Task <IActionResult> Edit(int id, [Bind("TeacherID,TeacherName,DOB,TeachersCellPhone,Religion,TeacherAddress,ImagePath,ClassID")] TeacherInformation teacherInformation)
{
if (id != teacherInformation.TeacherID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(teacherInformation);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeacherInformationExists(teacherInformation.TeacherID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClassID"] = new SelectList(_context.ClassInformation, "ClassID", "ClassName", teacherInformation.ClassID);
return(View(teacherInformation));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int teacerId = Convert.ToInt32(lblTID.Text);
using (ctx = new TeacherInformationDataContext())
{
TeacherInformation teacher = (from c in ctx.TeacherInformations
where c.TeacherID == teacerId
select c).FirstOrDefault();
ctx.TeacherInformations.DeleteOnSubmit(teacher);
ctx.SubmitChanges();
}
ShowAlert("Data Deleted Successfully!!");
this.DataLoad();
ClearData();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (ctx = new TeacherInformationDataContext())
{
TeacherInformation teacher = new TeacherInformation
{
TeacherName = txtName.Text,
Email = txtEmail.Text,
Phone = txtMobile.Text,
DOB = Convert.ToDateTime(txtDOB.Text),
Course = ddlCourse.SelectedValue,
Address = txtAddress.Text
};
ctx.TeacherInformations.InsertOnSubmit(teacher);
ctx.SubmitChanges();
}
ShowAlert("Data Inserted Successfully!!");
this.DataLoad();
ClearData();
}
public async Task <IActionResult> Create([Bind("TeacherID,TeacherName,DOB,TeachersCellPhone,Religion,TeacherAddress,ImagePath,ClassID")] TeacherInformation teacherInformation, IFormFile file)
{
if (ModelState.IsValid)
{
_context.Add(teacherInformation);
await _context.SaveChangesAsync();
// Code to upload image if not null
if (file != null || file.Length != 0)
{
// Create a File Info
FileInfo fi = new FileInfo(file.FileName);
// This code creates a unique file name to prevent duplications
// stored at the file location
var newFilename = teacherInformation.TeacherID + "_" + String.Format("{0:d}",
(DateTime.Now.Ticks / 10) % 100000000) + fi.Extension;
var webPath = hostingEnvironment.WebRootPath;
var path = Path.Combine("", webPath + @"\ImageFiles\" + newFilename);
// IMPORTANT: The pathToSave variable will be save on the column in the database
var pathToSave = @"/ImageFiles/" + newFilename;
// This stream the physical file to the allocate wwwroot/ImageFiles folder
using (var stream = new FileStream(path, FileMode.Create))
{
await file.CopyToAsync(stream);
}
// This save the path to the record
teacherInformation.ImagePath = pathToSave;
_context.Update(teacherInformation);
await _context.SaveChangesAsync();
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClassID"] = new SelectList(_context.ClassInformation, "ClassID", "ClassName", teacherInformation.ClassID);
return(View(teacherInformation));
}
public TeacherInformation GetTeacherInformation(Teacher teacher)
{
if (teacher == null)
{
throw new ArgumentNullException(nameof(teacher));
}
TeacherInformation teacherInformation = new TeacherInformation();
teacherInformation.FullName = teacher.FullName;
List <Course> courses = _courseRepository.GetAll();
List <Didactic> didactics = _didacticRepository.GetAll();
List <Course> filteredCourses = new List <Course>();
List <Didactic> filteredDidactics = new List <Didactic>();
foreach (var didactic in didactics)
{
if (didactic.TeacherId == teacher.Id)
{
filteredDidactics.Add(didactic);
}
}
foreach (var course in courses)
{
foreach (var didactic in filteredDidactics)
{
if (course.Id == didactic.CourseId)
{
filteredCourses.Add(course);
}
}
}
teacherInformation.Courses = filteredCourses;
return(teacherInformation);
}
