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 Delete(int CategoryId) { TeacherCategoryModel TModel = new TeacherCategoryModel(); TModel.TeacherCategoryId = CategoryId; return(PartialView("DeleteTeacherCategory", TModel)); }
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 Category() { List <tblUserCategory> Categorylist = Connection.tblUserCategories.ToList(); TeacherCategoryModel tcm = new TeacherCategoryModel(); List <UserCategoryModel> tcmlist = Categorylist.Select(x => new UserCategoryModel { CategoryId = x.CategoryId, CategoryName = x.CategoryName, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(View(tcmlist)); }
public ActionResult Index() { var Category = Connection.GDgetAllTeacherCategory("Y"); List <GDgetAllTeacherCategory_Result> Categorylist = Category.ToList(); TeacherCategoryModel tcm = new TeacherCategoryModel(); List <TeacherCategoryModel> tcmlist = Categorylist.Select(x => new TeacherCategoryModel { TeacherCategoryId = x.TeacherCategoryId, TeacherCategoryName = x.TeacherCategoryName, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(View(tcmlist)); }
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 Index() { List <tblUser> users = Connection.tblUsers.ToList(); TeacherCategoryModel tcm = new TeacherCategoryModel(); List <UserModel> tcmlist = users.Select(x => new UserModel { UserId = x.UserId, UserCategory = x.UserCategory, LoginEmail = x.LoginEmail, PersonName = x.PersonName, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(View(tcmlist)); }
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()); } }