public Inventory(MySQLDriver driver)
{
_SQL = driver;
_deadlines = new Deadlines(_SQL);
_materialTypes = new MaterialTypes(_SQL);
_units = new Units(_SQL);
_companies = new Companies(_SQL);
_currencies = new Currencies(_SQL);
}
public Transfers(MySQLDriver driver)
{
this._SQL = driver;
_deadlines = new Deadlines(_SQL);
_units = new Units(_SQL);
_companies = new Companies(_SQL);
_materialTypes = new MaterialTypes(_SQL);
_currencies = new Currencies(_SQL);
}
public Materials(MySQLDriver driver, Companies companies, Units units, Deadlines deadlines)
{
this._SQL = driver;
_companies = companies;
_units = units;
_currencies = new Currencies(_SQL);
_materialTypes = new MaterialTypes(_SQL);
_deadlines = deadlines;
}
public void refreshData()
{
listBox1.Items.Clear();
companies = new Companies(SQL);
List<Company> tbl = companies.getList();
foreach (Company collumn in tbl) {
listBox1.Items.Add(collumn);
}
HandleSecurity();
}
private DeadlineTransferRow parseTransferLine(String line)
{
MaterialTypes MaterialTypes = new MaterialTypes(_SQL);
Units Units = new Units(_SQL);
String IDMaterialString = MySQLDriver.parseCollumn(line, "ID_MATERIAL", true);
String IDTransferString = MySQLDriver.parseCollumn(line, "ID_TRANSFER", true);
String MaterialTypeString = MySQLDriver.parseCollumn(line, "ID_MATERIALTYPE", true);
String AmountString = MySQLDriver.parseCollumn(line, "AMOUNT", true).Replace('.', ',');
String UnitString = MySQLDriver.parseCollumn(line, "ID_UNIT", true);
String PriceString = MySQLDriver.parseCollumn(line, "PRICE", true).Replace('.', ',');
String CompanyString = MySQLDriver.parseCollumn(line, "ID_COMPANY", true);
String CourseDateString = MySQLDriver.parseCollumn(line, "COURSEDATE");
String CourseString = MySQLDriver.parseCollumn(line, "COURSE", true).Replace('.', ',');
String CurrencyString = MySQLDriver.parseCollumn(line, "CURRENCY", true);
Companies Companies = new Companies(_SQL);
Currencies Currencies = new Currencies(_SQL);
return new DeadlineTransferRow(
int.Parse(IDMaterialString), int.Parse(IDTransferString), MaterialTypes.GetRecord(int.Parse(MaterialTypeString)),
float.Parse(AmountString), Units.GetRecord(int.Parse(UnitString)), float.Parse(PriceString),
Companies.GetRecord(int.Parse(CompanyString), true), DateTimeUtils.SQLDateToDateTime(CourseDateString),
float.Parse(CourseString), Currencies.getCurrency(int.Parse(CurrencyString))
);
}
