Ejemplo n.º 1
0
        public void Execute(object parameter)
        {
            try
            {
                var dbservice = VEFModule.UnityContainer.Resolve(typeof(IDatabaseService), "") as IDatabaseService;

                IDALOptions options = dbservice.CurrentDB.DBOptions;
                options.Host = mpm.DBFilePath; //TODO use settings!!

                var ctx = ((IDAL.IDAL)dbservice.CurrentDB).GetDataContextOpt(false);

                IDAL.IDAL.TruncateDatabase(ctx);

                RekursivSaveToDB(mpm, ctx);

                //   Type t = parameter as Type;

                //to create the objects i need the parameter data!!!!
                //         mpm.Save();
                //if (t.Name == "SceneDataModel")
                //{
                //    //KH 29.03             mpm.Items.Add(new SceneDataModel() { Parent = mpm, UnityContainer = mpm.UnityContainer, Name = "new scene", ContentID = "SceneID:##:" });
                //    // Type instance = (Type)Activator.CreateInstance(t);
                //    // object obj = t.GetConstructor(new Type[] { }).Invoke(new object[] { });
                //    //   mpm.Items.Add(obj as IItem);
                //}
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Ejemplo n.º 2
0
 /// <summary>
 /// Adds a base item to the project-file manager
 /// </summary>
 /// <param name="theme">The item to add</param>
 /// <returns>true, if successful - false, otherwise</returns>
 public bool AddDBOption(IDALOptions db)
 {
     if (!DBOptions.Contains(db))
     {
         DBOptions.Add(db);
         return(true);
     }
     return(false);
 }
Ejemplo n.º 3
0
        public IDAL_DCTX GetDataContextOpt(Boolean checkUser = true)
        {
            IDAL_DCTX ctx = new IDAL_DCTX();

            try
            {
                var _databaseService = VEFModule.UnityContainer.Resolve(typeof(IDatabaseService), "") as IDatabaseService;

                ////if (m_DBFound)
                ////{

                ////}
                ////else
                ////    ShowDBSetting(m_Container);

                //   PS_COMID_DataContext crmDataContext = new PS_COMID_DataContext();

                IDALOptions options = _databaseService.CurrentDB.DBOptions;
                if (options.DBType == DBType.MSSQL)
                {
                    //

                    //string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;Server = " + options.Host + "; Database = PNDS; User Id = " + options.User + ";Password = "******"metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=AP-HAAG\\SQLEX2008R203;initial catalog=PNDS;user id=PecuSoft;password=sesam1997oeffne;MultipleActiveResultSets=True;App=EntityFramework\"";
                    string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=" + options.Host + ";initial catalog=PNDS;user id=" + options.User + ";password="******";MultipleActiveResultSets=True;App=EntityFramework\"";

                    //string connectionString = "User Id=" + options.User + ";Password="******";Server=" + options.Host + ";Direct=True;Sid=" + options.ServiceName + ";Persist Security Info=True";
                    //   string providerPrefix = "";
                    //if (!ConnectionDialog.Show(out connectionString, out providerPrefix))
                    //{
                    //    stripLabel.Text = "Incorrect connection string";
                    //    return;
                    //}

                    //Frame activating
                    //  Stream contextStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(String.Format("ComID.IDAL.MDB.CrmDataMapping{0}.lqml", providerPrefix));
                    //   Devart.Data.Linq.Mapping.MappingSource mappingSource = Devart.Data.Linq.Mapping.XmlMappingSource.FromStream(contextStream);

                    //PNDSEntities crmDataContext = new PNDSEntities(m_Container, connectionString);//, mappingSource);

                    //crmDataContext.CTXID = _databaseService.GetNextCtxID();

                    ////    crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);

                    //crmDataContext.Database.Connection.Open();
                    ////    foreach (ListViewItem lvItem in lvFrames.Items)
                    ////        ((BaseControl)lvItem.Tag).OpenClick();

                    //if (checkUser && _databaseService.LoggedUser.UserID < 1)
                    //{
                    //    ShowLoginDialog(m_Container);
                    //    return null;
                    //}

                    //return crmDataContext;
                }
                else if (options.DBType == DBType.SQLite)
                {
                    //System.Data.SQLite.SQLiteConnection.CreateFile("databaseFile.db3");        // Create the file which will be hosting our database
                    //using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=\"F:\\Projekte\\coop\\XGame\\data\\dbData.s3db\""))
                    //{
                    //    using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(con))
                    //    {
                    //        con.Open();                             // Open the connection to the database

                    //        //com.CommandText = createTableQuery;     // Set CommandText to our query that will create the table
                    //        //com.ExecuteNonQuery();                  // Execute the query

                    //        //com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key one','value one')";     // Add the first entry into our database
                    //        //com.ExecuteNonQuery();      // Execute the query
                    //        //com.CommandText = "INSERT INTO MyTable (Key,Value) Values ('key two','value value')";   // Add another entry into our database
                    //        //com.ExecuteNonQuery();      // Execute the query

                    //        //com.CommandText = "Select * FROM MyTable";      // Select all rows from our database table

                    //        //using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
                    //        //{
                    //        //    while (reader.Read())
                    //        //    {
                    //        //        Console.WriteLine(reader["Key"] + " : " + reader["Value"]);     // Display the value of the key and value column for every row
                    //        //    }
                    //        //}
                    //        con.Close();        // Close the connection to the database
                    //    }
                    //}

                    //todo per settings!
                    //       string connectionString = "metadata=res://*/MDB.EDM_DBData.csdl|res://*/MDB.EDM_DBData.ssdl|res://*/MDB.EDM_DBData.msl;provider=System.Data.SQLite.EF6;provider connection string=\"data source=F:\\Projekte\\coop\\XGame\\data\\dbData.s3db\"";

                    //   string connectionString = "data source=F:\\Projekte\\coop\\XGame\\data\\dbData.s3db";
                    string connectionString = _databaseService.CurrentDB.DBOptions.Host;
                    //  string connectionString = "metadata=res://*/MDB.EDM_DBData.csdl|res://*/MDB.EDM_DBData.ssdl|res://*/MDB.EDM_DBData.msl;provider=System.Data.SQLite.EF6;provider connection string=\"data source=" + options.Host + "\""; //D:\\Projekte\\coop\\VEX\\Test\\dbData.s3db\"";

                    //  string connectionString = "metadata=res://*/MDB.MDB_PNDS.csdl|res://*/MDB.MDB_PNDS.ssdl|res://*/MDB.MDB_PNDS.msl;provider=System.Data.SqlClient;provider connection string=\"data source=" + options.Host + ";initial catalog=PNDS;user id=" + options.User + ";password="******";MultipleActiveResultSets=True;App=EntityFramework\"";
                    dbDataEntities crmDataContext = new dbDataEntities(connectionString);//, mappingSource);

                    crmDataContext.CTXID = _databaseService.GetNextCtxID();

                    //    crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);

                    //-------------   crmDataContext..Database..Connection.Open();
                    //    foreach (ListViewItem lvItem in lvFrames.Items)
                    //        ((BaseControl)lvItem.Tag).OpenClick();

                    if (checkUser && _databaseService.LoggedUser.UserID < 1)
                    {
                        ShowLoginDialog();
                        return(null);
                    }
                    ctx.Context = crmDataContext;

                    return(ctx);
                }
                else if (options.DBType == DBType.Oracle)
                {
                    //string connectionString = "User Id=" + options.User + ";Password="******";Server=" + options.Host + ";Direct=True;Sid=" + options.ServiceName + ";Persist Security Info=True";
                    ////   string providerPrefix = "";
                    ////if (!ConnectionDialog.Show(out connectionString, out providerPrefix))
                    ////{
                    ////    stripLabel.Text = "Incorrect connection string";
                    ////    return;
                    ////}

                    ////Frame activating
                    ////  Stream contextStream = Assembly.GetExecutingAssembly().GetManifestResourceStream(String.Format("ComID.IDAL.MDB.CrmDataMapping{0}.lqml", providerPrefix));
                    ////   Devart.Data.Linq.Mapping.MappingSource mappingSource = Devart.Data.Linq.Mapping.XmlMappingSource.FromStream(contextStream);

                    //PNDSEntities crmDataContext = new PNDSEntities(m_Container, connectionString);//, mappingSource);

                    //crmDataContext.CTXID = _databaseService.GetNextCtxID();

                    ////    crmDataContext.Connection.StateChange += new System.Data.StateChangeEventHandler(Connection_StateChange);

                    //crmDataContext.Database.Connection.Open();
                    ////    foreach (ListViewItem lvItem in lvFrames.Items)
                    ////        ((BaseControl)lvItem.Tag).OpenClick();

                    //if (checkUser && _databaseService.LoggedUser.UserID < 1)
                    //{
                    //    ShowLoginDialog(m_Container);
                    //    return null;
                    //}

                    //return crmDataContext;
                }
            }
            catch (Exception ex)
            {
                var loggerService = VEFModule.UnityContainer.Resolve(typeof(ILoggerService), "") as ILoggerService;
                loggerService.Log("Datenbankverbindung fehlgeschlagen." + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), LogCategory.Exception, LogPriority.High);
                //
                //  workspace.NotificationRequest.Raise(new Notification { Content = "Datenbankverbindung fehlgeschlagen." + (ex.InnerException != null ? ex.InnerException.Message : ex.Message), Title = "Fehler" });

                //  stripLabel.Text = ex.Message;
            }
            return(ctx);
        }