public InboundQTabPnll(string pSqlConnectionString, string pUserId) { TabFilter = ""; DefaultView = null; CptyLkupTable = null; InitializeComponent(); sqlConnectionString = pSqlConnectionString; imagesDal = new ImagesDal(sqlConnectionString); this.Dock = DockStyle.Fill; p_UserId = pUserId; inboundDocsDal = new InboundDocsDal(sqlConnectionString); vaulter = new Vaulter(sqlConnectionString); xmitRequestDal = new XmitRequestDal(sqlConnectionString); }
private void LoadInitialData() { string currentTableLoad = ""; try { DateTime startTime = DateTime.Now; Program.splashForm.ShowLoadProgress("Loading Summary data..."); currentTableLoad = "SummaryData"; VPcTradeSummaryDal vpcTradeSummaryDal = new VPcTradeSummaryDal(sqlConnectionStr); IList<SummaryData> summaryList; //if (isTestMode) // summaryList = vpcTradeSummaryDal.GetAllStub(); //else string tradeIdList = ""; summaryList = vpcTradeSummaryDal.GetAll(v_PermKeyDBInClauseStr); if (summaryList.Count == 0) { XtraMessageBox.Show("There are currently no trades for your permission set." + Environment.NewLine + "The application has started normally and is listening for new trade activity.", APP_NAME + " Logon", MessageBoxButtons.OK, MessageBoxIcon.Information); } else tradeIdList = vpcTradeSummaryDal.GetTradeIdListString(summaryList); //Israel 9/28/2015 //string filterText = ""; // GetMessageFilterString("G"); //summaryDataTable = CollectionHelper.ConvertTo<SummaryData>(summaryList, filterText); summaryDataTable = CollectionHelper.ConvertTo<SummaryData>(summaryList); summaryDataTable.PrimaryKey = new DataColumn[] { summaryDataTable.Columns["Id"] }; Program.splashForm.ShowLoadProgress("Loading Requirement data..."); currentTableLoad = "RqmtData"; VPcTradeRqmtDal vpcTradeRqmtDal = new VPcTradeRqmtDal(sqlConnectionStr); IList<RqmtData> rqmtList; //if (isTestMode) // rqmtList = vpcTradeRqmtDal.GetAllStub(); //else if (summaryList.Count > 0) { rqmtList = vpcTradeRqmtDal.GetAll(tradeIdList); rqmtDataTable = CollectionHelper.ConvertTo<RqmtData>(rqmtList); } rqmtDataTable.PrimaryKey = new DataColumn[] { rqmtDataTable.Columns["Id"] }; Program.splashForm.ShowLoadProgress("Loading Confirmation data..."); currentTableLoad = "TradeRqmtConfirm"; TradeRqmtConfirmDal tradeRqmtConfirmDal = new TradeRqmtConfirmDal(sqlConnectionStr); IList<TradeRqmtConfirm> confirmList; //if (isTestMode) // confirmList = tradeRqmtConfirmDal.GetAllStub(); //else if (summaryList.Count > 0) { confirmList = tradeRqmtConfirmDal.GetAll(tradeIdList); confirmDataTable = CollectionHelper.ConvertTo<TradeRqmtConfirm>(confirmList); } confirmDataTable.PrimaryKey = new DataColumn[] { confirmDataTable.Columns["Id"] }; Program.splashForm.ShowLoadProgress("Loading Base data..."); currentTableLoad = "RqmtStatusColor"; RqmtStatusColorsDal rqmtStatusColorsDal = new RqmtStatusColorsDal(sqlConnectionStr); IList<RqmtStatusColor> rqmtStatusColorList; //if (isTestMode) // rqmtStatusColorList = rqmtStatusColorsDal.GetAllStub(); //else rqmtStatusColorList = rqmtStatusColorsDal.GetAll(); rqmtStatusColorTable = CollectionHelper.ConvertTo<RqmtStatusColor>(rqmtStatusColorList); currentTableLoad = "ColorTranslate"; ColorTranslateDal colorTranslateDal = new ColorTranslateDal(sqlConnectionStr); IList<ColorTranslate> colorTranslateList; //if (isTestMode) // colorTranslateList = colorTranslateDal.GetAllStub(); //else colorTranslateList = colorTranslateDal.GetAll(); colorTranslateTable = CollectionHelper.ConvertTo<ColorTranslate>(colorTranslateList); currentTableLoad = "RqmtView"; RqmtDal rqmtDal = new RqmtDal(sqlConnectionStr); IList<RqmtView> rqmtViewList; //if (isTestMode) // rqmtViewList = rqmtDal.GetAllStub(); //else rqmtViewList = rqmtDal.GetAll(); rqmtView = CollectionHelper.ConvertTo<RqmtView>(rqmtViewList); currentTableLoad = "RqmtStatusView"; RqmtStatusDal rqmtStatusDal = new RqmtStatusDal(sqlConnectionStr); IList<RqmtStatusView> rqmtStatusViewList; //if (isTestMode) // rqmtStatusViewList = rqmtStatusDal.GetAllStub(); //else rqmtStatusViewList = rqmtStatusDal.GetAll(); rqmtStatusView = CollectionHelper.ConvertTo<RqmtStatusView>(rqmtStatusViewList); currentTableLoad = "TradeDataCdtyLkupView"; CdtyCodeLkupDal cdtyCodeLkupDal = new CdtyCodeLkupDal(sqlConnectionStr); IList<BdtaCdtyLkup> cdtyCodeList; //if (isTestMode) // cdtyCodeList = cdtyCodeLkupDal.GetAllStub(); //else cdtyCodeList = cdtyCodeLkupDal.GetAll(); cdtyLkupTbl = CollectionHelper.ConvertTo<BdtaCdtyLkup>(cdtyCodeList); currentTableLoad = "TradeDataCptyLkupView"; CptyInfoDal cptyInfoDal = new CptyInfoDal(sqlConnectionStr); IList<BdtaCptyLkup> cptyList; //if (isTestMode) // cptyList = cptyInfoDal.GetOpenConfirmLookupStub(); //else cptyList = cptyInfoDal.GetOpenConfirmLookup(); cptyLkupTbl = CollectionHelper.ConvertTo<BdtaCptyLkup>(cptyList); dataSet.Tables.Add(cptyLkupTbl); // used for inbound panel's cpty ref mapping currentTableLoad = "InboundDocsView"; Program.splashForm.ShowLoadProgress("Loading Inbound Documents..."); InboundDocsDal inboundDocsDal = new InboundDocsDal(sqlConnectionStr); IList<InboundDocsView> inboundDocList; //if (isTestMode) // inboundDocList = inboundDocsDal.GetAllStub(); //else inboundDocList = inboundDocsDal.GetAll(); //Israel 9/18/2015 //inboundDocDataTable = CollectionHelper.ConvertTo(inboundDocList, ibQry); inboundDocDataTable = CollectionHelper.ConvertTo(inboundDocList); dataSet.Tables.Add(inboundDocDataTable); Program.splashForm.ShowLoadProgress("Loading Associated Documents..."); currentTableLoad = "AssociatedDoc"; AssociatedDocsDal associatedDocsDal = new AssociatedDocsDal(sqlConnectionStr); IList<AssociatedDoc> associatedDocList; //if (isTestMode) // associatedDocList = associatedDocsDal.GetAllStub(); //else associatedDocList = associatedDocsDal.GetAll(); //assocDocDataTable = CollectionHelper.ConvertTo(associatedDocList, ibQry); assocDocDataTable = CollectionHelper.ConvertTo(associatedDocList); dataSet.Tables.Add(assocDocDataTable); DateTime endTime = DateTime.Now; TimeSpan elapsed = endTime - startTime; Program.splashForm.ShowLoadProgress("Establishing dataset relationships..."); DataColumn[] colPk = new DataColumn[1]; colPk[0] = rqmtStatusColorTable.Columns["Hashkey"]; rqmtStatusColorTable.PrimaryKey = colPk; colPk[0] = colorTranslateTable.Columns["Code"]; colorTranslateTable.PrimaryKey = colPk; rqmtView.DefaultView.RowFilter = "[ActiveFlag] = 'Y' and [DetActRqmtFlag] = 'Y'"; rqmtView.PrimaryKey = new DataColumn[] { rqmtView.Columns["Code"] }; addRqmtForm.lookupRqmt.Properties.DataSource = rqmtView.DefaultView; addRqmtForm.lookupRqmt.Properties.DisplayMember = "DisplayText"; } catch (Exception except) { throw new Exception("Table being loaded=" + currentTableLoad + "." + Environment.NewLine + "Error CNF-010 in " + FORM_NAME + ".LoadInitialData(): " + except.Message); } }
private void ReOpenAnInboundDocument() { string docId = ""; try { myTimer.Stop(); InputBoxResult result = InputBox.Show("Inbound Doc ID:", "Re-Open Inbound Document", docId, null); if (result.OK) { Int32 inbDocsId = Convert.ToInt32(result.Text); string docStatus = AssociatedDoc.OPEN; Int32 rowsUpdated = 0; InboundDocsDal inboundDocsDal = new InboundDocsDal(sqlConnectionStr); rowsUpdated = inboundDocsDal.UpdateStatus(inbDocsId, docStatus); if (rowsUpdated == 0) //throw new Exception("Error re-opening Inbound Document ID:" + inbDocsId.ToString()); throw new Exception("An error occurred while re-opening Inbound Document Id:" + inbDocsId.ToString() + Environment.NewLine + "Error CNF-194 in " + FORM_NAME + ".ReOpenAnInboundDocument()"); } } catch (Exception ex) { //XtraMessageBox.Show("Exception in Re-Open Inbound Document: " + ex.Message); XtraMessageBox.Show("An error occurred while attempting to Re-Open an Inbound Document." + Environment.NewLine + "Error CNF-195 in " + FORM_NAME + ".ReOpenAnInboundDocument(): " + ex.Message, MAIN_FORM_ERROR_CAPTION, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { myTimer.Start(); } }
private void ReOpenInboundDocument(long inbDocId) { var inboundDocsDal = new InboundDocsDal(sqlConnectionString); var id = Convert.ToInt32(inbDocId); var rowsUpdated = inboundDocsDal.UpdateStatus(id, AssociatedDoc.OPEN); if (rowsUpdated <= 0) { throw new Exception("An error occurred while re-opening inbound document Id: " + inbDocId + "." + Environment.NewLine + "Error CNF-444 in " + FORM_NAME + ".ReOpenInboundDocument()."); } var dataRow = MasterInboundDocsTable.Rows.Find(id); dataRow["DocStatusCode"] = AssociatedDoc.OPEN; }