public string AddTrainee(TraineeVM vm)
{
try
{
var chkTrainee = context.Trainees.Where(f => f.FirstName == vm.FirstName && f.LastName == vm.LastName && f.Deanery == vm.Deanery).FirstOrDefault();
if (chkTrainee == null)
{
Trainee newTrainee = new Trainee
{
TraineeId = vm.TraineeId,
FirstName = vm.FirstName,
LastName = vm.LastName,
MiddleName = vm.MiddleName,
PhoneNumber = vm.PhoneNumber,
Deanery = vm.Deanery,
Parish = vm.Parish,
Pathway = vm.Pathway,
DateAdded = DateTime.Now
};
context.Trainees.Add(newTrainee);
context.SaveChanges();
return("success");
}
else
{
return("This trainee already exists");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult DeleteConfirmed(int id, TraineeVM traineeVM)
{
var query = db.Trainees.Single(t => t.TraineeID == id);
var trainee = Mapper.Map <Trainee, TraineeVM>(query);
db.Trainees.Remove(query);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(TraineeVM traineeVM)
{
if (ModelState.IsValid)
{
var trainee = Mapper.Map <Trainee>(traineeVM);
db.Entry(trainee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(traineeVM));
}
public ActionResult Create(TraineeVM traineeVM)
{
if (ModelState.IsValid)
{
var teacherslist = db.Teachers.ToList();
ViewBag.TeacherID = new SelectList(teacherslist, "TeacherID", "TeacherName");
var trainee = Mapper.Map <Trainee>(traineeVM);
db.Trainees.Add(trainee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(traineeVM));
}
public ActionResult Create(TraineeVM tr)
{
if (ModelState.IsValid == true)
{
var teacherslist = db.Teachers.ToList();
ViewBag.TeacherID = new SelectList(teacherslist, "TeacherID", "TeacherName");
var trainee = Mapper.Map <Trainee>(tr);
string fileName = Path.GetFileNameWithoutExtension(trainee.Picture.FileName);
string extention = Path.GetExtension(trainee.Picture.FileName);
HttpPostedFileBase postedFile = trainee.Picture;
int length = postedFile.ContentLength;
if (extention.ToLower() == ".jpg" || extention.ToLower() == ".jpeg" || extention.ToLower() == ".png")
{
if (length <= 1000000)
{
fileName = fileName + extention;
tr.UploadImage = "~/Images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Images/"), fileName);
tr.Picture.SaveAs(fileName);
db.Trainees.Add(trainee);
int a = db.SaveChanges();
if (a > 0)
{
TempData["CreateMessage"] = "<script>alert('Data inserted Successfully')</script>";
ModelState.Clear();
return(RedirectToAction("Index", "Trainee"));
}
else
{
TempData["CreateMessage"] = "<script>alert('Data not inserted')</script>";
}
}
else
{
TempData["SizeMessage"] = "<script>alert('Image Size Should Less Than 1 MB')</script>";
}
}
else
{
TempData["ExtentionMessage"] = "<script>alert('Format Not Supported')</script>";
}
}
return(View());
}
public TraineeVM GetTraineeByID(int TraineeId)
{
Trainee trainee = context.Trainees.Where(f => f.TraineeId == TraineeId).FirstOrDefault();
var model = new TraineeVM
{
TraineeId = trainee.TraineeId,
FirstName = trainee.FirstName,
LastName = trainee.LastName,
MiddleName = trainee.MiddleName,
PhoneNumber = trainee.PhoneNumber,
Deanery = trainee.Deanery,
Parish = trainee.Parish,
Pathway = trainee.Pathway,
DateAdded = trainee.DateAdded
};
return(model);
}
public string UpdateTrainee(TraineeVM vm)
{
Trainee trainee = context.Trainees.Where(f => f.TraineeId == vm.TraineeId).FirstOrDefault();
if (trainee != null)
{
trainee.FirstName = trainee.FirstName;
trainee.LastName = trainee.LastName;
trainee.MiddleName = trainee.MiddleName;
trainee.PhoneNumber = trainee.PhoneNumber;
trainee.Deanery = trainee.Deanery;
trainee.Parish = trainee.Parish;
trainee.Pathway = trainee.Pathway;
//DateAdded = trainee.DateAdded
}
context.SaveChanges();
return("success");
}
