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