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);
}
