private void saveDataCharge(BEXPORT_LC ExLC) { if (ExLC.WaiveCharges.Equals(bd.YesNo.NO)) { BEXPORT_LC_CHARGES ExLCCharge; if (tbChargeAmt1.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(txtChargeCode1, rcbChargeCcy1, rcbChargeAcct1, tbChargeAmt1, rcbPartyCharged1, rcbAmortCharge1, rcbChargeStatus1, lblTaxCode1, lblTaxAmt1, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } if (tbChargeAmt2.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(txtChargeCode2, rcbChargeCcy2, rcbChargeAcct2, tbChargeAmt2, rcbPartyCharged2, rcbAmortCharge2, rcbChargeStatus2, lblTaxCode2, lblTaxAmt2, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } if (tbChargeAmt3.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(txtChargeCode3, rcbChargeCcy3, rcbChargeAcct3, tbChargeAmt3, rcbPartyCharged3, rcbAmortCharge3, rcbChargeStatus3, lblTaxCode3, lblTaxAmt3, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } } }
private void loadCharge(BEXPORT_LC_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; LoadChargeAcct(ref cbChargeAcc, cbChargeCcy.SelectedValue); 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(); }
private void saveCharge(RadTextBox txtChargeCode, RadComboBox cbChargeCcy, RadComboBox cbChargeAcc, RadNumericTextBox txtChargeAmt, RadComboBox cbChargeParty, RadComboBox cbChargeAmort, RadComboBox cbChargeStatus, Label lblTaxCode, Label lblTaxAmt, ref BEXPORT_LC_CHARGES ExLCCharge) { ExLCCharge.ExportLCCode = 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; ExLCCharge.TabId = TabId; if (!string.IsNullOrEmpty(lblTaxAmt.Text)) ExLCCharge.TaxAmt = Convert.ToDouble(lblTaxAmt.Text); }
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e) { string LCCode = tbLCCode.Text.Trim(), AmendNo = tbLCCode.Text.Trim() + "." + txtNumberOfAmendment.Value.Value; if (tbLCCode.Text.IndexOf(".") > 0) { LCCode = tbLCCode.Text.Substring(0, tbLCCode.Text.IndexOf(".")); AmendNo = tbLCCode.Text.Trim(); } var ExLC = dbEntities.findExportLC(LCCode); var ExLCAmend = dbEntities.findExportLCAmend(AmendNo); var toolBarButton = e.Item as RadToolBarButton; var commandName = toolBarButton.CommandName.ToLower(); switch (commandName) { case bc.Commands.Commit: if (ExLCAmend == null) { ExLCAmend = new BEXPORT_LC_AMEND(); ExLCAmend.AmendNo = AmendNo; ExLCAmend.AmendStatus = bd.TransactionStatus.UNA; ExLCAmend.AmendBy = this.UserInfo.Username; ExLCAmend.AmendDate = DateTime.Now; saveLCAmend(ref ExLCAmend); dbEntities.BEXPORT_LC_AMEND.Add(ExLCAmend); } else { ExLCAmend.AmendNo = AmendNo; ExLCAmend.AmendStatus = bd.TransactionStatus.UNA; saveLCAmend(ref ExLCAmend); //Xoa di insert lai var ExLCCharge = dbEntities.BEXPORT_LC_CHARGES.Where(p => p.ExportLCCode.Trim().ToLower().Equals(AmendNo.ToLower())); if (ExLCCharge != null) { foreach (BEXPORT_LC_CHARGES ch in ExLCCharge) { dbEntities.BEXPORT_LC_CHARGES.Remove(ch); } } } if (ExLCAmend.WaiveCharges.Equals(bd.YesNo.NO)) { BEXPORT_LC_CHARGES ExLCCharge; if (tbChargeAmt1.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(ExLCAmend.AmendNo, txtChargeCode1, rcbChargeCcy1, rcbChargeAcct1, tbChargeAmt1, rcbPartyCharged1, rcbAmortCharge1, rcbChargeStatus1, lblTaxCode1, lblTaxAmt1, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } if (tbChargeAmt2.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(ExLCAmend.AmendNo, txtChargeCode2, rcbChargeCcy2, rcbChargeAcct2, tbChargeAmt2, rcbPartyCharged2, rcbAmortCharge2, rcbChargeStatus2, lblTaxCode2, lblTaxAmt2, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } if (tbChargeAmt3.Value.HasValue) { ExLCCharge = new BEXPORT_LC_CHARGES(); saveCharge(ExLCAmend.AmendNo, txtChargeCode3, rcbChargeCcy3, rcbChargeAcct3, tbChargeAmt3, rcbPartyCharged3, rcbAmortCharge3, rcbChargeStatus3, lblTaxCode3, lblTaxAmt3, ref ExLCCharge); dbEntities.BEXPORT_LC_CHARGES.Add(ExLCCharge); } } // ExLC.AmendStatus = bd.TransactionStatus.UNA; ExLC.AmendBy = this.UserInfo.Username; ExLC.AmendDate = DateTime.Now; // try { dbEntities.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Diagnostics.Trace.TraceInformation("Class: {0}, Property: {1}, Error: {2}", validationErrors.Entry.Entity.GetType().FullName, validationError.PropertyName, validationError.ErrorMessage); } } throw; // You can also choose to handle the exception here... } // Response.Redirect("Default.aspx?tabid=" + this.TabId); break; case bc.Commands.Authorize: case bc.Commands.Reverse: if (commandName.Equals(bc.Commands.Authorize)) { ExLC.AmendStatus = bd.TransactionStatus.AUT; ExLCAmend.AmendStatus = bd.TransactionStatus.AUT; ExLC.Amount = ExLCAmend.NewDocumentaryCreditAmountAfterAmendment; // dbEntities.SaveChanges(); Response.Redirect("Default.aspx?tabid=" + this.TabId); return; } // ExLC.AmendStatus = bd.TransactionStatus.REV; ExLCAmend.AmendStatus = bd.TransactionStatus.REV; dbEntities.SaveChanges(); Response.Redirect("Default.aspx?tabid=" + this.TabId + "&code=" + tbLCCode.Text); break; } }