public static bool Delete(int id)
{
bool result = false;
using (EmplDataContext db = new EmplDataContext())
{
MST_JobPositions mstJobPosition = db.MST_JobPositions.Where(x => x.Id == id).FirstOrDefault();
try
{
db.MST_JobPositions.Remove(mstJobPosition);
db.SaveChanges();
result = true;
}
catch
{
result = false;
}
}
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);
}
