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