public JsonResult DeleteTestSection(EPortal.Models.TestSection TestSectioninfo) { int result = 0; // validation = EPortal.Utility.Utility.ValidateProperty(orgdata.Code, "Required"); //string orgid = Session["OrgId"].ToString(); string orgid = User.OrgId; string errormsg = string.Empty; using (EPortalEntities entity = new EPortalEntities()) { var checkreferance = (from r in entity.TestQuestions where r.OrganizationID == orgid && r.TestSectionId == TestSectioninfo.Id select r).FirstOrDefault(); if (checkreferance != null) { errormsg = "Operation conflict:Operation cannot be performed.Record already in Used."; } else { entity.Entry(TestSectioninfo).State = System.Data.Entity.EntityState.Deleted; result = entity.SaveChanges(); } } return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetTestSectionInfo(EPortal.Models.TestSection TestSectioninfo) { //string orgid = Session["OrgId"].ToString(); string orgid = User.OrgId; TestSectionList TestSectioninfoTestSection = new TestSectionList(); List <TestListInfo> testlistinfo = null; using (EPortalEntities entity = new EPortalEntities()) { TestSectioninfoTestSection = (from o in entity.TestSections join p in entity.Tests on o.ParentId equals p.Id where o.Id == TestSectioninfo.Id && o.OrganizationID == orgid select new TestSectionList { Id = o.Id, TestSectionCode = o.TestSectionCode, TestSectionName = o.TestSectionName, parentId = o.ParentId, parentName = p.TestName, Operation = "Edit", IsTestPublish = p.IsPublish }).FirstOrDefault(); testlistinfo = (from t in entity.Tests where t.OrganizationID == orgid select new TestListInfo { TestId = t.Id, Code = t.TestCode, Name = t.TestName, Selected = (TestSectioninfoTestSection.parentId == t.Id) ? true : false }).ToList(); } return(Json(new { editdta = TestSectioninfoTestSection, testlist = testlistinfo }, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveTestSection(EPortal.Models.TestSection TestSectionInfo) { string errormsg = ""; int result = 0; // if ((TestSectionInfo.TestSectionCode != "" || TestSectionInfo.TestSectionCode != null) && (TestSectionInfo.TestSectionName != "" || TestSectionInfo.TestSectionName != null)) { //string orgid = Session["OrgId"].ToString(); string orgid = User.OrgId; using (EPortalEntities entity = new EPortalEntities()) { if (TestSectionInfo.Operation == "Create") { var checkdublivate = (from ts in entity.TestSections where ts.OrganizationID == orgid && ts.TestSectionCode == TestSectionInfo.TestSectionCode && ts.ParentId == TestSectionInfo.ParentId select ts).FirstOrDefault(); if (checkdublivate == null) { TestSectionInfo.Id = Guid.NewGuid().ToString(); TestSectionInfo.OrganizationID = orgid; TestSectionInfo.RowState = true; TestSectionInfo.CreateDateTime = System.DateTime.Now; entity.Entry(TestSectionInfo).State = System.Data.Entity.EntityState.Added; entity.TestSections.Add(TestSectionInfo); try { result = entity.SaveChanges(); } catch (Exception ex) { } } else { errormsg = "Test Section already exist with same Code."; } } else { EPortal.Models.TestSection usedata = (from o in entity.TestSections where o.OrganizationID == orgid && o.Id == TestSectionInfo.Id select o ).FirstOrDefault(); usedata.TestSectionCode = TestSectionInfo.TestSectionCode; usedata.TestSectionName = TestSectionInfo.TestSectionName; usedata.ParentId = TestSectionInfo.ParentId; entity.Entry(usedata).State = System.Data.Entity.EntityState.Modified; try { result = entity.SaveChanges(); } catch (Exception ex) { } } } } //else //{ // if (TestSectionInfo.TestSectionCode != "" || TestSectionInfo.TestSectionCode != null) // { // errormsg = "Please enter Code."; // } // if (TestSectionInfo.TestSectionName != "" || TestSectionInfo.TestSectionName != null) // { // errormsg = "Please enter Name."; // } //} return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet)); }