public ActionResult Index()
        {
            try
            {
                var Qualification = Connection.GDgetAllQualification("Y");
                List <GDgetAllQualification_Result> Qualificationlist = Qualification.ToList();

                QulificationModel tcm = new QulificationModel();

                List <QulificationModel> tcmlist = Qualificationlist.Select(x => new QulificationModel
                {
                    QualificationId   = x.QualificationId,
                    QualificationName = x.QualificationName,
                    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
     {
         QulificationModel TModel = new QulificationModel();
         TModel.QualificationId = Code;
         return(PartialView("DeleteView", TModel));
     }
     catch (Exception ex)
     {
         Errorlog.ErrorManager.LogError(ex);
         return(View());
     }
 }
        public ActionResult Delete(QulificationModel Model)
        {
            UserId = USession.User_Id;
            try
            {
                Connection.GDdeleteQualification("N", Model.QualificationId, UserId);
                Connection.SaveChanges();


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

                Connection.GDModifyQualification(Model.QualificationName, Model.QualificationId, UserId);
                Connection.SaveChanges();

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

                tblQualification TCtable = Connection.tblQualifications.SingleOrDefault(x => x.QualificationId == Code);
                TModel.IsActive = TCtable.IsActive;

                TModel.QualificationId   = TCtable.QualificationId;
                TModel.QualificationName = TCtable.QualificationName;

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