public List<Fabrica> createTable()
    {
        var farmManager =
          new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);

        var factory = Fabrica.Text.Length > 0 ? Fabrica.Text.Trim() : null;
        var farm = Ferma.Text.Length > 0 ? Ferma.Text.Trim() : null;
        var cod = Code.Text.Length > 0 ? Code.Text.Trim() : null;

        var farms = farmManager.GetAllFarms(farm, cod);

        var factoryManager =
          new FactoryManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
        var factories = factoryManager.GetFactories(factory);

        var countiesManager =
         new CountyManager(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
        var counties = countiesManager.GetAllCounties();

        var values = farms.Select(x => new Fabrica
        {
            id = x.Id.ToString(),
            cod = x.Cod,
            nume = x.Nume,
            numar = x.Numar,
            email = x.Email,
            telefon = x.Telefon,
            oras = x.Oras,
            strada = x.Strada,
            fabricaid = x.FabricaId.ToString(),
            judet = x.Judet
        }).ToList();

        var farctorieslist = values.ToList();

        foreach (var fabrica in farctorieslist)
        {
            var factoryEntity = factories.FirstOrDefault(x => x.Id.ToString(CultureInfo.InvariantCulture) == fabrica.fabricaid);
            if (factoryEntity == null)
                values.Remove(fabrica);
            else
                fabrica.fabricaid = factoryEntity.Nume;

            var countyEntity = counties.FirstOrDefault(x => x.Id.ToString(CultureInfo.InvariantCulture) == fabrica.judet);
            if (countyEntity != null)
                fabrica.judet = countyEntity.DenLoc;
        }

        lcount.Text = values.Count + " ferme";
        return values;
    }
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
			FCCL_DAL.Entities.Ferme_CCL farm = null;
			if (Request.Params["ID"] != null)
			{
				var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
				farm = farmManager.GetFarmById(Convert.ToInt32(Request.Params["ID"]));
			}

            var fabricaManager =
               new FactoryManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
            var fabrici = fabricaManager.GetFactories();
            Asociatia.DataSource = fabrici;
			if (farm != null && farm.FabricaId != null)
			{
				Asociatia.SelectedValue = farm.FabricaId.ToString();
			}
            Asociatia.DataBind();

            var countyManager =
                new CountyManager(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
            var counties = countyManager.GetAllCounties();
            Judet.DataSource = counties;
			if (farm != null && farm.JudetId != null)
			{
				Judet.SelectedValue = farm.JudetId.ToString();
			}
            Judet.DataBind();

            InsertF.Visible = true;

			if (farm != null)
			{
				//populate farm table
				IdFerma.Text = farm.Id.ToString();
				FermaCod.Text = farm.Cod;
				FermaName.Text = farm.Nume;
				FarmEmail.Text = farm.Email;
				Localitate.Text = farm.Oras;
				Strada.Text = farm.Strada;
				Numar.Text = farm.Numar;
				CodPostal.Text = farm.CodPostal;
				Telefon.Text = farm.Telefon;
				Fax.Text = farm.Fax;
				PersContact.Text = farm.PersoanaDeContact;
				TelPersContact.Text = farm.TelPersoanaContact;
				SendSms.Checked = farm.SendSms;

				//populate user table
				var userManager =
					new UserManager(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
				var userInfo = userManager.GetUserInformationByCod(farm.Cod);
				if (userInfo != null)
				{
					UserId.Value = userInfo.UserId.ToString();
					Nume.Text = userInfo.LastName;
					Prenume.Text = userInfo.FirstName;
					UserNameLbl.Text = userInfo.UserName;
					Email.Text = userInfo.Email;
					Update.Visible = true;
					ResetareParola.Visible = true;
					UserNameLbl.Visible = true;
					Parola.Visible = false;
				}
				else
				{
					Insert.Visible = true;
					UserName.Visible = true;
				}
				UserCodLbl.Text = farm.Cod;
				UpdateF.Visible = true;
				DeleteF.Visible = true;
			}
        }
    }