public LoginForm()
{
InitializeComponent();
conn = Authorization.login(AppSettings.Nick, AppSettings.Password);
SQL = new MySQLDriver(conn);
Auth = new Authorization(SQL);
AppSettings.lForm = this;
ShowInTaskbar = true;
}
public MySQLDriver(exIfConnector connector)
{
this._connector = connector;
_unTransferableWords = new Dictionary<string, string>();
_unTransferableWords.Add("+", "[!PLUS!]");
_unTransferableWords.Add("&", "[!AND!]");
_unTransferableWords.Add("\\", "[!BCKSLA!]");
//UnTransferableWords.Add("'", "[!APOS!]");
}
public CompanyForm()
{
InitializeComponent();
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
SQL = new MySQLDriver(connector);
Auth = new Authorization(SQL);
refreshData();
}
public DeadlineForm()
{
InitializeComponent();
errorProvider = new ErrorProvider();
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
SQL = new MySQLDriver(connector);
Auth = new Authorization(SQL);
refreshData();
}
public ProductToMaterialForm()
{
InitializeComponent();
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
connector.onError = new Action(() => connectorErrorHandler(connector));
SQL = new MySQLDriver(connector);
List<Product> products = new Products(SQL).getList();
((DataGridViewComboBoxColumn)dataGridView1.Columns["Product"]).Items.Clear();
foreach (Product p in products)
{
((DataGridViewComboBoxColumn)dataGridView1.Columns["Product"]).Items.Add(p.ToString());
}
}
public InventoryForm()
{
InitializeComponent();
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
SQL = new MySQLDriver(connector);
Inventory = new Inventory(SQL);
Corrections = new Corrections(SQL);
Deadlines = new Deadlines(SQL);
Auth = new Authorization(SQL);
dateTimePicker1.Value = DateTime.Now;
resizeByDataGrid(dataGridView1);
}
public SettingsForm()
{
InitializeComponent();
Conn = Authorization.login(AppSettings.Nick, AppSettings.Password);
SQL = new MySQLDriver(Conn);
Auth = new Authorization(SQL);
Groups = new Groups(SQL);
Permissions = new Permissions(SQL);
FormNames = new FormNames(SQL);
ActionNames = new ActionNames(SQL);
Users = new Users(SQL);
refreshTab("tabPage1");
refreshTab("tabPage2");
refreshTab("tabPage3");
}
private void connectorErrorHandler(exIfConnector conn)
{
return;
}
public override void init(bool firstRun = true)
{
Status = "Připojování k databázi...";
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
connector.onError = new Action(()=>connectorErrorHandler(connector));
SQL = new MySQLDriver(connector);
Units = new Units(SQL);
Auth = new Authorization(SQL);
MaterialTypes = new MaterialTypes(SQL);
Compositions = new Compositions(SQL);
Status = "Inicializace...";
if (firstRun){}
initState = true;
if (!connector.IsConnected())
{
handleError();
return;
}
reload();
refresh();
}
private void control(exIfConnector conn)
{
while (!end) {
if (!conn.IsConnected())
{
Invoke(new Action(() =>
{
connLosHandled = false;
if (!conn.IsConnected())
{
handleError();
}
}));
while (!connLosHandled) { controler.Wait(1000); }
}
}
}
private void connectorErrorHandler(exIfConnector conn)
{
try
{
Invoke(new Action(() =>
{
if (!Error)
handleError();
}));
}
catch (Exception) { return; }
}
public override void init(bool firstRun = true)
{
Status = "Připojování k databázi...";
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
connector.onError = new Action(()=>connectorErrorHandler(connector));
SQL = new MySQLDriver(connector);
Transfers = new Transfers(SQL);
Currencies = new Currencies(SQL);
ExchangeRates = new ExchangeRate("http://www.cnb.cz/cs/financni_trhy/devizovy_trh/kurzy_devizoveho_trhu/denni_kurz.txt");
Status = "Inicializace...";
if (firstRun)
{
}
List<Currency> curlst = (Currencies).getList();
if (!connector.IsConnected()) return;
if (currencies != curlst)
{
currencies = curlst;
comboBox1.Items.Clear();
((DataGridViewComboBoxColumn)dataGridView1.Columns["CurrencyColumn"]).Items.Clear();
foreach (Currency cmpn in currencies)
{
((DataGridViewComboBoxColumn)dataGridView1.Columns["CurrencyColumn"]).Items.Add(cmpn.ToString());
comboBox1.Items.Add(cmpn.ToString());
}
}
Status = "Stahuji aktuální kurzovní lístek ČNB...";
comboBox1.Text = "EUR";
kurz = ExchangeRates.getByDate(Currencies.getCurrency("EUR"), DateTime.Now);
if (kurz == 0) MessageBox.Show("Dnešní kurzovní lístek není na webu ČNB k dispozici.");
if (!connector.IsConnected()) return;
textBox1.Text = kurz.ToString();
initState = true;
if (!connector.IsConnected())
{
handleError();
return;
}
reload();
refresh();
}
public override void init(bool firstRun = true)
{
Status = "Připojování k databázi...";
connector = Authorization.login(AppSettings.Nick, AppSettings.Password);
connector.onError = new Action(()=>connectorErrorHandler(connector));
SQL = new MySQLDriver(connector);
ProductExports = new ProductExports(SQL);
Auth = new Authorization(SQL);
Status = "Inicializace...";
if (firstRun)
{
monthComboBox.Items.Clear();
monthComboBox.Items.AddRange(((new Months()).getList()).ToArray());
monthComboBox.Text = (new Months()).getMonth(DateTime.Now.Month).ToString();
Deadline deadline = (new Deadlines(SQL)).GetLast();
yearUpDown.Value = (deadline.EventDate.Month == 12) ? deadline.EventDate.Year + 1 : deadline.EventDate.Year;
}
initState = true;
if (!connector.IsConnected())
{
handleError();
return;
}
reload();
refresh();
}
