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