using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class MainPage : System.Web.UI.Page
{
    //Nazwa Bazy plus DataContext
    DataClassesDataContext DB = new DataClassesDataContext();

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

    private void LoadData()
    {
        Database_Content.DataSource = DB.Produkts;
        Database_Content.DataBind();
    }




    protected void Database_Content_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandName == "btnDelete")
        {
            DB.Produkts.DeleteOnSubmit(
                DB.Produkts.Single(x => x.Id == Int32.Parse(e.CommandArgument.ToString())));
            DB.SubmitChanges();
            LoadData();
        }
        else if (e.CommandName == "btnEdit")
        {
            Produkt produkt = GenerateProdukt();
            DB.Produkts.Single(x => x.Id == produkt.Id);
            DB.SubmitChanges();
            LoadData();
        }
    }

    private Produkt GenerateProdukt()
    {
        return new Produkt
        {
            Id = Int32.Parse(txbID.Text),
            Nazwa = txbNazwa.Text,
            Cena = Int32.Parse(txbCena.Text),
            Opis = "temp"
        };
    }

    protected void btnAdd_Click(object sender, EventArgs e)
    {
        lblError.Text = " ";
        //TODO z formularza
        if (txbID.Text != "" && txbCena.Text != "" && txbNazwa.Text != "")
        {

            Produkt produkt =  GenerateProdukt();
            DB.Produkts.InsertOnSubmit(produkt);
            try
            {
                DB.SubmitChanges();
                txbCena.Text = ""; txbID.Text = ""; txbNazwa.Text = "";
            }
            catch (Exception ex)
            {
                lblError.Text = ex.ToString();
            }
        }else
        {
            lblError.Text = "Podano złe dane do bazy";
        }
    }
}