public ActionResult GridView1PartialAddNew(iys.ModelProject.DOCUMENT item) { var model = db.DOCUMENTS; try { item.PATH = filePath; item.VISIBLE = true; item.CREATE_USER = getCurrentUserName(); item.CREATE_DATE = DateTime.Now; item.LAST_UPDATE = DateTime.Now; item.LAST_UPDATE_USER = getCurrentUserName(); filePath = null; model.Add(item); db.SaveChanges(); } catch (Exception e) { ViewData["EditError"] = e.Message; } //} //else // ViewData["EditError"] = "Please, correct all errors."; var model1 = from d in db.DOCUMENTS join b in db.CHAPTERS on d.CHAPTER_CODE equals b.CHAPTER_CODE join cs in db.COURSES on d.COURSE_CODE equals cs.COURSE_CODE join lesson in db.LESSONS on d.LESSON_CODE equals lesson.LESSON_CODE select new { d.DOCUMENT_CODE, CHAPTER_CODE = b.CHAPTER_NAME, d.DOCUMENT_TYPE, d.DURATION, d.LINK_TYPE, d.PATH, LESSON_CODE = lesson.LESSON_NAME, COURSE_CODE = cs.COURSE_NAME, d.DOCUMENT_NAME }; return(PartialView("_GridView1Partial", model.ToList())); }
public ActionResult GridView1PartialUpdate(iys.ModelProject.DOCUMENT item) { var model = db.DOCUMENTS; try { item.PATH = filePath; item.PRIORITY = 0; item.ROW_ORDER_NO = 0; item.VISIBLE = true; item.CREATE_USER = getCurrentUserName(); item.CREATE_DATE = DateTime.Now; item.LAST_UPDATE = DateTime.Now; item.LAST_UPDATE_USER = getCurrentUserName(); filePath = null; /// DOCUMENT modelItem = model.FirstOrDefault(it => it.DOCUMENT_CODE == item.DOCUMENT_CODE); if (item != null) { db.DOCUMENTS.Attach(item); db.Entry(item).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception e) { ViewData["EditError"] = e.Message; } //} //else // ViewData["EditError"] = "Please, correct all errors."; var model1 = from d in db.DOCUMENTS join b in db.CHAPTERS on d.CHAPTER_CODE equals b.CHAPTER_CODE join cs in db.COURSES on d.COURSE_CODE equals cs.COURSE_CODE join lesson in db.LESSONS on d.LESSON_CODE equals lesson.LESSON_CODE select new { d.DOCUMENT_CODE, CHAPTER_CODE = b.CHAPTER_NAME, d.DOCUMENT_TYPE, d.DURATION, d.LINK_TYPE, d.PATH, LESSON_CODE = lesson.LESSON_NAME, COURSE_CODE = cs.COURSE_NAME, d.DOCUMENT_NAME }; return(PartialView("_GridView1Partial", model.ToList())); }