private void CommitData() { var ds = new BEXPORT_DOCUMENTPROCESSING(); var dr = new BEXPORT_DOCUMENTPROCESSING(); ds = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == txtCode.Text).FirstOrDefault(); if (ds == null) { dr = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == txtCode.Text).FirstOrDefault(); } var dsCharge = dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Where(x => x.LCCode == txtCode.Text).ToList(); if (dsCharge != null && dsCharge.Count > 0) { foreach (BEXPORT_DOCUMENTPROCESSINGCHARGE item in dsCharge) { dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Remove(item); } dbEntities.SaveChanges(); } if (ds == null && dr == null) { var CCode = ""; var CId = ""; if (txtCode.Text.IndexOf('.') != -1) { var code = txtCode.Text.Split('.'); CCode = code[0]; CId = code[1]; } BEXPORT_DOCUMENTPROCESSING obj = new BEXPORT_DOCUMENTPROCESSING { DrawType = comboDrawType.SelectedValue, PresentorNo = comboPresentorNo.Text, PresentorName = txtPresentorName.Text, PresentorRefNo = txtPresentorRefNo.Text, Currency = lblCurrency.Text, BookingDate = dteBookingDate.SelectedDate, DocsReceivedDate = dteDocsReceivedDate.SelectedDate, DocsCode1 = comboDocsCode1.SelectedValue, DocsCode2 = comboDocsCode2.SelectedValue, DocsCode3 = comboDocsCode3.SelectedValue, OtherDocs1 = txtOtherDocs1.Text, OtherDocs2 = txtOtherDocs2.Text, OtherDocs3 = txtOtherDocs3.Text, Discrepancies = txtDiscrepancies.Text, DisposalOfDocs = txtDisposalOfDocs.Text, TraceDate = dteTraceDate.SelectedDate, DocsReceivedDate_Supplemental = dteDocsReceivedDate_Supplemental.SelectedDate, PresentorRefNo_Supplemental = txtPresentorRefNo_Supplemental.Text, Docs_Supplemental1 = txtDocs_Supplemental1.Text, LCCode=CCode, PaymentNo = long.Parse(CId), PaymentId=txtCode.Text, Id=long.Parse(CId), DocumentType = TabId.ToString(), FullDocsAmount=txtFullDocsAmount.Value, WaiveCharges=comboWaiveCharges.SelectedValue, ChargeRemarks = tbChargeRemarks.Text, VATNo=tbVatNo.Text }; if (!String.IsNullOrEmpty(numAmount.Text)) { obj.Amount = double.Parse(numAmount.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals1.Text)) { obj.NoOfOriginals1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals2.Text)) { obj.NoOfOriginals2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals3.Text)) { obj.NoOfOriginals3 = long.Parse(numNoOfOriginals3.Text); } if (!String.IsNullOrEmpty(numNoOfCopies1.Text)) { obj.NoOfCopies1 = long.Parse(numNoOfCopies1.Text); } if (!String.IsNullOrEmpty(numNoOfCopies2.Text)) { obj.NoOfCopies2 = long.Parse(numNoOfCopies2.Text); } if (!String.IsNullOrEmpty(numNoOfCopies3.Text)) { obj.NoOfCopies3 = long.Parse(numNoOfCopies3.Text); } if (TabId == TabDocsWithNoDiscrepancies || TabId == TabDocsWithDiscrepancies) { obj.Status = "UNA"; } dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Add(obj); dbEntities.SaveChanges(); if (divCharge.Visible && comboWaiveCharges.SelectedValue.Equals("YES")) { //save tab charge BEXPORT_DOCUMENTPROCESSINGCHARGE charge = new BEXPORT_DOCUMENTPROCESSINGCHARGE { LCCode = txtCode.Text, WaiveCharges = comboWaiveCharges.SelectedValue, Chargecode = tbChargeCode.SelectedValue, ChargeAcct = rcbChargeAcct.SelectedValue, ChargePeriod = tbChargePeriod.Text, ChargeCcy = rcbChargeCcy.SelectedValue, PartyCharged = rcbPartyCharged.SelectedValue, OmortCharges = rcbOmortCharge.SelectedValue, ChargeStatus = rcbChargeStatus.SelectedValue, ChargeRemarks = tbChargeRemarks.Text, VATNo = tbVatNo.Text, TaxCode = lblTaxCode.Text, Rowchages = "1", ViewType = TabId }; if (!String.IsNullOrEmpty(lblTaxAmt.Text)) { charge.TaxAmt = double.Parse(lblTaxAmt.Text); } if (!String.IsNullOrEmpty(tbExcheRate.Text)) { charge.ExchRate = double.Parse(tbExcheRate.Text); } if (!String.IsNullOrEmpty(tbChargeAmt.Text)) { charge.ChargeAmt = double.Parse(tbChargeAmt.Text); } dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Add(charge); dbEntities.SaveChanges(); // BEXPORT_DOCUMENTPROCESSINGCHARGE charge2 = new BEXPORT_DOCUMENTPROCESSINGCHARGE { LCCode = txtCode.Text, WaiveCharges = comboWaiveCharges.SelectedValue, Chargecode = tbChargeCode2.SelectedValue, ChargeAcct = rcbChargeAcct2.SelectedValue, ChargePeriod = tbChargePeriod2.Text, ChargeCcy = rcbChargeCcy2.SelectedValue, PartyCharged = rcbPartyCharged2.SelectedValue, OmortCharges = rcbOmortCharges2.SelectedValue, ChargeStatus = rcbChargeStatus2.SelectedValue, ChargeRemarks = tbChargeRemarks.Text, VATNo = tbVatNo.Text, TaxCode = lblTaxCode.Text, Rowchages = "2", ViewType = TabId }; if (!String.IsNullOrEmpty(lblTaxAmt2.Text)) { charge2.TaxAmt = double.Parse(lblTaxAmt2.Text); } if (!String.IsNullOrEmpty(tbExcheRate2.Text)) { charge2.ExchRate = double.Parse(tbExcheRate2.Text); } if (!String.IsNullOrEmpty(tbChargeAmt2.Text)) { charge2.ChargeAmt = double.Parse(tbChargeAmt2.Text); } dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Add(charge2); dbEntities.SaveChanges(); // //kiem tra tab BEXPORT_DOCUMENTPROCESSINGCHARGE charge3 = new BEXPORT_DOCUMENTPROCESSINGCHARGE { LCCode = txtCode.Text, WaiveCharges = comboWaiveCharges.SelectedValue, Chargecode = tbChargeCode3.SelectedValue, ChargeAcct = rcbChargeAcct3.SelectedValue, ChargePeriod = tbChargePeriod3.Text, ChargeCcy = rcbChargeCcy3.SelectedValue, PartyCharged = rcbPartyCharged3.SelectedValue, OmortCharges = rcbOmortCharges3.SelectedValue, ChargeStatus = rcbChargeStatus3.SelectedValue, ChargeRemarks = tbChargeRemarks.Text, VATNo = tbVatNo.Text, TaxCode = lblTaxCode.Text, Rowchages = "3", ViewType = TabId }; if (!String.IsNullOrEmpty(lblTaxAmt3.Text)) { charge3.TaxAmt = double.Parse(lblTaxAmt3.Text); } if (!String.IsNullOrEmpty(tbExcheRate3.Text)) { charge3.ExchRate = double.Parse(tbExcheRate3.Text); } if (!String.IsNullOrEmpty(tbChargeAmt3.Text)) { charge3.ChargeAmt = double.Parse(tbChargeAmt3.Text); } dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Add(charge3); // dbEntities.SaveChanges(); } } else { if (ds != null) { if (TabId == TabDocsReject || TabId == TabDocsAccept) { if (TabId == TabDocsReject) { ds.RejectDrawType = comboDrawType.SelectedValue; ds.RejectBy = UserId.ToString(); ds.RejectStatus = TransactionStatus.UNA; ds.RejectDate = DateTime.Now; } else if (TabId == TabDocsAccept) { ds.AcceptStatus = TransactionStatus.UNA; ds.AcceptRemarts = txtAcceptRemarks.Text; ds.AcceptDrawType = comboDrawType.SelectedValue; ds.AcceptBy = UserId.ToString(); ds.AcceptDate = txtAcceptDate.SelectedDate; } dbEntities.SaveChanges(); } else { ds.DrawType = comboDrawType.SelectedValue; ds.PresentorNo = comboPresentorNo.Text; ds.PresentorName = txtPresentorName.Text; ds.PresentorRefNo = txtPresentorRefNo.Text; ds.Currency = lblCurrency.Text; ds.BookingDate = dteBookingDate.SelectedDate; ds.DocsReceivedDate = dteDocsReceivedDate.SelectedDate; ds.DocsCode1 = comboDocsCode1.SelectedValue; ds.DocsCode2 = comboDocsCode2.SelectedValue; ds.DocsCode3 = comboDocsCode3.SelectedValue; ds.OtherDocs1 = txtOtherDocs1.Text; ds.OtherDocs2 = txtOtherDocs2.Text; ds.OtherDocs3 = txtOtherDocs3.Text; ds.Discrepancies = txtDiscrepancies.Text; ds.DisposalOfDocs = txtDisposalOfDocs.Text; ds.TraceDate = dteTraceDate.SelectedDate; ds.DocsReceivedDate_Supplemental = dteDocsReceivedDate_Supplemental.SelectedDate; ds.PresentorRefNo_Supplemental = txtPresentorRefNo_Supplemental.Text; ds.Docs_Supplemental1 = txtDocs_Supplemental1.Text; ds.DocumentType = TabId.ToString(); ds.FullDocsAmount = txtFullDocsAmount.Value; ds.WaiveCharges = comboWaiveCharges.SelectedValue; ds.ChargeRemarks = tbChargeRemarks.Text; ds.VATNo = tbVatNo.Text; if (!String.IsNullOrEmpty(numAmount.Text)) { ds.Amount = double.Parse(numAmount.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals1.Text)) { ds.NoOfOriginals1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals2.Text)) { ds.NoOfOriginals2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals3.Text)) { ds.NoOfOriginals3 = long.Parse(numNoOfOriginals3.Text); } if (!String.IsNullOrEmpty(numNoOfCopies1.Text)) { ds.NoOfCopies1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfCopies2.Text)) { ds.NoOfCopies2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfCopies3.Text)) { ds.NoOfCopies3 = long.Parse(numNoOfOriginals3.Text); } if (TabId == TabDocsWithNoDiscrepancies || TabId == TabDocsWithDiscrepancies) { ds.Status = TransactionStatus.UNA; } else if (TabId == TabDocsAmend) { ds.AmendStatus = TransactionStatus.UNA; } dbEntities.SaveChanges(); } } else if (dr != null) { if (TabId == TabDocsReject || TabId == TabDocsAccept) { if (TabId == TabDocsReject) { dr.RejectDrawType = comboDrawType.SelectedValue; dr.RejectBy = UserId.ToString(); dr.RejectStatus = TransactionStatus.UNA; dr.RejectDate = DateTime.Now; } else if (TabId == TabDocsAccept) { dr.AcceptStatus = TransactionStatus.UNA; dr.AcceptRemarts = txtAcceptRemarks.Text; dr.AcceptDrawType = comboDrawType.SelectedValue; dr.AcceptBy = UserId.ToString(); dr.AcceptDate = txtAcceptDate.SelectedDate; } dbEntities.SaveChanges(); } else { dr.DrawType = comboDrawType.SelectedValue; dr.PresentorNo = comboPresentorNo.Text; dr.PresentorName = txtPresentorName.Text; dr.PresentorRefNo = txtPresentorRefNo.Text; dr.Currency = lblCurrency.Text; dr.BookingDate = dteBookingDate.SelectedDate; dr.DocsReceivedDate = dteDocsReceivedDate.SelectedDate; dr.DocsCode1 = comboDocsCode1.SelectedValue; dr.DocsCode2 = comboDocsCode2.SelectedValue; dr.DocsCode3 = comboDocsCode3.SelectedValue; dr.OtherDocs1 = txtOtherDocs1.Text; dr.OtherDocs2 = txtOtherDocs2.Text; dr.OtherDocs3 = txtOtherDocs3.Text; dr.Discrepancies = txtDiscrepancies.Text; dr.DisposalOfDocs = txtDisposalOfDocs.Text; dr.TraceDate = dteTraceDate.SelectedDate; dr.DocsReceivedDate_Supplemental = dteDocsReceivedDate_Supplemental.SelectedDate; dr.PresentorRefNo_Supplemental = txtPresentorRefNo_Supplemental.Text; dr.Docs_Supplemental1 = txtDocs_Supplemental1.Text; dr.DocumentType = TabId.ToString(); if (!String.IsNullOrEmpty(numAmount.Text)) { dr.Amount = double.Parse(numAmount.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals1.Text)) { dr.NoOfOriginals1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals2.Text)) { dr.NoOfOriginals2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals3.Text)) { dr.NoOfOriginals3 = long.Parse(numNoOfOriginals3.Text); } if (!String.IsNullOrEmpty(numNoOfCopies1.Text)) { dr.NoOfCopies1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfCopies2.Text)) { dr.NoOfCopies2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfCopies3.Text)) { dr.NoOfCopies3 = long.Parse(numNoOfOriginals3.Text); } if (TabId == TabDocsWithNoDiscrepancies || TabId == TabDocsWithDiscrepancies) { dr.Status = TransactionStatus.UNA; } else if (TabId == TabDocsAmend) { dr.AmendStatus = TransactionStatus.UNA; } dbEntities.SaveChanges(); } } } }
// protected void btnLoadDocsInfo_Click(object sender, EventArgs e) { lblError.Text = ""; if (txtCode.Text.IndexOf('.') == -1) { lblError.Text = "This Docs was not found"; } else { //bind tab charge cbo acc var lstAcc = txtCode.Text.Split('.'); if (lstAcc != null) { var name = lstAcc[0].ToString(); var bindCharge = entContext.BAdvisingAndNegotiationLCs.Where(x => x.NormalLCCode == name).FirstOrDefault(); if (bindCharge != null) { txtCustomerName.Value = bindCharge.BeneficiaryName; bc.Commont.initRadComboBox(ref tabCableCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, bindCharge.Currency)); bc.Commont.initRadComboBox(ref tabPaymentCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, bindCharge.Currency)); bc.Commont.initRadComboBox(ref tabHandlingCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, bindCharge.Currency)); bc.Commont.initRadComboBox(ref tabDiscrepenciesCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, bindCharge.Currency)); bc.Commont.initRadComboBox(ref tabOtherCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, bindCharge.Currency)); } } // var dsDetails = entContext.B_ExportLCPayments.Where(x => x.LCCode == txtCode.Text).FirstOrDefault(); if (dsDetails == null) { var lstDetails = entContext.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == txtCode.Text).ToList(); if (lstDetails == null) { lblError.Text = "This Docs was not found"; return; } else { var drDetails=new BEXPORT_DOCUMENTPROCESSING(); if (lstDetails.Count == 1) { drDetails = lstDetails[0]; } else { drDetails = lstDetails.Where(x => x.ActiveRecordFlag == YesNo.YES).FirstOrDefault(); } //kiem tra lai Status !AUT, RejectStatus if (drDetails.Status != "AUT") { lblError.Text = "This Docs has wrong Status (" + drDetails.Status + ") !"; return; } else { if (drDetails.RejectStatus != null) { if (!drDetails.RejectStatus.ToString().Equals(bd.TransactionStatus.REV) && !drDetails.RejectStatus.ToString().Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This Docs is waiting for reject !"; return; } } if (Convert.ToInt32(drDetails.PaymentFullFlag) != 0) { lblError.Text = "This Doc is already payment completed !"; return; } } // lblCurrency.Text = drDetails.Currency; if (drDetails.Amount != null) { txtDrawingAmount.Value = drDetails.Amount; } txtValueDate.SelectedDate = drDetails.BookingDate; //cboDepositAccount.SelectedValue=drDetails.a bc.Commont.initRadComboBox(ref cboNostroAcct, "Description", "AccountNo", bd.SQLData.B_BSWIFTCODE_GetByCurrency(drDetails.Currency)); txtAmountCredited.Value = 0; txtFullyUtilised.Text = bd.YesNo.NO; //MT202 lblTransactionReferenceNumber.Text = txtCode.Text; txtRelatedReference.Text = drDetails.PresentorNo; dteValueDate_MT202.SelectedDate = DateTime.Now; setCurrency(ref comboCurrency, lblCurrency.Text); numAmount.Value = txtDrawingAmount.Value; //MT756 txtSendingBankTRN.Text = txtCode.Text; txtRelatedReferenceMT400.Text = drDetails.PresentorNo; numAmountCollected.Value = txtDrawingAmount.Value; dteValueDate_MT400.SelectedDate = DateTime.Now; setCurrency(ref comboCurrency_MT400, lblCurrency.Text); numAmount_MT400.Value = txtDrawingAmount.Value; txtAmtDrFromAcct.Value = txtDrawingAmount.Value; //Charge txtVatNo.Text = bd.IssueLC.GetVatNo(); // setToolbar(1); return; } } else { //xet Status if (dsDetails.Status.ToString().Equals(bd.TransactionStatus.AUT) || dsDetails.Status.ToString().Equals(bd.TransactionStatus.REV)) { bc.Commont.SetTatusFormControls(this.Controls, false); setToolbar(0); } else { setToolbar(1); } //tab Main cboDrawType.SelectedValue = dsDetails.DrawType; lblCurrency.Text = dsDetails.Currency; if (dsDetails.WaiveCharges != null) { cboWaiveCharges.SelectedValue = dsDetails.WaiveCharges; } txtChargeRemarks.Text = dsDetails.ChargeRemarks; txtVatNo.Text = dsDetails.VATNo; if (dsDetails.DrawingAmount != null) { txtDrawingAmount.Value = dsDetails.DrawingAmount; } if (dsDetails.UpdatedDate != null) { txtValueDate.SelectedDate = dsDetails.UpdatedDate; } if (dsDetails.DepositAccount != null) { cboDepositAccount.SelectedValue = dsDetails.DepositAccount; } if (dsDetails.ExchangeRate != null) { txtExchangeRate.Value = dsDetails.ExchangeRate; } txtAmtDRFrAcctCcy.Text = dsDetails.AmtDRFrAcctCcy; if (dsDetails.ProvAmtRelease != null) { txtProvAmtRelease.Value = dsDetails.ProvAmtRelease; } txtAmtDrFromAcct.Value = txtDrawingAmount.Value; if (dsDetails.PaymentMethod != null) { cboPaymentMethod.SelectedValue = dsDetails.PaymentMethod; } if (dsDetails.NostroAcct != null) { cboNostroAcct.SelectedValue = dsDetails.NostroAcct; } if (dsDetails.AmountCredited != null) { txtAmountCredited.Value = dsDetails.AmountCredited; } txtPaymentRemarks.Text = dsDetails.PaymentRemarks; txtFullyUtilised.Text = dsDetails.FullyUtilised; //bind tab MT202 var dsMT202 = entContext.B_ExportLCPaymentMT202s.Where(x => x.PaymentCode == txtCode.Text).FirstOrDefault(); if (dsMT202 != null) { lblTransactionReferenceNumber.Text = dsMT202.TransactionReferenceNumber; txtRelatedReference.Text = dsMT202.RelatedReference; if (dsMT202.ValueDate!=null) { dteValueDate_MT202.SelectedDate = dsMT202.ValueDate; } if (dsMT202.Currency != null) { comboCurrency.SelectedValue = dsMT202.Currency; } if (dsMT202.Amount != null) { numAmount.Value = dsMT202.Amount; } lblOrderingInstitution.Text = dsMT202.OrderingInstitution; lblSenderCorrespondent1.Text = dsMT202.SenderCorrespondent1; lblSenderCorrespondent2.Text = dsMT202.SenderCorrespondent2; lblReceiverCorrespondentName2.Text = dsMT202.ReceiverCorrespondent1; if (dsMT202.IntermediaryBankType != null) { comboIntermediaryBankType.SelectedValue = dsMT202.IntermediaryBankType; } txtIntermediaryBank.Text = dsMT202.IntermediaryBank; txtIntermediaryBankName.Text = dsMT202.IntermediaryBankName; txtIntermediaryBankAddr1.Text = dsMT202.IntermediaryBankAddr1; txtIntermediaryBankAddr2.Text = dsMT202.IntermediaryBankAddr2; txtIntermediaryBankAddr3.Text = dsMT202.IntermediaryBankAddr3; if (dsMT202.AccountWithInstitutionType != null) { comboAccountWithInstitutionType.SelectedValue = dsMT202.AccountWithInstitutionType; } txtAccountWithInstitution.Text = dsMT202.AccountWithInstitution; txtAccountWithInstitutionName.Text = dsMT202.AccountWithInstitutionName; txtAccountWithInstitutionAddr1.Text = dsMT202.AccountWithInstitutionAddr1; txtAccountWithInstitutionAddr2.Text = dsMT202.AccountWithInstitutionAddr2; txtAccountWithInstitutionAddr3.Text = dsMT202.AccountWithInstitutionAddr3; if (dsMT202.BeneficiaryBankType != null) { comboBeneficiaryBankType.SelectedValue = dsMT202.BeneficiaryBankType; } txtBeneficiaryBank.Text = dsMT202.BeneficiaryBank; txtBeneficiaryBankName.Text = dsMT202.BeneficiaryBankName; txtBeneficiaryBankAddr1.Text = dsMT202.BeneficiaryBankAddr1; txtBeneficiaryBankAddr2.Text = dsMT202.BeneficiaryBankAddr2; txtBeneficiaryBankAddr3.Text = dsMT202.BeneficiaryBankAddr3; txtSenderToReceiverInformation.Text = dsMT202.SenderToReceiverInformation; txtSenderToReceiverInformation2.Text = dsMT202.SenderToReceiverInformation2; txtSenderToReceiverInformation3.Text = dsMT202.SenderToReceiverInformation3; } //tab MT756 var dsMT756 = entContext.B_ExportLCPaymentMT756s.Where(x => x.PaymentCode == txtCode.Text).FirstOrDefault(); if (dsMT756 != null) { comboCreateMT756.SelectedValue = bd.YesNo.YES; txtRelatedReferenceMT400.Text = dsMT756.RelatedReference; txtSendingBankTRN.Text = dsMT756.SendingBankTRN; if (dsMT756.AmountCollected != null) { numAmountCollected.Value = dsMT756.AmountCollected; } if (dsMT756.ValueDate != null) { dteValueDate_MT400.SelectedDate = dsMT756.ValueDate; } if (dsMT756.Currency != null) { comboCurrency_MT400.SelectedValue = dsMT756.Currency; } if (dsMT756.Amount != null) { numAmount_MT400.Value = dsMT756.Amount; } if (dsMT756.SenderCorrespondentType != null) { comboSenderCorrespondentType.SelectedValue = dsMT756.SenderCorrespondentType; } txtSenderCorrespondentNo.Text = dsMT756.SenderCorrespondentNo; txtSenderCorrespondentName.Text = dsMT756.SenderCorrespondentName; txtSenderCorrespondentAddress1.Text = dsMT756.SenderCorrespondentAddr1; txtSenderCorrespondentAddress2.Text = dsMT756.SenderCorrespondentAddr2; txtSenderCorrespondentAddress3.Text = dsMT756.SenderCorrespondentAddr3; if (dsMT756.ReceiverCorrespondentType != null) { comboReceiverCorrespondentType.SelectedValue = dsMT756.ReceiverCorrespondentType; } txtReceiverCorrespondentNo.Text = dsMT756.ReceiverCorrespondentNo; txtReceiverCorrespondentName.Text = dsMT756.ReceiverCorrespondentName; txtReceiverCorrespondentAddr1.Text = dsMT756.ReceiverCorrespondentAddr1; txtReceiverCorrespondentAddr2.Text = dsMT756.ReceiverCorrespondentAddr2; txtReceiverCorrespondentAddr3.Text = dsMT756.ReceiverCorrespondentAddr3; txtDetailOfCharges1.Text = dsMT756.DetailOfCharges1; txtDetailOfCharges2.Text = dsMT756.DetailOfCharges2; txtDetailOfCharges3.Text = dsMT756.DetailOfCharges3; txtSenderToReceiverInformation1_400_1.Text = dsMT756.SenderToReceiverInformation1; txtSenderToReceiverInformation1_400_2.Text = dsMT756.SenderToReceiverInformation2; txtSenderToReceiverInformation1_400_3.Text = dsMT756.SenderToReceiverInformation3; //tab charge var dsCharge = entContext.B_ExportLCPaymentCharges.Where(x => x.PaymentId == dsMT756.PaymentId).ToList(); foreach (var item in dsCharge) { if (item.ChargeCode == "ILC.CABLE") { tabCableCharge.Style.Add("display", "block"); tabCableCharge_cboChargeAcc.SelectedValue = item.ChargeAcct; tabCableCharge_cboChargeCcy.SelectedValue = item.ChargeCcy; bc.Commont.initRadComboBox(ref tabCableCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, item.ChargeCcy)); if (item.ExchangeRate != null) { tabCableCharge_txtExchangeRate.Value = item.ExchangeRate; } if (item.ChargeAmt != null) { tabCableCharge_txtChargeAmt.Value = item.ChargeAmt; } if (item.PartyCharged != null) { tabCableCharge_cboPartyCharged.SelectedValue = item.PartyCharged; } if (item.AmortCharge != null) { tabCableCharge_cboAmortCharge.SelectedValue = item.AmortCharge; } tabCableCharge_txtTaxCode.Text = item.TaxCode; lblTaxCcy.Text = item.ChargeCcy; tabCableCharge_txtTaxAmt.Value = item.TaxAmt; } if (item.ChargeCode == "ILC.PAYMENT") { tabPaymentCharge.Style.Add("display", "block"); tabPaymentCharge_cboChargeAcc.SelectedValue = item.ChargeAcct; tabPaymentCharge_cboChargeCcy.SelectedValue = item.ChargeCcy; bc.Commont.initRadComboBox(ref tabPaymentCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, item.ChargeCcy)); if (item.ExchangeRate != null) { tabPaymentCharge_txtExchangeRate.Value = item.ExchangeRate; } if (item.PartyCharged != null) { tabPaymentCharge_cboPartyCharged.SelectedValue = item.PartyCharged; } if (item.AmortCharge != null) { tabPaymentCharge_cboAmortCharge.SelectedValue = item.AmortCharge; } if (item.ChargeStatus != null) { tabPaymentCharge_cboChargeStatus.SelectedValue = item.ChargeStatus; } tabPaymentCharge_txtTaxCode.Text = item.TaxCode; if (item.TaxAmt != null) { tabPaymentCharge_txtTaxAmt.Value = item.TaxAmt; } } if (item.ChargeCode == "ILC.HANDLING") { bc.Commont.initRadComboBox(ref tabHandlingCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, item.ChargeCcy)); tabHandlingCharge_cboChargeAcc.SelectedValue = item.ChargeAcct; if (item.ChargeCcy != null) { tabHandlingCharge_cboChargeCcy.SelectedValue = item.ChargeCcy; } if (item.ExchangeRate != null) { tabHandlingCharge_txtExchangeRate.Value = item.ExchangeRate; } if(item.ChargeAmt!=null) { tabHandlingCharge_txtChargeAmt.Value = item.ChargeAmt; } if (item.PartyCharged != null) { tabHandlingCharge_cboPartyCharged.SelectedValue = item.PartyCharged; } if (item.AmortCharge != null) { tabHandlingCharge_cboAmortCharge.SelectedValue = item.AmortCharge; } tabHandlingCharge_cboChargeStatus.Text = item.ChargeStatus; tabHandlingCharge_txtTaxCode.Text = item.TaxCode; if (item.TaxAmt != null) { tabHandlingCharge_txtTaxAmt.Value = item.TaxAmt; } } if (item.ChargeCode == "ILC.DISCRP") { tabDiscrepenciesCharge.Style.Add("display", "block"); tabDiscrepenciesCharge_cboChargeAcc.SelectedValue = item.ChargeAcct; bc.Commont.initRadComboBox(ref tabDiscrepenciesCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, item.ChargeCcy)); if (item.ChargeCcy != null) { tabDiscrepenciesCharge_cboChargeCcy.SelectedValue = item.ChargeCcy; } if (item.ExchangeRate != null) { tabDiscrepenciesCharge_txtExchangeRate.Value = item.ExchangeRate; } if (item.ChargeAmt != null) { tabDiscrepenciesCharge_txtChargeAmt.Value = item.ChargeAmt; } if(item.PartyCharged!=null) { tabDiscrepenciesCharge_cboPartyCharged.SelectedValue = item.PartyCharged; } if (item.AmortCharge != null) { tabDiscrepenciesCharge_cboAmortCharge.SelectedValue = item.AmortCharge; } if (item.ChargeStatus != null) { tabDiscrepenciesCharge_cboChargeStatus.SelectedValue = item.ChargeStatus; } tabDiscrepenciesCharge_txtTaxCode.Text = item.TaxCode; if (item.TaxAmt != null) { tabDiscrepenciesCharge_txtTaxAmt.Value = item.TaxAmt; } } if (item.ChargeCode == "ILC.OTHER") { tabOtherCharge.Style.Add("display", "block"); tabCableCharge_cboChargeAcc.SelectedValue = item.ChargeAcct; bc.Commont.initRadComboBox(ref tabOtherCharge_cboChargeAcc, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, item.ChargeCcy)); if (item.ChargeCcy != null) { tabOtherCharge_cboChargeCcy.SelectedValue = item.ChargeCcy; } if (item.ExchangeRate != null) { tabOtherCharge_txtExchangeRate.Value = item.ExchangeRate; } if (item.ChargeAmt != null) { tabOtherCharge_txtChargeAmt.Value = item.ChargeAmt; } if (item.PartyCharged != null) { tabOtherCharge_cboPartyCharged.SelectedValue = item.PartyCharged; } if (item.AmortCharge != null) { tabOtherCharge_cboAmortCharge.SelectedValue = item.AmortCharge; } if (item.ChargeStatus != null) { tabOtherCharge_cboChargeStatus.SelectedValue = item.ChargeStatus; } tabOtherCharge_txtTaxCode.Text = item.TaxCode; if (item.TaxAmt != null) { tabOtherCharge_txtTaxAmt.Value = item.TaxAmt; } } } } } setToolbar(1); } }
protected void btSearch_Click(object sender, EventArgs e) { RadToolBar1.FindItemByValue("btCommitData").Enabled = false; lblError.Text = ""; switch (this.TabId) { case TabDocsWithDiscrepancies: case TabDocsWithNoDiscrepancies: //fieldsetDiscrepancies.Visible = (this.TabId == TabDocsWithDiscrepancies); var dsDetail = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(dr => dr.LCCode == txtCode.Text && dr.Status == "UNA"&&(dr.ActiveRecordFlag==null||dr.ActiveRecordFlag==YesNo.YES)).FirstOrDefault(); var dsCharge = new List<BEXPORT_DOCUMENTPROCESSINGCHARGE>(); if (!String.IsNullOrEmpty(txtCode.Text) && txtCode.Text.LastIndexOf(".") > 0) { var drDetail = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == txtCode.Text && (x.ActiveRecordFlag == null || x.ActiveRecordFlag == YesNo.YES)).FirstOrDefault(); if (drDetail == null) { lblError.Text = "This Docs not found !"; SetNullValue(); bc.Commont.SetTatusFormControls(this.Controls, true); tbChargeCode.Enabled = false; tbChargeCode2.Enabled = false; tbChargeCode3.Enabled = false; return; } bc.Commont.SetTatusFormControls(this.Controls, false); txtCode.Enabled = true; // var name=txtCode.Text.Split('.'); var namese = name[0]; if(name!=null) { var lstOriginalBA = dbEntities.BAdvisingAndNegotiationLCs.Where(x => x.NormalLCCode == namese&&(x.ActiveRecordFlag==null||x.ActiveRecordFlag==YesNo.YES)).FirstOrDefault(); if(lstOriginalBA!=null) { txtCustomerName.Value = lstOriginalBA.BeneficiaryName; bc.Commont.initRadComboBox(ref rcbChargeAcct, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginalBA.Currency)); bc.Commont.initRadComboBox(ref rcbChargeAcct2, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginalBA.Currency)); bc.Commont.initRadComboBox(ref rcbChargeAcct3, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginalBA.Currency)); } } // //Hiển thị thông tin docs comboPresentorNo.Text = txtCode.Text; switch (drDetail.Status) { case bd.TransactionStatus.UNA: RadToolBar1.FindItemByValue("btCommitData").Enabled = true; bc.Commont.SetTatusFormControls(this.Controls, true); break; case bd.TransactionStatus.AUT: RadToolBar1.FindItemByValue("btPreview").Enabled = false; RadToolBar1.FindItemByValue("btAuthorize").Enabled = false; RadToolBar1.FindItemByValue("btReverse").Enabled = false; RadToolBar1.FindItemByValue("btSearch").Enabled = false; RadToolBar1.FindItemByValue("btPrint").Enabled = true; bc.Commont.SetTatusFormControls(this.Controls, false); txtCode.Enabled = false; lblError.Text = "This LC has approved"; break; } if (drDetail.WaiveCharges == "YES") { dsCharge = dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Where(dr => dr.LCCode == drDetail.PaymentId).ToList(); } loadDocsDetail(drDetail,dsCharge); return; } if (dsDetail != null) { lblError.Text = "Previous docs is wating for approve!"; if (dsDetail.WaiveCharges == "YES") { dsCharge = dbEntities.BEXPORT_DOCUMENTPROCESSINGCHARGEs.Where(dr => dr.LCCode == dsDetail.PaymentId).ToList(); } //bc.Commont.SetTatusFormControls(this.Controls, false); //hien thi thong tin docs dang cho duyet loadDocsDetail(dsDetail, dsCharge); return; // } //get data from advisingnegotiaton var lstOriginal=dbEntities.BAdvisingAndNegotiationLCs.Where(dr=>dr.NormalLCCode==txtCode.Text).FirstOrDefault(); if(lstOriginal==null) { lblError.Text="This LC was not found"; return; } if(!lstOriginal.Status.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This LC has not authorized"; return; } else if (lstOriginal.AmendStatus != null && !lstOriginal.AmendStatus.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This LC waiting for amend approve !"; return; } else if (lstOriginal.AcceptStatus != null && !lstOriginal.AcceptStatus.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This LC waiting for accept approve !"; return; } else if (lstOriginal.CancelStatus != null && !lstOriginal.CancelStatus.Equals(bd.TransactionStatus.REV)) { lblError.Text = "This LC is rejected !"; return; } SetNullValue(); txtFullDocsAmount.Value = lstOriginal.Amount; //load charge acc txtCustomerName.Value = lstOriginal.BeneficiaryName; bc.Commont.initRadComboBox(ref rcbChargeAcct, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginal.Currency)); bc.Commont.initRadComboBox(ref rcbChargeAcct2, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginal.Currency)); bc.Commont.initRadComboBox(ref rcbChargeAcct3, "Display", "Id", bd.SQLData.B_BDRFROMACCOUNT_GetByCurrency(txtCustomerName.Value, lstOriginal.Currency)); // bc.Commont.SetTatusFormControls(this.Controls, true); tbChargeCode.Enabled = false; tbChargeCode2.Enabled = false; tbChargeCode3.Enabled = false; //sinh ra PaymentID var dsPayDetail = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(dr => dr.LCCode == txtCode.Text).ToList(); var maxId = dsPayDetail.Max(x => x.PaymentNo); if (maxId == null) { maxId = 1; } else { maxId = maxId + 1; } txtCode.Text = lstOriginal.NormalLCCode + "." + maxId; comboPresentorNo.Text = txtCode.Text; // //txtCode.Text = lstOriginal.NormalLCCode; //hiddenCustomerName.Value = dsDetail.ApplicantName; lblCurrency.Text = lstOriginal.Currency; //numAmount.Value = Convert.ToDouble(dsDetail.Amount) - Convert.ToDouble(dsDetail.t.TotalDocsAmount); dteBookingDate.SelectedDate = DateTime.Now; comboDrawType.SelectedValue = "CO"; comboDrawType.Enabled = false; RadToolBar1.FindItemByValue("btCommitData").Enabled = true; break; case TabDocsReject: case TabDocsAmend: case TabDocsAccept: var chkdsDetail = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(dr => dr.PaymentId == txtCode.Text&&(dr.ActiveRecordFlag==null||dr.ActiveRecordFlag==YesNo.YES)).FirstOrDefault(); if (this.TabId == TabDocsAmend) { var chkfindTypeAmend = txtCode.Text.Split('.'); if (chkfindTypeAmend != null && chkfindTypeAmend.Length > 0) { if (chkfindTypeAmend.Length == 3) { chkdsDetail = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.AmendNo == txtCode.Text).FirstOrDefault(); } } } var chkdsCharge = new List<BEXPORT_DOCUMENTPROCESSINGCHARGE>(); if (chkdsDetail != null) { // string Status = "", RejectStatus = "",AmendStatus=""; if (chkdsDetail.Status != null) Status = chkdsDetail.Status; if (chkdsDetail.RejectStatus != null) RejectStatus = chkdsDetail.RejectStatus; if (chkdsDetail.AmendStatus != null) AmendStatus = chkdsDetail.AmendStatus; // switch (this.TabId) { case TabDocsReject: case TabDocsAccept: if (!Status.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This Docs is not authorize !"; return; } if (!(String.IsNullOrEmpty(RejectStatus) || RejectStatus.Equals(bd.TransactionStatus.REV))) { lblError.Text = "This Docs is reject !"; return; } if (Convert.ToInt32(chkdsDetail.PaymentFullFlag)!= 0) { lblError.Text = "This Doc is already payment completed !"; return; } if (this.TabId == TabDocsAccept) { string AcceptStatus = ""; if (chkdsDetail.AcceptStatus != null) AcceptStatus = chkdsDetail.AcceptStatus.ToString(); if (AcceptStatus.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This Docs is accepted !"; return; } if (AcceptStatus.Equals(bd.TransactionStatus.UNA)) { lblError.Text = "This Docs is waiting for accept approve !"; return; } } break; case TabDocsAmend: //xet xem truong hop Amend user nhap TF.x hay TF.x.y var findTypeAmend = txtCode.Text.Split('.'); if (findTypeAmend != null && findTypeAmend.Length > 0) { if (findTypeAmend.Length == 2) { if (!Status.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This Docs is not allow amend !"; return; } //else if (AmendStatus == "AUT") //{ // lblError.Text = "This LC was approve for amend"; //} else if (!String.IsNullOrEmpty(RejectStatus)) { lblError.Text = "This LC was rejected or waited for approve reject"; return; } //them phan Amend ngay 18/11/2014 else { var objAmend = new BEXPORT_DOCUMENTPROCESSING(); var chkAmend = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == txtCode.Text).ToList(); if (chkAmend != null && chkAmend.Count > 0) { objAmend = chkAmend.Where(x => (x.ActiveRecordFlag == null || x.ActiveRecordFlag == YesNo.YES) && (x.AmendStatus == "UNA")).FirstOrDefault(); if (objAmend != null) { loadDocsDetail(objAmend, chkdsCharge); bc.Commont.SetTatusFormControls(this.Controls, this.TabId == TabDocsAmend); comboDrawType.Enabled = false; RadToolBar1.FindItemByValue("btCommitData").Enabled = true; } else { var maxAmendId = chkAmend.Max(x => x.AmendId); if (maxAmendId == null) { maxAmendId = 1; } else { maxAmendId = maxAmendId + 1; } var code = txtCode.Text; //lay dong dang active de Amend tiep var ctnAmend = chkAmend.Where(x => x.ActiveRecordFlag==null||x.ActiveRecordFlag == YesNo.YES).FirstOrDefault(); // loadDocsDetail(ctnAmend, chkdsCharge); bc.Commont.SetTatusFormControls(this.Controls, this.TabId == TabDocsAmend); comboDrawType.Enabled = false; RadToolBar1.FindItemByValue("btCommitData").Enabled = true; txtCode.Text = code + "." + maxAmendId; } } //chua co dong Amend nao nhu vay } return; } else if(findTypeAmend.Length==3) { if (!Status.Equals(bd.TransactionStatus.AUT)) { lblError.Text = "This Docs is not allow amend !"; return; } else if (AmendStatus == "AUT") { lblError.Text = "This LC amend has approve "; return; } else if (!String.IsNullOrEmpty(RejectStatus)) { lblError.Text = "This LC was rejected or waited for approve reject"; return; } //them phan Amend ngay 18/11/2014 else { var objAmend = new BEXPORT_DOCUMENTPROCESSING(); var chkAmend = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.AmendNo == txtCode.Text).FirstOrDefault(); if (chkAmend != null) { loadDocsDetail(chkAmend, chkdsCharge); bc.Commont.SetTatusFormControls(this.Controls, this.TabId == TabDocsAmend); comboDrawType.Enabled = false; RadToolBar1.FindItemByValue("btCommitData").Enabled = true; } } } } // break; } // loadDocsDetail(chkdsDetail, chkdsCharge); bc.Commont.SetTatusFormControls(this.Controls, this.TabId == TabDocsAmend); comboDrawType.Enabled = false; RadToolBar1.FindItemByValue("btCommitData").Enabled = true; switch (this.TabId) { case TabDocsReject: comboDrawType.SelectedValue = "CR"; break; case TabDocsAccept: comboDrawType.SelectedValue = "AC"; txtAcceptDate.SelectedDate = DateTime.Now; txtAcceptRemarks.Enabled = true; break; } break; // } else { lblError.Text = "This Docs not found !"; return; } } }
private void setDocsCodeData(BEXPORT_DOCUMENTPROCESSING dsDetail, int stt, ref RadComboBox cboDocsCode, ref RadNumericTextBox txtNumOfOriginals, ref RadNumericTextBox txtNumofCopies, ref RadTextBox txtOtherDocs) { cboDocsCode.SelectedValue = dsDetail.DocsCode1; if (stt == 1) { if (dsDetail.NoOfOriginals1 != null) { txtNumOfOriginals.Value = Convert.ToDouble(dsDetail.NoOfOriginals1); } if (dsDetail.OtherDocs1 != null) { txtOtherDocs.Text = dsDetail.OtherDocs1; } } else if (stt == 2) { if (dsDetail.NoOfOriginals2 != null) { txtNumOfOriginals.Value = Convert.ToDouble(dsDetail.NoOfOriginals2); } if (dsDetail.OtherDocs2 != null) { txtOtherDocs.Text = dsDetail.OtherDocs2; } } else if (stt == 3) { if (dsDetail.NoOfOriginals3 != null) { txtNumOfOriginals.Value = Convert.ToDouble(dsDetail.NoOfOriginals3); } if (dsDetail.OtherDocs3 != null) { txtOtherDocs.Text = dsDetail.OtherDocs3; } } switch (stt) { case 1: divDocsCode1.Visible = (txtNumOfOriginals.Value > 0 || txtNumofCopies.Value > 0 || !String.IsNullOrEmpty(txtOtherDocs.Text)); break; case 2: divDocsCode1.Visible = (txtNumOfOriginals.Value > 0 || txtNumofCopies.Value > 0 || !String.IsNullOrEmpty(txtOtherDocs.Text)); break; case 3: divDocsCode1.Visible = (txtNumOfOriginals.Value > 0 || txtNumofCopies.Value > 0 || !String.IsNullOrEmpty(txtOtherDocs.Text)); break; } }
private void SaveAmend() { try { int AmendPreId = 0; string AmendNo = ""; var findTypeAmend = txtCode.Text.Split('.'); if (findTypeAmend != null && findTypeAmend.Length > 0) { //truong hop them moi if (findTypeAmend.Length == 3) { //xet xem so TF nay co hay chua var chkAmend = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.AmendNo == txtCode.Text).FirstOrDefault(); //neu chua co thi them moi, co roi thi update //truong hop chua co--> se them moi if (chkAmend == null) { //xet record truoc do bang cach lay id -1 neu lon hon 0 se update TF.x.y, nguoc lai chi update TF.x if (!String.IsNullOrEmpty(findTypeAmend[2])) { AmendPreId = int.Parse(findTypeAmend[2]) - 1; } if (AmendPreId > 0) { //xet Amend truoc do AmendNo = findTypeAmend[0] + "." + findTypeAmend[1] + "." + AmendPreId; var objPreAmend = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.AmendNo == AmendNo).FirstOrDefault(); if (objPreAmend != null) { objPreAmend.ActiveRecordFlag = YesNo.NO; } // } else { AmendNo = findTypeAmend[0] + "." + findTypeAmend[1]; var objPreAmend = dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Where(x => x.PaymentId == AmendNo).FirstOrDefault(); if (objPreAmend != null) { objPreAmend.ActiveRecordFlag = YesNo.NO; } } //update dbEntities.SaveChanges(); //them moi record hien tai BEXPORT_DOCUMENTPROCESSING objInsertAmend = new BEXPORT_DOCUMENTPROCESSING { DrawType = comboDrawType.SelectedValue, PresentorNo = comboPresentorNo.Text, PresentorName = txtPresentorName.Text, PresentorRefNo = txtPresentorRefNo.Text, Currency = lblCurrency.Text, BookingDate = dteBookingDate.SelectedDate, DocsReceivedDate = dteDocsReceivedDate.SelectedDate, DocsCode1 = comboDocsCode1.SelectedValue, DocsCode2 = comboDocsCode2.SelectedValue, DocsCode3 = comboDocsCode3.SelectedValue, OtherDocs1 = txtOtherDocs1.Text, OtherDocs2 = txtOtherDocs2.Text, OtherDocs3 = txtOtherDocs3.Text, Discrepancies = txtDiscrepancies.Text, DisposalOfDocs = txtDisposalOfDocs.Text, TraceDate = dteTraceDate.SelectedDate, DocsReceivedDate_Supplemental = dteDocsReceivedDate_Supplemental.SelectedDate, PresentorRefNo_Supplemental = txtPresentorRefNo_Supplemental.Text, Docs_Supplemental1 = txtDocs_Supplemental1.Text, LCCode = findTypeAmend[0], PaymentNo = long.Parse(findTypeAmend[1]), PaymentId = findTypeAmend[0] + "." + findTypeAmend[1], Id = long.Parse(findTypeAmend[1]), DocumentType = TabId.ToString(), FullDocsAmount = txtFullDocsAmount.Value, WaiveCharges = comboWaiveCharges.SelectedValue, ChargeRemarks = tbChargeRemarks.Text, VATNo = tbVatNo.Text, AmendId = int.Parse(findTypeAmend[2]), AmendNo = txtCode.Text, ActiveRecordFlag = YesNo.YES, Status = "AUT", OldDocsReceivedDate = dteDocsReceivedDate.SelectedDate, RefAmendNo = AmendNo, AmendStatus = "UNA" }; if (!String.IsNullOrEmpty(numAmount.Text)) { objInsertAmend.Amount = double.Parse(numAmount.Text); objInsertAmend.OldAmount = numAmount.Value; } if (!String.IsNullOrEmpty(numNoOfOriginals1.Text)) { objInsertAmend.NoOfOriginals1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals2.Text)) { objInsertAmend.NoOfOriginals2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals3.Text)) { objInsertAmend.NoOfOriginals3 = long.Parse(numNoOfOriginals3.Text); } if (!String.IsNullOrEmpty(numNoOfCopies1.Text)) { objInsertAmend.NoOfCopies1 = long.Parse(numNoOfCopies1.Text); } if (!String.IsNullOrEmpty(numNoOfCopies2.Text)) { objInsertAmend.NoOfCopies2 = long.Parse(numNoOfCopies2.Text); } if (!String.IsNullOrEmpty(numNoOfCopies3.Text)) { objInsertAmend.NoOfCopies3 = long.Parse(numNoOfCopies3.Text); } dbEntities.BEXPORT_DOCUMENTPROCESSINGs.Add(objInsertAmend); dbEntities.SaveChanges(); // } else { //truong hop update du lieu da co chkAmend.DrawType = comboDrawType.SelectedValue; chkAmend.PresentorNo = comboPresentorNo.Text; chkAmend.PresentorName = txtPresentorName.Text; chkAmend.PresentorRefNo = txtPresentorRefNo.Text; chkAmend.Currency = lblCurrency.Text; chkAmend.BookingDate = dteBookingDate.SelectedDate; chkAmend.DocsReceivedDate = dteDocsReceivedDate.SelectedDate; chkAmend.DocsCode1 = comboDocsCode1.SelectedValue; chkAmend.DocsCode2 = comboDocsCode2.SelectedValue; chkAmend.DocsCode3 = comboDocsCode3.SelectedValue; chkAmend.OtherDocs1 = txtOtherDocs1.Text; chkAmend.OtherDocs2 = txtOtherDocs2.Text; chkAmend.OtherDocs3 = txtOtherDocs3.Text; chkAmend.Discrepancies = txtDiscrepancies.Text; chkAmend.DisposalOfDocs = txtDisposalOfDocs.Text; chkAmend.TraceDate = dteTraceDate.SelectedDate; chkAmend.DocsReceivedDate_Supplemental = dteDocsReceivedDate_Supplemental.SelectedDate; chkAmend.PresentorRefNo_Supplemental = txtPresentorRefNo_Supplemental.Text; chkAmend.Docs_Supplemental1 = txtDocs_Supplemental1.Text; chkAmend.LCCode = findTypeAmend[0]; chkAmend.PaymentNo = long.Parse(findTypeAmend[1]); chkAmend.PaymentId = findTypeAmend[0] + "." + findTypeAmend[1]; //chkAmend.Id = long.Parse(findTypeAmend[1]); chkAmend.DocumentType = TabId.ToString(); chkAmend.FullDocsAmount = txtFullDocsAmount.Value; chkAmend.WaiveCharges = comboWaiveCharges.SelectedValue; chkAmend.ChargeRemarks = tbChargeRemarks.Text; chkAmend.VATNo = tbVatNo.Text; chkAmend.AmendId = int.Parse(findTypeAmend[2]); chkAmend.AmendNo = txtCode.Text; chkAmend.ActiveRecordFlag = YesNo.YES; chkAmend.Status = "AUT"; chkAmend.OldDocsReceivedDate = dteDocsReceivedDate.SelectedDate; chkAmend.RefAmendNo = AmendNo; chkAmend.AmendStatus = "UNA"; // if (!String.IsNullOrEmpty(numAmount.Text)) { chkAmend.Amount = double.Parse(numAmount.Text); chkAmend.OldAmount = numAmount.Value; } if (!String.IsNullOrEmpty(numNoOfOriginals1.Text)) { chkAmend.NoOfOriginals1 = long.Parse(numNoOfOriginals1.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals2.Text)) { chkAmend.NoOfOriginals2 = long.Parse(numNoOfOriginals2.Text); } if (!String.IsNullOrEmpty(numNoOfOriginals3.Text)) { chkAmend.NoOfOriginals3 = long.Parse(numNoOfOriginals3.Text); } if (!String.IsNullOrEmpty(numNoOfCopies1.Text)) { chkAmend.NoOfCopies1 = long.Parse(numNoOfCopies1.Text); } if (!String.IsNullOrEmpty(numNoOfCopies2.Text)) { chkAmend.NoOfCopies2 = long.Parse(numNoOfCopies2.Text); } if (!String.IsNullOrEmpty(numNoOfCopies3.Text)) { chkAmend.NoOfCopies3 = long.Parse(numNoOfCopies3.Text); } dbEntities.SaveChanges(); } } } } catch (Exception ex) { lblError.Text = ex.Message; } }
//protected void rcbChargeAcct_ItemDataBound(object sender, RadComboBoxItemEventArgs e) //{ // DataRowView row = e.Item.DataItem as DataRowView; // e.Item.Attributes["Id"] = row["Id"].ToString(); // e.Item.Attributes["Name"] = row["Name"].ToString(); //} private void parseDocsCode(int Order, BEXPORT_DOCUMENTPROCESSING dsDetail, ref System.Web.UI.HtmlControls.HtmlGenericControl divDocsCode, ref RadComboBox cbDocsCode, ref RadNumericTextBox tbNoOfOriginals, ref RadNumericTextBox tbNoOfCopies) { if (Order == 1) { string DocsCode = dsDetail.DocsCode1; if (dsDetail.NoOfOriginals1 != null) { tbNoOfOriginals.Value = Convert.ToInt32(dsDetail.NoOfOriginals1); } if (dsDetail.NoOfCopies1 != null) { tbNoOfCopies.Value = Convert.ToInt32(dsDetail.NoOfCopies1); } } else if (Order == 2) { string DocsCode = dsDetail.DocsCode2; if (dsDetail.NoOfOriginals2 != null) { tbNoOfOriginals.Value = Convert.ToInt32(dsDetail.NoOfOriginals2); } if (dsDetail.NoOfCopies2 != null) { tbNoOfCopies.Value = Convert.ToInt32(dsDetail.NoOfCopies2); } } else if (Order == 3) { string DocsCode = dsDetail.DocsCode3; if (dsDetail.NoOfOriginals3 != null) { tbNoOfOriginals.Value = Convert.ToInt32(dsDetail.NoOfOriginals3); } if (dsDetail.NoOfCopies2 != null) { tbNoOfCopies.Value = Convert.ToInt32(dsDetail.NoOfCopies3); } } }
//protected void comboWaiveCharges_OnSelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) //{ // bool WaiveCharges = (comboWaiveCharges.SelectedValue == "YES"); // //divCharge.Visible = WaiveCharges; // divACCPTCHG.Visible = WaiveCharges; // divCABLECHG.Visible = WaiveCharges; // divPAYMENTCHG.Visible = WaiveCharges; //} private void loadDocsDetail(BEXPORT_DOCUMENTPROCESSING dsDetail, List<BEXPORT_DOCUMENTPROCESSINGCHARGE> dsCharge) { if ((!String.IsNullOrEmpty(dsDetail.AcceptDate.ToString())) && (dsDetail.AcceptDate.ToString().IndexOf("1/1/1900") == -1)) { txtAcceptDate.SelectedDate = Convert.ToDateTime(dsDetail.AcceptDate); } txtAcceptRemarks.Text = dsDetail.AcceptRemarts; // txtFullDocsAmount.Value = dsDetail.FullDocsAmount; // if (TabId != TabDocsAmend) { txtCode.Text = dsDetail.PaymentId; } else { txtCode.Text = dsDetail.AmendNo; } comboDrawType.SelectedValue = dsDetail.DrawType; comboPresentorNo.Text = dsDetail.PresentorNo; txtPresentorName.Text = dsDetail.PresentorName; txtPresentorRefNo.Text = dsDetail.PresentorRefNo; lblCurrency.Text = dsDetail.Currency; numAmount.Value = Convert.ToDouble(dsDetail.Amount); if ((!String.IsNullOrEmpty(dsDetail.BookingDate.ToString())) && (dsDetail.BookingDate.ToString().IndexOf("1/1/1900") == -1)) { dteBookingDate.SelectedDate = Convert.ToDateTime(dsDetail.BookingDate); } if ((!String.IsNullOrEmpty(dsDetail.DocsReceivedDate.ToString())) && (dsDetail.DocsReceivedDate.ToString().IndexOf("1/1/1900") == -1)) { dteDocsReceivedDate.SelectedDate = Convert.ToDateTime(dsDetail.DocsReceivedDate); } setDocsCodeData(dsDetail, 1, ref comboDocsCode1, ref numNoOfOriginals1, ref numNoOfCopies1, ref txtOtherDocs1); setDocsCodeData(dsDetail, 2, ref comboDocsCode2, ref numNoOfOriginals2, ref numNoOfCopies2, ref txtOtherDocs2); setDocsCodeData(dsDetail, 3, ref comboDocsCode3, ref numNoOfOriginals3, ref numNoOfCopies3, ref txtOtherDocs3); if ((!String.IsNullOrEmpty(dsDetail.TraceDate.ToString())) && (dsDetail.TraceDate.ToString().IndexOf("1/1/1900") == -1)) { dteTraceDate.SelectedDate = Convert.ToDateTime(dsDetail.TraceDate); } if ((!String.IsNullOrEmpty(dsDetail.DocsReceivedDate_Supplemental.ToString())) && (dsDetail.DocsReceivedDate_Supplemental.ToString().IndexOf("1/1/1900") == -1)) { dteDocsReceivedDate_Supplemental.SelectedDate = Convert.ToDateTime(dsDetail.DocsReceivedDate_Supplemental); } txtPresentorRefNo_Supplemental.Text = dsDetail.PresentorRefNo_Supplemental; txtDocs_Supplemental1.Text = dsDetail.Docs_Supplemental1; DocsType = Convert.ToInt32(dsDetail.DocumentType); bool isDocsDiscrepancies = (TabId == TabDocsWithDiscrepancies); fieldsetDiscrepancies.Visible = isDocsDiscrepancies; if (isDocsDiscrepancies) { txtDiscrepancies.Text = dsDetail.Discrepancies; txtDisposalOfDocs.Text = dsDetail.DisposalOfDocs; } comboWaiveCharges.SelectedValue = dsDetail.WaiveCharges; tbChargeRemarks.Text = dsDetail.ChargeRemarks; tbVatNo.Text = dsDetail.VATNo; parseDocsCode(1, dsDetail, ref divDocsCode1, ref comboDocsCode1, ref numNoOfOriginals1, ref numNoOfCopies1); parseDocsCode(2, dsDetail, ref divDocsCode2, ref comboDocsCode2, ref numNoOfOriginals2, ref numNoOfCopies2); parseDocsCode(3, dsDetail, ref divDocsCode3, ref comboDocsCode3, ref numNoOfOriginals3, ref numNoOfCopies3); //TAB CHARGE if (isDocsDiscrepancies) { divCharge.Visible = isDocsDiscrepancies; divCharge.Style.Add("display", "block"); if (dsCharge != null && dsCharge.Count > 0) { TCharge.Style.Add("display", "block"); TCharge.Visible = true; foreach (var item in dsCharge) { if (item.Chargecode == "ILC.CABLE") { parseTabCharge(item, ref tbChargeCode, ref rcbChargeCcy, ref rcbChargeAcct, ref tbChargeAmt, ref rcbPartyCharged, ref rcbOmortCharge, ref lblTaxCode, ref lblTaxAmt); } else if (item.Chargecode == "ILC.OPEN") { parseTabCharge(item, ref tbChargeCode2, ref rcbChargeCcy2, ref rcbChargeAcct2, ref tbChargeAmt2, ref rcbPartyCharged2, ref rcbOmortCharges2, ref lblTaxCode2, ref lblTaxAmt2); } else if (item.Chargecode == "ILC.OPENAMORT") { parseTabCharge(item, ref tbChargeCode3, ref rcbChargeCcy3, ref rcbChargeAcct3, ref tbChargeAmt3, ref rcbPartyCharged3, ref rcbOmortCharges3, ref lblTaxCode3, ref lblTaxAmt3); } } } else { comboWaiveCharges.SelectedValue = "NO"; TCharge.Visible = false; TCharge.Style.Add("display", "none"); } } else { divCharge.Style.Add("display", "none"); divCharge.Visible = isDocsDiscrepancies; } //comboWaiveCharges_OnSelectedIndexChanged(null, null); }