Ejemplo n.º 1
0
        public static bool getRestaurant(int id, ref KahnoRestaurant restaurantOBJ)
        {
            //checking if restaurant exists
            SqlConnection conn = new SqlConnection(connectString);

            conn.Open();

            string     sqlGetUser = ("SELECT * FROM [RESTAURANT] WHERE RestaurantID = @id");
            SqlCommand commquery  = new SqlCommand(sqlGetUser, conn);

            commquery.Parameters.AddWithValue("@id", id);
            SqlDataReader drquery = commquery.ExecuteReader();

            drquery.Read();


            if (drquery.HasRows)
            {
                restaurantOBJ = new KahnoRestaurant(drquery.GetInt32(0), drquery.GetValue(1).ToString(), drquery.GetValue(2).ToString(), drquery.GetInt32(3));
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            ////////checking if user is logged in, copy paste on every page, will redirect to login if not logged in and create the user object
            ///Don't use this one yet, we need a better version
            KahnoUser currentuser = new KahnoUser();

            try
            {
                currentuser = (KahnoUser)Session["localuser"];
                if (currentuser.userid == 0)
                {
                    Response.Redirect("Login.aspx");
                }

                if (currentuser.isowner == "n")
                {
                    Response.Redirect("Login.aspx");
                }
            }
            catch
            {
                Response.Redirect("Login.aspx");
            }
            ////////////////////////////////////////////////////////////////
            try
            {
                currentRestaurant = (KahnoRestaurant)Session["currentRestaurant"];
            }
            catch
            {
                Response.Redirect("Admin.aspx");
            }
            Label1.Text = "Menu for " + currentRestaurant.restaurantname;
        }
Ejemplo n.º 3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            ////////checking if user is logged in, copy paste on every page, will redirect to login if not logged in and create the user object
            ///Don't use this one yet, we need a better version
            KahnoUser currentuser = new KahnoUser();

            currentuser = (KahnoUser)Session["localuser"];
            if (currentuser.userid == 0)
            {
                Response.Redirect("Login.aspx");
            }

            if (currentuser.restaurantno == 0)
            {
                Response.Redirect("CreateRestaurantForm.aspx");
            }
            if (currentuser.isowner == "n")
            {
                Response.Redirect("Login.aspx");
            }

            ////////////////////////////////////////////////////////////////

            /////////////creatign restaurant object
            ///
            KahnoRestaurant currentRestaurant = new KahnoRestaurant();

            KahnLib.getRestaurant(currentuser.restaurantno, ref currentRestaurant);
            Session["currentRestaurant"] = currentRestaurant;
            //////////////
            //Label3.Text = "Welcome " + currentuser.fname + " Your restaurant is " + currentRestaurant.restaurantname + currentuser.restaurantno + (Int32)Session["RID"];

            Label3.Text = "Welcome " + currentuser.fname + ", owner of " + currentRestaurant.restaurantname + " with restaurant ID: " + (Int32)Session["RID"];
        }
        protected void lnkSelect_Click(object sender, EventArgs e)
        {
            int             restaurantID      = Convert.ToInt32((sender as Button).CommandArgument);
            KahnoRestaurant currentRestaurant = new KahnoRestaurant();

            KahnLib.getRestaurant(restaurantID, ref currentRestaurant);
            Session["currentRestaurant"] = currentRestaurant;

            Session["restaurantID"] = currentRestaurant.restaurantID;
            Response.Redirect("RestaurantMenuPage.aspx");
        }
Ejemplo n.º 5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            KahnoRestaurant currentRestaurant = (KahnoRestaurant)Session["currentRestaurant"];

            Heading.InnerText = currentRestaurant.restaurantname;
            if (IsPostBack == false)
            {
                Session["orderCount"] = 0;
                Session["counter"]    = 0;
            }
        }
Ejemplo n.º 6
0
        protected void btnConfirm_Click(object sender, EventArgs e)
        {
            restaurant = (KahnoRestaurant)Session["currentRestaurant"];


            DateTime time      = DateTime.Now;
            string   format    = "yyyy-MM-dd HH:mm:ss";
            string   finaltime = time.ToString(format);

            user = (KahnoUser)Session["localuser"];

            int user1 = Convert.ToInt32(user.userid);

            int restaurantSend = restaurant.restaurantID;

            //insert into db first then get orderNumber
            KahnLib.InsertOrder(finaltime, user1, restaurantSend);

            int orderNumber = KahnLib.getOrderNumber();

            List <int> CurrentCart         = new List <int>();
            List <int> CurrentCartQuantity = new List <int>();

            if (Session["list"] != null && Session["CartQuantity"] != null)
            {
                CurrentCart         = (List <int>)Session["list"];
                CurrentCartQuantity = (List <int>)Session["CartQuantity"];
            }
            else
            {
                Response.Redirect("Login.aspx");
            }

            double total = 0;
            int    i     = 0;

            foreach (int element in CurrentCart)
            {
                total = CurrentCartQuantity[i] * KahnLib.getOrderPrice(CurrentCart[i]);
                KahnLib.getOrder(CurrentCart[i], CurrentCartQuantity[i]);
                string        connectString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\KahnoDB.mdf;Integrated Security=True;Connect Timeout=30";
                SqlConnection conn          = new SqlConnection(connectString);
                conn.Open();
                SqlDataAdapter adapter      = new SqlDataAdapter();
                SqlConnection  con          = new SqlConnection(connectString);
                string         insert_query = "INSERT INTO [ORDERDETAIL] (Quantity,OrderNumber,PricePaidPerItem,ItemNumber) VALUES(@quantity,@OrderNo,@total,@itemNo)";
                SqlCommand     comm         = new SqlCommand(insert_query, conn);

                comm.Parameters.AddWithValue("@quantity", CurrentCartQuantity[i]);
                comm.Parameters.AddWithValue("@OrderNo", orderNumber);
                comm.Parameters.AddWithValue("@total", total);
                comm.Parameters.AddWithValue("@itemNo", CurrentCart[i]);
                comm.ExecuteNonQuery();
                con.Close();
                comm.Dispose();
                i++;
            }
            Response.Redirect("Success.aspx");
            Session["list"]         = null;
            Session["CartQuantity"] = null;
        }