private void saveCharge(RadTextBox txtChargeCode, RadComboBox cbChargeCcy, RadComboBox cbChargeAcc, RadNumericTextBox txtChargeAmt, RadComboBox cbChargeParty, RadComboBox cbChargeAmort,
RadComboBox cbChargeStatus, Label lblTaxCode, Label lblTaxAmt, ref BEXPORT_LC_DOCS_PROCESSING_CHARGES ExLCCharge)
{
ExLCCharge.DocsCode = tbLCCode.Text;
ExLCCharge.ChargeCode = txtChargeCode.Text;
ExLCCharge.ChargeCcy = cbChargeCcy.SelectedValue;
ExLCCharge.ChargeAcc = cbChargeAcc.SelectedValue;
ExLCCharge.ChargeAmt = txtChargeAmt.Value;
ExLCCharge.PartyCharged = cbChargeParty.SelectedValue;
ExLCCharge.AmortCharge = cbChargeAmort.SelectedValue;
ExLCCharge.ChargeStatus = cbChargeStatus.SelectedValue;
ExLCCharge.TaxCode = lblTaxCode.Text;
if (!string.IsNullOrEmpty(lblTaxAmt.Text))
ExLCCharge.TaxAmt = Convert.ToDouble(lblTaxAmt.Text);
}
private void loadCharge(BEXPORT_LC_DOCS_PROCESSING_CHARGES ExLCCharge, ref RadTextBox txtChargeCode, ref RadComboBox cbChargeCcy, ref RadComboBox cbChargeAcc, ref RadNumericTextBox txtChargeAmt,
ref RadComboBox cbChargeParty, ref RadComboBox cbChargeAmort, ref RadComboBox cbChargeStatus, ref Label lblTaxCode, ref Label lblTaxAmt)
{
txtChargeCode.Text = ExLCCharge.ChargeCode;
cbChargeCcy.SelectedValue = ExLCCharge.ChargeCcy;
cbChargeAcc.SelectedValue = ExLCCharge.ChargeAcc;
txtChargeAmt.Value = ExLCCharge.ChargeAmt;
cbChargeParty.SelectedValue = ExLCCharge.PartyCharged;
cbChargeAmort.SelectedValue = ExLCCharge.AmortCharge;
cbChargeStatus.SelectedValue = ExLCCharge.ChargeStatus;
lblTaxCode.Text = ExLCCharge.TaxCode;
if (ExLCCharge.TaxAmt.HasValue)
lblTaxAmt.Text = ExLCCharge.TaxAmt.ToString();
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
string docCode = tbLCCode.Text.Trim(), lcCode;
var ExLCDoc = dbEntities.findExportLCDoc(docCode);
BEXPORT_LC ExLC;
var toolBarButton = e.Item as RadToolBarButton;
var commandName = toolBarButton.CommandName.ToLower();
#region Register
if (TabId == ExportLCDocProcessing.Actions.Register || TabId == ExportLCDocProcessing.Actions.Register1)
{
lcCode = docCode.Substring(0, docCode.IndexOf("."));
ExLC = dbEntities.findExportLC(lcCode);
var ExLCAmount = ExLC.Amount - (ExLC.PaymentAmount.HasValue ? ExLC.PaymentAmount.Value : 0);
switch (commandName)
{
case bc.Commands.Commit:
if (ExLCAmount < txtAmount.Value.Value)
{
lblLCCodeMessage.Text = "Doc Amount must less than or equal LC Amount";
return;
}
if (ExLCDoc == null)
{
ExLCDoc = new BEXPORT_LC_DOCS_PROCESSING();
ExLCDoc.DocCode = tbLCCode.Text;
ExLCDoc.AmendNo = docCode;
ExLCDoc.ActiveRecordFlag = "Yes";
ExLCDoc.Status = bd.TransactionStatus.UNA;
ExLCDoc.CreateDate = DateTime.Now;
ExLCDoc.CreateBy = this.UserInfo.Username;
saveLCDoc(ref ExLCDoc);
dbEntities.BEXPORT_LC_DOCS_PROCESSING.Add(ExLCDoc);
}
else
{
ExLCDoc.Status = bd.TransactionStatus.UNA;
ExLCDoc.ActiveRecordFlag = "Yes";
ExLCDoc.UpdateDate = DateTime.Now;
ExLCDoc.UpdatedBy = this.UserInfo.Username;
saveLCDoc(ref ExLCDoc);
//Xoa di insert lai
var ExLCDocCharge = dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Where(p => p.DocsCode.Trim().ToLower().Equals(docCode.ToLower()));
if (ExLCDocCharge != null)
{
foreach(BEXPORT_LC_DOCS_PROCESSING_CHARGES ch in ExLCDocCharge)
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Remove(ch);
}
}
if (ExLCDoc.WaiveCharges.Equals(bd.YesNo.NO))
{
BEXPORT_LC_DOCS_PROCESSING_CHARGES ExLCCharge;
if (tbChargeAmt1.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode1, rcbChargeCcy1, rcbChargeAcct1, tbChargeAmt1, rcbPartyCharged1, rcbAmortCharge1, rcbChargeStatus1, lblTaxCode1, lblTaxAmt1, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
if (tbChargeAmt2.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode2, rcbChargeCcy2, rcbChargeAcct2, tbChargeAmt2, rcbPartyCharged2, rcbAmortCharge2, rcbChargeStatus2, lblTaxCode2, lblTaxAmt2, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
if (tbChargeAmt3.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode3, rcbChargeCcy3, rcbChargeAcct3, tbChargeAmt3, rcbPartyCharged3, rcbAmortCharge3, rcbChargeStatus3, lblTaxCode3, lblTaxAmt3, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
}
//
dbEntities.SaveChanges();
//
Response.Redirect("Default.aspx?tabid=" + this.TabId);
break;
case bc.Commands.Authorize:
case bc.Commands.Reverse:
if (ExLCDoc != null)
{
if (commandName.Equals(bc.Commands.Authorize))
{
ExLCDoc.Status = bd.TransactionStatus.AUT;
ExLCDoc.AuthorizedBy = this.UserInfo.Username;
ExLCDoc.AuthorizedDate = DateTime.Now;
//
if (ExLC.PaymentAmount.HasValue)
ExLC.PaymentAmount += ExLCDoc.Amount;
else
ExLC.PaymentAmount = ExLCDoc.Amount;
ExLC.PaymentFull = (ExLC.PaymentAmount == ExLC.Amount);
//
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId);
}
else
{
ExLCDoc.Status = bd.TransactionStatus.REV;
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId + "&code=" + tbLCCode.Text);
}
}
break;
}
return;
}
#endregion Register
#region Amend
if (TabId == ExportLCDocProcessing.Actions.Amend)
{
docCode = docCode.Split('.')[0] + "." + docCode.Split('.')[1];
switch (commandName)
{
case bc.Commands.Commit:
if (ExLCDoc == null)
{
var ExLCDocOld = dbEntities.findExportLCDoc(docCode);
ExLCDocOld.ActiveRecordFlag = "No";
ExLCDoc = new BEXPORT_LC_DOCS_PROCESSING()
{
AmendNo = tbLCCode.Text.Trim(),
AmendNoOriginal = ExLCDocOld.AmendNo,
DocCode = ExLCDocOld.DocCode,
ActiveRecordFlag = "Yes",
AmendStatus = bd.TransactionStatus.UNA,
AmendDate = DateTime.Now,
AmendBy = this.UserInfo.Username,
PaymentFull = ExLCDocOld.PaymentFull,
Status = ExLCDocOld.Status,
CreateBy = ExLCDocOld.CreateBy,
CreateDate = ExLCDocOld.CreateDate,
UpdatedBy = ExLCDocOld.UpdatedBy,
UpdateDate = ExLCDocOld.UpdateDate,
AuthorizedBy = ExLCDocOld.AuthorizedBy,
AuthorizedDate = ExLCDocOld.AuthorizedDate,
RejectStatus = ExLCDocOld.RejectStatus,
RejectDate = ExLCDocOld.RejectDate,
AcceptStatus = ExLCDocOld.AcceptStatus,
AcceptDate = ExLCDocOld.AcceptDate,
PaymentAmount = ExLCDocOld.PaymentAmount
};
saveLCDoc(ref ExLCDoc);
dbEntities.BEXPORT_LC_DOCS_PROCESSING.Add(ExLCDoc);
}
else
{
var ExLCDocOld = dbEntities.findExportLCDoc(ExLCDoc.AmendNoOriginal, true);
ExLCDocOld.ActiveRecordFlag = "No";
//
ExLCDoc.AmendStatus = bd.TransactionStatus.UNA;
ExLCDoc.ActiveRecordFlag = "Yes";
ExLCDoc.UpdateDate = DateTime.Now;
ExLCDoc.UpdatedBy = this.UserInfo.Username;
saveLCDoc(ref ExLCDoc);
//Xoa di insert lai
var ExLCDocCharge = dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Where(p => p.DocsCode.Trim().ToLower().Equals(ExLCDoc.AmendNo.ToLower()));
if (ExLCDocCharge != null)
{
foreach (BEXPORT_LC_DOCS_PROCESSING_CHARGES ch in ExLCDocCharge)
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Remove(ch);
}
}
if (ExLCDoc.WaiveCharges.Equals(bd.YesNo.NO))
{
BEXPORT_LC_DOCS_PROCESSING_CHARGES ExLCCharge;
if (tbChargeAmt1.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode1, rcbChargeCcy1, rcbChargeAcct1, tbChargeAmt1, rcbPartyCharged1, rcbAmortCharge1, rcbChargeStatus1, lblTaxCode1, lblTaxAmt1, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
if (tbChargeAmt2.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode2, rcbChargeCcy2, rcbChargeAcct2, tbChargeAmt2, rcbPartyCharged2, rcbAmortCharge2, rcbChargeStatus2, lblTaxCode2, lblTaxAmt2, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
if (tbChargeAmt3.Value.HasValue)
{
ExLCCharge = new BEXPORT_LC_DOCS_PROCESSING_CHARGES();
saveCharge(txtChargeCode3, rcbChargeCcy3, rcbChargeAcct3, tbChargeAmt3, rcbPartyCharged3, rcbAmortCharge3, rcbChargeStatus3, lblTaxCode3, lblTaxAmt3, ref ExLCCharge);
dbEntities.BEXPORT_LC_DOCS_PROCESSING_CHARGES.Add(ExLCCharge);
}
}
//
dbEntities.SaveChanges();
//
Response.Redirect("Default.aspx?tabid=" + this.TabId);
break;
case bc.Commands.Authorize:
case bc.Commands.Reverse:
if (ExLCDoc != null)
{
var ExLCDocOld = dbEntities.findExportLCDoc(ExLCDoc.AmendNoOriginal, true);
if (commandName.Equals(bc.Commands.Authorize))
{
if (!ExLCDoc.Amount.HasValue) ExLCDoc.Amount = ExLCDocOld.Amount;
if (!string.IsNullOrEmpty(ExLCDoc.Tenor)) ExLCDoc.Tenor = ExLCDocOld.Tenor;
ExLCDoc.AmendStatus = bd.TransactionStatus.AUT;
//
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId);
}
else
{
ExLCDocOld.ActiveRecordFlag = "Yes";
//
ExLCDoc.AmendStatus = bd.TransactionStatus.REV;
ExLCDoc.ActiveRecordFlag = "No";
//
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId + "&code=" + tbLCCode.Text);
}
}
break;
}
return;
}
#endregion Amend
#region Accept, Reject
if (TabId == ExportLCDocProcessing.Actions.Reject || TabId == ExportLCDocProcessing.Actions.Accept)
{
switch (commandName)
{
case bc.Commands.Commit:
if (ExLCDoc != null)
{
if (TabId == ExportLCDocProcessing.Actions.Reject)
{
ExLCDoc.RejectStatus = bd.TransactionStatus.UNA;
ExLCDoc.RejectDate = DateTime.Now;
}
else
{
ExLCDoc.AcceptStatus = bd.TransactionStatus.UNA;
ExLCDoc.AcceptDate = txtAcceptDate.SelectedDate;
ExLCDoc.AcceptRemarks = txtAcceptRemarks.Text;
}
saveLCDoc(ref ExLCDoc);
dbEntities.SaveChanges();
}
//
Response.Redirect("Default.aspx?tabid=" + this.TabId);
break;
case bc.Commands.Authorize:
case bc.Commands.Reverse:
if (ExLCDoc != null)
{
if (commandName.Equals(bc.Commands.Authorize))
{
if (TabId == ExportLCDocProcessing.Actions.Reject)
ExLCDoc.RejectStatus = bd.TransactionStatus.AUT;
else
ExLCDoc.AcceptStatus = bd.TransactionStatus.AUT;
//
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId);
}
else
{
if (TabId == ExportLCDocProcessing.Actions.Reject)
ExLCDoc.RejectStatus = bd.TransactionStatus.REV;
else
ExLCDoc.AcceptStatus = bd.TransactionStatus.REV;
//
dbEntities.SaveChanges();
Response.Redirect("Default.aspx?tabid=" + this.TabId + "&code=" + tbLCCode.Text);
}
}
break;
}
return;
}
#endregion Accept, Reject
}
