// Subroutine to bind gridview private void _subBind() { ordersClass objOrders = new ordersClass(); grv_orders.DataSource = objOrders.getOrders(); grv_orders.DataBind(); }
// Delete selected orders row protected void DeleteOrders(object sender, EventArgs e) { LinkButton lnkDelete = (LinkButton)sender; ordersClass objOrders = new ordersClass(); objOrders.OrdersID = Int32.Parse(lnkDelete.CommandArgument); lbl_msg.Text = objOrders.deleteOrders(); _subBind(); }
// Insert new order protected void InsertOrders(object sender, EventArgs e) { ordersClass objOrders = new ordersClass(); objOrders.OrdersName = txt_nameI.Text.ToString(); objOrders.OrdersNumber = txt_numberI.Text.ToString(); objOrders.OrdersFood = txt_foodI.Text.ToString(); objOrders.OrdersFoodquantity = Int32.Parse(txt_foodquantityI.Text.ToString()); objOrders.OrdersDrink = txt_drinkI.Text.ToString(); objOrders.OrdersDrinkquantity = Int32.Parse(txt_drinkquantityI.Text.ToString()); objOrders.OrdersSauce = Int32.Parse(txt_sauceI.Text.ToString()); objOrders.OrdersAddress = txt_addressI.Text.ToString(); lbl_msg.Text = objOrders.insertOrders(); _subBind(); }
// Update orders: updates the selected orders row protected void UpdateOrders(object sender, GridViewUpdateEventArgs e) { ordersClass objOrders = new ordersClass(); objOrders.OrdersID = Int32.Parse(((Label)grv_orders.Rows[e.RowIndex].FindControl("lbl_ID")).Text); objOrders.OrdersName = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_nameU")).Text; objOrders.OrdersNumber = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_numberU")).Text; objOrders.OrdersFood = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_foodU")).Text; objOrders.OrdersFoodquantity = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_foodquantityU")).Text); objOrders.OrdersDrink = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_drinkU")).Text; objOrders.OrdersDrinkquantity = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_drinkquantityU")).Text); objOrders.OrdersSauce = Int32.Parse(((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_sauceU")).Text); objOrders.OrdersAddress = ((TextBox)grv_orders.Rows[e.RowIndex].FindControl("txt_addressU")).Text; lbl_msg.Text = objOrders.updateOrders(); grv_orders.EditIndex = -1; _subBind(); }
//connected model // Retrieves values from database table and passes values into properties. Stores values in a list and returns public List <ordersClass> getOrders() { List <ordersClass> allOrders = new List <ordersClass>(); SqlConnection conn = new SqlConnection(_connString); SqlCommand cmd = new SqlCommand("SELECT * FROM orders", conn); try { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); // dr.read reads each row until there are none left while (dr.Read()) { ordersClass objOrders = new ordersClass(); objOrders.OrdersID = Convert.ToInt32(dr["id"].ToString()); objOrders.OrdersName = (string)dr["name"]; objOrders.OrdersNumber = (string)dr["number"]; objOrders.OrdersFood = (string)dr["food"]; objOrders.OrdersFoodquantity = Convert.ToInt32(dr["foodquantity"].ToString()); objOrders.OrdersDrink = (string)dr["drink"]; objOrders.OrdersDrinkquantity = Convert.ToInt32(dr["drinkquantity"].ToString()); objOrders.OrdersSauce = Convert.ToInt32(dr["sauce"].ToString()); objOrders.OrdersAddress = (string)dr["address"]; allOrders.Add(objOrders); } return(allOrders); } catch (Exception err) { allOrders.Clear(); ordersClass objOrders = new ordersClass(); objOrders.OrdersName = "Server Error (DB): " + err.Message.ToString(); allOrders.Add(objOrders); return(allOrders); } finally { conn.Close(); } }