private void SaveJob() { try { string userId = HttpContext.Current.User.Identity.Name; ASPxPageControl pageControl = this.grid_Export.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl; //ASPxTextBox houseId = pageControl.FindControl("txtHouseId") as ASPxTextBox; ASPxTextBox expNoCtr = this.grid_Export.FindEditFormTemplateControl("txtHouseNo") as ASPxTextBox; int expN = 0; //SafeValue.SafeInt(expNoCtr.Text,0); string expNs = expNoCtr.Text.Trim(); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(AirImport), "JobNo='" + expNs + "'"); AirImport exp = C2.Manager.ORManager.GetObject(query) as AirImport; bool isNew = false; if (exp == null) { isNew = true; expN = 0; //GetNo("IMPORT"); exp = new AirImport(); exp.RefNo = Request.QueryString["masterNo"].ToString(); exp.JobNo = C2Setup.GetSubNo(exp.RefNo, "AE"); exp.CreateBy = userId; exp.CreateDateTime = DateTime.Now; exp.Total = "0"; exp.RefType = "AE"; exp.StatusCode = "USE"; } ASPxSpinEdit spin_Weight = this.grid_Export.FindEditFormTemplateControl("spin_Weight") as ASPxSpinEdit; exp.Weight = SafeValue.SafeDecimal(spin_Weight.Text); ASPxSpinEdit spin_Volume = this.grid_Export.FindEditFormTemplateControl("spin_Volume") as ASPxSpinEdit; exp.Volume = SafeValue.SafeDecimal(spin_Volume.Text); ASPxSpinEdit spin_Qty = this.grid_Export.FindEditFormTemplateControl("spin_Qty") as ASPxSpinEdit; exp.Qty = SafeValue.SafeInt(spin_Qty.Text, 0); ASPxButtonEdit txt_PackageType = this.grid_Export.FindEditFormTemplateControl("txt_PackageType") as ASPxButtonEdit; exp.PackageType = txt_PackageType.Text; ASPxComboBox txt_TsInd = this.grid_Export.FindEditFormTemplateControl("txt_TsInd") as ASPxComboBox; exp.TsInd = txt_TsInd.Text; ASPxMemo remark = this.grid_Export.FindEditFormTemplateControl("Memo_Remark") as ASPxMemo; exp.Remark = remark.Text; ASPxMemo marking = this.grid_Export.FindEditFormTemplateControl("Memo_Marking") as ASPxMemo; exp.Marking = marking.Text; ASPxMemo memo_Des = this.grid_Export.FindEditFormTemplateControl("Memo_Des") as ASPxMemo; exp.Description = memo_Des.Text; ASPxButtonEdit txtCustId = this.grid_Export.FindEditFormTemplateControl("txtCustId") as ASPxButtonEdit; exp.CustomerId = txtCustId.Text; ASPxTextBox txtHouseBl = this.grid_Export.FindEditFormTemplateControl("txtHouseBl") as ASPxTextBox; exp.Hawb = txtHouseBl.Text; ASPxMemo tbxShipperName = pageControl.FindControl("tbxShipperName") as ASPxMemo; exp.ShipperName = tbxShipperName.Text; ASPxMemo tbxIssuedBy = pageControl.FindControl("tbxIssuedBy") as ASPxMemo; exp.IssuedBy = tbxIssuedBy.Text; ASPxMemo tbxConsigneeName = pageControl.FindControl("tbxConsigneeName") as ASPxMemo; exp.ConsigneeName = tbxConsigneeName.Text; ASPxMemo tbxCarrierAgent = pageControl.FindControl("tbxCarrierAgent") as ASPxMemo; exp.CarrierAgent = tbxCarrierAgent.Text; ASPxMemo tbxAccountInfo = pageControl.FindControl("tbxAccountInfo") as ASPxMemo; exp.AccountInfo = tbxAccountInfo.Text; ASPxTextBox tbxAgentIATACode = pageControl.FindControl("tbxAgentIATACode") as ASPxTextBox; exp.AgentIATACode = tbxAgentIATACode.Text; ASPxTextBox tbxAgentAccountNo = pageControl.FindControl("tbxAgentAccountNo") as ASPxTextBox; exp.AgentAccountNo = tbxAgentAccountNo.Text; ASPxTextBox tbxAirportDeparture = pageControl.FindControl("tbxAirportDeparture") as ASPxTextBox; exp.AirportDeparture = tbxAirportDeparture.Text; ASPxTextBox tbxConnDest1 = pageControl.FindControl("tbxConnDest1") as ASPxTextBox; exp.ConnDest1 = tbxConnDest1.Text; ASPxTextBox tbxConnCarrier1 = pageControl.FindControl("tbxConnCarrier1") as ASPxTextBox; exp.ConnCarrier1 = tbxConnCarrier1.Text; ASPxTextBox tbxConnDest2 = pageControl.FindControl("tbxConnDest2") as ASPxTextBox; exp.ConnDest2 = tbxConnDest2.Text; ASPxTextBox tbxConnCarrier2 = pageControl.FindControl("tbxConnCarrier2") as ASPxTextBox; exp.ConnCarrier2 = tbxConnCarrier2.Text; ASPxTextBox tbxConnDest3 = pageControl.FindControl("tbxConnDest3") as ASPxTextBox; exp.ConnDest3 = tbxConnDest3.Text; ASPxTextBox tbxConnCarrier3 = pageControl.FindControl("tbxConnCarrier3") as ASPxTextBox; exp.ConnCarrier3 = tbxConnCarrier3.Text; ASPxTextBox tbxCurrency = pageControl.FindControl("tbxCurrency") as ASPxTextBox; exp.Currency = tbxCurrency.Text; ASPxTextBox tbxChgsCode = pageControl.FindControl("tbxChgsCode") as ASPxTextBox; exp.ChgsCode = tbxChgsCode.Text; ASPxTextBox tbxPPD1 = pageControl.FindControl("tbxPPD1") as ASPxTextBox; exp.Ppd1 = tbxPPD1.Text; ASPxTextBox tbxCOLL1 = pageControl.FindControl("tbxCOLL1") as ASPxTextBox; exp.Coll1 = tbxCOLL1.Text; ASPxTextBox tbxPPD2 = pageControl.FindControl("tbxPPD2") as ASPxTextBox; exp.Ppd2 = tbxPPD2.Text; ASPxTextBox tbxCOLL2 = pageControl.FindControl("tbxCOLL2") as ASPxTextBox; exp.Coll2 = tbxCOLL2.Text; ASPxTextBox tbxCarriageValue = pageControl.FindControl("tbxCarriageValue") as ASPxTextBox; exp.CarriageValue = tbxCarriageValue.Text; ASPxTextBox tbxCustomValue = pageControl.FindControl("tbxCustomValue") as ASPxTextBox; exp.CustomValue = tbxCustomValue.Text; ASPxTextBox tbxAirportDestination = pageControl.FindControl("tbxAirportDestination") as ASPxTextBox; exp.AirportDestination = tbxAirportDestination.Text; ASPxTextBox tbxRequestedFlight = pageControl.FindControl("tbxRequestedFlight") as ASPxTextBox; exp.RequestedFlight = tbxRequestedFlight.Text; ASPxTextBox tbxRequestedDate = pageControl.FindControl("tbxRequestedDate") as ASPxTextBox; exp.RequestedDate = tbxRequestedDate.Text; ASPxTextBox tbxAmountInsurance = pageControl.FindControl("tbxAmountInsurance") as ASPxTextBox; exp.AmountInsurance = tbxAmountInsurance.Text; ASPxMemo tbxHandlingInfo = pageControl.FindControl("tbxHandlingInfo") as ASPxMemo; exp.HandlingInfo = tbxHandlingInfo.Text; ASPxTextBox tbxPiece = pageControl.FindControl("tbxPiece") as ASPxTextBox; exp.Piece = tbxPiece.Text; ASPxSpinEdit tbxGrossWeight = pageControl.FindControl("tbxGrossWeight") as ASPxSpinEdit; exp.GrossWeight = tbxGrossWeight.Text; ASPxSpinEdit tbxUnit = pageControl.FindControl("tbxUnit") as ASPxSpinEdit; exp.Unit = tbxUnit.Text; ASPxTextBox tbxRateClass = pageControl.FindControl("tbxRateClass") as ASPxTextBox; exp.RateClass = tbxRateClass.Text; ASPxTextBox tbxCommodityItemNo = pageControl.FindControl("tbxCommodityItemNo") as ASPxTextBox; exp.CommodityItemNo = tbxCommodityItemNo.Text; ASPxSpinEdit tbxChargeableWeight = pageControl.FindControl("tbxChargeableWeight") as ASPxSpinEdit; exp.ChargeableWeight = tbxChargeableWeight.Text; ASPxTextBox tbxRateCharge = pageControl.FindControl("tbxRateCharge") as ASPxTextBox; exp.RateCharge = tbxRateCharge.Text; ASPxSpinEdit tbxTotal = pageControl.FindControl("tbxTotal") as ASPxSpinEdit; exp.Total = tbxTotal.Text; ASPxMemo tbxGoodsNature = pageControl.FindControl("tbxGoodsNature") as ASPxMemo; exp.GoodsNature = tbxGoodsNature.Text; ASPxMemo tbxContentRemark = pageControl.FindControl("tbxContentRemark") as ASPxMemo; exp.ContentRemark = tbxContentRemark.Text; ASPxTextBox tbxWeightChargeP = pageControl.FindControl("tbxWeightChargeP") as ASPxTextBox; exp.WeightChargeP = tbxWeightChargeP.Text; ASPxTextBox tbxWeightChargeC = pageControl.FindControl("tbxWeightChargeC") as ASPxTextBox; exp.WeightChargeC = tbxWeightChargeC.Text; ASPxTextBox tbxValuationChargeP = pageControl.FindControl("tbxValuationChargeP") as ASPxTextBox; exp.ValuationChargeP = tbxValuationChargeP.Text; ASPxTextBox tbxValuationChargeC = pageControl.FindControl("tbxValuationChargeC") as ASPxTextBox; exp.ValuationChargeC = tbxValuationChargeC.Text; ASPxTextBox tbxTaxP = pageControl.FindControl("tbxTaxP") as ASPxTextBox; exp.TaxP = tbxTaxP.Text; ASPxTextBox tbxTaxC = pageControl.FindControl("tbxTaxC") as ASPxTextBox; exp.TaxC = tbxTaxC.Text; ASPxTextBox tbxOtherAgentChargeP = pageControl.FindControl("tbxOtherAgentChargeP") as ASPxTextBox; exp.OtherAgentChargeP = tbxOtherAgentChargeP.Text; ASPxTextBox tbxOtherAgentChargeC = pageControl.FindControl("tbxOtherAgentChargeC") as ASPxTextBox; exp.OtherAgentChargeC = tbxOtherAgentChargeC.Text; ASPxTextBox tbxOtherCarrierChargeP = pageControl.FindControl("tbxOtherCarrierChargeP") as ASPxTextBox; exp.OtherCarrierChargeP = tbxOtherCarrierChargeP.Text; ASPxTextBox tbxOtherCarrierChargeC = pageControl.FindControl("tbxOtherCarrierChargeC") as ASPxTextBox; exp.OtherCarrierChargeC = tbxOtherCarrierChargeC.Text; ASPxTextBox tbxTotalPrepaid = pageControl.FindControl("tbxTotalPrepaid") as ASPxTextBox; exp.TotalPrepaid = tbxTotalPrepaid.Text; ASPxTextBox tbxTotalCollect = pageControl.FindControl("tbxTotalCollect") as ASPxTextBox; exp.TotalCollect = tbxTotalCollect.Text; ASPxTextBox tbxCurrencyRate = pageControl.FindControl("tbxCurrencyRate") as ASPxTextBox; exp.CurrencyRate = tbxCurrencyRate.Text; ASPxTextBox tbxChargeDestCurrency = pageControl.FindControl("tbxChargeDestCurrency") as ASPxTextBox; exp.ChargeDestCurrency = tbxChargeDestCurrency.Text; ASPxTextBox tbxOtherCharge1 = pageControl.FindControl("tbxOtherCharge1") as ASPxTextBox; exp.OtherCharge1 = tbxOtherCharge1.Text; ASPxTextBox tbxOtherCharge1Currency = pageControl.FindControl("tbxOtherCharge1Currency") as ASPxTextBox; exp.OtherCharge1Currency = tbxOtherCharge1Currency.Text; ASPxSpinEdit tbxOtherCharge1Amount = pageControl.FindControl("tbxOtherCharge1Amount") as ASPxSpinEdit; exp.OtherCharge1Amount = SafeValue.SafeDecimal(tbxOtherCharge1Amount.Text); ASPxTextBox tbxOtherCharge2 = pageControl.FindControl("tbxOtherCharge2") as ASPxTextBox; exp.OtherCharge2 = tbxOtherCharge2.Text; ASPxTextBox tbxOtherCharge2Currency = pageControl.FindControl("tbxOtherCharge2Currency") as ASPxTextBox; exp.OtherCharge2Currency = tbxOtherCharge2Currency.Text; ASPxSpinEdit tbxOtherCharge2Amount = pageControl.FindControl("tbxOtherCharge2Amount") as ASPxSpinEdit; exp.OtherCharge2Amount = SafeValue.SafeDecimal(tbxOtherCharge2Amount.Text); ASPxTextBox tbxOtherCharge3 = pageControl.FindControl("tbxOtherCharge3") as ASPxTextBox; exp.OtherCharge3 = tbxOtherCharge3.Text; ASPxTextBox tbxOtherCharge3Currency = pageControl.FindControl("tbxOtherCharge3Currency") as ASPxTextBox; exp.OtherCharge3Currency = tbxOtherCharge3Currency.Text; ASPxSpinEdit tbxOtherCharge3Amount = pageControl.FindControl("tbxOtherCharge3Amount") as ASPxSpinEdit; exp.OtherCharge3Amount = SafeValue.SafeDecimal(tbxOtherCharge3Amount.Text); ASPxTextBox tbxOtherCharge4 = pageControl.FindControl("tbxOtherCharge4") as ASPxTextBox; exp.OtherCharge4 = tbxOtherCharge4.Text; ASPxTextBox tbxOtherCharge4Currency = pageControl.FindControl("tbxOtherCharge4Currency") as ASPxTextBox; exp.OtherCharge4Currency = tbxOtherCharge4Currency.Text; ASPxSpinEdit tbxOtherCharge4Amount = pageControl.FindControl("tbxOtherCharge4Amount") as ASPxSpinEdit; exp.OtherCharge4Amount = SafeValue.SafeDecimal(tbxOtherCharge4Amount.Text); ASPxTextBox tbxOtherCharge5 = pageControl.FindControl("tbxOtherCharge5") as ASPxTextBox; exp.OtherCharge5 = tbxOtherCharge5.Text; ASPxTextBox tbxOtherCharge5Currency = pageControl.FindControl("tbxOtherCharge5Currency") as ASPxTextBox; exp.OtherCharge5Currency = tbxOtherCharge5Currency.Text; ASPxSpinEdit tbxOtherCharge5Amount = pageControl.FindControl("tbxOtherCharge5Amount") as ASPxSpinEdit; exp.OtherCharge5Amount = SafeValue.SafeDecimal(tbxOtherCharge5Amount.Text); ASPxTextBox tbxSignatureShipper = pageControl.FindControl("tbxSignatureShipper") as ASPxTextBox; exp.SignatureShipper = tbxSignatureShipper.Text; ASPxTextBox tbxExecuteDate = pageControl.FindControl("tbxExecuteDate") as ASPxTextBox; exp.ExecuteDate = tbxExecuteDate.Text; ASPxTextBox tbxExecutePlace = pageControl.FindControl("tbxExecutePlace") as ASPxTextBox; exp.ExecutePlace = tbxExecutePlace.Text; ASPxTextBox tbxSignatureIssuing = pageControl.FindControl("tbxSignatureIssuing") as ASPxTextBox; exp.SignatureIssuing = tbxSignatureIssuing.Text; ASPxButtonEdit haulier = pageControl.FindControl("txt_Ref_H_Haulier") as ASPxButtonEdit; exp.HaulierName = haulier.Text; ASPxTextBox crno = pageControl.FindControl("txt_Ref_H_CrNo") as ASPxTextBox; exp.HaulierCrNo = crno.Text; ASPxTextBox attention = pageControl.FindControl("txt_Ref_H_Attention") as ASPxTextBox; exp.HaulierAttention = attention.Text; ASPxMemo collectFrm1 = pageControl.FindControl("txt_Ref_H_CltFrm") as ASPxMemo; exp.HaulierCollect = collectFrm1.Text; ASPxMemo truckTo1 = pageControl.FindControl("txt_Ref_H_TruckTo") as ASPxMemo; exp.HaulierTruck = truckTo1.Text; ASPxDateEdit collectDate = pageControl.FindControl("date_Ref_H_CltDate") as ASPxDateEdit; exp.HaulierCollectDate = collectDate.Date; ASPxMemo haulierRmk = pageControl.FindControl("txt_Ref_H_Rmk1") as ASPxMemo; exp.HaulierRemark = haulierRmk.Text; ASPxMemo haulierPermit = pageControl.FindControl("txt_Hbl_Permit") as ASPxMemo; exp.PermitRmk = haulierPermit.Text; ASPxTextBox txt_DriverName = pageControl.FindControl("txt_DriverName") as ASPxTextBox; exp.DriverName = txt_DriverName.Text; ASPxTextBox txt_DriverMobile = pageControl.FindControl("txt_DriverMobile") as ASPxTextBox; exp.DriverMobile = txt_DriverMobile.Text; ASPxTextBox txt_DriverLicense = pageControl.FindControl("txt_DriverLicense") as ASPxTextBox; exp.DriverLicense = txt_DriverLicense.Text; ASPxTextBox txt_VehicleNo = pageControl.FindControl("txt_VehicleNo") as ASPxTextBox; exp.VehicleNo = txt_VehicleNo.Text; ASPxTextBox txt_VehicleType = pageControl.FindControl("txt_VehicleType") as ASPxTextBox; exp.VehicleType = txt_VehicleType.Text; ASPxMemo me_DriverRemark = pageControl.FindControl("me_DriverRemark") as ASPxMemo; exp.DriverRemark = me_DriverRemark.Text; ASPxDateEdit deliveryDate = this.grid_Export.FindEditFormTemplateControl("date_DeliveryDate") as ASPxDateEdit; exp.DeliveryDate = deliveryDate.Date; ASPxComboBox doReady = this.grid_Export.FindEditFormTemplateControl("txtDoReady") as ASPxComboBox; exp.DoReadyInd = doReady.Text; ASPxButtonEdit txtPODBy = pageControl.FindControl("txtPODBy") as ASPxButtonEdit; exp.PODBy = txtPODBy.Text; ASPxDateEdit date_PodTime = pageControl.FindControl("date_PodTime") as ASPxDateEdit; exp.PODTime = date_PodTime.Date; ASPxMemo me_Remark = pageControl.FindControl("me_Remark") as ASPxMemo; exp.PODRemark = me_Remark.Text; exp.PODUpdateUser = EzshipHelper.GetUserName(); exp.PODUpdateTime = DateTime.Now; ASPxTextBox txt_TsBkgRef = this.grid_Export.FindEditFormTemplateControl("txt_TsBkgRef") as ASPxTextBox; exp.TsBkgRef = txt_TsBkgRef.Text; ASPxTextBox txt_TsBkgUser = this.grid_Export.FindEditFormTemplateControl("txt_TsBkgUser") as ASPxTextBox; exp.TsBkgUser = txt_TsBkgUser.Text; ASPxDateEdit date_TsBkgTime = this.grid_Export.FindEditFormTemplateControl("date_TsBkgTime") as ASPxDateEdit; exp.TsBkgTime = date_TsBkgTime.Date; if (isNew) { exp.CloseInd = "N"; exp.CreateBy = userId; exp.CreateDateTime = DateTime.Now; exp.RefNo = Request.QueryString["masterNo"].ToString(); C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(exp); //SetNewNo("IMPORT", expN); } else { exp.UpdateBy = userId; exp.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(exp); } UpdateMast(exp.RefNo); Session["AirExpWhere"] = "JobNo='" + exp.JobNo + "'"; this.dsJob.FilterExpression = Session["AirExpWhere"].ToString(); if (this.grid_Export.GetRow(0) != null) { this.grid_Export.StartEdit(0); } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } }
private void SaveJob() { try { ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox txtRefNo = this.grid_ref.FindEditFormTemplateControl("txt_RefN") as ASPxTextBox; ASPxTextBox txt_Id = this.grid_ref.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; ASPxDateEdit refDate = this.grid_ref.FindEditFormTemplateControl("date_RefDate") as ASPxDateEdit; string refNo = SafeValue.SafeString(txt_RefNo.Text, ""); int id = SafeValue.SafeInt(txt_Id.Text, 0); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(AirImportRef), "Id=" + id + ""); AirImportRef airRef = C2.Manager.ORManager.GetObject(query) as AirImportRef; bool isNew = false; string userId = HttpContext.Current.User.Identity.Name; if (airRef == null) { airRef = new AirImportRef(); isNew = true; refNo = C2Setup.GetNextNo("AI", "AirImport", refDate.Date); AirImport air = new AirImport(); air.JobNo = C2Setup.GetSubNo(refNo, "AI"); air.CloseInd = "N"; air.CreateBy = userId; air.CreateDateTime = DateTime.Now; air.RefNo = refNo; air.Total = "0"; air.RefType = "AI"; air.StatusCode = "USE"; C2.Manager.ORManager.StartTracking(air, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(air); } ASPxButtonEdit txt_AgentId = this.grid_ref.FindEditFormTemplateControl("txt_AgentId") as ASPxButtonEdit; airRef.AgentId = txt_AgentId.Text; ASPxButtonEdit localCust = this.grid_ref.FindEditFormTemplateControl("txt_LocalCust") as ASPxButtonEdit; airRef.LocalCust = localCust.Text; ASPxMemo remarks = pageControl.FindControl("txt_Remarks") as ASPxMemo; airRef.Remarks = remarks.Text; ASPxButtonEdit tbxAirportCode0 = pageControl.FindControl("tbxAirportCode0") as ASPxButtonEdit; airRef.AirportCode0 = tbxAirportCode0.Text; ASPxTextBox tbxAirportName0 = pageControl.FindControl("tbxAirportName0") as ASPxTextBox; airRef.AirportName0 = tbxAirportName0.Text; ASPxDateEdit date_FlightDate0 = pageControl.FindControl("date_FlightDate0") as ASPxDateEdit; airRef.FlightDate0 = date_FlightDate0.Date; ASPxTextBox tbxFlightTime0 = pageControl.FindControl("tbxFlightTime0") as ASPxTextBox; airRef.FlightTime0 = tbxFlightTime0.Text; airRef.RefDate = refDate.Date; ASPxButtonEdit tbxAirportCode1 = pageControl.FindControl("txt_AirportCode1") as ASPxButtonEdit; airRef.AirportCode1 = tbxAirportCode1.Text; ASPxTextBox tbxAirportName1 = pageControl.FindControl("txt_AirportName1") as ASPxTextBox; airRef.AirportName1 = tbxAirportName1.Text; ASPxDateEdit spin_FlightDate1 = pageControl.FindControl("spin_FlightDate1") as ASPxDateEdit; airRef.FlightDate1 = spin_FlightDate1.Date; ASPxTextBox txt_FlightTime1 = pageControl.FindControl("txt_FlightTime1") as ASPxTextBox; airRef.FlightTime1 = txt_FlightTime1.Text; ASPxTextBox tbxAirlineCode1 = pageControl.FindControl("tbxAirlineCode1") as ASPxTextBox; airRef.AirlineCode1 = tbxAirlineCode1.Text; ASPxTextBox tbxAirlineName1 = pageControl.FindControl("tbxAirlineName1") as ASPxTextBox; airRef.AirlineName1 = tbxAirlineName1.Text; ASPxTextBox tbxFlightNo1 = pageControl.FindControl("tbxFlightNo1") as ASPxTextBox; airRef.FlightNo1 = tbxFlightNo1.Text; ASPxDateEdit tbxAirFlightDate1 = pageControl.FindControl("tbxAirFlightDate1") as ASPxDateEdit; airRef.AirFlightDate1 = tbxAirFlightDate1.Date; ASPxTextBox tbxAirFlightTime1 = pageControl.FindControl("tbxAirFlightTime1") as ASPxTextBox; airRef.AirFlightTime1 = tbxAirFlightTime1.Text; ASPxButtonEdit tbxAirLinePortCode1 = pageControl.FindControl("tbxAirLinePortCode1") as ASPxButtonEdit; airRef.AirLinePortCode1 = tbxAirLinePortCode1.Text; ASPxTextBox tbxAirLinePortName1 = pageControl.FindControl("tbxAirLinePortName1") as ASPxTextBox; airRef.AirLinePortName1 = tbxAirLinePortName1.Text; ASPxTextBox tbxAirlineCode2 = pageControl.FindControl("tbxAirlineCode2") as ASPxTextBox; airRef.AirlineCode2 = tbxAirlineCode2.Text; ASPxTextBox tbxAirlineName2 = pageControl.FindControl("tbxAirlineName2") as ASPxTextBox; airRef.AirlineName2 = tbxAirlineName2.Text; ASPxTextBox tbxFlightNo2 = pageControl.FindControl("tbxFlightNo2") as ASPxTextBox; airRef.FlightNo2 = tbxFlightNo2.Text; ASPxDateEdit tbxFlightDate2 = pageControl.FindControl("tbxFlightDate2") as ASPxDateEdit; airRef.FlightDate2 = tbxFlightDate2.Date; ASPxTextBox tbxFlightTime2 = pageControl.FindControl("tbxFlightTime2") as ASPxTextBox; airRef.FlightTime2 = tbxFlightTime2.Text; ASPxButtonEdit tbxAirportCode2 = pageControl.FindControl("tbxAirportCode2") as ASPxButtonEdit; airRef.AirportCode2 = tbxAirportCode2.Text; ASPxTextBox AirportName2 = pageControl.FindControl("tbxAirportName2") as ASPxTextBox; airRef.AirportName2 = AirportName2.Text; ASPxTextBox tbxAirlineCode3 = pageControl.FindControl("tbxAirlineCode3") as ASPxTextBox; airRef.AirlineCode3 = tbxAirlineCode3.Text; ASPxTextBox tbxAirlineName3 = pageControl.FindControl("tbxAirlineName3") as ASPxTextBox; airRef.AirlineName3 = tbxAirlineName3.Text; ASPxTextBox tbxFlightNo3 = pageControl.FindControl("tbxFlightNo3") as ASPxTextBox; airRef.FlightNo3 = tbxFlightNo3.Text; ASPxDateEdit tbxFlightDate3 = pageControl.FindControl("tbxFlightDate3") as ASPxDateEdit; airRef.FlightDate3 = tbxFlightDate3.Date; ASPxTextBox tbxFlightTime3 = pageControl.FindControl("tbxFlightTime3") as ASPxTextBox; airRef.FlightTime3 = tbxFlightTime3.Text; ASPxButtonEdit tbxAirportCode3 = pageControl.FindControl("tbxAirportCode3") as ASPxButtonEdit; airRef.AirportCode3 = tbxAirportCode3.Text; ASPxTextBox tbxAirportName3 = pageControl.FindControl("tbxAirportName3") as ASPxTextBox; airRef.AirportName3 = tbxAirportName3.Text; ASPxTextBox tbxAirlineCode4 = pageControl.FindControl("tbxAirlineCode4") as ASPxTextBox; airRef.AirlineCode4 = tbxAirlineCode4.Text; ASPxTextBox tbxAirlineName4 = pageControl.FindControl("tbxAirlineName4") as ASPxTextBox; airRef.AirlineName4 = tbxAirlineName4.Text; ASPxTextBox tbxFlightNo4 = pageControl.FindControl("tbxFlightNo4") as ASPxTextBox; airRef.FlightNo4 = tbxFlightNo4.Text; ASPxDateEdit tbxFlightDate4 = pageControl.FindControl("tbxFlightDate4") as ASPxDateEdit; airRef.FlightDate4 = tbxFlightDate4.Date; ASPxTextBox tbxFlightTime4 = pageControl.FindControl("tbxFlightTime4") as ASPxTextBox; airRef.FlightTime4 = tbxFlightTime4.Text; ASPxButtonEdit tbxAirportCode4 = pageControl.FindControl("tbxAirportCode4") as ASPxButtonEdit; airRef.AirportCode4 = tbxAirportCode4.Text; ASPxTextBox AirportName4 = pageControl.FindControl("tbxAirportName4") as ASPxTextBox; airRef.AirportName4 = AirportName4.Text; ASPxTextBox txtMAWB = this.grid_ref.FindEditFormTemplateControl("txt_MAWB") as ASPxTextBox; airRef.Mawb = txtMAWB.Text; ASPxButtonEdit txt_CrAgentId = this.grid_ref.FindEditFormTemplateControl("txt_CrAgentId") as ASPxButtonEdit; airRef.CarrierAgentId = txt_CrAgentId.Text; ASPxTextBox txt_CrBkgRefN = this.grid_ref.FindEditFormTemplateControl("txt_CrBkgRefN") as ASPxTextBox; airRef.CarrierBkgNo = txt_CrBkgRefN.Text; ASPxButtonEdit txt_NvoccAgentId = pageControl.FindControl("txt_NvoccAgentId") as ASPxButtonEdit; airRef.NvoccAgentId = txt_NvoccAgentId.Text; ASPxTextBox txt_NvoccBl = pageControl.FindControl("txt_NvoccBl") as ASPxTextBox; airRef.NvoccBlNO = txt_NvoccBl.Text; ASPxButtonEdit cbx_Currency = pageControl.FindControl("cbx_Currency") as ASPxButtonEdit; airRef.CurrencyId = cbx_Currency.Text; ASPxSpinEdit spin_CrExRate = pageControl.FindControl("spin_CrExRate") as ASPxSpinEdit; airRef.ExRate = SafeValue.SafeDecimal(spin_CrExRate.Value, 0); ASPxButtonEdit txt_WhId = pageControl.FindControl("txt_WhId") as ASPxButtonEdit; airRef.WareHouseId = txt_WhId.Text; ASPxMemo tbxShipperName = pageControl.FindControl("tbxShipperName") as ASPxMemo; airRef.ShipperName = tbxShipperName.Text; ASPxMemo tbxIssuedBy = pageControl.FindControl("tbxIssuedBy") as ASPxMemo; airRef.IssuedBy = tbxIssuedBy.Text; ASPxMemo tbxConsigneeName = pageControl.FindControl("tbxConsigneeName") as ASPxMemo; airRef.ConsigneeName = tbxConsigneeName.Text; ASPxMemo tbxCarrierAgent = pageControl.FindControl("tbxCarrierAgent") as ASPxMemo; airRef.CarrierAgent = tbxCarrierAgent.Text; ASPxMemo tbxAccountInfo = pageControl.FindControl("tbxAccountInfo") as ASPxMemo; airRef.AccountInfo = tbxAccountInfo.Text; ASPxTextBox tbxAgentIATACode = pageControl.FindControl("tbxAgentIATACode") as ASPxTextBox; airRef.AgentIATACode = tbxAgentIATACode.Text; ASPxTextBox tbxAgentAccountNo = pageControl.FindControl("tbxAgentAccountNo") as ASPxTextBox; airRef.AgentAccountNo = tbxAgentAccountNo.Text; ASPxTextBox tbxAirportDeparture = pageControl.FindControl("tbxAirportDeparture") as ASPxTextBox; airRef.AirportDeparture = tbxAirportDeparture.Text; ASPxTextBox tbxConnDest1 = pageControl.FindControl("tbxConnDest1") as ASPxTextBox; airRef.ConnDest1 = tbxConnDest1.Text; ASPxTextBox tbxConnCarrier1 = pageControl.FindControl("tbxConnCarrier1") as ASPxTextBox; airRef.ConnCarrier1 = tbxConnCarrier1.Text; ASPxTextBox tbxConnDest2 = pageControl.FindControl("tbxConnDest2") as ASPxTextBox; airRef.ConnDest2 = tbxConnDest2.Text; ASPxTextBox tbxConnCarrier2 = pageControl.FindControl("tbxConnCarrier2") as ASPxTextBox; airRef.ConnCarrier2 = tbxConnCarrier2.Text; ASPxTextBox tbxConnDest3 = pageControl.FindControl("tbxConnDest3") as ASPxTextBox; airRef.ConnDest3 = tbxConnDest3.Text; ASPxTextBox tbxConnCarrier3 = pageControl.FindControl("tbxConnCarrier3") as ASPxTextBox; airRef.ConnCarrier3 = tbxConnCarrier3.Text; ASPxTextBox tbxCurrency = pageControl.FindControl("tbxCurrency") as ASPxTextBox; airRef.Currency = tbxCurrency.Text; ASPxTextBox tbxChgsCode = pageControl.FindControl("tbxChgsCode") as ASPxTextBox; airRef.ChgsCode = tbxChgsCode.Text; ASPxTextBox tbxPPD1 = pageControl.FindControl("tbxPPD1") as ASPxTextBox; airRef.Ppd1 = tbxPPD1.Text; ASPxTextBox tbxCOLL1 = pageControl.FindControl("tbxCOLL1") as ASPxTextBox; airRef.Coll1 = tbxCOLL1.Text; ASPxTextBox tbxPPD2 = pageControl.FindControl("tbxPPD2") as ASPxTextBox; airRef.Ppd2 = tbxPPD2.Text; ASPxTextBox tbxCOLL2 = pageControl.FindControl("tbxCOLL2") as ASPxTextBox; airRef.Coll2 = tbxCOLL2.Text; ASPxTextBox tbxCarriageValue = pageControl.FindControl("tbxCarriageValue") as ASPxTextBox; airRef.CarriageValue = tbxCarriageValue.Text; ASPxTextBox tbxCustomValue = pageControl.FindControl("tbxCustomValue") as ASPxTextBox; airRef.CustomValue = tbxCustomValue.Text; ASPxTextBox tbxAirportDestination = pageControl.FindControl("tbxAirportDestination") as ASPxTextBox; airRef.AirportDestination = tbxAirportDestination.Text; ASPxTextBox tbxRequestedFlight = pageControl.FindControl("tbxRequestedFlight") as ASPxTextBox; airRef.RequestedFlight = tbxRequestedFlight.Text; ASPxTextBox tbxRequestedDate = pageControl.FindControl("tbxRequestedDate") as ASPxTextBox; airRef.RequestedDate = tbxRequestedDate.Text; ASPxTextBox tbxAmountInsurance = pageControl.FindControl("tbxAmountInsurance") as ASPxTextBox; airRef.AmountInsurance = tbxAmountInsurance.Text; ASPxMemo tbxHandlingInfo = pageControl.FindControl("tbxHandlingInfo") as ASPxMemo; airRef.HandlingInfo = tbxHandlingInfo.Text; ASPxTextBox tbxPiece = pageControl.FindControl("tbxPiece") as ASPxTextBox; airRef.Piece = tbxPiece.Text; ASPxSpinEdit tbxGrossWeight = pageControl.FindControl("tbxGrossWeight") as ASPxSpinEdit; airRef.GrossWeight = tbxGrossWeight.Text; ASPxSpinEdit tbxUnit = pageControl.FindControl("tbxUnit") as ASPxSpinEdit; airRef.Unit = tbxUnit.Text; ASPxTextBox tbxRateClass = pageControl.FindControl("tbxRateClass") as ASPxTextBox; airRef.RateClass = tbxRateClass.Text; ASPxTextBox tbxCommodityItemNo = pageControl.FindControl("tbxCommodityItemNo") as ASPxTextBox; airRef.CommodityItemNo = tbxCommodityItemNo.Text; ASPxSpinEdit tbxChargeableWeight = pageControl.FindControl("tbxChargeableWeight") as ASPxSpinEdit; airRef.ChargeableWeight = tbxChargeableWeight.Text; ASPxTextBox tbxRateCharge = pageControl.FindControl("tbxRateCharge") as ASPxTextBox; airRef.RateCharge = tbxRateCharge.Text; ASPxSpinEdit tbxTotal = pageControl.FindControl("tbxTotal") as ASPxSpinEdit; airRef.Total = tbxTotal.Text; ASPxMemo tbxGoodsNature = pageControl.FindControl("tbxGoodsNature") as ASPxMemo; airRef.GoodsNature = tbxGoodsNature.Text; ASPxMemo tbxContentRemark = pageControl.FindControl("tbxContentRemark") as ASPxMemo; airRef.ContentRemark = tbxContentRemark.Text; ASPxTextBox tbxWeightChargeP = pageControl.FindControl("tbxWeightChargeP") as ASPxTextBox; airRef.WeightChargeP = tbxWeightChargeP.Text; ASPxTextBox tbxWeightChargeC = pageControl.FindControl("tbxWeightChargeC") as ASPxTextBox; airRef.WeightChargeC = tbxWeightChargeC.Text; ASPxTextBox tbxValuationChargeP = pageControl.FindControl("tbxValuationChargeP") as ASPxTextBox; airRef.ValuationChargeP = tbxValuationChargeP.Text; ASPxTextBox tbxValuationChargeC = pageControl.FindControl("tbxValuationChargeC") as ASPxTextBox; airRef.ValuationChargeC = tbxValuationChargeC.Text; ASPxTextBox tbxTaxP = pageControl.FindControl("tbxTaxP") as ASPxTextBox; airRef.TaxP = tbxTaxP.Text; ASPxTextBox tbxTaxC = pageControl.FindControl("tbxTaxC") as ASPxTextBox; airRef.TaxC = tbxTaxC.Text; ASPxTextBox tbxOtherAgentChargeP = pageControl.FindControl("tbxOtherAgentChargeP") as ASPxTextBox; airRef.OtherAgentChargeP = tbxOtherAgentChargeP.Text; ASPxTextBox tbxOtherAgentChargeC = pageControl.FindControl("tbxOtherAgentChargeC") as ASPxTextBox; airRef.OtherAgentChargeC = tbxOtherAgentChargeC.Text; ASPxTextBox tbxOtherCarrierChargeP = pageControl.FindControl("tbxOtherCarrierChargeP") as ASPxTextBox; airRef.OtherCarrierChargeP = tbxOtherCarrierChargeP.Text; ASPxTextBox tbxOtherCarrierChargeC = pageControl.FindControl("tbxOtherCarrierChargeC") as ASPxTextBox; airRef.OtherCarrierChargeC = tbxOtherCarrierChargeC.Text; ASPxTextBox tbxTotalPrepaid = pageControl.FindControl("tbxTotalPrepaid") as ASPxTextBox; airRef.TotalPrepaid = tbxTotalPrepaid.Text; ASPxTextBox tbxTotalCollect = pageControl.FindControl("tbxTotalCollect") as ASPxTextBox; airRef.TotalCollect = tbxTotalCollect.Text; ASPxTextBox tbxCurrencyRate = pageControl.FindControl("tbxCurrencyRate") as ASPxTextBox; airRef.CurrencyRate = tbxCurrencyRate.Text; ASPxTextBox tbxChargeDestCurrency = pageControl.FindControl("tbxChargeDestCurrency") as ASPxTextBox; airRef.ChargeDestCurrency = tbxChargeDestCurrency.Text; ASPxTextBox tbxOtherCharge1 = pageControl.FindControl("tbxOtherCharge1") as ASPxTextBox; airRef.OtherCharge1 = tbxOtherCharge1.Text; ASPxTextBox tbxOtherCharge1Currency = pageControl.FindControl("tbxOtherCharge1Currency") as ASPxTextBox; airRef.OtherCharge1Currency = tbxOtherCharge1Currency.Text; ASPxSpinEdit tbxOtherCharge1Amount = pageControl.FindControl("tbxOtherCharge1Amount") as ASPxSpinEdit; airRef.OtherCharge1Amount = SafeValue.SafeDecimal(tbxOtherCharge1Amount.Text); ASPxTextBox tbxOtherCharge2 = pageControl.FindControl("tbxOtherCharge2") as ASPxTextBox; airRef.OtherCharge2 = tbxOtherCharge2.Text; ASPxTextBox tbxOtherCharge2Currency = pageControl.FindControl("tbxOtherCharge2Currency") as ASPxTextBox; airRef.OtherCharge2Currency = tbxOtherCharge2Currency.Text; ASPxSpinEdit tbxOtherCharge2Amount = pageControl.FindControl("tbxOtherCharge2Amount") as ASPxSpinEdit; airRef.OtherCharge2Amount = SafeValue.SafeDecimal(tbxOtherCharge2Amount.Text); ASPxTextBox tbxOtherCharge3 = pageControl.FindControl("tbxOtherCharge3") as ASPxTextBox; airRef.OtherCharge3 = tbxOtherCharge3.Text; ASPxTextBox tbxOtherCharge3Currency = pageControl.FindControl("tbxOtherCharge3Currency") as ASPxTextBox; airRef.OtherCharge3Currency = tbxOtherCharge3Currency.Text; ASPxSpinEdit tbxOtherCharge3Amount = pageControl.FindControl("tbxOtherCharge3Amount") as ASPxSpinEdit; airRef.OtherCharge3Amount = SafeValue.SafeDecimal(tbxOtherCharge3Amount.Text); ASPxTextBox tbxOtherCharge4 = pageControl.FindControl("tbxOtherCharge4") as ASPxTextBox; airRef.OtherCharge4 = tbxOtherCharge4.Text; ASPxTextBox tbxOtherCharge4Currency = pageControl.FindControl("tbxOtherCharge4Currency") as ASPxTextBox; airRef.OtherCharge4Currency = tbxOtherCharge4Currency.Text; ASPxSpinEdit tbxOtherCharge4Amount = pageControl.FindControl("tbxOtherCharge4Amount") as ASPxSpinEdit; airRef.OtherCharge4Amount = SafeValue.SafeDecimal(tbxOtherCharge4Amount.Text); ASPxTextBox tbxOtherCharge5 = pageControl.FindControl("tbxOtherCharge5") as ASPxTextBox; airRef.OtherCharge5 = tbxOtherCharge5.Text; ASPxTextBox tbxOtherCharge5Currency = pageControl.FindControl("tbxOtherCharge5Currency") as ASPxTextBox; airRef.OtherCharge5Currency = tbxOtherCharge5Currency.Text; ASPxSpinEdit tbxOtherCharge5Amount = pageControl.FindControl("tbxOtherCharge5Amount") as ASPxSpinEdit; airRef.OtherCharge5Amount = SafeValue.SafeDecimal(tbxOtherCharge5Amount.Text); ASPxTextBox tbxSignatureShipper = pageControl.FindControl("tbxSignatureShipper") as ASPxTextBox; airRef.SignatureShipper = tbxSignatureShipper.Text; ASPxTextBox tbxExecuteDate = pageControl.FindControl("tbxExecuteDate") as ASPxTextBox; airRef.ExecuteDate = tbxExecuteDate.Text; ASPxTextBox tbxExecutePlace = pageControl.FindControl("tbxExecutePlace") as ASPxTextBox; airRef.ExecutePlace = tbxExecutePlace.Text; ASPxTextBox tbxSignatureIssuing = pageControl.FindControl("tbxSignatureIssuing") as ASPxTextBox; airRef.SignatureIssuing = tbxSignatureIssuing.Text; if (isNew) { airRef.CloseInd = "N"; airRef.CreateBy = userId; airRef.CreateDateTime = DateTime.Now; airRef.RefNo = refNo.ToString(); airRef.RefType = "AI"; airRef.UpdateBy = userId; airRef.UpdateDateTime = DateTime.Now; airRef.StatusCode = "USE"; Manager.ORManager.StartTracking(airRef, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(airRef); C2Setup.SetNextNo(airRef.RefType, "AirImport", refNo, airRef.RefDate); } else { airRef.UpdateBy = userId; airRef.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(airRef, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(airRef); } Session["AirImpMastWhere"] = "RefNo='" + refNo + "'"; this.dsImportRef.FilterExpression = Session["AirImpMastWhere"].ToString(); if (this.grid_ref.GetRow(0) != null) { this.grid_ref.StartEdit(0); } } catch { } }