public ActionResult Delete(JobPositionsViewModel model)
{
if (JobPositionDAL.Delete(model.Id))
{
return(RedirectToAction("Index"));
}
else
{
return(View(JobPositionDAL.GetById(model.Id)));
}
}
public ActionResult Edit(JobPositionsViewModel model)
{
if (JobPositionDAL.Update(model))
{
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public static JobPositionsViewModel GetById(int id)
{
JobPositionsViewModel result = new JobPositionsViewModel();
using (EmplDataContext db = new EmplDataContext())
{
result = (from j in db.MST_JobPositions
where j.Id == id
select new JobPositionsViewModel
{
Id = j.Id,
Name = j.Name
}).FirstOrDefault();
}
return(result);
}
public static bool Add(JobPositionsViewModel model)
{
bool result = false;
using (EmplDataContext db = new EmplDataContext())
{
MST_JobPositions mstJobPosition = new MST_JobPositions();
mstJobPosition.Name = model.Name;
try
{
db.MST_JobPositions.Add(mstJobPosition);
db.SaveChanges();
result = true;
}
catch
{
result = false;
}
}
return(result);
}
public static bool Update(JobPositionsViewModel model)
{
bool result = false;
using (EmplDataContext db = new EmplDataContext())
{
MST_JobPositions mstJobPosition = db.MST_JobPositions.Where(x => x.Id == model.Id).FirstOrDefault();
mstJobPosition.Name = model.Name;
mstJobPosition.ModifiedBy = 1;
mstJobPosition.ModifiedOn = DateTime.Now;
try
{
db.SaveChanges();
result = true;
}
catch
{
result = false;
}
}
return(result);
}
