public ActionResult GetData()
{
using (DBModel1 db = new DBModel1())
{
List <Trip> tripList = db.Trips.ToList <Trip>();
return(Json(new { data = tripList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (DBModel1 db = new DBModel1())
{
Employee emp = db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>();
db.Employees.Remove(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (DBModel1 db = new DBModel1())
{
Trip trp = db.Trips.Where(x => x.Id == id).FirstOrDefault <Trip>();
db.Trips.Remove(trp);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
return(View(new Employee()));
}
else
{
using (DBModel1 db = new DBModel1())
{
return(View(db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>()));
}
}
}
public ActionResult AddorEdit(int id = 0)
{
if (id == 0)
{
return(View(new Trip()));
}
else
{
using (DBModel1 db = new DBModel1())
{
return(View(db.Trips.Where(x => x.Id == id).FirstOrDefault <Trip>()));
}
}
}
public ActionResult AddOrEdit(Employee emp)
{
using (DBModel1 db = new DBModel1())
{
if (emp.EmployeeID == 0)
{
db.Employees.Add(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddorEdit(Trip trp)
{
using (DBModel1 db = new DBModel1())
{
if (trp.Id == 0)
{
db.Trips.Add(trp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(trp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
