void OnCusipSelected(object sender, CusipSelectEventArgs e) { IncomingDeliveryOrderParam p = new IncomingDeliveryOrderParam(); p.DateAndTimeStamp_Date.AddParamValue(DateTime.Today); p.Cusip.AddParamValue(e.Cusip); df.Load(Orders, p); //Remove records that are receives but 5239 is not the receiver, same for deliver Orders.RemoveAll(delegate(IncomingDeliveryOrderObject d) { return((d.Receiver != Settings.Account.Padded() && d.DelivererReceiverIndicator == "R") || (d.Deliverer != Settings.Account.Padded() && d.DelivererReceiverIndicator == "D")); }); Display.Load(Orders); Display.Sort("DateAndTimeStamp"); ColorRows(); this.Text = "DTC Activity " + e.Cusip; //ALANDIAS cbPendingFilter_CheckedChanged(null, null); //-------- }
private void LoadDtcActivity() { //get the DTC Activity IncomingDeliveryOrderParam doFromDtcParam = new IncomingDeliveryOrderParam(); doFromDtcParam.DateAndTimeStamp_Date.AddParamValue(ProcessDate); idFact.Load(DtcActivity, doFromDtcParam); //Get Dtc Pending Activity DtcPendingActivity = DtcActivity.FindAll(delegate(IncomingDeliveryOrderObject d) { return(d.DtcStatusIndicator != "X" && d.DtcStatusIndicator != " "); }); //Remove pending DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) { return(d.DtcStatusIndicator != "X" && d.DtcStatusIndicator != " "); }); /* * //Get Dtc NPB Activity * DtcNpbActivity = DtcActivity.FindAll(delegate(IncomingDeliveryOrderObject d) * { return d.Deliverer == "00000238" && d.Receiver == "00005239" && d.ReasonCode == "010"; }); */ //Now store all the DTC Activity for use in the price control form //AllDtcActivity = DtcActivity.FindAll(delegate(IncomingDeliveryOrderObject d) //{ return d.Receiver == "00005239" || d.Deliverer == "00005239" || d.Receiver == "00000269" || d.Deliverer == "00000269"; }); AllDtcActivity = new List <IncomingDeliveryOrderObject>(DtcActivity); //Remove non 5239 activity DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) { return(d.Receiver != Settings.Account.Padded() && d.Deliverer != Settings.Account.Padded()); }); /* Dont care about NPB * //Remove the NPB activity * DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) * { return d.Deliverer == "00000238" && d.Receiver == "00005239" && d.ReasonCode == "010"; }); * * DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) * { return d.Deliverer == "00005239" && d.Receiver == "00000238" && d.ReasonCode == "020"; }); */ //Remove records with an actioncode of 0 DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) { return(d.ActionCode == "0"); }); //Remove records that are receives but 5239 is not the receiver, same for deliver DtcActivity.RemoveAll(delegate(IncomingDeliveryOrderObject d) { return((d.Receiver != Settings.Account.Padded() && d.DelivererReceiverIndicator == "R") || (d.Deliverer != Settings.Account.Padded() && d.DelivererReceiverIndicator == "D")); }); //get the maxId if (DtcActivity.Count > 0) { MaxDtcId = DtcActivity.Max(item => item.Id); } else { MaxDtcId = 0; } b = "1"; }
private void ResearchForm_Load(object sender, EventArgs e) { helper.SetAllColumns(); IncomingDeliveryOrderParam p = new IncomingDeliveryOrderParam(); p.DateAndTimeStamp_Date.AddParamValue(DateTime.Today); p.ReasonCode.AddParamValue("010", "<>", ConditionalEnum.AND); p.ReasonCode.AddParamValue("020", "<>", ConditionalEnum.AND); doFact.Load(orders, p, "00005239", null); lblCount.Text = orders.Count.ToString(); }
private void Filter() { IncomingDeliveryOrderParam p = new IncomingDeliveryOrderParam(); string maple = null; string ctpy = null; p.DateAndTimeStamp_Date.AddParamValue(dtpDate.Value.Date); if (!string.IsNullOrEmpty(cbxMapleCtpy.Text)) { maple = cbxMapleCtpy.Text.ToString(); maple = maple.PadLeft(8, '0'); } if (!string.IsNullOrEmpty(txtCtpy.Text)) { ctpy = txtCtpy.Text.ToString(); ctpy = ctpy.PadLeft(8, '0'); } if (!string.IsNullOrEmpty(txtHour.Text) && !string.IsNullOrEmpty(txtMinute.Text)) { DateTime t = dtpDate.Value.Date.AddHours(double.Parse(txtHour.Text)).AddMinutes(double.Parse(txtMinute.Text)); p.DateAndTimeStamp.AddParamValue(t); p.DateAndTimeStamp.Comparer = cbxTimeCriteria.SelectedItem.ToString(); } foreach (object o in lstCusip.Items) { p.Cusip.AddParamValue(o); } foreach (object o in lstReasonCode.Items) { p.ReasonCode.AddParamValue(o); } if (!string.IsNullOrEmpty(txtShares.Text)) { p.ShareQuantity.AddParamValue(int.Parse(txtShares.Text)); p.ShareQuantity.Comparer = cbxSharesCriteria.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(txtMoneyValue.Text)) { p.MoneyValue.AddParamValue(float.Parse(txtMoneyValue.Text)); p.MoneyValue.Comparer = cbxMoneyCriteria.SelectedItem.ToString(); } if (!string.IsNullOrEmpty(cbxDirection.Text)) { if (cbxDirection.Text == "Deliverer") { p.DelivererReceiverIndicator.AddParamValue("D"); } if (cbxDirection.Text == "Receiver") { p.DelivererReceiverIndicator.AddParamValue("R"); } } foreach (object i in clbStatus.CheckedItems) { switch (i.ToString()) { case "Made": p.DtcStatusIndicator.AddParamValue(""); break; case "Pending": p.DtcStatusIndicator.AddParamValue("P"); break; case "Made after Pending": p.DtcStatusIndicator.AddParamValue("X"); break; case "CNS Deliver DO Drop": p.DtcStatusIndicator.AddParamValue("C"); break; case "SDFS Prevent-Pend Drop": p.DtcStatusIndicator.AddParamValue("D"); break; case "Killed": p.DtcStatusIndicator.AddParamValue("K"); break; case "Repended": p.DtcStatusIndicator.AddParamValue("R"); break; default: break; } } orders.Clear(); doFact.Load(orders, p, maple, ctpy); lblCount.Text = orders.Count.ToString(); }