protected void grid_bkg_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxPageControl pageControl = this.grid_ref.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox refNo = pageControl.FindControl("txt_RefN") as ASPxTextBox; e.NewValues["JobNo"] = C2Setup.GetSubNo(refNo.Text, "SE"); e.NewValues["RefNo"] = refNo.Text; e.NewValues["CreateBy"] = EzshipHelper.GetUserName(); e.NewValues["CreateDateTime"] = DateTime.Now; e.NewValues["UpdateBy"] = EzshipHelper.GetUserName(); e.NewValues["UpdateDateTime"] = DateTime.Now; e.NewValues["StatusCode"] = "USE"; string sql_pod = string.Format("select Pod from SeaExportRef where RefNo='{0}'", refNo.Text); string pod1 = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql_pod), "SGSIN"); string expN = C2Setup.GetNextNo("ExportBooking"); string bkgN = SafeValue.SafeString(System.Configuration.ConfigurationManager.AppSettings["BookingPrefix"]); //if (pol.Length == 5) // bkgN += pol.Substring(2); if (pod1.Length == 5) { bkgN += pod1.Substring(2); } e.NewValues["BkgRefNo"] = bkgN + expN; string bkgN1 = SafeValue.SafeString(System.Configuration.ConfigurationManager.AppSettings["BookingPrefix"]); if (pod1.Length == 5) { bkgN1 += "/" + pod1.Substring(2); } e.NewValues["HblNo"] = bkgN1 + "/" + expN; }
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 string Tranship(string impNo) { string user = HttpContext.Current.User.Identity.Name; //string pod = tPod.Text; string refN = SafeValue.SafeString(Request.QueryString["refNo"]); string sql = string.Format("select Pol,Pod,Vessel, Voyage, Eta, Etd, EtaDest from SeaExportRef where RefNo='{0}'", refN); DataTable tab_expRef = ConnectSql.GetTab(sql); if (tab_expRef.Rows.Count == 0) { return("Error"); } string pod = SafeValue.SafeString(tab_expRef.Rows[0]["Pod"]); string pol = SafeValue.SafeString(tab_expRef.Rows[0]["Pol"]); string polName = EzshipHelper.GetPortName(pol, "SINGAPORE"); string podName = EzshipHelper.GetPortName(pod, "SINGAPORE"); SeaExport exp = new SeaExport(); #region export info exp.AsAgent = "N"; string bkgNo = C2Setup.GetNextNo("ExportBooking"); string bkgNPrefix = "SIN"; if (pod.Length == 5) { bkgNPrefix += pod.Substring(2); } exp.BkgRefNo = bkgNPrefix + bkgNo; exp.CollectFrom = ""; exp.CreateBy = EzshipHelper.GetUserName(); exp.CreateDateTime = DateTime.Now; exp.CustomerId = ""; exp.ExpressBl = "N"; exp.FrtTerm = "FP"; exp.HaulierAttention = ""; exp.HaulierCollect = ""; exp.HaulierCrNo = ""; exp.HaulierName = ""; exp.HaulierRemark = ""; exp.HaulierTruck = ""; exp.HblNo = ""; exp.ImpCharge = 0; exp.JobNo = C2Setup.GetSubNo(refN, "SE"); exp.Marking = ""; exp.PermitRmk = ""; exp.PlaceDeliveryId = pod; exp.PlaceDeliveryName = podName; exp.PlaceDeliveryTerm = "CFS"; exp.PlaceDischargeName = podName; exp.PlaceLoadingName = polName; exp.PlaceReceiveId = pol; exp.PlaceReceiveName = polName; exp.PlaceReceiveTerm = "CFS"; exp.Pod = pod; exp.Pol = pol; exp.PreCarriage = ""; exp.RefNo = refN; exp.Remark = ""; exp.SAgentRemark = ""; exp.SConsigneeRemark = ""; exp.ShipLoadInd = "N"; exp.ShipOnBoardDate = DateTime.Today; exp.ShipOnBoardInd = "N"; exp.ShipperContact = ""; exp.ShipperEmail = ""; exp.ShipperFax = ""; exp.ShipperId = ""; exp.ShipperName = ""; exp.ShipperTel = ""; exp.SNotifyPartyRemark = ""; exp.SShipperRemark = ""; exp.StatusCode = "USE"; exp.SurrenderBl = "N"; exp.TsInd = "Y"; exp.TsJobNo = impNo; exp.UpdateBy = EzshipHelper.GetUserName(); exp.UpdateDateTime = DateTime.Now; string finDest = pod; decimal wt = 0; decimal m3 = 0; int qty = 0; string pkgType = ""; sql = string.Format(@"SELECT TsPod, TsPortFinName, TsVessel, TsVoyage, TsColoader, TsEtd, TsEta, TsAgentId, TsRemark, TsAgtRate, TsTotAgtRate, TsImpRate, TsTotImpRate,Weight,Volume,Qty,PackageType FROM SeaImport where JobNo='{0}'", impNo); DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; if (tab.Rows.Count > 0) { DataRow row = tab.Rows[0]; pod = row["TsPod"].ToString(); finDest = row["TsPortFinName"].ToString(); wt = SafeValue.SafeDecimal(row["Weight"], 0); m3 = SafeValue.SafeDecimal(row["Volume"], 0); qty = SafeValue.SafeInt(row["Qty"], 0); pkgType = row["PackageType"].ToString(); } exp.FinDest = finDest; exp.Weight = wt; exp.Volume = m3; exp.Qty = qty; exp.PackageType = pkgType; #endregion C2.Manager.ORManager.StartTracking(exp, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(exp); C2Setup.SetNextNo("ExportBooking", bkgNo); //create bkg #region booking and marking Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(SeaImportMkg), "JobNo='" + exp.TsJobNo + "'"); ObjectSet set_impMkgs = C2.Manager.ORManager.GetObjectSet(query); for (int m = 0; m < set_impMkgs.Count; m++) { C2.SeaImportMkg impMkg = set_impMkgs[m] as C2.SeaImportMkg; C2.SeaExportMkg mkg_bkg = new SeaExportMkg(); mkg_bkg.ContainerNo = ""; mkg_bkg.ContainerType = ""; mkg_bkg.Description = impMkg.Description; mkg_bkg.CreateDateTime = DateTime.Now; mkg_bkg.JobNo = exp.JobNo; mkg_bkg.Marking = impMkg.Marking; mkg_bkg.MkgType = "BKG"; mkg_bkg.PackageType = ""; mkg_bkg.Qty = impMkg.Qty; mkg_bkg.RefNo = exp.RefNo; mkg_bkg.Remark = impMkg.Remark; mkg_bkg.SealNo = ""; mkg_bkg.CreateBy = EzshipHelper.GetUserName(); mkg_bkg.Volume = impMkg.Volume; mkg_bkg.Weight = impMkg.Weight; C2.Manager.ORManager.StartTracking(mkg_bkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg_bkg); C2.SeaExportMkg mkg = new SeaExportMkg(); mkg.ContainerNo = ""; mkg.ContainerType = ""; mkg.Description = impMkg.Description; mkg.CreateDateTime = DateTime.Now; mkg.JobNo = exp.JobNo; mkg.Marking = impMkg.Marking; mkg.MkgType = "BL"; mkg.PackageType = ""; mkg.Qty = impMkg.Qty; mkg.RefNo = exp.RefNo; mkg.Remark = impMkg.Remark; mkg.SealNo = ""; mkg.CreateBy = EzshipHelper.GetUserName(); mkg.Volume = impMkg.Volume; mkg.Weight = impMkg.Weight; C2.Manager.ORManager.StartTracking(mkg, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(mkg); } #endregion //update import info DataRow row1 = tab_expRef.Rows[0]; string ves = row1["Vessel"].ToString(); string voy = row1["Voyage"].ToString(); DateTime eta = SafeValue.SafeDate(row1["Eta"], new DateTime(1900, 1, 1)); DateTime etd = SafeValue.SafeDate(row1["Etd"], new DateTime(1900, 1, 1)); // DateTime etaDest = SafeValue.SafeDate(row["EtaDest"], new DateTime(1900, 1, 1)); sql = string.Format("Update SeaImport Set TsVessel='{0}', TsVoyage='{1}', TsEtd='{2}', TsEta='{3}',TsSchNo='{4}', TsBkgNo='{5}', TsPortFinName='{6}',tsBkgId='{7}',TsJobNo='{9}',TsRefNo='{10}' where JobNo='{8}'", ves, voy, etd, eta, refN, exp.BkgRefNo, finDest, exp.SequenceId, impNo, exp.JobNo, exp.RefNo); int res = C2.Manager.ORManager.ExecuteCommand(sql); return("Success"); }
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 { } }