static void Main(string[] args)
{
Console.OutputEncoding = Encoding.UTF8;
foreach (var item in db.MON_HOC)
{
Console.WriteLine("Id: {0},Tên: {1},Tín chỉ: {2},", item.ID, item.TEN, item.TIN_CHI);
}
// INSERT
MON_HOC mh = new MON_HOC()
{
TEN = "Kinh tế lượng", TIN_CHI = 5
};
db.MON_HOC.Add(mh);
db.SaveChanges();
// DELETE
var mh370 = db.MON_HOC.Where(x => x.ID == 1).FirstOrDefault();
db.MON_HOC.Remove(mh370);
db.SaveChanges();
// UPDATE
MON_HOC mhTemp = db.MON_HOC.Where(x => x.ID == 2).FirstOrDefault();
mhTemp.TIN_CHI = 10;
db.Entry(mhTemp).State = EntityState.Modified;
db.SaveChanges();
Console.ReadKey();
}
public ActionResult DeleteConfirmed(Guid id)
{
MON_HOC mON_HOC = db.MON_HOC.Find(id);
db.MON_HOC.Remove(mON_HOC);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "MA_MON,TEN_MON")] MON_HOC mON_HOC)
{
if (ModelState.IsValid)
{
db.Entry(mON_HOC).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(mON_HOC));
}
public ActionResult Create(FormCollection f)
{
if (ModelState.IsValid)
{
MON_HOC mh = new MON_HOC();
mh.MA_MON = Guid.NewGuid();
mh.TEN_MON = f["tenmon"];
db.MON_HOC.Add(mh);
db.SaveChanges();
return(RedirectToAction("Index", "MON_HOC", new { area = "Admin" }));
}
return(View());
}
// GET: Admin/MON_HOC/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MON_HOC mON_HOC = db.MON_HOC.Find(id);
if (mON_HOC == null)
{
return(HttpNotFound());
}
return(View(mON_HOC));
}
