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