public JsonResult GetAllAuthorizations() { tbotEntities e = new tbotEntities(); var result = e.Authorizations.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllEnvironments() { tbotEntities e = new tbotEntities(); var result = e.Environments.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEndPointComponents() { tbotEntities e = new tbotEntities(); var result = e.View_EndPointComponent.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetEndPointObject(int EndPointId) { tbotEntities e = new tbotEntities(); var result = e.Get_EndPointObjectComponentCount_GroupedInCount_By_EndPointObject_For_EndPointId(EndPointId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GropuEndPointObject(int EndPointObjectId, string Section) { tbotEntities e = new tbotEntities(); var result = e.Group_EndPointObject_By_EndPointObjectId(EndPointObjectId, Section); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult UngropuEndPointObject(int EndPointObjectGroupId) { tbotEntities e = new tbotEntities(); var result = e.UnGroup_EndPointObject_By_EndPointObjectGroupId(EndPointObjectGroupId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetEndPointObjectForEndPointObjectGroupSection(string EndPointObjectGroupSection) { tbotEntities e = new tbotEntities(); var result = e.Get_EndPointObject_EndPoint_For_EndPointObjectGroupSection(EndPointObjectGroupSection); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetEndPointObjectGroupList() { tbotEntities e = new tbotEntities(); var result = e.View_EndPointObjectGroup_Distinct.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult AddEndPoint(int InstanceId, string EndPointName) { tbotEntities e = new tbotEntities(); var result = e.Add_EndPoint_For_InstanceId(InstanceId, EndPointName); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult RemoveEndPoint(int EndPointId) { tbotEntities e = new tbotEntities(); var result = e.Remove_EndPoint_By_EndPointId(EndPointId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetEndPointObjectGroups(int EndPointObjectId) { tbotEntities e = new tbotEntities(); var result = e.Get_EndPointObjectGroups_For_EndPointObjectId(EndPointObjectId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetEndPoints(int InstanceId) { tbotEntities e = new tbotEntities(); var result = e.Get_EndPoints_For_InstanceId(InstanceId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult GetEndPointObjectComponentsforEndPointObjectId(int EndPointObjectId) { tbotEntities e = new tbotEntities(); var result = e.Get_EndPointObjectComponents_For_EndPointObjectId(EndPointObjectId); var table = LinqExtensions.ToPivotTable(result, item => item.ComponentName, item => item.EndPointObjectId, items => items.Any() ? items.First().ComponentValue : null, true, "EndPoint"); string jsonString = string.Empty; //Ignores nulll key value pairs while serializing jsonString = JsonConvert.SerializeObject(table, Newtonsoft.Json.Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); return(Json(jsonString, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInstances() { tbotEntities e = new tbotEntities(); var result = e.Instances.ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult EditEndPointObjectComponentValue(int EndPointObjectComponentId, string EndPointObjectComponentValue) { tbotEntities e = new tbotEntities(); var result = e.Edit_EndPointObjectComponentValue_For_EndPointObjectComponentId(EndPointObjectComponentId, EndPointObjectComponentValue); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult AddEndPointObjectComponent(int EndPointObjectId, string EndPointObjectComponentName) { tbotEntities e = new tbotEntities(); var result = e.Add_EndPointObjectComponent_For_EndPointObjectId(EndPointObjectId, EndPointObjectComponentName); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult AddEndPointObject(int EndPointId) { tbotEntities e = new tbotEntities(); var result = e.Add_EndPointObject_For_EndPointId(EndPointId); return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult AddTestCases(Models.TestCase TestCase) { //question.Date = DateTime.Parse(DateTime.Now.ToShortTimeString()); tbotEntities e = new tbotEntities(); e.TestCases.Add(TestCase); //e.APIs.Add(apiInput); e.SaveChanges(); return(Json(new { status = "Api Input added successfully" })); }
public JsonResult AddApiInfo(List <Models.EndPoint> apiArrayList) { //question.Date = DateTime.Parse(DateTime.Now.ToShortTimeString()); tbotEntities e = new tbotEntities(); //foreach (var api in apiArrayList) //{ // e.APIs.Add(api); // api.SchemaUrl = @"https://git.ellucian.com:8443/projects/HEDM/repos/hedm-models/raw/schema/" // + api.EndPoint // + @".json?at=refs%2Fheads%2F" // + api.Version // +@".0"; //} //e.APIs.Add(apiInput); e.SaveChanges(); return(Json(new { status = "Api Input added successfully" })); }
public JsonResult GetEndPointComponentsAsJsonString() { tbotEntities e = new tbotEntities(); //var result = e.View_EndPointComponent.ToList(); var result = e.EndPointComponents .Where(a => a.InstanceId == 1) .Select(i => new { i.EndPointComponentName, i.Value, i.InstanceId }); var table = LinqExtensions.ToPivotTable(result, item => item.EndPointComponentName, item => item.InstanceId, items => items.Any() ? items.First().Value : null, false); string jsonString = string.Empty; //Ignores nulll key value pairs while serializing jsonString = JsonConvert.SerializeObject(table); return(Json(jsonString, JsonRequestBehavior.AllowGet)); }