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