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