public void SaveTempo(object sender, EventArgs e)
        {
            try
            {
                using (MetromizerDataEntities context = new MetromizerDataEntities())
                {

                    tempos tempo = new tempos();
                    TextBox namebox = (TextBox)LoginView1.FindControl("SettingName");
                    string name = namebox.Text;
                    int bmp = int.Parse(TextBox1.Text);
                    int minutes = int.Parse(minutesfield.Text);

                    tempo.name = name;
                    tempo.bpm = bmp;
                    tempo.timeout = minutes;
                    tempo.user = User.Identity.Name;

                    context.tempos.Add(tempo);
                    context.SaveChanges();
                }
            }
            catch
            {
                Session.Add("message", "Opps, sorry ! Operation didn't succed...");
                Response.Redirect("~/result.aspx");
            }
            finally
            {
                Session.Add("message", "Operation was succed !");
                Response.Redirect("~/result.aspx");
            }
        }
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);

             using (MetromizerDataEntities context = new MetromizerDataEntities())
             {
                 tempos tempo = context.tempos.Find(ID);
                 context.tempos.Remove(tempo);

                 context.SaveChanges();
                 Response.Redirect("~/Organizer.aspx");

             }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (User.Identity.IsAuthenticated == false)
            {
                Response.Redirect("~/Login.aspx");
                return;
            }

            if (!IsPostBack)
            {
                using (MetromizerDataEntities context = new MetromizerDataEntities())
                {
                    var  result = from t in context.tempos where t.user == User.Identity.Name select t;

                    if (result.Count() == 0)
                    {
                        Label lb = new Label();
                        lb.Text = "You don't have any saved tempos at your collecion! You can do this by using ";
                        HyperLink hl = new HyperLink();
                        hl.Text = "Simple Metronome";
                        hl.NavigateUrl = "~/simple-metronome.aspx";
                        content.Controls.Add(lb);
                        content.Controls.Add(hl);
                        Wizard1.Visible = false;
                        return;
                    }

                    dt = new DataTable();

                    dt.Columns.Add("ajdi", typeof(int));
                    dt.Columns.Add("Name", typeof(string));
                    dt.Columns.Add("Beats Per Minute", typeof(int));
                    dt.Columns.Add("Minutes", typeof(string));

                    foreach (var item in result)
                        dt.Rows.Add(item.ID, item.name, item.bpm, item.timeout);

                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                    ViewState["template"] = dt.Clone();
                }
            }
        }