public ActionResult Create(TeacherCategoryModel Model)
{
try
{
tblTeacherCategory TCategory = new tblTeacherCategory();
TCategory.CreatedBy = "ADMIN";
TCategory.CreatedDate = DateTime.Now;
TCategory.IsActive = "Y";
TCategory.TeacherCategoryId = 0;
TCategory.TeacherCategoryName = Model.TeacherCategoryName;
Connection.tblTeacherCategories.Add(TCategory);
Connection.SaveChanges();
return(RedirectToAction("Index"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
public ActionResult Edit(int CategoryId)
{
TeacherCategoryModel TModel = new TeacherCategoryModel();
tblTeacherCategory TCtable = Connection.tblTeacherCategories.SingleOrDefault(
x => x.TeacherCategoryId == CategoryId);
TModel.TeacherCategoryName = TCtable.TeacherCategoryName;
TModel.TeacherCategoryId = TCtable.TeacherCategoryId;
TModel.ModifiedBy = "ADMIN"; //User session needed
TModel.ModifiedDate = DateTime.Now;
return(PartialView("EditTeacherCategory", TModel));
}
public ActionResult Edit(TeacherCategoryModel Model)
{
try
{
tblTeacherCategory TCtable = Connection.tblTeacherCategories.SingleOrDefault(
x => x.TeacherCategoryId == Model.TeacherCategoryId);
TCtable.TeacherCategoryName = Model.TeacherCategoryName;
TCtable.ModifiedBy = "ADMIN";;
TCtable.ModifiedDate = DateTime.Now;
Connection.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(TeacherCategoryModel Model)
{
try
{
tblTeacherCategory TCtable = Connection.tblTeacherCategories.SingleOrDefault(
x => x.TeacherCategoryId == Model.TeacherCategoryId);
TCtable.TeacherCategoryId = Model.TeacherCategoryId;
TCtable.ModifiedBy = "ADMIN";;
TCtable.IsActive = "N";
TCtable.ModifiedDate = DateTime.Now;
Connection.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch
{
return(View());
}
}