public JsonResult Delete(int id) { KhoiHoc sinhVien = db.KhoiHocs.Find(id); sinhVien.Active = false; return(Json(db.SaveChanges())); }
public int Update(KhoiHoc k) { //if (checkmaKhoiHoc_ID(k.Makhoihoc) != 0) //{ k.Tenkhoihoc = Tools.ChuanHoaXau(k.Tenkhoihoc); return(dal.Update(k)); //} //else return -1; }
public int Insert(KhoiHoc kh) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_TENKHOIHOC, SqlDbType.NVarChar, 20) }; parm[0].Value = kh.Tenkhoihoc; return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Insert", parm)); }
public int Insert(KhoiHoc k) { //if (checkmaKhoiHoc_ID(k.Makhoihoc) == 0) //{ k.Tenkhoihoc = Tools.ChuanHoaXau(k.Tenkhoihoc); return(dal.Insert(k)); //} //else return -1; }
public ActionResult Edit(KhoiHoc obj) { if (obj.IDKhoiHoc > 0) { db.Entry(obj).State = EntityState.Modified; } else { obj.Active = true; db.KhoiHocs.Add(obj); } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(int?id) { KhoiHoc obj = new KhoiHoc(); if (id.HasValue) { obj = db.KhoiHocs.Find(id); } if (obj == null) { return(HttpNotFound()); } return(View(obj)); }
public KhoiHoc getmaKhoiHoc(int makhoihoc) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter(PARM_MAKHOIHOC, SqlDbType.Int) }; parm[0].Value = makhoihoc; KhoiHoc cls = null; SqlDataReader dra = DataAccessHelper.ExecuteReader(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Sel_ID", parm); if (dra.Read()) { cls = new KhoiHoc( int.Parse(dra["makhoihoc"].ToString()), dra["tenkhoihoc"].ToString()); } dra.Dispose(); return(cls); }
public JsonResult AjaxUpdateKhoiHoc(KhoiHoc obj) { try { if (obj != null) { int result = k.Update(obj); return(Json(result, JsonRequestBehavior.AllowGet)); } else { return(Json(-1, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(-1, JsonRequestBehavior.AllowGet)); } }