CheckOut.aspx.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace TestGrounds
{
    public partial class CheckOut : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            LoadlstConfirm();
            CalcSum();
            string test = GenDateSubString();
        }
        private void CalcSum()
        {
            int sum = 0;
            Order o = new Order();
            o = (Order)Session["Order"];
            if (o != null)
            {
                foreach (Pizza item in o.pizzas)
                {
                    sum += item.price;
                }
            }
            Session["sum"] = sum;
            lblSum.Text = "Totalt Belopp: " + sum.ToString();
        }

        private void LoadlstConfirm()
        {
            lstConfirm.Items.Clear();
            Order o = new Order();
            o = (Order)Session["Order"];
            foreach (Pizza element in o.pizzas)
            {
                lstConfirm.Items.Add(element.name);
            }
        }

        private SqlDataReader FetchWriteData(string sql)
        {
            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = WebConfigurationManager.ConnectionStrings["MinConn"].ConnectionString;

            conn.Open();

            SqlCommand cmd = new SqlCommand(sql, conn);

            SqlDataReader reader = cmd.ExecuteReader();

            return reader;

            //while (reader.Read())
            //{
            //    //Code here
            //}
        }

        //Generate unique ID for OrderFin.dbo (an Order consists of one or more entries with the same ID)


        private void ConfirmOrder()
        {
            string id = GenDateSubString();
            Order o = new Order();
            o = (Order)Session["order"];
            string sql = "";
            string user = Session["user"].ToString();
            foreach (Pizza item in o.pizzas)
            {
                sql = "INSERT INTO OrderFin(ID, name, price, customer) VALUES('" + id + "', '" + item.name + "', " + item.price + ", '" + user + "')";
                SqlDataReader writer = FetchWriteData(sql);
                writer = null;
            }
            Session["thankYou"] = "Thank You For Choosing Tomasos! Your Order Will Arrive Within 1 Hour";
            Session["order"] = null;
            Response.Redirect("~/Start.aspx");
        }

        private string GenDateSubString()
        {
            if (Session["user"] == null)
            {
                Session["user"] = "Guest";
            }
            string user = Session["user"].ToString();
            string time = DateTime.Now.ToString();
            string replacedString = time.Replace(":", "");
            string sub = replacedString.Substring(((replacedString.Length) - 4), 4);
            string sub2 = user.Substring(0, 2);
            lblDateCheckOut.Text = sub + sub2;
            return sub + sub2;
        }

        protected void btnConfirmOrder_Click(object sender, EventArgs e)
        {
            ConfirmOrder();
        }
    }
}