public ActionResult Create([Bind(Include = "EmployeeID,PhoneNumberID,PhoneNumber,ModifiedDate,PhoneNumberTypeID")] Employee_PhoneNumber employee_PhoneNumber)
{
if (ModelState.IsValid) //demander au prof pour cette situation ou il faut que le champ PhoneNumberID de la table Employee_PhoneNumber soir le meme que le champ PhoneNumberID de la table Employee_PhoneNumberType
{
employee_PhoneNumber.ModifiedDate = DateTime.Now;
var typesNumeros = from b in db.NumeroTypes
where b.PhoneNumberTypeID == employee_PhoneNumber.PhoneNumberTypeID
select b;
foreach (Employee_PhoneNumberType type in typesNumeros)
{
employee_PhoneNumber.PhoneNumberTypeID = type.PhoneNumberTypeID;
}
//employee_PhoneNumber.PhoneNumberID =
// employee_PhoneNumber.PhoneNumberID = query.FirstOrDefault<Employee_PhoneNumberType>();
db.EmployesNumeros.Add(employee_PhoneNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employes, "EmployeeID", "FirstName", employee_PhoneNumber.EmployeeID);
ViewBag.PhoneNumberTypeID = new SelectList(db.NumeroTypes, "PhoneNumberTypeID", "PhoneNumbertype", employee_PhoneNumber.PhoneNumberTypeID);
return(View(employee_PhoneNumber));
}
public ActionResult DeleteConfirmed(int id, int id2)
{
Employee_PhoneNumber employee_PhoneNumber = db.EmployesNumeros.Find(id2, id);
db.EmployesNumeros.Remove(employee_PhoneNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "EmployeeID,PhoneNumberID,PhoneNumber,ModifiedDate,PhoneNumberTypeID")] Employee_PhoneNumber employee_PhoneNumber)
{
if (ModelState.IsValid)
{
employee_PhoneNumber.ModifiedDate = DateTime.Now;
db.Entry(employee_PhoneNumber).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employes, "EmployeeID", "FirstName", employee_PhoneNumber.EmployeeID);
ViewBag.PhoneNumberTypeID = new SelectList(db.NumeroTypes, "PhoneNumberTypeID", "PhoneNumbertype", employee_PhoneNumber.PhoneNumberTypeID);
return(View(employee_PhoneNumber));
}
// GET: Employee_PhoneNumber/Details/5
public ActionResult Details(int?id, int?id2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employee_PhoneNumber employee_PhoneNumber = db.EmployesNumeros.Find(id2, id);
if (employee_PhoneNumber == null)
{
return(HttpNotFound());
}
return(View(employee_PhoneNumber));
}
// GET: Employee_PhoneNumber/Edit/5
public ActionResult Edit(int?id, int?id2)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employee_PhoneNumber employee_PhoneNumber = db.EmployesNumeros.Find(id2, id);
if (employee_PhoneNumber == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeID = new SelectList(db.Employes, "EmployeeID", "FirstName", employee_PhoneNumber.EmployeeID);
ViewBag.PhoneNumberTypeID = new SelectList(db.NumeroTypes, "PhoneNumberTypeID", "PhoneNumbertype", employee_PhoneNumber.PhoneNumberTypeID);
return(View(employee_PhoneNumber));
}
