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();
}
}
}
}
private void parseTabCharge(BEXPORT_DOCUMENTPROCESSINGCHARGE drDetail, ref RadComboBox cbChargeCode, ref RadComboBox cbChargeCcy, ref RadComboBox cbChargeAcct
, ref RadNumericTextBox tbChargeAmt, ref RadComboBox cbPartyCharged, ref RadComboBox cbOmortCharges
, ref System.Web.UI.WebControls.Label lblTaxCode, ref System.Web.UI.WebControls.Label lblTaxAmt)
{
cbChargeCode.SelectedValue = drDetail.Chargecode;
cbChargeCcy.SelectedValue = drDetail.ChargeCcy;
cbChargeAcct.SelectedValue = drDetail.ChargeAcct;
if (drDetail.ChargeAmt != null)
tbChargeAmt.Value = Convert.ToInt32(drDetail.ChargeAmt);
cbPartyCharged.SelectedValue = drDetail.PartyCharged;
cbOmortCharges.SelectedValue = drDetail.OmortCharges;
lblTaxCode.Text = drDetail.TaxCode;
if (drDetail.TaxAmt!=null)
lblTaxAmt.Text = drDetail.TaxAmt.ToString();
}
