public static DataTable GetCompletedCRMSalesOrderIDsByCompany(string company) { string query = "SELECT "; query = string.Format(query, company); using (OracleConnection conn = new OracleConnection(BaanDBConnectionString)) { conn.Open(); using (OracleCommand command = conn.CreateCommand()) { command.CommandText = query; command.Parameters.AddWithValue(":PARAM1", new DateTime(Settings.Default.QueryYear, 1, 1)); using (OracleDataAdapter adapter = new OracleDataAdapter(command)) { BaanDataSet.SalesOrderDataTable table = new BaanDataSet.SalesOrderDataTable(); adapter.Fill(table); return table; } } } }
internal void FetchBAANSaleOrder() { BAANSalesOrders = new BaanDataSetTableAdapters.SalesOrderTableAdapter().GetDataByCompany(company); }