/// <summary>
/// Convert a Microsoft Access database into a DataSet
/// </summary>
/// <param name="filename"></param>
/// <returns></returns>
public DataSet ImportAccess(string filename)
{
// Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet OLEDB:Database Password=MyDbPassword;
string connectionString = string.Format(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=admin;Password=;",
filename);
OleDbManager m = new OleDbManager(connectionString);
return(m.FillTables());
}
/// <summary>
/// Convert a Microsoft Excel into a DataSet
/// </summary>
/// <param name="filename"></param>
/// <returns></returns>
public DataSet ImportExcel(string filename)
{
string connectionString = string.Format(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR={1};IMEX=1"";",
filename,
useHeaderRow ? "Yes" : "No");
OleDbManager m = new OleDbManager(connectionString);
return(m.FillTables());
}
/// <summary>
/// Convert a DBF File into a DataSet
/// </summary>
/// <param name="filename"></param>
/// <returns></returns>
private DataSet ImportDBF(string filename)
{
string folder = Path.GetDirectoryName(filename);
string fname = Path.GetFileNameWithoutExtension(filename);
string connectionString = string.Format(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=dBASE IV;User ID=Admin;Password=;",
folder);
OleDbManager m = new OleDbManager(connectionString);
return(ToDataSet(m.FillTable("select * from " + fname, fname)));
}
private void btnGetFromAccess_Click(object sender, EventArgs e)
{
Stopwatch stpwtch = new Stopwatch(); stpwtch.Start();
OleDbManager oledbMan = new OleDbManager(
@"Provider=Microsoft.Jet.Oledb.4.0;Data Source=D:\E\Yazılım\CSharp\CShap.Kod.Ornek.Uyg\Uygulamalar\Calisan Uygulamalar\ILLER\IllerUygulaması\IllerUygulaması\bin\Debug\dbofl;User Id=admin;Jet OLEDB:Database Password=DilkiDepesi"
/*
* @"Provider=Microsoft.Jet.Oledb.4.0;
* Data Source=D:\E\Yazılım\CSharp\CShap.Kod.Ornek.Uyg\Uygulamalar\Calisan Uygulamalar\FilmArşivi\film arsivi\WindowsApplication1\bin\Debug\indexim.mdb"*/
);
dataGridView1.DataSource = oledbMan.GetResultSetOfQuery(
@"Select * from iller;"
//"Select count(dvd),tur from indexim group by tur"
).Tables[0];
stpwtch.Stop();
MessageBox.Show(String.Format("Geçen Zaman : {0}", stpwtch.ElapsedMilliseconds));
}
static void Main(string[] args)
{
string provider = "Microsoft.ACE.OLEDB.12.0";
string datasource = System.Environment.CurrentDirectory + "\\users.accdb";
string userid = "";
string password = "";
string conString = "Provider=" + provider + ";Data Source=" + datasource
+ "; User ID=" + userid + ";Password="******";";
try {
IServerView view = new view.ServerForm();
DataManager manager = new OleDbManager(conString);
ServerController ctl = new ServerController(view);
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
}
public Accountant Load()
{
Accounting.Util.AppEnv.Instance.AddLogger(DacII.Util.WinFormUtil.Instance);
mAccountant = new Accountant("MyobAccountant");
mAccountant.ApplicationDirPath = mApplicationDirPath;
DbManager default_factory = new MyobDbManager(mAccountant, "DefaultFactory");
mAccountant.DefaultMgrFactory = default_factory;
DbManager primary_factory = new OleDbManager(mAccountant, "PrimaryFactory");
primary_factory.Database = string.Format("{0}\\config.mdb", mApplicationDirPath);
primary_factory.DbPassword = "******";
mAccountant.AddMgrFactory(primary_factory);
mAccountant.ConfigMgrFactory = primary_factory;
mAccountant.MiscNumberMgrFactory = primary_factory;
mAccountant.ConfigMgr.Prefix = "Myob";
DbManager secondary_factory = new OleDbManager(mAccountant, "SecondaryFactory");
secondary_factory.Database = string.Format("{0}\\inventorist.mdb", mApplicationDirPath);
secondary_factory.DbPassword = "******";
mAccountant.AddMgrFactory(secondary_factory);
mAccountant.AuthItemMgrFactory = secondary_factory;
mAccountant.AuthRoleMgrFactory = secondary_factory;
mAccountant.AuthUserMgrFactory = secondary_factory;
mAccountant.ItemAddOnMgrFactory = secondary_factory;
mAccountant.ItemSizeMgrFactory = secondary_factory;
mAccountant.GenderMgrFactory = secondary_factory;
mAccountant.DataFieldMgrFactory = secondary_factory;
mAccountant.ItemDataFieldEntryMgrFactory = secondary_factory;
mAccountant.ItemDataFieldEntryMgr.UseMemoryStore = false;
return(mAccountant);
}
public Accountant CreateAccountant(params object[] options)
{
string accountant_name = (string)options[0];
Accountant _obj = new Accountant(accountant_name);
_obj.ApplicationDirPath = mApplicationDirPath;
DbManager default_factory = new MyobDbManager(_obj, "DefaultFactory");
_obj.DefaultMgrFactory = default_factory;
DbManager primary_factory = new OleDbManager(_obj, "PrimaryFactory");
primary_factory.Database = string.Format("{0}\\config.mdb", mApplicationDirPath);
primary_factory.DbPassword = "******";
_obj.AddMgrFactory(primary_factory);
_obj.ConfigMgrFactory = primary_factory;
_obj.MiscNumberMgrFactory = primary_factory;
_obj.ConfigMgr.Prefix = "Myob";
DbManager secondary_factory = new OleDbManager(_obj, "SecondaryFactory");
secondary_factory.Database = string.Format("{0}\\inventorist.mdb", mApplicationDirPath);
secondary_factory.DbPassword = "******";
_obj.AddMgrFactory(secondary_factory);
_obj.AuthItemMgrFactory = secondary_factory;
_obj.AuthRoleMgrFactory = secondary_factory;
_obj.AuthUserMgrFactory = secondary_factory;
_obj.ItemSizeMgrFactory = secondary_factory;
_obj.ItemAddOnMgrFactory = secondary_factory;
_obj.GenderMgrFactory = secondary_factory;
return(_obj);
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (!System.IO.File.Exists(txtApp.Text))
{
MessageBox.Show("The Myob Application path is not set correctly!");
DialogResult = DialogResult.None;
return;
}
if (!System.IO.File.Exists(txtDB.Text))
{
MessageBox.Show("The Myob Database path is not set correctly!");
DialogResult = DialogResult.None;
return;
}
DbManager secondary_factory = null;
string network_db = "0";
if (rdoLocalDb.Checked)
{
secondary_factory = new OleDbManager(mAccountant, "SecondaryFactory");
secondary_factory.Database = mAccountant.GetFullPath("inventorist.mdb");
secondary_factory.DbPassword = "******";
}
else if (rdoNetworkedMySQL.Checked)
{
secondary_factory = new MySQLDbManager(mAccountant, "SecondaryFactory");
secondary_factory.DbUsername = (txtMySQLUID.Text);
secondary_factory.DbPassword = (txtMySQLPWD.Text);
secondary_factory.Database = (txtMySQLDb.Text);
secondary_factory.HostExePath = (txtMySQLHost.Text);
secondary_factory.Port = (txtMySQLPort.Text);
network_db = "1";
}
else if (rdoNetworkedMSSQL.Checked)
{
secondary_factory = new SqlClientDbManager(mAccountant, "SecondaryFactory");
secondary_factory.DbUsername = (txtMSSQLUID.Text);
secondary_factory.DbPassword = (txtMSSQLPWD.Text);
secondary_factory.Database = (txtMSSQLDb.Text);
secondary_factory.HostExePath = (txtMSSQLHost.Text);
secondary_factory.Port = (txtMSSQLPort.Text);
network_db = "2";
}
mAccountant.ConfigMgr.SetParam("NETWORK_NETWORKDB", network_db);
mAccountant.AddMgrFactory(secondary_factory);
mAccountant.AuthItemMgrFactory = secondary_factory;
mAccountant.AuthRoleMgrFactory = secondary_factory;
mAccountant.AuthUserMgrFactory = secondary_factory;
mAccountant.ItemAddOnMgrFactory = secondary_factory;
mAccountant.GenderMgrFactory = secondary_factory;
mAccountant.ItemSizeMgrFactory = secondary_factory;
List <string> message = new List <string>();
if (!ValidateLogin(message))
{
if (message.Count == 0)
{
MessageBox.Show("Invalid Login!");
}
else
{
MessageBox.Show("Invalid Login! (" + message[0] + ")");
}
DialogResult = DialogResult.None;
}
}
