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();
}
}
