public ActionResult DeleteConfirmed(int id) { DM_CT dm_ct = db.DM_CT.Find(id); db.DM_CT.Remove(dm_ct); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /DM_CT/Delete/5 public ActionResult Delete(int id) { DM_CT dm_ct = db.DM_CT.Find(id); if (dm_ct == null) { return(HttpNotFound()); } return(View(dm_ct)); }
// GET: /DM_CT/Edit/5 public ActionResult Edit(int id) { DM_CT dm_ct = db.DM_CT.Find(id); if (dm_ct == null) { return(HttpNotFound()); } //ViewBag.MaCap2 = new SelectList(db.DMCap2, "Macap2", "Ten", dm_ct.MaCap2); return(View(dm_ct)); }
public ActionResult Edit([Bind(Include = "idct,Ma_CT,Ten_CT,Ma_EC,Ma_BaselA,Ma_BaselY,TC_Nguyhai,Trangthai_tontai,Nguong_nguyhai,status,tuxuly")] DM_CT dm_ct) { //if (ModelState.IsValid) //{ db.Entry(dm_ct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); //} ////ViewBag.MaCap2 = new SelectList(db.DMCap2, "Macap2", "Ten", dm_ct.MaCap2); //return View(dm_ct); }
public void load_DMCT() { string filename = @"D:\Quan Ly Chat Thai\Danh muc chat thai.docx"; string mact, tenct, maec, mabasela, mabasely, tinhchat, trangthai, nguong, cap2; var template = DocX.Load(filename); Table table = template.Tables[0]; for (int i = 1; i < table.RowCount; i++) { if (table.Rows[i].Cells[0].Paragraphs.First().Text.Trim().Length > 10) { mact = table.Rows[i].Cells[0].Paragraphs.First().Text.Trim().Substring(0, 10); } else { mact = table.Rows[i].Cells[0].Paragraphs.First().Text.Trim(); } if (mact.Length >= 8) { if (table.Rows[i].Cells[1].Paragraphs.First().Text.Trim().Length > 150) { tenct = table.Rows[i].Cells[1].Paragraphs.First().Text.Trim().Substring(0, 150); } else { tenct = table.Rows[i].Cells[1].Paragraphs.First().Text.Trim(); } if (table.Rows[i].Cells[2].Paragraphs.First().Text.Trim().Length > 10) { maec = table.Rows[i].Cells[2].Paragraphs.First().Text.Trim().Substring(0, 10); } else { maec = table.Rows[i].Cells[2].Paragraphs.First().Text.Trim(); } mabasela = table.Rows[i].Cells[3].Paragraphs.First().Text.Trim(); if (mabasela.Length > 20) { mabasela = mabasela.Substring(0, 20); } if (table.Rows[i].Cells[4].Paragraphs.First().Text.Trim().Length > 20) { mabasely = table.Rows[i].Cells[4].Paragraphs.First().Text.Trim().Substring(0, 20); } else { mabasely = table.Rows[i].Cells[4].Paragraphs.First().Text.Trim(); } if (table.Rows[i].Cells[5].Paragraphs.First().Text.Trim().Length > 50) { tinhchat = table.Rows[i].Cells[5].Paragraphs.First().Text.Trim().Substring(0, 50); } else { tinhchat = table.Rows[i].Cells[5].Paragraphs.First().Text.Trim(); } if (table.Rows[i].Cells[6].Paragraphs.First().Text.Trim().Length > 20) { trangthai = table.Rows[i].Cells[6].Paragraphs.First().Text.Trim().Substring(0, 20); } else { trangthai = table.Rows[i].Paragraphs.First().Text.Trim().Trim(); } if (table.Rows[i].Cells[7].Paragraphs.First().Text.Trim().Length > 10) { nguong = table.Rows[i].Cells[7].Paragraphs.First().Text.Trim().Substring(0, 10); } else { nguong = table.Rows[i].Cells[7].Paragraphs.First().Text.Trim(); } cap2 = mact.Substring(0, 5); DM_CT ct = new DM_CT(); ct.Ma_CT = mact; ct.Ten_CT = tenct; ct.Ma_EC = maec; ct.Ma_BaselA = mabasela; ct.Ma_BaselY = mabasely; ct.TC_Nguyhai = tinhchat; ct.Trangthai_tontai = trangthai; ct.Nguong_nguyhai = nguong; ct.MaCap2 = cap2; db.DM_CT.Add(ct); db.SaveChanges(); } } template.Dispose(); }