public ActionResult Edit(Staff r, string command) { if (r == null || string.IsNullOrEmpty(command)) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (r == null || string.IsNullOrEmpty(command)) { return HttpNotFound(); } Debug.WriteLine("in edit"); if (command.Equals("Update")) { Debug.WriteLine("c " + command); if (ModelState.IsValid) { r.updateEmployee(r); } else { Debug.WriteLine("username " + r.username); return View(r); } } else { Debug.WriteLine("c " + command); r.deleteEmployee(r.username); } return RedirectToAction("Details"); }
public ActionResult Register(Staff r) { if (ModelState.IsValid) { r.insertEmployee(r); } else { return View(r); } return RedirectToAction("Details"); }
// GET: /Employee/Edit public ActionResult Edit(string username) { Debug.WriteLine("in controller " + username); if (username == null) { Debug.WriteLine("null"); return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (username == null) { Debug.WriteLine("not found"); return HttpNotFound(); } Staff s = new Staff(username); return View(s); }
public ActionResult Register(Staff r) { if (r == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (r == null) { return HttpNotFound(); } if (ModelState.IsValid) { r.insertEmployee(r); } else { return View(r); } return RedirectToAction("Details"); }
public ActionResult Edit(Staff r, string command) { Debug.WriteLine("in edit"); if (command.Equals("Update")) { Debug.WriteLine("c " + command); if (ModelState.IsValid) { r.updateEmployee(r); } else { Debug.WriteLine("username " + r.username); return View(r); } } else { Debug.WriteLine("c " + command); r.deleteEmployee(r.username); } return RedirectToAction("Details"); }
public void updateEmployee(Staff s) { using (MySqlConnection con = new MySqlConnection(con_str)) { con.Open(); using (MySqlCommand cmd = new MySqlCommand("updateEmployee", con)) { Debug.WriteLine("updating " + s.username); cmd.CommandType = CommandType.StoredProcedure; //params for updating username table cmd.Parameters.AddWithValue("@_username", s.username); cmd.Parameters.AddWithValue("@password", Encryption.Encrypt(s.password)); cmd.Parameters.AddWithValue("@accountType", s.acctype.ToString()); //params for updating address table cmd.Parameters.AddWithValue("@firstLine", s.firstLine); if (s.secondLine != null) { cmd.Parameters.AddWithValue("@secondLine", s.secondLine); } else { cmd.Parameters.AddWithValue("@secondLine", null); } cmd.Parameters.AddWithValue("@town", s.town); cmd.Parameters.AddWithValue("@postcode", s.postcode); cmd.Parameters.AddWithValue("@region", s.region); cmd.Parameters.AddWithValue("@country", s.country); //params for updating bankDetails table cmd.Parameters.AddWithValue("@sortCode", s.sortCode); cmd.Parameters.AddWithValue("@accountNumber", s.accountNumber); //params for updating contact table cmd.Parameters.AddWithValue("@title", s.title.ToString()); cmd.Parameters.AddWithValue("@forename", s.forename); cmd.Parameters.AddWithValue("@surname", s.surname); cmd.Parameters.AddWithValue("@firstNumber", s.firstNumber); if (s.secondaryNumber != null) { cmd.Parameters.AddWithValue("@secondaryNumber", s.secondaryNumber); } else { cmd.Parameters.AddWithValue("@secondaryNumber", null); } cmd.Parameters.AddWithValue("@email", s.email); if (s.fax != null) { cmd.Parameters.AddWithValue("@fax", s.fax); } else { cmd.Parameters.AddWithValue("@fax", null); } //params for updating staff table cmd.Parameters.AddWithValue("@role", s.role); cmd.Parameters.AddWithValue("@hourlyRate", s.hourlyRate); cmd.Parameters.AddWithValue("@startDate", s.startDate.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@ni", s.ni); cmd.Parameters.AddWithValue("@department", s.department); cmd.ExecuteNonQuery(); con.Close(); } } }