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