public ActionResult GridViewPartialUpdate(iys.ModelProject.LESSON item)
{
var model = db.LESSONS;
if (ModelState.IsValid)
{
try
{
item.LAST_UPDATE = DateTime.Now;
item.LAST_UPDATE_USER = getCurrentUserName();
var modelItem = model.FirstOrDefault(it => it.LESSON_CODE == item.LESSON_CODE);
if (modelItem != null)
{
this.UpdateModel(modelItem);
db.SaveChanges();
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
var model1 = from less in db.LESSONS
join cha in db.CHAPTERS on less.CHAPTER_CODE equals cha.CHAPTER_CODE
join course in db.COURSES on cha.COURSE_CODE equals course.COURSE_CODE
select new { less.LESSON_CODE, CHAPTER_CODE = cha.CHAPTER_NAME, less.LESSON_NAME, less.DURATION, COURSE_CODE = course.COURSE_NAME };
return(PartialView("_GridViewPartial", model.ToList()));
}
public ActionResult GridViewPartialAddNew(iys.ModelProject.LESSON item)
{
var model = db.LESSONS;
//if (ModelState.IsValid)
//{
try
{
//item.LESSON_CODE =
//item.LESSON_NAME =
item.RES_CODE = 0;
item.ROW_NO = 0;
//item.COURSE_CODE =
//item.CHAPTER_CODE =
//item.DURATION =
item.CREATE_USER = getCurrentUserName();
item.CREATE_DATE = DateTime.Now;
item.LAST_UPDATE = DateTime.Now;
item.LAST_UPDATE_USER = getCurrentUserName();
model.Add(item);
db.SaveChanges();
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
//}
//else
// ViewData["EditError"] = "Please, correct all errors.";
var model1 = from less in db.LESSONS
join cha in db.CHAPTERS on less.CHAPTER_CODE equals cha.CHAPTER_CODE
join course in db.COURSES on cha.COURSE_CODE equals course.COURSE_CODE
select new { less.LESSON_CODE, CHAPTER_CODE = cha.CHAPTER_NAME, less.LESSON_NAME, less.DURATION, COURSE_CODE = course.COURSE_NAME };
return(PartialView("_GridViewPartial", model.ToList()));
}
