public override ReportTypeTable MakeReportTable()
{
string sql = String.Format("select DESCR," +
"REPORT_TYPE_ID," +
"SHORT_NAME," +
"SQL," +
"ALLOW_DYNAMIC_MODS," +
"DATA_DUMP_ONLY," +
"MUST_ENCRYPT " +
"from SPHRSBILLING.REPORT_TYPE");
DataTable dt = OracleHelper.ExecuteQuery(base.ConnectionString.Value, sql, null);
ObservableCollection <ContractRateAlt> rpt = ConvertDataTableToObservableCollection(dt);
ReportTypeTable rtt = new ReportTypeTable();
rtt.AvailableFields = GetAvailableFields();
foreach (ContractRateAlt package in rpt)
{
package.Table = rtt;
package.AvailableFields = rtt.AvailableFields;
rtt.Add(package);
}
return(rtt);
}
/// <summary>
/// Ctor uses a of Models
/// </summary>
/// <param name="notes">List<ContractNote></param>
public DetailInvoiceFileVM(ReportTypeTable _Table)
{
Target = Spheris.Billing.Data.BillingDataFactory.NewInstance().CreateInvoiceDetailRepository();
table = Target.MakeReportTable();
SelectedGrid = new ObservableCollection <object>();
SelectedData = new ObservableCollection <object>();
status = "Ok";
#if TOO_SLOW
table.ParseEntireTable();
#endif
SaveCommand = new SimpleCommand
{
CanExecuteDelegate = x => (HasErrorVM == null),
ExecuteDelegate = x => Save()
};
NoSaveCommand = new SimpleCommand
{
CanExecuteDelegate = x => (HasErrorVM == null),
ExecuteDelegate = x => NoSave()
};
CancelCommand = new SimpleCommand
{
CanExecuteDelegate = x => !IsBusy,
ExecuteDelegate = x => Cancel()
};
NewTypeCommand = new SimpleCommand
{
CanExecuteDelegate = x => (HasErrorVM == null),
ExecuteDelegate = x => NewType()
};
RemoveTypeCommand = new SimpleCommand
{
CanExecuteDelegate = x => !IsBusy,
ExecuteDelegate = x => RemoveType()
};
SQLCommand = new SimpleCommand
{
CanExecuteDelegate = x => !IsBusy,
ExecuteDelegate = x => SwapMode()
};
ShiftLeftCommand = new SimpleCommand
{
CanExecuteDelegate = x => !IsBusy,
ExecuteDelegate = x => ShiftLeft()
};
ShiftRightCommand = new SimpleCommand
{
CanExecuteDelegate = x => !IsBusy,
ExecuteDelegate = x => ShiftRight()
};
Package = Table[0];
//Package = Table[ Table.Count - 1 ];
}
