how to INSERT,UPDATE,DELETE record using STORED PROCEDURE

Stored Procedure

CREATE PROCEDURE v_sp_applygame
(
    @id  int=0,
    @name  varchar(50)='',
    @edu varchar(50) ='',
    @photo varchar(50)='',
    @gender varchar(50)='',
    @game varchar(50)='',
    @status  varchar(50)=''
)
AS
BEGIN
    SET NOCOUNT ON;
    if(@status='select')
    begin
       SELECT * from v_applygame
    end


    else if(@status='insert')
    begin
       insert into v_applygame values(@name,@edu,@photo,@gender,@game)
    end
    else if(@status='delete')
    begin
       delete from v_applygame where id=@id
    end
    else if(@status='update')
    begin
       update v_applygame set  name=@name,education=@edu,photo=@photo,
                                             gender=@gender,game=@game where id=@id
    end
END


Default.aspx.CS

    SqlConnection con = new SqlConnection("ConnectionString");
    DataTable dt = new DataTable();
    static int i;
    public void fillgrid()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("v_sp_applygame", cn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@status", SqlDbType.VarChar).Value = "select";
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
        con.Close();
    }

   protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fillgrid();
        }
    }

  
protected void submit_Click(object sender, EventArgs e)
    {
        if (submit.Text == "Insert")
        {
            string gm = null;
            for (int z = 0; z < CheckBoxList1.Items.Count; z++)
            {
                if (CheckBoxList1.Items[z].Selected)
                {
                    gm += CheckBoxList1.Items[z].Value.ToString() + ",";
                }
            }
            con.Open();
            FileUpload1.SaveAs(Server.MapPath("~/photo/") + FileUpload1.FileName);
            SqlCommand cmd = new SqlCommand("v_sp_applygame", cn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@status", SqlDbType.VarChar).Value = "insert";
            cmd.Parameters.AddWithValue("@name", SqlDbType.VarChar).Value = TextBox1.Text;
            cmd.Parameters.AddWithValue("@edu", SqlDbType.VarChar).Value = 
                    DropDownList1.SelectedValue.ToString();
            cmd.Parameters.AddWithValue("@photo", SqlDbType.VarChar).Value = "~/photo/" + 
                    FileUpload1.FileName.ToString();
            cmd.Parameters.AddWithValue("@gender", SqlDbType.VarChar).Value = 
                    RadioButtonList1.SelectedValue.ToString();
            cmd.Parameters.AddWithValue("@game", SqlDbType.VarChar).Value = gm;
            cmd.ExecuteNonQuery();
            cn.Close();
            fillgrid();
         }
        else
        {
            string gm = null;
            for (int z = 0; z < CheckBoxList1.Items.Count; z++)
            {
                if (CheckBoxList1.Items[z].Selected)
                {
                    gm += CheckBoxList1.Items[z].Value.ToString() + ",";
                }
            }
            con.Open();
            FileUpload1.SaveAs(Server.MapPath("~/photo/") + FileUpload1.FileName);
            SqlCommand cmd = new SqlCommand("v_sp_applygame", cn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@status", SqlDbType.VarChar).Value = "update";
            cmd.Parameters.Add("@id", SqlDbType.Int).Value = i;
            cmd.Parameters.AddWithValue("@name", SqlDbType.VarChar).Value = TextBox1.Text;
            cmd.Parameters.AddWithValue("@edu", SqlDbType.VarChar).Value =      
                    DropDownList1.SelectedValue.ToString();
            cmd.Parameters.AddWithValue("@photo", SqlDbType.VarChar).Value = "~/photo/" + 
                    FileUpload1.FileName.ToString();
            cmd.Parameters.AddWithValue("@gender", SqlDbType.VarChar).Value = 
                    RadioButtonList1.SelectedValue.ToString();                           
            cmd.Parameters.AddWithValue("@game", SqlDbType.VarChar).Value = gm.ToString();
            cmd.ExecuteNonQuery();
            con.Close();
            fillgrid();
           submit.Text = "Insert";
        }
    }


 protected void delete_Click(object sender, EventArgs e)
    {
        con.Open();
        ImageButton lb = (ImageButton)sender;
        GridViewRow row = (GridViewRow)lb.NamingContainer;
        HiddenField id = (HiddenField)row.FindControl("id");
        SqlCommand cmd = new SqlCommand("v_sp_applygame", cn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@status", SqlDbType.VarChar).Value = "delete";
        cmd.Parameters.Add("@id", SqlDbType.Int).Value = id.Value;
        cmd.ExecuteNonQuery();
        con.Close();
        fillgrid();
    }