コード例 #1
0
        protected void LoadExpDoc(BEXPORT_DOCUMETARYCOLLECTION expDoc)
        {
            if (expDoc != null)
            {
                //mainToolbar.FindItemByValue("btReview").Enabled = false;

                //var drow = dsDoc.Tables[0].Rows[0];

                #region Load Export Collection
                comboCollectionType.SelectedValue = expDoc.CollectionType;
                lblCollectionTypeName.Text = comboCollectionType.SelectedItem.Attributes["Description"];

                comboDrawerCusNo.SelectedValue = expDoc.DrawerCusNo;
                txtDrawerCusName.Text = expDoc.DrawerCusName;
                txtDrawerAddr1.Text = expDoc.DrawerAddr1;
                txtDrawerAddr2.Text = expDoc.DrawerAddr2;
                txtDrawerAddr3.Text = expDoc.DrawerAddr3;
                txtDrawerRefNo.Text = expDoc.DrawerRefNo;
                comboCollectingBankNo.SelectedValue = expDoc.CollectingBankNo;
                txtCollectingBankName.Text = expDoc.CollectingBankName;
                txtCollectingBankAddr1.Text = expDoc.CollectingBankAddr1;
                txtCollectingBankAddr2.Text = expDoc.CollectingBankAddr2;
                comboCollectingBankAcct.SelectedValue = expDoc.CollectingBankAcct;
                txtDraweeCusNo.Text = expDoc.DraweeCusNo;
                txtDraweeCusName.Text = expDoc.DraweeCusName;
                txtDraweeAddr1.Text = expDoc.DraweeAddr1;
                txtDraweeAddr2.Text = expDoc.DraweeAddr2;
                txtDraweeAddr3.Text = expDoc.DraweeAddr3;
                comboNostroCusNo.SelectedValue = expDoc.NostroCusNo;
                lblNostroCusName.Text = comboNostroCusNo.SelectedItem.Attributes["Description"];
                comboCreditCurrency.SelectedValue = expDoc.Currency;
                comboCurrency.SelectedValue = expDoc.Currency;
                loadNostroAccount();
                LoadCreditAccount();
                numAmount.Value = expDoc.Amount;
                txtTenor.Text = expDoc.Tenor;
                numReminderDays.Text = (expDoc.ReminderDays??0).ToString();

                comboCommodity.SelectedValue = expDoc.Commodity;
                txtCommodityName.Text = comboCommodity.SelectedItem.Attributes["Name2"];

                comboDocsCode1.SelectedValue = expDoc.DocsCode1;
                numNoOfOriginals1.Text = (expDoc.NoOfOriginals1??0).ToString();
                numNoOfCopies1.Text = (expDoc.NoOfCopies1??0).ToString();

                comboDocsCode2.SelectedValue = expDoc.DocsCode2;
                numNoOfOriginals2.Text = (expDoc.NoOfOriginals2 ?? 0).ToString();
                numNoOfCopies2.Text = (expDoc.NoOfCopies2 ?? 0).ToString();

                comboDocsCode3.SelectedValue = expDoc.DocsCode3;
                numNoOfOriginals3.Text = (expDoc.NoOfOriginals3 ?? 0).ToString();
                numNoOfCopies3.Text = (expDoc.NoOfCopies3 ?? 0).ToString();

                divDocsCode2.Visible = (expDoc.NoOfCopies2 ?? 0) > 0 || (expDoc.NoOfOriginals2 ?? 0) > 0;
                divDocsCode3.Visible = (expDoc.NoOfCopies3 ?? 0) > 0 || (expDoc.NoOfOriginals3 ?? 0) > 0;

                txtOtherDocs.Text = expDoc.OtherDocs;
                txtRemarks.Text = expDoc.Remarks;

                if (expDoc.DocsReceivedDate.HasValue && expDoc.DocsReceivedDate.Value != new DateTime(1900,1,1))
                {
                    dteDocsReceivedDate.SelectedDate = expDoc.DocsReceivedDate.Value;
                }
                if (expDoc.MaturityDate.HasValue && expDoc.MaturityDate.Value != new DateTime(1900, 1, 1))
                {
                    dteMaturityDate.SelectedDate = expDoc.MaturityDate.Value;
                }
                if (expDoc.TracerDate.HasValue && expDoc.TracerDate.Value != new DateTime(1900, 1, 1))
                {
                    dteTracerDate.SelectedDate = expDoc.TracerDate.Value;
                }

                comboCurrencyMt910.SelectedValue = comboCreditCurrency.SelectedValue;
                //bc.Commont.initRadComboBox(ref cboNostroAcct, "Code", "AccountNo", _entities.BSWIFTCODEs.Where(q => q.Currency.Equals(expDoc.Currency)).ToList());//
                //cboNostroAcct
                #endregion
            }
            else
            {
                comboCollectionType.SelectedValue = string.Empty;
                lblCollectionTypeName.Text = string.Empty;

                comboNostroCusNo.SelectedValue = string.Empty;
                txtDrawerCusName.Text = string.Empty;
                txtDrawerAddr1.Text = string.Empty;
                txtDrawerAddr2.Text = string.Empty;
                txtDrawerAddr3.Text = string.Empty;
                txtDrawerRefNo.Text = string.Empty;
                comboCollectingBankNo.SelectedValue = string.Empty;
                txtCollectingBankName.Text = string.Empty;
                txtCollectingBankAddr1.Text = string.Empty;
                txtCollectingBankAddr2.Text = string.Empty;
                comboCollectingBankAcct.SelectedValue = string.Empty;
                txtDraweeCusName.Text = string.Empty;
                txtDraweeAddr1.Text = string.Empty;
                txtDraweeAddr2.Text = string.Empty;
                txtDraweeAddr3.Text = string.Empty;
                comboNostroCusNo.SelectedValue = string.Empty;
                comboCurrency.SelectedValue = string.Empty;
                numAmount.Text = string.Empty;
                txtTenor.Text = "AT SIGHT";
                numReminderDays.Text = string.Empty;

                comboCommodity.SelectedValue = string.Empty;
                comboDocsCode1.SelectedValue = string.Empty;
                numNoOfOriginals1.Text = string.Empty;
                numNoOfCopies1.Text = string.Empty;

                comboDocsCode2.SelectedValue = string.Empty;
                numNoOfOriginals2.Text = string.Empty;
                numNoOfCopies2.Text = string.Empty;

                txtOtherDocs.Text = string.Empty;
                txtRemarks.Text = string.Empty;

                dteDocsReceivedDate.SelectedDate = null;
                dteMaturityDate.SelectedDate = null;
                dteTracerDate.SelectedDate = null;

            }

            //SetVisibilityByStatus(dsDoc);
        }
コード例 #2
0
 private bool CheckStatusExportDocumentCollection(BEXPORT_DOCUMETARYCOLLECTION expDoc)
 {
     if (expDoc.Status != "AUT" || expDoc.Cancel_Status == "UNA" || (expDoc.Amend_Status != null && expDoc.Amend_Status != "AUT"))
     {
         lblError.Text = "Document was not authorized";
         return false;
     }
     if (expDoc.Cancel_Status == "AUT")
     {
         lblError.Text = "Document was canceled";
         return false;
     }
     if ((expDoc.PaymentFullFlag??0) == 1)
     {
         lblError.Text = "This document was paid full";
         return false;
     }
     return true;
 }
コード例 #3
0
        protected void SaveDataAmend()
        {
            try
            {
                int AmendPreId = 0;
                string AmendNo = "";
                var Code = txtCode.Text.Trim();
                var objPreAmend = new BEXPORT_DOCUMETARYCOLLECTION();
                if (!String.IsNullOrEmpty(Code))
                {
                    if (Code.IndexOf('.') != -1)
                    {

                        var findTypeAmend = Code.Split('.');
                        if (findTypeAmend != null && findTypeAmend.Length > 0)
                        {
                            if (findTypeAmend.Length == 2)
                            {
                                var chkAmend = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => x.AmendNo == Code).FirstOrDefault();
                                //truong hop chua co
                                if (chkAmend == null)
                                {
                                    if (!String.IsNullOrEmpty(findTypeAmend[1]))
                                    {
                                        AmendPreId = int.Parse(findTypeAmend[1]) - 1;
                                    }
                                    if (AmendPreId > 0)
                                    {
                                        ///xet Amend truoc do
                                        ///
                                        AmendNo = findTypeAmend[0] + "." + AmendPreId;

                                        objPreAmend = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => x.AmendNo == AmendNo).FirstOrDefault();
                                        if (objPreAmend != null)
                                        {
                                            objPreAmend.ActiveRecordFlag = YesNo.NO;
                                        }
                                    }
                                    else
                                    {
                                        //nguoc lai update Status cho Amend goc
                                        AmendNo = findTypeAmend[0];
                                        objPreAmend = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => x.DocCollectCode == AmendNo).FirstOrDefault();
                                        if (objPreAmend != null)
                                        {
                                            objPreAmend.ActiveRecordFlag = YesNo.NO;
                                        }
                                    }
                                    _entities.SaveChanges();
                                    //them moi dong hien tai
                                    BEXPORT_DOCUMETARYCOLLECTION objInsert = new BEXPORT_DOCUMETARYCOLLECTION
                                    {
                                        DocCollectCode = findTypeAmend[0],
                                        DrawerCusNo = comboDrawerCusNo.SelectedValue,
                                        DrawerCusName = txtDrawerCusName.Text.Trim(),
                                        DrawerAddr1 = txtDrawerAddr1.Text.Trim(),
                                        DrawerAddr2 = txtDrawerAddr2.Text.Trim(),
                                        DrawerAddr3 = txtDrawerAddr3.Text.Trim(),
                                        DrawerRefNo = txtDrawerRefNo.Text.Trim(),
                                        CollectingBankNo = comboCollectingBankNo.Text,
                                        CollectingBankName = txtCollectingBankName.Text.Trim(),
                                        CollectingBankAddr1 = txtCollectingBankAddr1.Text.Trim(),
                                        CollectingBankAddr2 = txtCollectingBankAddr2.Text.Trim(),
                                        CollectingBankAddr3 = txtCollectingBankAddr3.Text.Trim(),
                                        CollectingBankAcct = comboCollectingBankAcct.SelectedValue,
                                        DraweeCusNo = txtDraweeCusNo.Text.Trim(),
                                        DraweeCusName = txtDraweeCusName.Text.Trim(),
                                        DraweeAddr1 = txtDraweeAddr1.Text.Trim(),
                                        DraweeAddr2 = txtDraweeAddr2.Text.Trim(),
                                        DraweeAddr3 = txtDraweeAddr3.Text.Trim(),
                                        DraweeAddr4 = txtDraweeAddr4.Text.Trim(),
                                        NostroCusNo = comboNostroCusNo.Text,
                                        Currency = comboCurrency.SelectedValue,
                                        Amount = numAmount.Value,
                                        DocsReceivedDate = dteDocsReceivedDate.SelectedDate,
                                        MaturityDate = dteMaturityDate.SelectedDate,
                                        Tenor = txtTenor.Text.Trim(),
                                        TracerDate = dteTracerDate.SelectedDate,
                                        Commodity = comboCommodity.SelectedValue,
                                        DocsCode1 = comboDocsCode1.SelectedValue,
                                        DocsCode2 = comboDocsCode2.SelectedValue,
                                        DocsCode3 = comboDocsCode3.SelectedValue,
                                        OtherDocs = txtOtherDocs.Text.Trim(),
                                        Remarks = txtRemarks.Text.Trim(),
                                        Remarks1 = txtRemarks1.Text.Trim(),
                                        Remarks2 = txtRemarks2.Text.Trim(),
                                        Remarks3 = txtRemarks3.Text.Trim(),
                                        CreateDate = DateTime.Now,
                                        CreateBy = UserId.ToString(),
                                        CollectionType = comboCollectionType.SelectedValue,
                                        CancelDate = dteCancelDate.SelectedDate,
                                        ContingentExpiryDate = dteContingentExpiryDate.SelectedDate,
                                        CancelRemark = txtCancelRemark.Text.Trim(),
                                        Accountofficer = comboAccountOfficer.SelectedValue,
                                        AcceptedDate = dtAcceptDate.SelectedDate,
                                        AcceptedRemarks = txtAcceptREmark.Text.Trim(),
                                        //Amend
                                        Amend_Status = "UNA",
                                        AmendBy = UserId.ToString(),
                                        AmendNo = txtCode.Text,
                                        RefAmendNo = findTypeAmend[0],
                                        ActiveRecordFlag=YesNo.YES,
                                        Status="AUT"

                                        //
                                    };
                                    if (objPreAmend != null)
                                    {

                                        objInsert.OldAmount = objPreAmend.Amount;
                                        objInsert.OldDocsReceivedDate = objPreAmend.OldDocsReceivedDate;
                                    }
                                    if (!String.IsNullOrEmpty(findTypeAmend[1]))
                                    {
                                        objInsert.AmendId = int.Parse(findTypeAmend[1]);
                                    }
                                    if (!String.IsNullOrEmpty(numReminderDays.Value.ToString()))
                                    {
                                        objInsert.ReminderDays = long.Parse(numReminderDays.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals1.Value.ToString()))
                                    {
                                        objInsert.NoOfOriginals1 = int.Parse(numNoOfOriginals1.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies1.Value.ToString()))
                                    {
                                        objInsert.NoOfCopies1 = int.Parse(numNoOfCopies1.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals2.Value.ToString()))
                                    {
                                        objInsert.NoOfOriginals2 = int.Parse(numNoOfOriginals2.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies2.Value.ToString()))
                                    {
                                        objInsert.NoOfCopies2 = int.Parse(numNoOfCopies2.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals3.Value.ToString()))
                                    {
                                        objInsert.NoOfOriginals3 = int.Parse(numNoOfOriginals3.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies3.Value.ToString()))
                                    {
                                        objInsert.NoOfCopies3 = int.Parse(numNoOfCopies3.Value.ToString());
                                    }
                                    _entities.BEXPORT_DOCUMETARYCOLLECTION.Add(objInsert);
                                    _entities.SaveChanges();
                                }
                                else
                                {
                                    chkAmend.DocCollectCode = findTypeAmend[0];
                                    chkAmend.DrawerCusNo = comboDrawerCusNo.SelectedValue;
                                    chkAmend.DrawerCusName = txtDrawerCusName.Text.Trim();
                                    chkAmend.DrawerAddr1 = txtDrawerAddr1.Text.Trim();
                                    chkAmend.DrawerAddr2 = txtDrawerAddr2.Text.Trim();
                                    chkAmend.DrawerAddr3 = txtDrawerAddr3.Text.Trim();
                                    chkAmend.DrawerRefNo = txtDrawerRefNo.Text.Trim();
                                    chkAmend.CollectingBankNo = comboCollectingBankNo.Text;
                                    chkAmend.CollectingBankName = txtCollectingBankName.Text.Trim();
                                    chkAmend.CollectingBankAddr1 = txtCollectingBankAddr1.Text.Trim();
                                    chkAmend.CollectingBankAddr2 = txtCollectingBankAddr2.Text.Trim();
                                    chkAmend.CollectingBankAddr3 = txtCollectingBankAddr3.Text.Trim();
                                    chkAmend.CollectingBankAcct = comboCollectingBankAcct.SelectedValue;
                                    chkAmend.DraweeCusNo = txtDraweeCusNo.Text.Trim();
                                    chkAmend.DraweeCusName = txtDraweeCusName.Text.Trim();
                                    chkAmend.DraweeAddr1 = txtDraweeAddr1.Text.Trim();
                                    chkAmend.DraweeAddr2 = txtDraweeAddr2.Text.Trim();
                                    chkAmend.DraweeAddr3 = txtDraweeAddr3.Text.Trim();
                                    chkAmend.DraweeAddr4 = txtDraweeAddr4.Text.Trim();
                                    chkAmend.NostroCusNo = comboNostroCusNo.Text;
                                    chkAmend.Currency = comboCurrency.SelectedValue;
                                    chkAmend.Amount = numAmount.Value;
                                    chkAmend.DocsReceivedDate = dteDocsReceivedDate.SelectedDate;
                                    chkAmend.MaturityDate = dteMaturityDate.SelectedDate;
                                    chkAmend.Tenor = txtTenor.Text.Trim();
                                    chkAmend.TracerDate = dteTracerDate.SelectedDate;
                                    chkAmend.Commodity = comboCommodity.SelectedValue;
                                    chkAmend.DocsCode1 = comboDocsCode1.SelectedValue;
                                    chkAmend.DocsCode2 = comboDocsCode2.SelectedValue;
                                    chkAmend.DocsCode3 = comboDocsCode3.SelectedValue;
                                    chkAmend.OtherDocs = txtOtherDocs.Text.Trim();
                                    chkAmend.Remarks = txtRemarks.Text.Trim();
                                    chkAmend.Remarks1 = txtRemarks1.Text.Trim();
                                    chkAmend.Remarks2 = txtRemarks2.Text.Trim();
                                    chkAmend.Remarks3 = txtRemarks3.Text.Trim();
                                    chkAmend.UpdatedBy = UserId.ToString();
                                    chkAmend.UpdatedDate = DateTime.Now;
                                    chkAmend.CollectionType = comboCollectionType.SelectedValue;
                                    chkAmend.CancelDate = dteCancelDate.SelectedDate;
                                    chkAmend.ContingentExpiryDate = dteContingentExpiryDate.SelectedDate;
                                    chkAmend.CancelRemark = txtCancelRemark.Text.Trim();
                                    chkAmend.Accountofficer = comboAccountOfficer.SelectedValue;
                                    chkAmend.AcceptedDate = dtAcceptDate.SelectedDate;
                                    chkAmend.AcceptedRemarks = txtAcceptREmark.Text.Trim();
                                    //Amend
                                    chkAmend.Amend_Status = "UNA";
                                    chkAmend.AmendBy = UserId.ToString();
                                    chkAmend.AmendNo = txtCode.Text;
                                    chkAmend.RefAmendNo = findTypeAmend[0];
                                    chkAmend.Status = "AUT";
                                    if (!String.IsNullOrEmpty(findTypeAmend[1]))
                                    {
                                        chkAmend.AmendId = int.Parse(findTypeAmend[1]);
                                    }
                                    if (!String.IsNullOrEmpty(numReminderDays.Value.ToString()))
                                    {
                                        chkAmend.ReminderDays = long.Parse(numReminderDays.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals1.Value.ToString()))
                                    {
                                        chkAmend.NoOfOriginals1 = int.Parse(numNoOfOriginals1.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies1.Value.ToString()))
                                    {
                                        chkAmend.NoOfCopies1 = int.Parse(numNoOfCopies1.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals2.Value.ToString()))
                                    {
                                        chkAmend.NoOfOriginals2 = int.Parse(numNoOfOriginals2.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies2.Value.ToString()))
                                    {
                                        chkAmend.NoOfCopies2 = int.Parse(numNoOfCopies2.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfOriginals3.Value.ToString()))
                                    {
                                        chkAmend.NoOfOriginals3 = int.Parse(numNoOfOriginals3.Value.ToString());
                                    }
                                    if (!String.IsNullOrEmpty(numNoOfCopies3.Value.ToString()))
                                    {
                                        chkAmend.NoOfCopies3 = int.Parse(numNoOfCopies3.Value.ToString());
                                    }
                                    _entities.SaveChanges();
                                }
                                //save phan Charge
                                var name = findTypeAmend[0];
                                var lstCharge = _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Where(x => x.DocCollectCode == name && x.TabId == TabId).ToList();
                                //truong hop da co -->update
                                if (lstCharge != null && lstCharge.Count > 0)
                                {
                                    String[] chargeCode = { "EC.AMEND", "EC.CABLE", "EC.COURIER", "EC.OTHER" };
                                    var listChargeCode = chargeCode.ToList();
                                    foreach (var item in lstCharge)
                                    {
                                        if (item.Chargecode == "EC.AMEND")
                                        {
                                            listChargeCode.Remove(item.Chargecode);
                                            item.DocCollectCode = findTypeAmend[0];
                                            item.WaiveCharges = comboWaiveCharges.SelectedValue;
                                            item.Chargecode = tbChargeCode.SelectedValue;
                                            item.ChargeAcct = rcbChargeAcct.SelectedValue;
                                            item.ChargeCcy = rcbChargeCcy.SelectedValue;
                                            if (!String.IsNullOrEmpty(tbChargeAmt.Value.ToString()))
                                            {
                                                item.ChargeAmt = decimal.Parse(tbChargeAmt.Value.ToString());
                                            }
                                            item.PartyCharged = rcbPartyCharged.SelectedValue;
                                            item.OmortCharges = rcbOmortCharge.SelectedValue;
                                            item.ChargeStatus = rcbChargeStatus.SelectedValue;
                                            item.ChargeRemarks = tbChargeRemarks.Text.Trim();
                                            item.VATNo = tbVatNo.Text;
                                            item.TaxCode = lblTaxCode.Text;
                                            item.TaxAmt = lblTaxAmt.Text;
                                            item.Rowchages = "1";
                                            item.TabId = TabId;
                                            item.AmendNo = Code;
                                            if(!String.IsNullOrEmpty(findTypeAmend[1].ToString()))
                                            {
                                                item.AmendId = int.Parse(findTypeAmend[1].ToString());
                                            }
                                        }
                                        else if (item.Chargecode == "EC.CABLE")
                                        {
                                            listChargeCode.Remove(item.Chargecode);
                                            item.DocCollectCode = findTypeAmend[0];
                                            item.WaiveCharges = comboWaiveCharges.SelectedValue;
                                            item.Chargecode = tbChargeCode2.SelectedValue;
                                            item.ChargeAcct = rcbChargeAcct2.SelectedValue;
                                            item.ChargeCcy = rcbChargeCcy2.SelectedValue;
                                            if (!String.IsNullOrEmpty(tbChargeAmt2.Value.ToString()))
                                            {
                                                item.ChargeAmt = decimal.Parse(tbChargeAmt2.Value.ToString());
                                            }
                                            item.PartyCharged = rcbPartyCharged2.SelectedValue;
                                            item.OmortCharges = rcbOmortCharge2.SelectedValue;
                                            item.ChargeStatus = rcbChargeStatus2.SelectedValue;
                                            item.ChargeRemarks = tbChargeRemarks.Text.Trim();
                                            item.VATNo = tbVatNo.Text;
                                            item.TaxCode = lblTaxCode2.Text;
                                            item.TaxAmt = lblTaxAmt2.Text;
                                            item.Rowchages = "2";
                                            item.TabId = TabId;
                                            item.AmendNo = Code;
                                            if (!String.IsNullOrEmpty(findTypeAmend[1].ToString()))
                                            {
                                                item.AmendId = int.Parse(findTypeAmend[1].ToString());
                                            }
                                        }
                                        else if (item.Chargecode == "EC.COURIER")
                                        {
                                            listChargeCode.Remove(item.Chargecode);
                                            item.DocCollectCode = findTypeAmend[0];
                                            item.WaiveCharges = comboWaiveCharges.SelectedValue;
                                            item.Chargecode = tbChargeCode3.SelectedValue;
                                            item.ChargeAcct = rcbChargeAcct3.SelectedValue;
                                            item.ChargeCcy = rcbChargeCcy3.SelectedValue;
                                            if (!String.IsNullOrEmpty(tbChargeAmt3.Value.ToString()))
                                            {
                                                item.ChargeAmt = decimal.Parse(tbChargeAmt3.Value.ToString());
                                            }
                                            item.PartyCharged = rcbPartyCharged3.SelectedValue;
                                            item.OmortCharges = rcbOmortCharge3.SelectedValue;
                                            item.ChargeStatus = rcbChargeStatus3.SelectedValue;
                                            item.ChargeRemarks = tbChargeRemarks.Text.Trim();
                                            item.VATNo = tbVatNo.Text;
                                            item.TaxCode = lblTaxCode3.Text;
                                            item.TaxAmt = lblTaxAmt3.Text;
                                            item.Rowchages = "3";
                                            item.TabId = TabId;
                                            item.AmendNo = Code;
                                            if (!String.IsNullOrEmpty(findTypeAmend[1].ToString()))
                                            {
                                                item.AmendId = int.Parse(findTypeAmend[1].ToString());
                                            }
                                        }
                                        else if (item.Chargecode == "EC.OTHER")
                                        {
                                            listChargeCode.Remove(item.Chargecode);
                                            item.DocCollectCode = findTypeAmend[0];
                                            item.WaiveCharges = comboWaiveCharges.SelectedValue;
                                            item.Chargecode = tbChargeCode4.SelectedValue;
                                            item.ChargeAcct = rcbChargeAcct4.SelectedValue;
                                            item.ChargeCcy = rcbChargeCcy4.SelectedValue;
                                            if (!String.IsNullOrEmpty(tbChargeAmt4.Value.ToString()))
                                            {
                                                item.ChargeAmt = decimal.Parse(tbChargeAmt4.Value.ToString());
                                            }
                                            item.PartyCharged = rcbPartyCharged4.SelectedValue;
                                            item.OmortCharges = rcbOmortCharge4.SelectedValue;
                                            item.ChargeStatus = rcbChargeStatus4.SelectedValue;
                                            item.ChargeRemarks = tbChargeRemarks.Text.Trim();
                                            item.VATNo = tbVatNo.Text;
                                            item.TaxCode = lblTaxCode4.Text;
                                            item.TaxAmt = lblTaxAmt4.Text;
                                            item.Rowchages = "4";
                                            item.TabId = TabId;
                                        }
                                        _entities.SaveChanges();
                                    }

                                    //in case new charge code is added to existing item, add it to DB
                                    if (listChargeCode.Count > 0)
                                    {
                                        foreach (String item in listChargeCode)
                                        {
                                            var objCharge = addNewChagre(item, Code, findTypeAmend);
                                            _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Add(objCharge);
                                            _entities.SaveChanges();
                                        }
                                    }
                                }

                                else
                                {

                                    var objCharge = addNewChagre("EC.AMEND", Code, findTypeAmend);
                                    _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Add(objCharge);
                                    _entities.SaveChanges();

                                    objCharge = addNewChagre("EC.CABLE", Code, findTypeAmend);
                                    _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Add(objCharge);
                                    _entities.SaveChanges();

                                    objCharge = addNewChagre("EC.COURIER", Code, findTypeAmend);
                                    _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Add(objCharge);
                                    _entities.SaveChanges();

                                    objCharge = addNewChagre("EC.OTHER", Code, findTypeAmend);
                                    _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Add(objCharge);
                                    _entities.SaveChanges();
                                }
                            }
                        }
                    }
                }
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException dbEX)
            {
                Exception raise = dbEX;
                foreach (var validationError in dbEX.EntityValidationErrors)
                {
                    string message = string.Format("{0}:{1}", validationError.Entry.Entity.ToString(), validationError.ValidationErrors);
                    raise = new InvalidOperationException(message, raise);
                }
                throw raise;
            }
        }
コード例 #4
0
        //load phan thong tin amend
        private void LoadExportDocAmend()
        {
            try
            {
                var Code = CodeId;
                if (Code != null)
                {
                    //nhap vao khong co dau .
                    if (Code.IndexOf('.') == -1)
                    {
                        var objAmend = new BEXPORT_DOCUMETARYCOLLECTION();
                        var lstDoc = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => (x.DocCollectCode == Code)).ToList();
                        if (lstDoc != null && lstDoc.Count > 0)
                        {

                            objAmend = lstDoc.Where(x => (x.ActiveRecordFlag == null || x.ActiveRecordFlag == YesNo.YES) && (x.Amend_Status == "UNA" || x.Amend_Status == "REV")).FirstOrDefault();
                            if (objAmend != null)
                            {
                                var objCharge = _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Where(x => x.DocCollectCode == objAmend.DocCollectCode).ToList();
                                LoadDataForAmend(objAmend, objCharge);
                                txtCode.Text = objAmend.AmendNo;
                                _exportCollection = new BEXPORT_DOCUMETARYCOLLECTION();
                                _exportCollection = objAmend;
                            }
                            else
                            {
                                //truong hop chua co
                                var maxAmendId = lstDoc.Max(x => x.AmendId);
                                if (maxAmendId == null)
                                {
                                    maxAmendId = 1;
                                }
                                else
                                {
                                    maxAmendId = maxAmendId + 1;
                                }
                                var code = CodeId;
                                var ctnAmend = lstDoc.Where(x => (x.ActiveRecordFlag == null || x.ActiveRecordFlag == YesNo.YES)).FirstOrDefault();
                                if (ctnAmend != null)
                                {
                                    _exportCollection = new BEXPORT_DOCUMETARYCOLLECTION();
                                    _exportCollection = ctnAmend;

                                    var objCharge = new List<BEXPORT_DOCUMETARYCOLLECTIONCHARGES>();
                                    LoadDataForAmend(ctnAmend, objCharge);
                                }
                                RadToolBar1.FindItemByValue("btSave").Enabled = true;
                                txtCode.Text = code + "." + maxAmendId;
                                //
                            }
                        }
                    }
                    else
                    {
                        var lstDoc = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => x.AmendNo == Code).FirstOrDefault();
                        if (lstDoc != null)
                        {
                            var objCharge = _entities.BEXPORT_DOCUMETARYCOLLECTIONCHARGES.Where(x => x.DocCollectCode == lstDoc.DocCollectCode && x.AmendNo == Code).ToList();
                            LoadDataForAmend(lstDoc, objCharge);
                            txtCode.Text = lstDoc.AmendNo;
                            _exportCollection = new BEXPORT_DOCUMETARYCOLLECTION();
                            _exportCollection = lstDoc;
                        }
                        else
                        {
                            lblError.Text = "This Amend ID was not found";
                        }
                    }
                }
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException dbEX)
            {
                Exception raise = dbEX;
                foreach (var validationError in dbEX.EntityValidationErrors)
                {
                    string message = string.Format("{0}:{1}", validationError.Entry.Entity.ToString(), validationError.ValidationErrors);
                    raise = new InvalidOperationException(message, raise);
                }
                lblError.Text = raise.Message;
                throw raise;
            }
        }
コード例 #5
0
        protected void LoadDataForAmend(BEXPORT_DOCUMETARYCOLLECTION obj, List<BEXPORT_DOCUMETARYCOLLECTIONCHARGES> lstCharge)
        {
            try
            {
                if (obj != null)
                {
                    RadToolBar1.FindItemByValue("btReview").Enabled = false;

                    if (!String.IsNullOrEmpty(obj.OldAmount.ToString()))
                    {
                        AmountOld = double.Parse(obj.OldAmount.ToString());
                    }
                    if (!String.IsNullOrEmpty(obj.Amount.ToString()))
                    {
                        Amount = double.Parse(obj.Amount.ToString());
                    }

                    /*
                     * If this is first time Amend data, old amount will be 0
                     * In that case, show old amount as original amount
                     */
                    if (0 == AmountOld)
                    {
                        AmountOld = Amount;
                    }

                    // DocumentaryCollectionCancel
                    if (!string.IsNullOrEmpty(obj.CancelDate.ToString()) && obj.CancelDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dteCancelDate.SelectedDate = DateTime.Parse(obj.CancelDate.ToString());
                    }
                    if (!string.IsNullOrEmpty(obj.ContingentExpiryDate.ToString()) && obj.ContingentExpiryDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dteContingentExpiryDate.SelectedDate = DateTime.Parse(obj.ContingentExpiryDate.ToString());
                    }

                    if (string.IsNullOrEmpty(obj.Cancel_Status))
                    {
                        dteCancelDate.SelectedDate = DateTime.Now;
                        dteContingentExpiryDate.SelectedDate = DateTime.Now;
                    }

                    txtCancelRemark.Text = obj.CancelRemark;

                    // Outgoing Document Acception
                    if (!string.IsNullOrEmpty(obj.AcceptedDate.ToString()) && obj.AcceptedDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dtAcceptDate.SelectedDate = DateTime.Parse(obj.AcceptedDate.ToString());
                    }

                    if (string.IsNullOrEmpty(obj.AcceptStatus))
                    {
                        dtAcceptDate.SelectedDate = DateTime.Now;
                    }

                    txtAcceptREmark.Text = obj.AcceptedRemarks;

                    ///////////////////////////////////////
                    // CC
                    if (obj.CollectionType == "CC")
                    {
                        comboCollectionType.Items.Clear();
                        comboCollectionType.DataValueField = "ID";
                        comboCollectionType.DataTextField = "ID";
                        comboCollectionType.DataSource = bd.SQLData.CreateGenerateDatas("DocumetaryCleanCollection_TabMain_CollectionType");
                        comboCollectionType.DataBind();
                        divCollectionType.Visible = false;
                        divDocsCode.Visible = false;
                        divDocsCode2.Visible = false;
                        divDocsCode3.Visible = false;

                    }
                    // end cc
                    comboCollectionType.SelectedValue = obj.CollectionType;
                    lblCollectionTypeName.Text = comboCollectionType.SelectedItem.Attributes["Description"];

                    comboAccountOfficer.SelectedValue = obj.Accountofficer;
                    comboDrawerCusNo.SelectedValue = obj.DrawerCusNo;
                    txtDrawerCusName.Text = obj.DrawerCusName;
                    txtDrawerAddr1.Text = obj.DrawerAddr1;
                    txtDrawerAddr2.Text = obj.DrawerAddr2;
                    txtDrawerAddr3.Text = obj.DrawerAddr3;
                    txtDrawerRefNo.Text = obj.DrawerRefNo;
                    comboCollectingBankNo.Text = obj.CollectingBankNo;
                    txtCollectingBankName.Text = obj.CollectingBankName;
                    txtCollectingBankAddr1.Text = obj.CollectingBankAddr1;
                    txtCollectingBankAddr2.Text = obj.CollectingBankAddr2;
                    comboCollectingBankAcct.SelectedValue = obj.CollectingBankAcct;
                    txtDraweeCusNo.Text = obj.DraweeCusNo;
                    txtDraweeCusName.Text = obj.DraweeCusName;
                    txtDraweeAddr1.Text = obj.DraweeAddr1;
                    txtDraweeAddr2.Text = obj.DraweeAddr2;
                    txtDraweeAddr3.Text = obj.DraweeAddr3;
                    txtDraweeAddr4.Text = obj.DraweeAddr4;
                    comboNostroCusNo.Text = obj.NostroCusNo;
                    loadNostroDes();
                    //lblNostroCusName.Text = comboNostroCusNo.SelectedItem.Attributes["Description"];
                    comboCurrency.SelectedValue = obj.Currency;
                    numAmount.Value = Amount;
                    lblAmount_New.Text = AmountOld.ToString("C");
                    txtTenor.Text = obj.Tenor;
                    numReminderDays.Text = obj.ReminderDays.ToString();

                    comboCommodity.SelectedValue = obj.Commodity;
                    //txtCommodityName.Text = comboCommodity.SelectedItem.Attributes["Name2;

                    comboDocsCode1.SelectedValue = obj.DocsCode1;
                    numNoOfOriginals1.Text = obj.NoOfOriginals1.ToString();
                    numNoOfCopies1.Text = obj.NoOfCopies1.ToString();

                    comboDocsCode2.SelectedValue = obj.DocsCode2;
                    numNoOfOriginals2.Text = obj.NoOfOriginals2.ToString();
                    numNoOfCopies2.Text = obj.NoOfCopies2.ToString();

                    comboDocsCode3.SelectedValue = obj.DocsCode3;
                    numNoOfOriginals3.Text = obj.NoOfOriginals3.ToString();
                    numNoOfCopies3.Text = obj.NoOfCopies3.ToString();

                    if ((!string.IsNullOrWhiteSpace(obj.NoOfOriginals2.ToString()) &&
                         int.Parse(obj.NoOfOriginals2.ToString()) > 0) ||
                        (!string.IsNullOrWhiteSpace(obj.NoOfCopies2.ToString()) &&
                         int.Parse(obj.NoOfCopies2.ToString()) > 0))
                    {
                        divDocsCode2.Visible = true;
                    }
                    if ((!string.IsNullOrWhiteSpace(obj.NoOfOriginals3.ToString()) &&
                         int.Parse(obj.NoOfOriginals3.ToString()) > 0) ||
                        (!string.IsNullOrWhiteSpace(obj.NoOfCopies3.ToString()) &&
                         int.Parse(obj.NoOfCopies3.ToString()) > 0))
                    {
                        divDocsCode3.Visible = true;
                    }

                    txtOtherDocs.Text = obj.OtherDocs;
                    txtRemarks.Text = obj.Remarks;
                    txtRemarks1.Text = obj.Remarks1;
                    txtRemarks2.Text = obj.Remarks2;
                    txtRemarks3.Text = obj.Remarks3;

                    if (!string.IsNullOrEmpty(obj.DocsReceivedDate.ToString()) && obj.DocsReceivedDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dteDocsReceivedDate.SelectedDate = DateTime.Parse(obj.DocsReceivedDate.ToString());
                    }
                    if (!string.IsNullOrEmpty(obj.MaturityDate.ToString()) && obj.MaturityDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dteMaturityDate.SelectedDate = DateTime.Parse(obj.MaturityDate.ToString());
                    }
                    if (!string.IsNullOrEmpty(obj.TracerDate.ToString()) && obj.TracerDate.ToString().IndexOf("1/1/1900") == -1)
                    {
                        dteTracerDate.SelectedDate = DateTime.Parse(obj.TracerDate.ToString());
                    }
                }
                else
                {
                    comboCollectionType.SelectedValue = string.Empty;
                    lblCollectionTypeName.Text = string.Empty;

                    comboNostroCusNo.Text = string.Empty;
                    txtDrawerCusName.Text = string.Empty;
                    txtDrawerAddr1.Text = string.Empty;
                    txtDrawerAddr2.Text = string.Empty;
                    txtDrawerAddr3.Text = string.Empty;
                    txtDrawerRefNo.Text = string.Empty;
                    comboCollectingBankNo.Text = string.Empty;
                    txtCollectingBankName.Text = string.Empty;
                    txtCollectingBankAddr1.Text = string.Empty;
                    txtCollectingBankAddr2.Text = string.Empty;
                    comboCollectingBankAcct.SelectedValue = string.Empty;
                    txtDraweeCusName.Text = string.Empty;
                    txtDraweeAddr1.Text = string.Empty;
                    txtDraweeAddr2.Text = string.Empty;
                    txtDraweeAddr3.Text = string.Empty;
                    txtDraweeAddr4.Text = string.Empty;
                    comboNostroCusNo.Text = string.Empty;
                    lblNostroCusName.Text = string.Empty;
                    comboCurrency.SelectedValue = string.Empty;
                    numAmount.Text = string.Empty;
                    txtTenor.Text = "AT SIGHT";
                    numReminderDays.Text = string.Empty;

                    comboCommodity.SelectedValue = string.Empty;
                    comboDocsCode1.SelectedValue = string.Empty;
                    numNoOfOriginals1.Text = string.Empty;
                    numNoOfCopies1.Text = string.Empty;

                    comboDocsCode2.SelectedValue = string.Empty;
                    numNoOfOriginals2.Text = string.Empty;
                    numNoOfCopies2.Text = string.Empty;

                    txtOtherDocs.Text = string.Empty;
                    txtRemarks.Text = string.Empty;
                    txtRemarks1.Text = string.Empty;
                    txtRemarks2.Text = string.Empty;
                    txtRemarks3.Text = string.Empty;

                    dteDocsReceivedDate.SelectedDate = null;
                    dteMaturityDate.SelectedDate = null;
                    dteTracerDate.SelectedDate = null;

                    Cal_TracerDate(false);
                }
                //khong load tab charge
                foreach (var item in lstCharge)
                {
                    if (item.Chargecode == "EC.AMEND")
                    {
                        comboWaiveCharges.SelectedValue = item.WaiveCharges;
                        rcbChargeAcct.SelectedValue = item.ChargeAcct;
                        //tbChargePeriod.Text = item.ChargePeriod;
                        rcbChargeCcy.SelectedValue = item.ChargeCcy;
                        if (!string.IsNullOrEmpty(rcbChargeCcy.SelectedValue))
                        {
                            LoadChargeAcct();
                        }
                        //tbExcheRate.Text = item.ExchRate;
                        tbChargeAmt.Text = item.ChargeAmt.ToString();
                        rcbPartyCharged.SelectedValue = item.PartyCharged;
                        rcbOmortCharge.SelectedValue = item.OmortCharges;
                        rcbChargeStatus.SelectedValue = item.ChargeStatus;
                        lblChargeStatus.Text = item.ChargeStatus;

                        tbChargeRemarks.Text = item.ChargeRemarks;
                        tbVatNo.Text = item.VATNo;
                        lblTaxCode.Text = item.TaxCode;
                        //lblTaxCcy.Text = item.TaxCcy;
                        lblTaxAmt.Text = item.TaxAmt;
                        tbChargeCode.SelectedValue = item.Chargecode;
                        ChargeAmount += ConvertStringToFloat(item.ChargeAmt.ToString());
                    }
                    else if (item.Chargecode == "EC.CABLE")
                    {
                        rcbChargeAcct2.SelectedValue = item.ChargeAcct;

                        rcbChargeCcy2.SelectedValue = item.ChargeCcy;
                        if (!string.IsNullOrEmpty(rcbChargeCcy2.SelectedValue))
                        {
                            LoadChargeAcct2();
                        }

                        tbChargeAmt2.Text = item.ChargeAmt.ToString();
                        rcbPartyCharged2.SelectedValue = item.PartyCharged;
                        rcbChargeStatus2.SelectedValue = item.ChargeStatus;
                        lblChargeStatus2.Text = item.ChargeStatus;

                        lblTaxCode2.Text = item.TaxCode;
                        lblTaxAmt2.Text = item.TaxAmt;

                        tbChargeCode2.SelectedValue = item.Chargecode;
                        ChargeAmount += ConvertStringToFloat(item.ChargeAmt.ToString());
                    }
                    else if (item.Chargecode == "EC.COURIER")
                    {
                        rcbChargeAcct3.SelectedValue = item.ChargeAcct;

                        rcbChargeCcy3.SelectedValue = item.ChargeCcy;
                        if (!string.IsNullOrEmpty(rcbChargeCcy3.SelectedValue))
                        {
                            LoadChargeAcct3();
                        }

                        tbChargeAmt3.Text = item.ChargeAmt.ToString();
                        rcbPartyCharged3.SelectedValue = item.PartyCharged;
                        //lblPartyCharged3.Text = item.PartyCharged;
                        rcbChargeStatus3.SelectedValue = item.ChargeStatus;
                        //lblChargeStatus3.Text = item.ChargeStatus;

                        lblTaxCode3.Text = item.TaxCode;
                        lblTaxAmt3.Text = item.TaxAmt;

                        tbChargeCode3.SelectedValue = item.Chargecode;
                        ChargeAmount += ConvertStringToFloat(item.ChargeAmt.ToString());
                    }
                    else if (item.Chargecode == "EC.OTHER")
                    {
                        rcbChargeAcct4.SelectedValue = item.ChargeAcct;

                        rcbChargeCcy4.SelectedValue = item.ChargeCcy;
                        if (!string.IsNullOrEmpty(rcbChargeCcy4.SelectedValue))
                        {
                            LoadChargeAcct4();
                        }

                        tbChargeAmt4.Text = item.ChargeAmt.ToString();
                        rcbPartyCharged4.SelectedValue = item.PartyCharged;
                        //lblPartyCharged4.Text = item.PartyCharged;
                        rcbChargeStatus4.SelectedValue = item.ChargeStatus;
                        //lblChargeStatus3.Text = item.ChargeStatus;

                        lblTaxCode4.Text = item.TaxCode;
                        lblTaxAmt4.Text = item.TaxAmt;

                        tbChargeCode4.SelectedValue = item.Chargecode;
                        ChargeAmount += ConvertStringToFloat(item.ChargeAmt.ToString());
                    }
                }
            }
            catch (System.Data.Entity.Validation.DbEntityValidationException dbEX)
            {
                Exception raise = dbEX;
                foreach (var validationError in dbEX.EntityValidationErrors)
                {
                    string message = string.Format("{0}:{1}", validationError.Entry.Entity.ToString(), validationError.ValidationErrors);
                    raise = new InvalidOperationException(message, raise);
                }
                lblError.Text = raise.Message;
                throw raise;
            }
            //SetVisibilityByStatus(dsDoc);
        }