public ActionResult Edit(JobTableViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (CrudJobDbEntities db = new CrudJobDbEntities())
{
var oJobsTable = db.JobTables.Find(model.Job);;
oJobsTable.Job = model.Job;
oJobsTable.JobTile = model.JobTile;
oJobsTable.JobDescription = model.JobDescription;
oJobsTable.FromDate = model.FromDate;
oJobsTable.ToDate = model.ToDate;
db.Entry(oJobsTable).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Jobs/Index"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Create(JobTableViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (CrudJobDbEntities db = new CrudJobDbEntities())
{
var oJobsTable = new JobTable();
oJobsTable.Job = model.Job;
oJobsTable.JobTile = model.JobTile;
oJobsTable.JobDescription = model.JobDescription;
oJobsTable.FromDate = model.FromDate;
oJobsTable.ToDate = model.ToDate;
db.JobTables.Add(oJobsTable);
db.SaveChanges();
}
return(Redirect("~/Jobs/Index"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Delete(string Id)
{
using (CrudJobDbEntities db = new CrudJobDbEntities())
{
var oJobsTable = db.JobTables.Find(Id);
db.JobTables.Remove(oJobsTable);
db.SaveChanges();
}
return(Redirect("~/Jobs/Index"));
}
// GET: Jobs/Edit/5
public ActionResult Edit(string Id)
{
JobTableViewModel model = new JobTableViewModel();
using (CrudJobDbEntities db = new CrudJobDbEntities())
{
var oJobsTable = db.JobTables.Find(Id);
model.Job = oJobsTable.Job;
model.JobTile = oJobsTable.JobTile;
model.JobDescription = oJobsTable.JobDescription;
model.FromDate = oJobsTable.FromDate;
model.ToDate = oJobsTable.ToDate;
}
return(View(model));
}
// GET: Jobs
public ActionResult Index()
{
List <ListJobTableViewModel> lst;
using (CrudJobDbEntities db = new CrudJobDbEntities())
{
lst = (from d in db.JobTables
select new ListJobTableViewModel
{
Job = d.Job,
JobTile = d.JobTile,
JobDescription = d.JobDescription,
FromDate = d.FromDate,
ToDate = d.ToDate
}).ToList();
}
return(View(lst));
}
