public IEnumerable <Suppliers> GetAll() { var sqlExpression = "SELECT * FROM Suppliers"; var connection = new MyDBConnection(); connection.OpenConnection(); SqlDataAdapter adapter = new SqlDataAdapter(sqlExpression, connection.Connection); var ds = new DataSet(); adapter.Fill(ds); connection.CloseConnection(); var list = new List <Suppliers>(); foreach (DataRow x in ds.Tables[0].Rows) { var id = x.ItemArray[0]; var name = x.ItemArray[1]; list.Add(new Suppliers((int)id, (string)name)); } return(list); }
public IEnumerable <Suppliers> GetSuppliersByMaxCategory(ref int counted) //4 query { var connection = new MyDBConnection(); connection.OpenConnection(); var sqlExpression = "SELECT v.supplier, s.supplierId, counted " + "FROM V5 v " + "JOIN Suppliers s ON v.supplier = s.name " + "ORDER BY counted DESC"; SqlDataAdapter adapter = new SqlDataAdapter(sqlExpression, connection.Connection); var ds = new DataSet(); adapter.Fill(ds); connection.CloseConnection(); counted = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[1]); var list = new List <Suppliers>(); foreach (DataRow x in ds.Tables[0].Rows) { if ((int)x.ItemArray[2] != counted) { break; } var id = x.ItemArray[1]; var name = x.ItemArray[0]; list.Add(new Suppliers((int)id, (string)name)); } return(list); }
private void SetupGeneratedStatements() { // Generate the Insert, Update and Delete statements using mysql DB so that we can test the exact strings. var databaseConnection = MyDBConnection.GetDatabaseConfig(DatabaseConfig.MySql).GetDatabaseConnection(); _insertSql = new InsertStatementGenerator(_filledCircle, databaseConnection).Generate(); _updateSql = new UpdateStatementGenerator(_filledCircle, databaseConnection).Generate(); _deleteSql = new DeleteStatementGenerator(_filledCircle, databaseConnection).Generate(); }
public override void TestFixtureSetup() { if (DatabaseConnection.CurrentConnection != null && DatabaseConnection.CurrentConnection.GetType() == typeof(DatabaseConnectionMySql)) { return; } DatabaseConnection.CurrentConnection = new DatabaseConnectionMySql("MySql.Data", "MySql.Data.MySqlClient.MySqlConnection"); DatabaseConnection.CurrentConnection.ConnectionString = MyDBConnection.GetDatabaseConfig().GetConnectionString(); DatabaseConnection.CurrentConnection.GetConnection(); BORegistry.DataAccessor = new DataAccessorDB(); }
public static void CreateContactPersonAddressTable(string cpAddressTableName, string cpTableName) { if (BORegistry.DataAccessor is DataAccessorInMemory) { return; } if (BORegistry.DataAccessor is DataAccessorMultiSource) { return; } var databaseConfig = MyDBConnection.GetDatabaseConfig(); var migrator = new Migrator(databaseConfig); migrator.DirectMigrateUp(new Migration_Temp_ContactPersonAddress(cpAddressTableName, cpTableName)); }
public void init() { _mockBo = new MockBO(); _propDefCol = _mockBo.PropDefCol; _RelKeyDef = new RelKeyDef(); IPropDef propDef = _propDefCol["MockBOID"]; RelPropDef relPropDef = new RelPropDef(propDef, "MockBOProp1"); _RelKeyDef.Add(relPropDef); _multipleRelationshipDef = new MultipleRelationshipDef("Relation1", typeof(MockBO), _RelKeyDef, false, "", DeleteParentAction.DeleteRelated); _singleRelationshipDef = new SingleRelationshipDef("Single", typeof(MockBO), _RelKeyDef, false, DeleteParentAction.DeleteRelated); DatabaseConnection.CurrentConnection.ConnectionString = MyDBConnection.GetConnectionString(); }
public Suppliers GetById(int id) { var connection = new MyDBConnection(); connection.OpenConnection(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("SELECT * FROM Suppliers WHERE supplierId = @id", connection.Connection); var idParam = new SqlParameter("@id", id); adapter.SelectCommand.Parameters.Add(idParam); var ds = new DataSet(); adapter.Fill(ds); connection.CloseConnection(); return(new Suppliers(id, (string)ds.Tables[0].Rows[0].ItemArray[1])); }
public Categories GetById(int id) { var connection = new MyDBConnection(); connection.OpenConnection(); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("SELECT * FROM Categories WHERE categoryId = @id", connection.Connection); var idParam = new SqlParameter("@id", id); adapter.SelectCommand.Parameters.Add(idParam); var ds = new DataSet(); adapter.Fill(ds); connection.CloseConnection(); return(new Categories(id, ds.Tables[0].Rows[0].ItemArray[1].ToString())); }
private static InsertStatementGenerator CreateInsertStatementGenerator(IBusinessObject shape, string databaseVendor) { var databaseConnection = MyDBConnection.GetDatabaseConfig(databaseVendor).GetDatabaseConnection(); return(new InsertStatementGenerator(shape, databaseConnection)); }
private static UpdateStatementGenerator CreateUpdateStatementGenerator(IBusinessObject businessObject, string databaseVendor) { var databaseConnection = MyDBConnection.GetDatabaseConfig(databaseVendor).GetDatabaseConnection(); return(new UpdateStatementGenerator(businessObject, databaseConnection)); }