/// <summary>
/// ConnectToDatabase.
/// Si connette ad un database esistente
/// </summary>
private bool ConnectToDatabase()
{
var connected = false;
var connectionString = GetConnectionString();
try
{
myConnection = new SqlProxyConnection(connectionString);
myConnection.Open();
connected = (myConnection.State == ConnectionState.Open);
// @@ try to remove changedatabase
//if (connected)
// myConnection.ChangeDatabase(lI.InitialCatalog);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString(), GlobalInfo.LoginInfo.InitialCatalog, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (SqlProxyDatabaseHelper.SearchTable <EF_Version>(myConnection))
{
if (MessageBox.Show(Properties.Resources.Database_WrongType,
Properties.Resources.Attention,
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
connected = false;
return(false);
}
else
{
RegisterModule RsT = new ERPFramework.ModuleData.RegisterModule();
RsT.CreateTable(myConnection, GlobalInfo.UserInfo.userType);
AddAdminUser();
}
}
else
{
RegisterModule RsT = new ERPFramework.ModuleData.RegisterModule();
connected = RsT.CreateTable(myConnection, GlobalInfo.UserInfo.userType);
}
return(connected);
}
public void AddTable <T>(bool toExport = true)
{
System.Diagnostics.Debug.Assert(typeof(T).BaseType == typeof(Table));
var existVirtual = typeof(T).GetField("IsVirtual");
var isVirtual = existVirtual == null
? false
: bool.Parse(existVirtual.GetValue(null).ToString());
var table = new TableDefinition {
Module = Module(), Table = typeof(T), ToExport = toExport, IsVirtual = isVirtual
};
if (!GlobalInfo.Tables.ContainsKey(table.Table.Name))
{
GlobalInfo.Tables.Add(table.Table.Name, table);
AddTableType <T>();
}
if (!isVirtual && SqlProxyDatabaseHelper.SearchTable <T>(GlobalInfo.SqlConnection))
{
SqlCreateTable.CreateTable <T>();
}
}