public ActionResult Create([Bind(Include = "CustomerId,CustomerFirstName,CustomerLastName,CustomerEmail,CustomerAddress")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "OrderId,CustomerId,OrderDate,OrderSum")] Order order) { if (ModelState.IsValid) { db.Orders.Add(order); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "CustomerFirstName", order.CustomerId); return(View(order)); }
public ActionResult Create([Bind(Include = "AID,JID,ATitle,PublishDate,Description")] Article article) { if (ModelState.IsValid) { db.Articles.Add(article); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.JID = new SelectList(db.Journalists, "JID", "JName", article.JID); return(View(article)); }
public ActionResult Register(Journalist journalist) { if (ModelState.IsValid) { db.Journalists.Add(journalist); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = journalist.JName + "Register successfully"; return(RedirectToAction("Index")); } return(View()); }
/// <summary> /// Insert New Employee /// </summary> /// <param name="Employe"></param> /// <returns></returns> public string Insert_Employee(Employee Employe) { if (Employe != null) { using (Week05Entities Obj = new Week05Entities()) { Obj.Employees.Add(Employe); Obj.SaveChanges(); return("Employee Added Successfully"); } } else { return("Employee Not Inserted! Try Again"); } }
/// <summary> /// Update Employee Information /// </summary> /// <param name="Emp"></param> /// <returns></returns> public string Update_Employee(Employee Emp) { if (Emp != null) { using (Week05Entities Obj = new Week05Entities()) { var Emp_ = Obj.Entry(Emp); Employee EmpObj = Obj.Employees.Where(x => x.Emp_Id == Emp.Emp_Id).FirstOrDefault(); EmpObj.Emp_Age = Emp.Emp_Age; EmpObj.Emp_City = Emp.Emp_City; EmpObj.Emp_Name = Emp.Emp_Name; Obj.SaveChanges(); return("Employee Updated Successfully"); } } else { return("Employee Not Updated! Try Again"); } }
/// <summary> /// Delete Employee Information /// </summary> /// <param name="Emp"></param> /// <returns></returns> public string Delete_Employee(Employee Emp) { if (Emp != null) { using (Week05Entities Obj = new Week05Entities()) { var Emp_ = Obj.Entry(Emp); if (Emp_.State == System.Data.Entity.EntityState.Detached) { Obj.Employees.Attach(Emp); Obj.Employees.Remove(Emp); } Obj.SaveChanges(); return("Employee Deleted Successfully"); } } else { return("Employee Not Deleted! Try Again"); } }