protected void FillElement(IWebElement element, object value)
        {
            if (value == null)
            {
                return;
            }

            if (IsInput(element))
            {
                String inputType = element.GetAttribute("type");
                if (inputType == null || inputType == TextInputType || inputType == PasswordInputType)
                {
                    element.SendKeys(value.ToString());
                }
                else if (inputType == CheckboxType)
                {
                    CheckBox checkBox = new CheckBox(element);
                    checkBox.Set(bool.Parse(value.ToString()));
                }
                else if (inputType == RadioType)
                {
                    Radio radio = new Radio(element);
                    radio.SelectByValue(value.ToString());
                }
            }
            else if (IsSelect(element))
            {
                Select select = new Select(element);
                select.SelectByValue(value.ToString());
            }
            else if (IsTextArea(element))
            {
                element.SendKeys(value.ToString());
            }
        }

 public Delete(string table, Select select, bool allowMultiple)
 {
     Table.Name = table;
     AllowMultiple = allowMultiple;
     Select = select;
     Filter = FilterType.Select;
 }

 public SelectionElement(string myAlias, Select.EdgeList myEdgeList, bool myIsGroupedOrAggregated, IDChainDefinition myRelatedIDChainDefinition, IAttributeDefinition myElement = null)
     : this(myAlias, myRelatedIDChainDefinition)
 {
     EdgeList = myEdgeList;
     IsGroupedOrAggregated = myIsGroupedOrAggregated;
     Element = myElement;
 }

        public void Acc_Exec_AggregateAvg()
        {
            const double expected = 28.8664;

            // overload #1
            double result = new
                Select(Aggregate.Avg("UnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #2
            result = new
                Select(Aggregate.Avg(Product.UnitPriceColumn))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #3
            result = new
                Select(Aggregate.Avg("UnitPrice", "AverageUnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #4
            result = new
                Select(Aggregate.Avg(Product.UnitPriceColumn, "AverageUnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);
        }

 // Use this for initialization
 void Start()
 {
     posicionAPuntador = new Vector3 (transform.position.x,transform.position.y+5,0);
     seleccionador = new Select ();
     seleccionador = GameObject.FindGameObjectWithTag("Select").GetComponent<Select>();
     escogido = false;
 }

    // Use this for initialization
    void Start()
    {
        IModule mountainTerrain = new RidgedMulti();
        IModule baseFlatTerrain = new Billow();
        ((Billow)baseFlatTerrain).Frequency = 2.0;
        IModule flatTerrain = new ScaleBias(baseFlatTerrain, 0.125, -0.75);
        IModule terrainType = new Perlin();
        ((Perlin)terrainType).Frequency = 0.5;
        ((Perlin)terrainType).Persistence = 0.25;
        IModule terrainSelector = new Select(flatTerrain, mountainTerrain, terrainType);
        ((Select)terrainSelector).SetBounds(0.0, 1000.0);
        ((Select)terrainSelector).SetEdgeFallOff(0.125);
        IModule finalTerrain = new Turbulence(terrainSelector);
        ((Turbulence)finalTerrain).Frequency = 4.0;
        ((Turbulence)finalTerrain).Power = 0.125;

        NoiseMapBuilderPlane heightMapBuilder = new NoiseMapBuilderPlane(256, 256);
        heightMapBuilder.SetBounds(6.0, 10.0, 1.0, 5.0);
        heightMapBuilder.Build(finalTerrain);
        RendererImage render = new RendererImage();
        render.SourceNoiseMap = heightMapBuilder.Map;
        render.ClearGradient ();
        render.AddGradientPoint(-1.0000, new Color32(32, 160, 0, 255));
        render.AddGradientPoint(-0.2500, new Color32(224, 224, 0, 255));
        render.AddGradientPoint(0.2500, new Color32(128, 128, 128, 255));
        render.AddGradientPoint(1.0000, new Color32(255, 255, 255, 255));
        render.IsLightEnabled = true;
        render.LightContrast = 3.0;
        render.LightBrightness = 2.0;
        render.Render();

        tex = render.GetTexture();
    }

 private bool BarcodeExist()
 {
     try
     {
         int count = 1;
         switch (SysPara.AutoGenerateBarcode)
         {
             case 0:
             case 1:
                 count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.Barcode).IsEqualTo(txtBarcode.Text.Trim()).
                     And(TTestInfo.Columns.PatientId).IsNotEqualTo(vPatient_ID).GetRecordCount();
                 break;
             case 2:
                 count = new Select().From(TTestInfo.Schema).Where(TTestInfo.Columns.TestTypeId).IsEqualTo(vTestType_ID).
                 And(TTestInfo.Columns.Barcode).IsEqualTo(txtBarcode.Text.Trim()).GetRecordCount();
                 break;
         }
         if (count > 0) return true;
         else return false;
     }
     catch (Exception ex)
     {
         return true;
     }
 }

        public void Exec_AggregateMax()
        {
            const double expected = 100.00;

            // overload #1
            double result = new
                Select(Aggregate.Max("UnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #2
            result = new
                Select(Aggregate.Max(Product.UnitPriceColumn))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #3
            result = new
                Select(Aggregate.Max("UnitPrice", "MostExpensive"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);

            // overload #4
            result = new
                Select(Aggregate.Max(Product.UnitPriceColumn, "MostExpensive"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            Assert.AreEqual(expected, result);
        }

	void Start() 
	{
		// STEP 1
		// Gradient is set directly on the object
		var mountainTerrain = new RidgedMultifractal();
		RenderAndSetImage(mountainTerrain);

		// Stop rendering if we're only getting as far as this tutorial
		// step. It saves me from doing multiple files.
		if (_tutorialStep <= 1) return;

		// STEP 2
		var baseFlatTerrain = new Billow();
		baseFlatTerrain.Frequency = 2.0;
		RenderAndSetImage(baseFlatTerrain);


		if (_tutorialStep <= 2) return;

		// STEP 3
		var flatTerrain = new ScaleBias(0.125, -0.75, baseFlatTerrain);
		RenderAndSetImage(flatTerrain);

		if (_tutorialStep <= 3) return;

		// STEP 4
		var terrainType = new Perlin();
		terrainType.Frequency = 0.5;
		terrainType.Persistence = 0.25;

		var finalTerrain = new Select(flatTerrain, mountainTerrain, terrainType);
		finalTerrain.SetBounds(0, 1000);
		finalTerrain.FallOff = 0.125;
		RenderAndSetImage(finalTerrain);
	}

        public void Exec_AggregateAvg()
        {
            const double expected = 55.5922077922078; //55.5922;

            // overload #1
            double result = new
                Select(Aggregate.Avg("UnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            //Assert.AreEqual(expected, result);
            Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));  // [[55.5922]]!=[[55.5922077922078]]

            // overload #2
            result = new
                Select(Aggregate.Avg(Product.UnitPriceColumn))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            //Assert.AreEqual(expected, result);
            Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
            // overload #3
            result = new
                Select(Aggregate.Avg("UnitPrice", "AverageUnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            //Assert.AreEqual(expected, result);
            Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
            // overload #4
            result = new
                Select(Aggregate.Avg(Product.UnitPriceColumn, "AverageUnitPrice"))
                .From(Product.Schema)
                .ExecuteScalar<double>();
            //Assert.AreEqual(expected, result);
            Assert.AreEqual(Math.Round(expected, 8), Math.Round(result, 8));
        }

    //databind to total orders by eta and company id
    protected void bind_chart(Int32 companyid)
    {
        try
        {
            int _countopen = 0;

            //total open orders for this company or total open orders for company = -1
            if (companyid > -1)
            {
                _countopen = new Select(OrderTable.OrderIDColumn).From<OrderTable>().Where(OrderTable.CompanyIDColumn).IsEqualTo(companyid).
                    And(OrderTable.JobClosedColumn).IsEqualTo(false).GetRecordCount();
            }
            else
            {
                _countopen = new Select(OrderTable.OrderIDColumn).From<OrderTable>().Where(OrderTable.JobClosedColumn).IsEqualTo(false).GetRecordCount();
            }
            //bind to gauge
            this.dxgaugeSumopen.Value = _countopen.ToString();
        }
        catch (Exception ex)
        {
            this.dxlblerr1.Text = ex.Message.ToString();
            this.dxlblerr1.Visible = true;
        }
    }

        public SelectTests()
        {
            context = new TestingContext();
            select = new Select<Role>(context.Set<Role>());

            context.DropData();
            SetUpData();
        }

        public SelectTests()
        {
            context = new TestingContext();
            select = new Select<Role>(context.Set<Role>());

            context.Set<Role>().Add(ObjectFactory.CreateRole());
            context.DropData();
        }

        /// <summary>
        /// hàm thực hiện việc xác nhận thông tin 
        /// </summary>
        /// <param name="objPhieuNhap"></param>
        /// <returns></returns>
        public ActionResult HuyXacNhanPhieuTraLaiKho(TPhieuNhapxuatthuoc objPhieuNhap)
        {
            HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties;
            string errorMessage = "";
            try
            {
                using (var Scope = new TransactionScope())
                {
                    using (var dbScope = new SharedDbConnectionScope())
                    {
                        SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema)
                            .Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu);
                        TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection =
                            sqlQuery.ExecuteAsCollection<TPhieuNhapxuatthuocChitietCollection>();

                        foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection)
                        {
                            //Kiểm tra ở kho nhập xem thuốc đã sử dụng chưa
                            ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt);
                            if (_Kiemtrathuochuyxacnhan != ActionResult.Success) return _Kiemtrathuochuyxacnhan;
                            int id_thuockho = -1;
                            StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
                                                                      objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
                                                                      objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhonhap, objPhieuNhapCt.MaNhacungcap,
                                                                      objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, -1, id_thuockho,
                                                                      objPhieuNhap.NgayXacnhan, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu);
                            sp.Execute();
                            sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhoxuat, objPhieuNhapCt.IdThuoc,
                                                          objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap,objPhieuNhapCt.GiaBan,
                                                          Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
                                                          Utility.Int32Dbnull(objPhieuNhapCt.SoLuong), objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objHisDuocProperties.XoaDulieuKhiThuocDaHet ? 1 : 0, errorMessage);

                            sp.Execute();
                            errorMessage = Utility.sDbnull(sp.OutputValues[0]);

                        }
                        //Xóa toàn bộ chi tiết trong TBiendongThuoc
                        new Delete().From(TBiendongThuoc.Schema)
                            .Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
                        new Update(TPhieuNhapxuatthuoc.Schema)
                            .Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(null)
                            .Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null)
                            .Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null)
                            .Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0)
                            .Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
                    }
                    Scope.Complete();
                    return ActionResult.Success;
                }
            }
            catch (Exception exception)
            {
                log.Error("Loi ban ra tu sp :{0}", errorMessage);
                log.Error("Loi trong qua trinh xac nhan don thuoc :{0}", exception);
                return ActionResult.Error;
            }
        }

 public void Exec_Simple()
 {
     //string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), @"MyApplication\Northwind.db3");
     //DataService.Providers["Northwind"].DefaultConnectionString =
     //    String.Format(@"Data Source={0};Version=3;New=False;Connection Timeout=3", dbPath);
     
     int records = new Select("productID").From("Products").GetRecordCount();
     Assert.IsTrue(records == 77);
 }

        public SelectTests()
        {
            context = new TestingContext();
            select = new Select<TestModel>(context.Set<TestModel>());

            context.Set<TestModel>().RemoveRange(context.Set<TestModel>());
            context.Set<TestModel>().Add(ObjectFactory.CreateTestModel());
            context.SaveChanges();
        }

		public void can_render_options_from_enumerable_of_simple_objects()
		{
			var optionNodes = new Select("foo.Bar").Options(new[] { 1, 2 }).ToString()
				.ShouldHaveHtmlNode("foo_Bar")
				.ShouldHaveChildNodesCount(2);

			optionNodes[0].ShouldBeUnSelectedOption("1", "1");
			optionNodes[1].ShouldBeUnSelectedOption("2", "2");
		}

    public static MvcHtmlString UxSelectWithDataSource(this HtmlHelper htmlHelper, DataSource dataSource, string selectedValue = null, SelectAppearanceType appearance = null, bool liveSearch = false, bool showTick = false, bool showArrow = false, bool autoWidth = true, string width = null, bool disabled = false, string header = null, string container = null, string clientId = null)
    {
        var select = new Select(selectedValue, dataSource, appearance, liveSearch, showTick, showArrow, autoWidth, width, disabled, header, container, clientId);

        MvcHtmlString start = htmlHelper.Partial("ControlTemplates/" + select.ViewTemplate + "Start", select);
        MvcHtmlString end = htmlHelper.Partial("ControlTemplates/" + select.ViewTemplate + "End", select);

        return MvcHtmlString.Create(start.ToHtmlString() + end.ToHtmlString());
    }

        static void Main(string[] args)
        {
            Select select = new Select();

            Authentication auth = new Authentication();
            auth.version = "1.1";   // Specify which Select API Version (1.0 or 1.1)

            PropertyFile rb = PropertyFile.getBundle("Environment");
            select.Url = rb.get("soap_url");
            auth.login = rb.get("soap_login");
            auth.password = rb.get("soap_password");

            // ProdTest
            //select.Url = "https://soap.prodtest.sj.vindicia.com/v1.0/soap.pl";
            //select.Url = "https://soap.prodtest.sj.vindicia.com/soap.pl";
            //auth.login = "xxx_soap";
            //auth.password = "";

            // Staging:
            //select.Url = https://soap.staging.sj.vindicia.com/soap.pl
            //auth.login = xxx_soap
            //auth.password = "";

            // Production:
            //select.Url = https://soap.vindicia.com/soap.pl
            //auth.login = xxx_soap
            //auth.password = "";

            Console.WriteLine("soapVersion=" + SEL001BillSelect.getSelectVersion(auth));
            Console.WriteLine();
            Console.WriteLine("Using version=" + auth.version);
            Console.WriteLine("soapURL=" + select.Url);
            Console.WriteLine("soapLogin=" + auth.login);

            Boolean bBill = true;
            Boolean bFetch = true;

            if (bBill)
            {
                SEL001BillSelect bill = new SEL001BillSelect();

                string startMerchantTransactionId = "FAILED" + DateTime.Now.DayOfYear + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second;
                string soapId = bill.run(select, auth, startMerchantTransactionId);

                Console.WriteLine("billTransactions soapId=" + soapId + "\n");
            }

            if (bFetch)
            {
                SEL002FetchSelect.run(select, auth);

                Console.WriteLine("fetchBillingResults completed.\n");
            }

            Console.ReadLine();
        }

 public ModuleBase GetTaigaNoise()
 {
     if (TaigaNoise == null)
     {
         TaigaNoise = new Select(0, 1, 1, StandartNoise, 
             new ScaleBias(0.5, 0, new Perlin(1, 2, 0.25, 4, DataBaseHandler.DataBase.Seed, QualityMode.High)), 
             new BiomeTranslator(Biomes, BiomeTypes.Taiga, Bounds.left, Bounds.top, Bounds.width, Bounds.height));
     }
     return TaigaNoise;
 }