//this method should to DataAccess project like the GetConnection method too
private void GetOpenDataConnection(string server, string database, string security)
{
string builder = BuildConnectionString(server, database, security);
try
{
OpenDatabaseConnection.GetConnection(builder);
//if (successConnect != null && successConnect.State == System.Data.ConnectionState.Open)
ConnectionStringButtonColor = new SolidColorBrush(Color.FromRgb(0, 255, 0));
IsEnabled_GetAllFromDatabase = true;
IsEnabled_SaveToDatabase = true;
}
catch (Exception ex)
{
MessageBox.Show("Wrong connection String" + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
ConnectionStringButtonColor = new SolidColorBrush(Color.FromRgb(250, 0, 0));
IsEnabled_GetAllFromDatabase = false;
IsEnabled_SaveToDatabase = false;
IsEnabled_UpdatePersonInDatabase = false;
IsEnabled_RemovePersonInDatabase = false;
}
}
private void OnSaveToDB()
{
if (!PersonList.Count.Equals(0))
{
if (MessageBox.Show("Do you want to save changes in the list to database?", "Question",
MessageBoxButton.YesNo,
MessageBoxImage.Warning) == MessageBoxResult.No)
{
var conn = OpenDatabaseConnection.GetConnection("ConnectionString");
if (conn == null ? IsEnabled_SaveToDatabase = false : IsEnabled_SaveToDatabase = true)
{
//TODO
//var dbContext = new PersonModelDataContext();
//dbContext.InsertToDb(conn, PersonList.ToList());
}
}
else
{
excelSave.SaveToExcel(PersonList.ToList());
return;
}
}
}