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