public ActionResult Edit(int staffId) { if (staffId < 0) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (staffId < 0) { return HttpNotFound(); } ModelState.Clear(); DailyHours d = new DailyHours(); d.getData(staffId); return View(d); }
public ActionResult Add(DailyHours h) { if (h == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (h == null) { return HttpNotFound(); } h.InsertDailyhours(h); ModelState.Clear(); DailyHours d = new DailyHours(); d.getNames(); return View(d); }
public ActionResult Edit(DailyHours d, string command) { if (d == null || string.IsNullOrEmpty(command)) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } if (d == null || string.IsNullOrEmpty(command)) { return HttpNotFound(); } if (command.Equals("Update")) { d.UpdateDailyHours(d); } else { d.DeleteDailyHours(d); } return RedirectToAction("Details"); }
public void DeleteDailyHours(DailyHours s) { try { string constr = ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString; MySqlConnection con = new MySqlConnection(); con.ConnectionString = constr; con.Open(); MySqlCommand cmd = new MySqlCommand("deleteDailyHours", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@icurrentDate", Convert.ToDateTime(s.currentDate).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@iStaff_staffId", s.staffId); cmd.ExecuteNonQuery(); con.Close(); } catch { System.Diagnostics.Debug.WriteLine("fail !"); } }
public void DeleteDailyHours(DailyHours s) { try { string constr = ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString; MySqlConnection con = new MySqlConnection(); con.ConnectionString = constr; con.Open(); MySqlCommand cmd = new MySqlCommand("deleteDailyHours", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@icurrentDate", Convert.ToDateTime(s.currentDate).ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@iStaff_staffId", s.staffId); cmd.ExecuteNonQuery(); con.Close(); } catch { System.Diagnostics.Debug.WriteLine("fail !"); } }
public ActionResult Add() { DailyHours d = new DailyHours(); d.getNames(); return View(d); }