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");
}
}
