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));
}
