public void SearchInvoicesByContract(decimal?invoiceId) { searchString = invoiceId.ToString(); selectedDeliveryMethod = null; selectedSpecialist = null; contractString = null; SearchString = invoiceId.ToString(); }
public ObservableCollection <InvoiceGroup> SearchT( ObservableCollection <InvoiceGroup> output, Action onCompleted ) { #if !ORACLE return(null); #endif IInvoiceGroupRepository DataTarget = Spheris.Billing.Data.BillingDataFactory.NewInstance().CreateInvoiceGroupRepository(); var syncContext = SynchronizationContext.Current; if (syncContext == null) { throw new InvalidOperationException("..."); } BillingSpecialist billSp = (SelectedSpecialist == null || SelectedSpecialist.Id == 0) ? null : SelectedSpecialist; DeliveryMethod delMethod = (SelectedDeliveryMethod == null || SelectedDeliveryMethod.Descr == "*") ? null : SelectedDeliveryMethod; string cntString = (string.IsNullOrEmpty(ContractString)) ? null : ContractString; string srchString = (string.IsNullOrEmpty(SearchString) || SearchString.Length < 3) ? null : SearchString; if (billSp == null && delMethod == null && string.IsNullOrEmpty(cntString) && string.IsNullOrEmpty(srchString)) { IGroups = null; return(null); } uiDispatcher = Dispatcher.CurrentDispatcher; if (workerThread != null) { Debug.WriteLine("Killing thread"); workerThread.Abort(); } workerThread = new Thread(new ThreadStart(delegate { try { var payload = DataTarget.FetchGroups(billSp, delMethod, (string.IsNullOrEmpty(contractString)) ? null : contractString, (string.IsNullOrEmpty(searchString)) ? null : searchString); if (payload != null) { syncContext.Post(arg => CreateOutput(payload as ObservableCollection <InvoiceGroup> /* output*/, onCompleted), null); } } catch (Exception x) { // throw x;// ThisView.ShowMsg(x.ToString()); } })); workerThread.Priority = ThreadPriority.Normal; workerThread.Start(); return(null); }
public void Search() { BillingSpecialist billSp = (SelectedSpecialist == null || SelectedSpecialist.Id == 0) ? null : SelectedSpecialist; DeliveryMethod delMethod = (SelectedDeliveryMethod == null || SelectedDeliveryMethod.Descr == "*") ? null : SelectedDeliveryMethod; string cntString = (string.IsNullOrEmpty(ContractString)) ? null : ContractString; string srchString = (string.IsNullOrEmpty(SearchString) || SearchString.Length < 3) ? null : SearchString; if (billSp == null && delMethod == null && string.IsNullOrEmpty(cntString) && string.IsNullOrEmpty(srchString)) { IGroups = null; } else { IGroups = DataTarget.FetchGroups(billSp, delMethod, (string.IsNullOrEmpty(ContractString)) ? null : ContractString, (string.IsNullOrEmpty(SearchString)) ? null : SearchString); } }
protected override void RowConverter(BillingSpecialist item, DataRow row) { int parsed = 0; try { if (int.TryParse(row["BILL_SPECIALIST_ID"].ToString(), out parsed)) { item.Id = parsed; } item.Name = row["NAME"].ToString(); item.Phone = row["PHONE"].ToString(); item.Email = row["INVOICE_EMAIL_BODY"].ToString(); item.DisplayTitle = row["DISPLAY_TITLE"].ToString(); item.InvoiceEmailBody = row["INVOICE_EMAIL_BODY"].ToString(); } catch (Exception sysEx) { throw sysEx; } }
public override ObservableCollection <BillingSpecialist> GetSpecialists() { #if !ORACLE return(null); #endif ObservableCollection <BillingSpecialist> specialists = new ObservableCollection <BillingSpecialist>(); try { const string sql = "select * from sphrsbilling.bill_specialist"; DataTable dt = OracleHelper.ExecuteQuery(base.ConnectionString.Value, sql, null); foreach (DataRow row in dt.Rows) { BillingSpecialist item = new BillingSpecialist { Id = int.Parse(row["BILL_SPECIALIST_ID"].ToString()), Name = row["NAME"].ToString(), Phone = row["PHONE"].ToString(), Email = row["EMAIL"].ToString(), DisplayTitle = row["DISPLAY_TITLE"].ToString(), InvoiceEmailBody = row["INVOICE_EMAIL_BODY"].ToString() }; specialists.Add(item); } } catch (OracleException ex) { throw ex; } catch (Exception sysEx) { throw sysEx; } return(specialists); }
public override void Remove(BillingSpecialist entity) { }
public override void Update(BillingSpecialist entity) { }
public override void Add(BillingSpecialist entity) { }
public override BillingSpecialist Get(BillingSpecialist entity) { return(null); }
public override ObservableCollection <InvoiceGroup> FetchGroups(BillingSpecialist specialist, DeliveryMethod deliveryMethod, string contractFilter, string descFilter) { ObservableCollection <InvoiceGroup> groups = null; try { string where = string.Empty; if (descFilter != null) { int output; string descWhere = String.Format(" UPPER (ig.DESCR) LIKE '%{0}%'", descFilter.ToUpper()); if (int.TryParse(descFilter.Trim(), out output)) { descWhere += String.Format(" OR ig.INVOICE_GRP_ID={0}", output); } descWhere = descWhere.Insert(0, "("); descWhere += ")"; where = Where(where, descWhere); } if (deliveryMethod != null) { where = Where(where, String.Format(" IG.DELIVERY_METHOD='{0}'", deliveryMethod.TheDeliveryMethod)); } if (specialist != null) { //where = Where(where, String.Format(" IG.Id='{0}'", specialist.Id)); where = Where(where, String.Format(" IG.BILL_SPECIALIST_ID='{0}'", specialist.Id)); } if (contractFilter != null) { int output; string conWhere = String.Format(" UPPER(CON.DESCR) LIKE '%{0}%'", contractFilter.ToUpper()); if (int.TryParse(contractFilter.Trim(), out output)) { conWhere += String.Format(" OR ig.CONTRACT_ID={0}", output); } conWhere = conWhere.Insert(0, "("); conWhere += ")"; where = Where(where, conWhere); } string sql = string.Format("select ig.* ,con.descr\r\n" + " ,nvl(case when ig.encryption_optout = 'Y' then 'N' \r\n" + " when ist.must_encrypt = 'Y' or r.must_encrypt = 'Y' then 'Y' else 'N' end, 'N') \r\n" + " as must_encrypt \r\n" + "from sphrsbilling.invoice_grp ig \r\n" + "left join sphrsbilling.invoice_style ist \r\n" + " on ist.invoice_style = ig.invoice_style \r\n" + "left join sphrsbilling.contract con \r\n" + " on con.contract_id = ig.contract_id \r\n" + "left join (select invoice_grp_id, max(rt.must_encrypt) as must_encrypt \r\n" + " from sphrsbilling.invoice_grp_report igr \r\n" + " join sphrsbilling.report_type rt \r\n" + " on rt.report_type_id = igr.report_type_id \r\n" + " where rt.must_encrypt = 'Y' \r\n" + " group by invoice_grp_id) r \r\n" + " on r.invoice_grp_id = ig.invoice_grp_id"); if (!string.IsNullOrEmpty(where)) { sql += where; } OracleParameter[] p = null; #if TIMEIT DateTime Start = DateTime.Now; #endif DataTable dt = OracleHelper.ExecuteQuery(base.ConnectionString.Value, sql, p); #if TIMEIT DateTime End = DateTime.Now; TimeSpan CallTime = End - Start; System.Diagnostics.Debug.WriteLine("Query Time: + " + CallTime.Milliseconds.ToString()); #endif groups = ConvertDataTableToObservableCollection(dt); } catch (OracleException ex) { throw ex; } catch (Exception sysEx) { throw sysEx; } return(groups); //return null; }
public abstract ObservableCollection <InvoiceGroup> FetchGroups(BillingSpecialist specialist, DeliveryMethod deliveryMethod, string contractFilter, string descFilter);