protected void buttonSubmit_Click(object sender, EventArgs e)
 {
     //Ensure the page is valid before you submit to the database
     if (Page.IsValid)
     {
         //Create instance of compost db and load values to go into the db
         Vermiculture vc = new Vermiculture
         {
             StartDate             = Convert.ToDateTime(startdatepicker.Text),
             EndDate               = Convert.ToDateTime(finishdatepicker.Text),
             VolumeCompostProduced = Convert.ToDouble(Vol_vermiproducde.Text),
             BedTemperature        = Convert.ToDouble(vermi_temp.Text),
             BedMoisture           = Convert.ToDouble(vermi_moistcon.Text),
             TeaProduced           = Convert.ToDouble(vermi_tea.Text),
             WormRemoved           = Convert.ToInt16(worms_removed.Text),
             ProductionCost        = Convert.ToDecimal(Cost_vermi.Text),
             MarketValue           = Convert.ToDecimal(marketcostvermi.Text),
             WormsAdded            = Convert.ToInt16(worms_added.Text),
             Notes = Notes1.Text
         };
         db.Vermicultures.InsertOnSubmit(vc);
         //Submit the changes and go home page
         //NOTE: Will not go to home page runnign in VS due to the way master pages work.
         try
         {
             db.SubmitChanges();
         }
         //If not throw error
         catch
         {
             Console.WriteLine(e);
             db.SubmitChanges();
         }
     }
 }
 partial void DeleteVermiculture(Vermiculture instance);
 partial void InsertVermiculture(Vermiculture instance);
 partial void UpdateVermiculture(Vermiculture instance);
    protected void buttonSubmit_Click(object sender, EventArgs e)
    {
        //Ensure the page is valid before you submit to the database
        if (Page.IsValid)
        {
            //Create instance of compost db and load values to go into the db
            Vermiculture vc = new Vermiculture
            {
                StartDate = Convert.ToDateTime(startdatepicker.Text),
                EndDate = Convert.ToDateTime(finishdatepicker.Text),
                VolumeCompostProduced = Convert.ToDouble(Vol_vermiproducde.Text),
                BedTemperature = Convert.ToDouble(vermi_temp.Text),
                BedMoisture = Convert.ToDouble(vermi_moistcon.Text),
                TeaProduced = Convert.ToDouble(vermi_tea.Text),
                WormRemoved = Convert.ToInt16(worms_removed.Text),
                ProductionCost = Convert.ToDecimal(Cost_vermi.Text),
                MarketValue = Convert.ToDecimal(marketcostvermi.Text),
                WormsAdded = Convert.ToInt16(worms_added.Text),
                Notes = Notes1.Text

            };
            db.Vermicultures.InsertOnSubmit(vc);
            //Submit the changes and go home page
            //NOTE: Will not go to home page runnign in VS due to the way master pages work.
            try
            {
                db.SubmitChanges();
            }
            //If not throw error
            catch
            {
                Console.WriteLine(e);
                db.SubmitChanges();
            }

        }
    }