protected void LinkButton_Bestil_Click(object sender, EventArgs e)
{
Kurv test = new Kurv();
int Kundeid = 3;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"INSERT INTO Ordrer (ordre_dato, ordre_status, FK_kunde_id) VALUES (GETDATE(), 1, @kundeid);
SELECT SCOPE_IDENTITY()";
cmd.Parameters.Add("@kundeid", SqlDbType.Int).Value = Kundeid;
conn.Open();
object OrdreId = cmd.ExecuteScalar();
conn.Close();
cmd.CommandText = @"INSERT INTO OrdreLinjer (FK_ordre_id, FK_produkt_id, antal, pris) VALUES (@ordreid, @produktid, @antal, @pris)";
cmd.Parameters.Add("@ordreid", SqlDbType.Int).Value = OrdreId;
cmd.Parameters.Add("@produktid", SqlDbType.VarChar);
cmd.Parameters.Add("@antal", SqlDbType.Int);
cmd.Parameters.Add("@pris", SqlDbType.Decimal);
conn.Open();
foreach (DataRow varenIKurven in test.get_kurv().Rows)
{
cmd.Parameters["@produktid"].Value = varenIKurven["produktid"];
cmd.Parameters["@antal"].Value = varenIKurven["antal"];
cmd.Parameters["@pris"].Value = varenIKurven["pris"];
cmd.ExecuteNonQuery();
}
conn.Close();
Response.Redirect("Samlede_ordrer.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Kurv nyKurv = new Kurv();
GridView1.DataSource = Session["kurv"];
GridView1.DataBind();
Label_PrisIAlt.Text = nyKurv.prisIalt(0).ToString();
}
}
protected void GridView_VisVare_SelectedIndexChanged(object sender, EventArgs e)
{
string varenr = GridView_VisVare.SelectedRow.Cells[1].Text;
TextBox TextBox1 = (TextBox)GridView_VisVare.SelectedRow.Cells[4].Controls[1];
int antal = Convert.ToInt32(TextBox1.Text);
Kurv minKurv = new Kurv();
minKurv.RetVare(varenr, antal);
Response.Redirect(Request.RawUrl);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
TableCell cell = GridView1.Rows[e.RowIndex].Cells[1];
string x = cell.Text;
//Response.Write(x);
Kurv minKurv = new Kurv();
minKurv.SletVare(x);
Response.Redirect("default.aspx");
}
protected void Repeater_vare_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "PutIKurv")
{
Kurv minKurv = new Kurv();
HiddenField pris = (HiddenField)e.Item.FindControl("HiddenField_pris");
HiddenField navn = (HiddenField)e.Item.FindControl("HiddenField_navn");
HiddenField produktid = (HiddenField)e.Item.FindControl("HiddenField_produktid");
decimal pris_con = Convert.ToDecimal(pris.Value);
int produkt_id = Convert.ToInt32(produktid.Value);
minKurv.PutiKurv(e.CommandArgument.ToString(), 1, pris_con, navn.Value, produkt_id);
Response.Redirect(Request.RawUrl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Kurv nyKurv = new Kurv();
GridView1.DataSource = Session["kurv"];
GridView1.DataBind();
Label_prisIalt.Text = nyKurv.prisIalt(0).ToString();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
if (!IsPostBack)
{
repeaterData();
}
}