public JsonResult UpdateDataSource(SavedDataSource obj, bool isSource)
{
try
{
string path = Server.MapPath("~/Content/Config/AutoSTIM/DataSources.json");
SourceTarget dataobj = JsonConvert.DeserializeObject <SourceTarget>(wc.DownloadString(path));
List <SavedDataSource> list;
if (isSource)
{
list = dataobj.Sources;
}
else
{
list = dataobj.Targets;
}
SavedDataSource updateobj = list.Where(x => x.SourceId == obj.SourceId).FirstOrDefault();
updateobj.ConnectionFriendlyName = obj.ConnectionFriendlyName;
updateobj.ConnectionString = obj.ConnectionString;
updateobj.Owner = obj.Owner;
updateobj.ConnectionType = obj.ConnectionType;
System.IO.File.WriteAllText(path, JsonConvert.SerializeObject(dataobj));
return(Json(true));
}
catch (Exception)
{
return(Json(false));
}
}
//Fetching ticket details T1804733
public JsonResult GetSourceTarget()
{
WebClient wc = new WebClient();
string json = wc.DownloadString(Server.MapPath("~/Content/Config/AutoSTM/DataSources.json"));
SourceTarget st = JsonConvert.DeserializeObject <SourceTarget>(json);
foreach (var item in st.Sources)
{
item.ConnectionLive = SQLConnectionCheck(item.ConnectionString);
}
foreach (var item in st.Targets)
{
item.ConnectionLive = SQLConnectionCheck(item.ConnectionString);
}
return(Json(st, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveDataSource(SavedDataSource obj, bool isSource)
{
try
{
string path = Server.MapPath("~/Content/Config/AutoSTM/DataSources.json");
bool exits = false;
if (obj.ConnectionType == "SQL")
{
exits = SQLConnectionCheck(obj.ConnectionString);
}
else
{
exits = true;
}
if (exits)
{
SourceTarget dataobj = JsonConvert.DeserializeObject <SourceTarget>(wc.DownloadString(path));
List <SavedDataSource> list;
if (isSource)
{
list = dataobj.Sources;
}
else
{
list = dataobj.Targets;
}
obj.SourceId = list.Count > 0 ? list.Select(x => x.SourceId).Max() + 1 : 1;
list.Add(obj);
System.IO.File.WriteAllText(path, JsonConvert.SerializeObject(dataobj));
return(Json(true));
}
else
{
return(Json(false));
}
}
catch (Exception)
{
return(Json(false));
}
}
public JsonResult DeleteDataSource(int sourceid, bool isSource)
{
try
{
string path = Server.MapPath("~/Content/Config/AutoSTM//DataSources.json");
SourceTarget dataobj = JsonConvert.DeserializeObject <SourceTarget>(wc.DownloadString(path));
List <SavedDataSource> list;
if (isSource)
{
list = dataobj.Sources;
}
else
{
list = dataobj.Targets;
}
list.Remove(list.Where(x => x.SourceId == sourceid).FirstOrDefault());
System.IO.File.WriteAllText(path, JsonConvert.SerializeObject(dataobj));
return(Json(true));
}
catch (Exception)
{
return(Json(false));
}
}
