public ActionResult DeleteConfirmed(int id)
{
CT_TOATHUOC cT_TOATHUOC = db.CT_TOATHUOC.Find(id);
db.CT_TOATHUOC.Remove(cT_TOATHUOC);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MATOATHUOC,MATHUOC,SOLUONG,LIEUDUNG")] CT_TOATHUOC cT_TOATHUOC)
{
if (ModelState.IsValid)
{
db.Entry(cT_TOATHUOC).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MATHUOC = new SelectList(db.THUOCs, "MATHUOC", "TENTHUOC", cT_TOATHUOC.MATHUOC);
ViewBag.MATOATHUOC = new SelectList(db.TOATHUOCs, "MATOATHUOC", "MATOATHUOC", cT_TOATHUOC.MATOATHUOC);
return(View(cT_TOATHUOC));
}
// GET: CT_TOATHUOC/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CT_TOATHUOC cT_TOATHUOC = db.CT_TOATHUOC.Find(id);
if (cT_TOATHUOC == null)
{
return(HttpNotFound());
}
return(View(cT_TOATHUOC));
}
public bool InsertCTTT(CT_TOATHUOC t)
{
try
{
SqlConnection conn = new SqlConnection(connecDB.connectionStr);
SqlCommand cmd = new SqlCommand("themCT_TOATHUOC", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@mathuoc", SqlDbType.NVarChar, 20);
//cmd.Parameters["@mathuoc"].Value = mt;
cmd.Parameters.Add("@TT_ID", SqlDbType.Int);
cmd.Parameters.Add("@VT_ID", SqlDbType.NVarChar, 20);
cmd.Parameters.Add("@CTT_SONGAYUONG", SqlDbType.Int);
cmd.Parameters.Add("@CTT_CACHDUNG", SqlDbType.NVarChar, 30);
cmd.Parameters.Add("@CTT_DVT", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@CTT_SANG", SqlDbType.Int);
cmd.Parameters.Add("@CTT_TRUA", SqlDbType.Int);
cmd.Parameters.Add("@CTT_CHIEU", SqlDbType.Int);
cmd.Parameters.Add("@CTT_TOI", SqlDbType.Int);
cmd.Parameters.Add("@CTT_SOLUONG", SqlDbType.Int);
cmd.Parameters.Add("@CTT_DANGTHUOC", SqlDbType.NVarChar, 100);
cmd.Parameters.Add("@CTT_DONGIA", SqlDbType.Float);
cmd.Parameters.Add("@CTT_THANHTIEN", SqlDbType.Float);
cmd.Parameters.Add("@CTT_IDNHAPKHOCHITIET", SqlDbType.Int);
cmd.Parameters["@TT_ID"].Value = t.Id_tt;
cmd.Parameters["@VT_ID"].Value = t.Id_thuoc;
cmd.Parameters["@CTT_SONGAYUONG"].Value = t.Ctt_songayuong;
cmd.Parameters["@CTT_CACHDUNG"].Value = t.Ctt_cachdung;
cmd.Parameters["@CTT_DVT"].Value = t.Ctt_dvt;
cmd.Parameters["@CTT_SANG"].Value = t.Ctt_sang;
cmd.Parameters["@CTT_TRUA"].Value = t.Ctt_trua;
cmd.Parameters["@CTT_CHIEU"].Value = t.Ctt_chieu;
cmd.Parameters["@CTT_TOI"].Value = t.Ctt_toi;
cmd.Parameters["@CTT_SOLUONG"].Value = t.Ctt_sl;
cmd.Parameters["@CTT_DANGTHUOC"].Value = t.Ctt_dangthuoc;
cmd.Parameters["@CTT_DONGIA"].Value = t.Ctt_dongia;
cmd.Parameters["@CTT_THANHTIEN"].Value = t.Ctt_thanhtien;
cmd.Parameters["@CTT_IDNHAPKHOCHITIET"].Value = t.Ctt_idnhapkhochitiet;
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
// GET: CT_TOATHUOC/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CT_TOATHUOC cT_TOATHUOC = db.CT_TOATHUOC.Find(id);
if (cT_TOATHUOC == null)
{
return(HttpNotFound());
}
ViewBag.MATHUOC = new SelectList(db.THUOCs, "MATHUOC", "TENTHUOC", cT_TOATHUOC.MATHUOC);
ViewBag.MATOATHUOC = new SelectList(db.TOATHUOCs, "MATOATHUOC", "MATOATHUOC", cT_TOATHUOC.MATOATHUOC);
return(View(cT_TOATHUOC));
}
