public IHttpActionResult DeleteDM_KHO(string id) { DM_KHO dM_KHO = db.DM_KHO.Find(id); if (dM_KHO == null) { return(NotFound()); } db.DM_KHO.Remove(dM_KHO); db.SaveChanges(); return(Ok(dM_KHO)); }
// GET: TruongAnHCM/KhoTAHCM/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DM_KHO dM_KHO = db.DM_KHO.Find(id); if (dM_KHO == null) { return(HttpNotFound()); } ViewBag.TRUC_THUOC = new SelectList(db.CCTC_CONG_TY, "MA_CONG_TY", "TEN_CONG_TY", dM_KHO.TRUC_THUOC); ViewBag.MA_KHO_CHA = new SelectList(db.DM_KHO, "MA_KHO", "TEN_KHO", dM_KHO.MA_KHO_CHA); return(View(dM_KHO)); }
public bool Update(DM_KHO kho) { try { SqlConnection con = new SqlConnection(db.connectionStr); SqlCommand cmd = new SqlCommand("updateKho", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@kho_id", SqlDbType.NVarChar, 10); cmd.Parameters.Add("@kho_ten", SqlDbType.NVarChar, 20); cmd.Parameters["@kho_id"].Value = kho.Makho; cmd.Parameters["@kho_ten"].Value = kho.Tenkho; con.Open(); int result = cmd.ExecuteNonQuery(); con.Close(); return(result > 0); } catch { } return(true); }