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