예제 #1
0
        private Int32 UpdateTradeRqmtConfirmRow(Int32 AId, Int32 ATradeId, Int32 ARqmtId, string ATemplateName,
           string AFaxTelexInd, string AFaxTelexNumber, string AConfirmLabel, string AConfirmCmt,
           string ANextStatusCode, string AActiveFlag)
        {
            //string agreementInfo = "";
            try
            {
                TradeRqmtConfirm tradeRqmtConfirmData = new TradeRqmtConfirm();
                tradeRqmtConfirmData.Id = AId;
                tradeRqmtConfirmData.TradeId = ATradeId;
                tradeRqmtConfirmData.RqmtId = ARqmtId;
                tradeRqmtConfirmData.TemplateName = ATemplateName;
                tradeRqmtConfirmData.NextStatusCode = ANextStatusCode;
                tradeRqmtConfirmData.ConfirmLabel = AConfirmLabel;
                tradeRqmtConfirmData.ConfirmCmt = AConfirmCmt;
                tradeRqmtConfirmData.FaxTelexInd = AFaxTelexInd;
                tradeRqmtConfirmData.FaxTelexNumber = AFaxTelexNumber;
                tradeRqmtConfirmData.ConfirmLabel = AConfirmLabel;
                tradeRqmtConfirmData.ConfirmCmt = AConfirmCmt;
                tradeRqmtConfirmData.ActiveFlag = AActiveFlag;

                TradeRqmtConfirmDal tradeRqmtConfirmDal = new TradeRqmtConfirmDal(sqlConnectionStr);

                Int32 spProcReturnValue = 0;
                //Israel 11/05/2015 -- Restored Insert capability
                if (AId == 0)
                    spProcReturnValue = tradeRqmtConfirmDal.Insert(tradeRqmtConfirmData);
                else
                {
                    spProcReturnValue = tradeRqmtConfirmDal.Update(tradeRqmtConfirmData);
                }

                if (spProcReturnValue > 0)
                {
                    if (AId == 0)
                    {
                        DataRow row = confirmDataTable.NewRow();
                        //row["Id"] = [email protected];
                        row["Id"] = spProcReturnValue;
                        row["RqmtId"] = ARqmtId;
                        row["TradeId"] = ATradeId;
                        //row["TemplateId"] = 0;
                        row["NextStatusCode"] = ANextStatusCode;
                        row["ConfirmLabel"] = AConfirmLabel;
                        row["ConfirmCmt"] = AConfirmCmt;
                        row["FaxTelexInd"] = AFaxTelexInd;
                        row["FaxTelexNumber"] = AFaxTelexNumber;
                        row["XmitStatusInd"] = "";
                        row["XmitAddr"] = "";
                        row["XmitCmt"] = "";
                        //row["XmitTimeStampgmt"] = System.DBNull.Value;
                        row["TemplateName"] = ATemplateName;
                        row["TemplateCategory"] = "";
                        row["TemplateTypeInd"] = "";
                        row["FinalApprovalFlag"] = "";
                        row["ActiveFlag"] = AActiveFlag;
                        confirmDataTable.Rows.Add(row);
                    }
                    else
                    {
                        string filterStr = "Id = " + AId.ToString();
                        foreach (DataRow row in confirmDataTable.Select(filterStr))
                        {
                            row.BeginEdit();
                            //row["TemplateId"] = 0;
                            row["TemplateName"] = ATemplateName;
                            row["NextStatusCode"] = ANextStatusCode;
                            row["ConfirmLabel"] = AConfirmLabel;
                            row["ConfirmCmt"] = AConfirmCmt;
                            row["FaxTelexInd"] = AFaxTelexInd;
                            row["FaxTelexNumber"] = AFaxTelexNumber;
                            row.AcceptChanges();
                            row.EndEdit();
                        }
                    }
                    return spProcReturnValue;
                }
                else
                {
                    //XtraMessageBox.Show("Error Updating: " + [email protected]);
                    XtraMessageBox.Show("Error Updating TradeRqmtConfirm.");
                    return -1;
                }
            }
            catch (Exception ex)
            {
                throw new Exception("An error occurred while attempting to update a Confirm using the following values:" + Environment.NewLine +
                    "Confirm Id: " + AId.ToString() + ", Trade Id: " + ATradeId.ToString() + ", Rqmt Id: " + ARqmtId.ToString() +
                        ", Template Name: " + ATemplateName + Environment.NewLine +
                    "Transmission Method: " + AFaxTelexInd + ", Transmission Send-To Address: " + AFaxTelexNumber + ", Active Flag: " + AActiveFlag + Environment.NewLine +
                     "Error CNF-129 in " + FORM_NAME + ".UpdateTradeRqmtConfirmRow(): " + ex.Message);
            }
        }
예제 #2
0
        private void CopyDataToBeUpdated()
        {
            sumDataCacheCopy.Clear();
            rqmtDataCacheCopy.Clear();
            assDocDataCacheCopy.Clear();
            inbDocViewCacheCopy.Clear();
            tradeRqmtConfirmCacheCopy.Clear();
            
            foreach (SummaryData data in sumDataCache)
            {
                SummaryData copyData = new SummaryData();
                copyData = data;
                sumDataCacheCopy.Add(copyData);
            }

            foreach (RqmtData data in rqmtDataCache)
            {
                RqmtData copyData = new RqmtData();
                copyData = data;
                rqmtDataCacheCopy.Add(copyData);
            }

            foreach (AssociatedDoc data in assDocDataCache)
            {
                AssociatedDoc copyData = new AssociatedDoc();
                copyData = data;
                assDocDataCacheCopy.Add(copyData);
            }

            foreach (InboundDocsView data in inbDocViewCache)
            {
                InboundDocsView copyData = new InboundDocsView();
                copyData = data;
                inbDocViewCacheCopy.Add(copyData);
            }

            foreach (TradeRqmtConfirm data in tradeRqmtConfirmCache)
            {
                TradeRqmtConfirm copyData = new TradeRqmtConfirm();
                copyData = data;
                tradeRqmtConfirmCacheCopy.Add(copyData);
            }
        }
예제 #3
0
        public Int32 Update(TradeRqmtConfirm pData)
        {
            string updateSql = DBUtils.SCHEMA_NAME + "PKG_RQMT_CONFIRM$p_update_rqmt_confirm";
            Int32 rowsUpdated = 0;
            
            using (SqlConnection conn = new SqlConnection(sqlConnStr))
            {
                using (SqlCommand cmd = new SqlCommand(updateSql, conn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.Add("@p_id", System.Data.SqlDbType.Int).Value = pData.Id;
                    cmd.Parameters.Add("@p_rqmt_id", System.Data.SqlDbType.Int).Value = pData.RqmtId;
                    cmd.Parameters.Add("@p_trade_id", System.Data.SqlDbType.Int).Value = pData.TradeId;
                    cmd.Parameters.Add("@p_template_name", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.TemplateName);
                    cmd.Parameters.Add("@p_confirm_cmt", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmCmt);
                    cmd.Parameters.Add("@p_fax_telex_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexInd);
                    cmd.Parameters.Add("@p_fax_telex_number", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexNumber);
                    cmd.Parameters.Add("@p_confirm_label", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmLabel);
                    cmd.Parameters.Add("@p_next_status_code", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.NextStatusCode);
                    cmd.Parameters.Add("@p_active_flag", System.Data.SqlDbType.VarChar).Value = pData.ActiveFlag;

                    conn.Open();
                    rowsUpdated = cmd.ExecuteNonQuery();
                }
            }
            return rowsUpdated;
        }
예제 #4
0
        public void Test_TradeRqmtConfirmDal()
        {
            messageSeqNo = 0;
            TradeRqmtConfirmDal tradeRqmtConfirmDal = new TradeRqmtConfirmDal(sqlConnectionString);
            List<TradeRqmtConfirm> rqmtConfirmDataList = new List<TradeRqmtConfirm>();
            rqmtConfirmDataList = tradeRqmtConfirmDal.GetAll();
            expectedCount = 2;
            actualCount = rqmtConfirmDataList.Count;
            Assert.AreEqual(expectedCount, actualCount, "Selected list count.");

            TradeRqmtConfirm trcData = new TradeRqmtConfirm();
            trcData.Id = 9;
            trcData.RqmtId = 10;
            trcData.TradeId = 15;
            trcData.TemplateName = "";
            trcData.ConfirmCmt = "Test...";
            trcData.FaxTelexInd = "";
            trcData.FaxTelexNumber = "";
            trcData.ConfirmLabel = "CONFIRM";
            trcData.NextStatusCode = "";
            trcData.ActiveFlag = "Y";


            tradeRqmtConfirmDal.Update(trcData);
        }
예제 #5
0
        public Int32 Insert(TradeRqmtConfirm pData)
        {
            string updateSql = DBUtils.SCHEMA_NAME + "PKG_RQMT_CONFIRM$p_insert_rqmt_confirm";
            Int32 rowsInserted = 0;
            Int32 seqNo = 0;
            string seqName = "SEQ_TRADE_RQMT_CONFIRM";
            seqNo = DBUtils.GetNextSequence(sqlConnStr, seqName);

            using (SqlConnection conn = new SqlConnection(sqlConnStr))
            {
                using (SqlCommand cmd = new SqlCommand(updateSql, conn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.Add("@p_id", System.Data.SqlDbType.Int).Value = seqNo;
                    cmd.Parameters.Add("@p_rqmt_id", System.Data.SqlDbType.Int).Value = pData.RqmtId;
                    cmd.Parameters.Add("@p_trade_id", System.Data.SqlDbType.Int).Value = pData.TradeId;
                    cmd.Parameters.Add("@p_template_name", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.TemplateName);
                    cmd.Parameters.Add("@p_confirm_cmt", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmCmt);
                    cmd.Parameters.Add("@p_fax_telex_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexInd);
                    cmd.Parameters.Add("@p_fax_telex_number", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.FaxTelexNumber);
                    cmd.Parameters.Add("@p_confirm_label", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.ConfirmLabel);
                    cmd.Parameters.Add("@p_next_status_code", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pData.NextStatusCode);
                    
                    conn.Open();
                    rowsInserted = cmd.ExecuteNonQuery();
                }
            }
            if (rowsInserted == 0)
                return rowsInserted;
            else
                return seqNo;
        }