private void OpenCSVFile(string srcFile) { if (!File.Exists(srcFile)) { "FileNotFound".GetFromResourece().Show(); return; } LoginInfo_CSV info = new LoginInfo_CSV() { Database = srcFile, IsFirstRowIsColumnName = true, }; App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler; try { App.MainEngineer.Open(info); if (App.MainEngineer.IsOpened) { App.MainEngineer.CurDatabase = info.Database; App.MainEngineer.CurPwd = info.Pwd; RibbionIDE ide = new RibbionIDE(); ide.ShowDialog(); } } catch (Exception ee) { App.ResetMainEngineer(); ee.HandleMyException(); } }
/// <summary> /// Here notice : /// The database in the connection is a folder name /// And the database name is the file name /// In CSV the filename is just the database name and the table name /// /// </summary> /// <param name="pInfo"></param> public override void Open(BaseLoginInfo pInfo) { //Record to base class (Vital) baseLoginInfo = pInfo; LoginInfo_CSV myInfo = pInfo as LoginInfo_CSV; LoginInfo_ForAllDbTypes allInfo = pInfo as LoginInfo_ForAllDbTypes; if ((myInfo == null) && (allInfo == null)) { throw new ArgumentException("Only Support Oledb login info and AllDBTypes Info"); } if (IsOpened) { return; } string myConnString = string.Empty; try { if (allInfo != null) { myInfo = new LoginInfo_CSV(); myInfo.Database = allInfo.Database; myInfo.Pwd = allInfo.Pwd; myInfo.Username = allInfo.Username; } //Process Database name myInfo.Database = Directory.GetParent(myInfo.Database).FullName; myConnString = DbConnectionString.TxtFile.OleDb_DelimitedColumns(myInfo.Database, myInfo.IsFirstRowIsColumnName); baseConn = new OleDbConnection(myConnString); baseConn.Open(); invalidator = new InvalidatorForOledb(); CurDatabase = myInfo.Database; CurPwd = myInfo.Pwd; } catch (Exception e) { throw e; } }
public override bool CreateDatabase(BaseLoginInfo loginInfo) { LoginInfo_CSV myInfo = loginInfo as LoginInfo_CSV; Debug.Assert(myInfo != null); bool result = false; try { File.Create(myInfo.Database); result = true; } catch (Exception ee) { throw ee; } return(result); }
private CoreEA.ICoreEAHander CreateHandler(UIElement curElement) { CoreEA.ICoreEAHander tempHandler = null; ISrcControl srcControl = (ISrcControl)curElement; try { #region Source Control Handler if (curElement.GetType() == typeof(SelectSourceDbFile_OleDB)) { SelectSourceDbFile_OleDB curUI = curElement as SelectSourceDbFile_OleDB; switch (curUI.CurrentDbType) { case UsingOleDbType.Excel: tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Excel).X_Handler; tempHandler.Open((LoginInfo_Excel)srcControl.X_Result); break; case UsingOleDbType.Access: tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.OleDb).X_Handler; tempHandler.Open((LoginInfo_Oledb)srcControl.X_Result); break; case UsingOleDbType.CSV: tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler; tempHandler.Open((LoginInfo_CSV)srcControl.X_Result); break; } } else if (curElement.GetType() == typeof(SelectSqlServerSource)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; tempHandler.Open((LoginInfo_SqlServer)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectMySqlSource)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; tempHandler.Open((LoginInfo_MySql)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectSqlite3DbFile)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler; tempHandler.Open((LoginInfo_Sqlite)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectSSCEFile)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; tempHandler.Open((LoginInfo_SSCE)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectEffiproz)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Effiproz).X_Handler; tempHandler.Open((LoginInfo_Effiproz)srcControl.X_Result); } #endregion #region TargetControlHandler //Here the type is the class name of TargetUI else if (curElement.GetType() == typeof(SelectTargetDb_SqlCe)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; LoginInfo_SSCE ceInfo = srcControl.X_Result as LoginInfo_SSCE; ceInfo.MaxDbSize = 3000; tempHandler.Open(ceInfo); } else if (curElement.GetType() == typeof(SelectSqlServerTarget)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; tempHandler.Open((LoginInfo_SqlServer)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectTargetSqliteDB)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler; tempHandler.Open((LoginInfo_Sqlite)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectTargetMySql)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; tempHandler.Open((LoginInfo_MySql)srcControl.X_Result); } else if (curElement.GetType() == typeof(SelectTargetCSVFile)) { tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler; LoginInfo_CSV tempLogInfo = srcControl.X_Result as LoginInfo_CSV; tempLogInfo.Database += "1.csv"; tempHandler.Open(tempLogInfo); } #endregion } catch (Exception ee) { ee.HandleMyException(); } Debug.Assert(tempHandler != null, "Handler can't be null"); return(tempHandler); }