/// <summary>
/// Loads the solution.
/// </summary>
/// <param name="node">The node.</param>
/// <returns></returns>
private static Solution LoadSolution(XElement node)
{
Solution solution = null;
if (node != null)
{
solution = new Solution();
solution.Name = node.GetAttributeValue(Constants.Name);
solution.ConnectionSetting = ConnectionStringModel.LoadConnectionString(node.Element(Constants.ConnectionString));
solution.FullXml = node.Element(Constants.Full);
solution.IncrementalXml = node.Elements(Constants.Incremental);
if (solution.FullXml != null)
{
SetDefaultEnabledValue(solution.FullXml);
}
if (solution.IncrementalXml != null)
{
foreach (var one in solution.IncrementalXml)
{
SetDefaultEnabledValue(one);
}
}
}
return(solution);
}
/// <summary>
/// Sets the control value by connection string model.
/// </summary>
/// <param name="connectionStringModel">The connection string model.</param>
private void SetControlValueByConnectionStringModel(ConnectionStringModel connectionStringModel)
{
this.txtServerIP.Text = connectionStringModel.Server;
this.txtDatabase.Text = connectionStringModel.Database;
this.txtUID.Text = connectionStringModel.UserName;
this.txtPwd.Text = connectionStringModel.Password;
this.rdBtnWindow.Checked = connectionStringModel.IsWindowsAuthentication;
}
public IHttpActionResult EditConnectionString(ConnectionStringModel ConnectionStringModel)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
return(Ok(_ConnectionStringManager.EditConnectionString(ConnectionStringModel)));
}
public IActionResult Index(ConnectionStringModel connectionStringModel)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "ConnectionString"));
}
return(View());
}
private void button1_Click(object sender, EventArgs e)
{
var dupa = new ConnectionStringModel(_sqlIp, _db, _sqlUser, _sqlPass);
var ble = dupa.ConnectionString;
var fly = new MsSql(dupa);
var emo = fly.IsConnection();
fly.ExecSql("select getdate()");
}
public static IServiceCollection AddSqlServer(this IServiceCollection services, IConfiguration configuration)
{
ConnectionStringModel model = configuration.GetSection("ConnectionStrings").Get <ConnectionStringModel>();
services.AddDbContext <ShopDbContext>(options =>
{
options.UseSqlServer(model?.DefaultConnection);
});
return(services);
}
//public IActionResult StoreAndShowTables([Bind("ConnectionString")] ConnectionStringModel connectionStringModel)
public IActionResult StoreAndShowTables(ConnectionStringModel connectionStringModel)
{
if (ModelState.IsValid)
{
//Connection string was provided, so redirect to tables display
return(RedirectToAction("Index", "Tables"));
}
return(View("Index", connectionStringModel));
}
/// <summary>
/// Gets the connection string by control.
/// </summary>
/// <param name="isWindowsAuthentication">if set to <c>true</c> [is windows authentication].</param>
/// <returns></returns>
private string GetConnectionStringByControl(bool isWindowsAuthentication)
{
ConnectionStringModel model = GetConnectionStringModelByControl();
if (isWindowsAuthentication)
{
model.UserName = model.Password = string.Empty;
}
return(model.ToConnectionString());
}
/// <summary>
/// Decode a connection string.
/// </summary>
/// <param name="connectionString">The connection string to decode.</param>
/// <returns>The model of connection string.</returns>
public ConnectionStringModel Decode(string connectionString)
{
var builder = new System.Data.Common.DbConnectionStringBuilder();
var model = new ConnectionStringModel();
builder.ConnectionString = connectionString;
model.SambaPath = this.GetConnectionStringValue(builder, Constants.ConnectionString.SambaPathKey);
model.Username = this.GetConnectionStringValue(builder, Constants.ConnectionString.UsernameKey);
model.Domain = this.GetConnectionStringValue(builder, Constants.ConnectionString.DomainKey);
model.Password = this.GetConnectionStringValue(builder, Constants.ConnectionString.PasswordKey);
return(model);
}
/// <summary>
/// Gets the connection string model by control.
/// </summary>
/// <param name="result">if set to <c>true</c> [result].</param>
/// <returns></returns>
public ConnectionStringModel GetConnectionStringModelByControl()
{
ConnectionStringModel model = new ConnectionStringModel();
model.Server = this.txtServerIP.Text;
model.Database = this.txtDatabase.Text;
model.UserName = this.txtUID.Text;
model.Password = this.txtPwd.Text;
if (rdBtnWindow.Checked)
{
model.UserName = model.Password = string.Empty;
}
return(model);
}
public MainModel()
{
CheckConnectionCommand = new DelegateCommand(x => CheckConnection());
BackupCommand = new DelegateCommand(x => Backup());
PathChoiceCommand = new DelegateCommand(x => PathChoice());
RestoreCommand = new DelegateCommand(x => Restore());
InfoTab = new InfoTabViewItem(AppStates.Awaiting);
if (ConnectionStringModel.SelectedAuthenticationKind.Value == null)
{
ConnectionStringModel.SelectedAuthenticationKind = ConnectionStringModel.AuthenticationKinds().FirstOrDefault(x => x.Key == AuthenticationKind.Windows);
}
}
public static ConnectionString CastToDbo(ConnectionStringModel connectionStringModel)
{
var machineId = 0;
if (connectionStringModel.MachineId.HasValue)
{
machineId = connectionStringModel.MachineId.Value;
}
return(new ConnectionString
{
MachineId = machineId,
ConnectionStringId = connectionStringModel.ConnectionStringId,
ConnectionStringName = connectionStringModel.ConnectionStringName,
ConnectionStringUrl = connectionStringModel.ConnectionStringUrl
});
}
public IActionResult Index(ConnectionStringModel connectionStringModel)
{
//TODO Als alternative einen Mood als String binden, evtl. Frage auf Stackoverflow dazu, wie kann ich einen Default-Typen binden??
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "ConnectionString"));
}
var tableNames = GetTableNames(connectionStringModel.ConnectionString);
return(View(new TableNames
{
Names = tableNames
}));
}
public void CheckConnectionFunc()
{
InfoTab = new InfoTabViewItem(AppStates.IsBusy);
OnPropertyChanged(nameof(InfoTab));
if (ConnectionStringModel.SelectedAuthenticationKind.Key == AuthenticationKind.Windows)
{
ConnectionStringModel.ConnectionString = $"Server={ConnectionStringModel.ServerNameText};Database=master;Trusted_Connection=True;";
var isSuccessfull = ConnectionStringModel.IsSQLConnected(ConnectionStringModel.ConnectionString);
if (isSuccessfull)
{
SaveSettings();
InfoTab = new InfoTabViewItem(AppStates.Connected);
}
else
{
InfoTab = new InfoTabViewItem(AppStates.ConnectionError);
}
}
else
{
ConnectionStringModel.ConnectionString = $"Server={ConnectionStringModel.ServerNameText};Database={ConnectionStringModel.DbNameText};User Id={ConnectionStringModel.UserNameText};" +
$"Password={ConnectionStringModel.PasswordText};";
var isSuccessfull = ConnectionStringModel.IsSQLConnected(ConnectionStringModel.ConnectionString);
if (isSuccessfull)
{
SaveSettings();
InfoTab = new InfoTabViewItem(AppStates.Connected);
}
else
{
InfoTab = new InfoTabViewItem(AppStates.ConnectionError);
}
}
OnPropertyChanged(nameof(InfoTab));
}
public void ChangeConnectionString(ConnectionStringModel input)
{
string connectionString = $@"Server={input.ServerName}; Database={input.DatabaseName}; Trusted_Connection=True;";
if (input.IsAuthenticate)
{
connectionString = $@"Data Source={input.ServerName};Initial Catalog={input.DatabaseName};User ID={input.UserName}; Password={input.Password}";
}
try
{
using var connection = new SqlConnection(connectionString);
connection.Open();
ConstantVariable.ConectionString = connectionString;
ConstantVariable.DatabaseName = input.DatabaseName;
ConstantVariable.ServerName = input.ServerName;
ConstantVariable.UserName = input.UserName;
ConstantVariable.Password = input.Password;
}
catch
{
throw new UserFriendlyException("Kết nối database thất bại, hãy kiểm tra lại kết nối");
}
}
/// <summary>
/// Create a ConnectionString to log in.
/// </summary>
/// <param name="connectionStringData">The connectionString data to encode.</param>
/// <returns>Encoded connection string</returns>
public string Encode(ConnectionStringModel connectionStringData)
{
return(this.Encode(connectionStringData.SambaPath, connectionStringData.Username, connectionStringData.Domain, connectionStringData.Password));
}
public MsSql(ConnectionStringModel connectionStringModel)
{
_connStr = connectionStringModel.ConnectionString;
}
public DataBasePublishViewModel()
{
_connectionStringList = new List <ConnectionStringModel>(DAL.ConnStrs.Select(x => new ConnectionStringModel
{
Title = x.Key,
Server = x.Value,
IconSource = new Uri($"/Resources/Images/SqlServer/{DAL.Create(x.Key).DbType.ToString().ToLower()}.png", UriKind.Relative),
SelectConncectionCmd = new Lazy <DelegateCommand <ConnectionStringModel> >(() => new DelegateCommand <ConnectionStringModel>((x) => _selectConnectionStringModel = x)).Value,
}));
_connectionStringCollection = new ObservableCollection <ConnectionStringModel>(_connectionStringList);
CurrentDirectoryFullPath = Environment.CurrentDirectory + @"\";
_tableCollection = new ObservableCollection <TableInfoModel>();
}
/// <summary>
/// Updates the connection string by value changed.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
private void UpdateConnectionStringByValueChanged(object sender, EventArgs e)
{
ConnectionStringModel model = GetConnectionStringModelByControl();
this.txtConnectionString.Text = GetConnectionStringByControl(isWindowsAuthentication);
}
/// <summary>
/// Handles the Leave event of the txtConnectionString control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
private void txtConnectionString_Leave(object sender, EventArgs e)
{
ConnectionStringModel connectionStringModel = ConnectionStringModel.LoadConnectionString(this.txtConnectionString.Text);
SetControlValueByConnectionStringModel(connectionStringModel);
}
public IActionResult Index(ConnectionStringModel connectionStringModel)
{
return(View(connectionStringModel));
}
public ConnectionString EditConnectionString(ConnectionStringModel editConnectionString)
{
var ConnectionString = ConnectionStringUtil.CastToDbo(editConnectionString);
return(_ConnectionStringRepository.Edit(ConnectionString));
}
public ConnectionString CreateConnectionString(ConnectionStringModel newConnectionString)
{
var ConnectionString = ConnectionStringUtil.CastToDbo(newConnectionString);
return(_ConnectionStringRepository.Create(ConnectionString));
}
public Traceability(ConnectionStringModel connectionStringModel)
{
_connStr = connectionStringModel.ConnectionString;
_msSql = new MsSql(connectionStringModel);
}
