public ActionResult Index()
        {
            try
            {
                var Category = Connection.GDgetAllSchoolCategory("Y");
                List <GDgetAllSchoolCategory_Result> Categorylist = Category.ToList();

                SchoolCategoryModel tcm = new SchoolCategoryModel();

                List <SchoolCategoryModel> tcmlist = Categorylist.Select(x => new SchoolCategoryModel
                {
                    SchoolCategoryId   = x.SchoolCategoryId,
                    SchoolCategoryName = x.SchoolCategoryName,
                    CreatedBy          = x.CreatedBy,
                    CreatedDate        = x.CreatedDate,
                    IsActive           = x.IsActive,
                    ModifiedBy         = x.ModifiedBy,
                    ModifiedDate       = x.ModifiedDate
                }).ToList();



                return(View(tcmlist));
            }
            catch (Exception ex)
            {
                Errorlog.ErrorManager.LogError(ex);
                return(View());
            }
        }
 public ActionResult Delete(int Code)
 {
     try
     {
         SchoolCategoryModel TModel = new SchoolCategoryModel();
         TModel.SchoolCategoryId = Code;
         return(PartialView("DeleteView", TModel));
     }
     catch (Exception ex)
     {
         Errorlog.ErrorManager.LogError(ex);
         return(View());
     }
 }
        public ActionResult Delete(SchoolCategoryModel Model)
        {
            UserId = USession.User_Id;
            try
            {
                Connection.GDdeleteSchoolCategory("N", Model.SchoolCategoryId, UserId);
                Connection.SaveChanges();


                return(Json(true, JsonRequestBehavior.AllowGet));
                //return RedirectToAction("Index");
            }
            catch (Exception ex)
            {
                Errorlog.ErrorManager.LogError(ex);
                return(View());
            }
        }
        public ActionResult Edit(SchoolCategoryModel Model)
        {
            UserId = USession.User_Id;
            try
            {
                tblSchoolCategory TCtable = Connection.tblSchoolCategories.SingleOrDefault(x => x.SchoolCategoryId == Model.SchoolCategoryId);

                Connection.GDModifySchoolCategory(Model.SchoolCategoryName, Model.SchoolCategoryId, UserId);
                Connection.SaveChanges();

                return(RedirectToAction("Index"));
            }
            catch (Exception ex)
            {
                Errorlog.ErrorManager.LogError(ex);
                return(View());
            }
        }
        public ActionResult Edit(int Code)
        {
            try{
                SchoolCategoryModel TModel = new SchoolCategoryModel();

                tblSchoolCategory TCtable = Connection.tblSchoolCategories.SingleOrDefault(x => x.SchoolCategoryId == Code);
                TModel.IsActive = TCtable.IsActive;

                TModel.SchoolCategoryId   = TCtable.SchoolCategoryId;
                TModel.SchoolCategoryName = TCtable.SchoolCategoryName;

                return(PartialView("EditView", TModel));
            }
            catch (Exception ex)
            {
                Errorlog.ErrorManager.LogError(ex);
                return(View());
            }
        }