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