public JsonResult SaveDBConnection(DBConnectionViewModel db) { var json = new JsonResults(); var rm = new ResultModel(); bool isSave = true; string connectionStr = "data source=" + db.DBServer + ";initial catalog=" + db.DBName + ";user id=" + db.UserName + ";password="******";"; try { connectionStr = Utilities.Encrypt(connectionStr); string baseDiv = AppDomain.CurrentDomain.BaseDirectory; XmlDocument xml = new XmlDocument(); string filePath = Path.Combine(baseDiv, "bin\\Configuration\\Data\\Database.config"); xml.Load(filePath); var element = xml.DocumentElement; element.FirstChild.FirstChild.InnerText = connectionStr; //var xmlNode = element.SelectSingleNode(@"/databaseList/database/connectionString"); //xmlNode.InnerText = connectionStr; xml.Save(filePath); rm.Status = true; rm.Result = isSave; } catch (Exception ex) { isSave = false; rm.Message = ex.Message; rm.Status = false; } json.Data = rm; return(json); }
public JsonResult CheckDBConnection(DBConnectionViewModel db) { var json = new JsonResults(); var rm = new ResultModel(); bool isConnection = true; string connectionStr = "data source=" + db.DBServer + ";initial catalog=" + db.DBName + ";user id=" + db.UserName + ";password="******";"; SqlConnection sc = new SqlConnection(connectionStr); try { sc.Open(); rm.Status = true; rm.Result = isConnection; } catch (Exception ex) { isConnection = false; rm.Message = ex.Message; rm.Status = false; } json.Data = rm; return(json); }
public DBConnectionView() { InitializeComponent(); MasterDbViewModel = new DBConnectionViewModel("Master"); TestDbViewModel = new DBConnectionViewModel("Test"); }