private ArrayList GetOrders() { ContentPlaceHolder cph = (ContentPlaceHolder)Master.FindControl("ContentPlaceHolder1"); ControlFinder <TextBox> cf = new ControlFinder <TextBox>(); cf.FindChildControlsRecursive(cph); var textBoxList = cf.FoundControls; ArrayList orderList = new ArrayList(); foreach (TextBox textBox in textBoxList) { if (textBox.Text != "") { int amountOfOrders = Convert.ToInt32(textBox.Text); if (amountOfOrders > 0) { TblMovies movies = Mothercode.GetMoviesById(Convert.ToInt32(textBox.ID)); Order order = new Order( Session["New"].ToString(), movies.MovieName, amountOfOrders, movies.TotalPrice, DateTime.Now, false); orderList.Add(order); } } } return(orderList); }
public static TblMovies GetMoviesById(int movieiD) { string query = String.Format("SELECT * FROM TblMovies WHERE Movieid = '{0}'", movieiD); TblMovies movies = null; try { connection.Open(); cmmd.CommandText = query; SqlDataReader reader = cmmd.ExecuteReader(); while (reader.Read()) { int movieid = reader.GetInt32(0); string moviename = reader.GetString(1); string amountmovie = reader.GetString(2); double totalprice = reader.GetDouble(3); string movieimage = reader.GetString(4); string movietext = reader.GetString(5); movies = new TblMovies(movieid, moviename, amountmovie, totalprice, movieimage, movietext); } } finally { connection.Close(); } return(movies); }
public static ArrayList ShowMovies(string movieName1) { ArrayList listmovie = new ArrayList(); string query = string.Format("SELECT * FROM TblMovies WHERE MovieName LIKE '{0}'", movieName1); try { connection.Open(); cmmd.CommandText = query; SqlDataReader reader = cmmd.ExecuteReader(); while (reader.Read()) { string moviename = reader.GetString(1); string amountmovie = reader.GetString(2); double totalprice = reader.GetDouble(3); string movieimage = reader.GetString(4); string movietext = reader.GetString(5); TblMovies movies1 = new TblMovies(moviename, amountmovie, totalprice, movieimage, movietext); listmovie.Add(movies1); } } finally { connection.Close(); } return(listmovie); }
public static void AddMovie(TblMovies tblMovies) { string query = string.Format( @"insert into TblMovies VALUES ('{0}', '{1}', @price,'{2}','{3}')", tblMovies.MovieName, tblMovies.AmountMovie, tblMovies.MovieImage, tblMovies.MovieText); cmmd.CommandText = query; cmmd.Parameters.Add(new SqlParameter("@price", tblMovies.TotalPrice)); try { connection.Open(); cmmd.ExecuteNonQuery(); } finally { connection.Close(); cmmd.Parameters.Clear(); } }