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