public void createWishList()
{
YourMoviePanel2.Controls.Clear();
list.Clear();
SqlConnection connection = new SqlConnection(Form4.connectionString);
connection.Open();
SqlDataAdapter a = new SqlDataAdapter("SELECT MovieName, Director, MovieType, ReleaseDate, AddDate, M.MID, Poster FROM MovieQueue as MQ, Movie as M WHERE M.MID = MQ.MID and MQ.CID ='" + UC1.id + "' order by [Sequence]", connection);
DataTable t = new DataTable();
a.Fill(t);
int i = 1;
int x = 0;
bool empty = true;
foreach (DataRow row in t.Rows)
{
foreach (DataColumn column in t.Columns)
{
movieInfo[x] = row[column].ToString();
x++;
}
x = 0;
MovieGroupBox newGroupBox = new MovieGroupBox();
newGroupBox.setGroupBox(YourMoviePanel2, i);
i++;
var releaseDate = movieInfo[3].Substring(0, movieInfo[3].IndexOf(' '));
var addDate = movieInfo[4].Substring(0, movieInfo[4].IndexOf(' '));
Byte[] data = new Byte[0];
if (row["Poster"] == DBNull.Value)
{
newGroupBox.setImage(newGroupBox.groupBox, ((Image)Properties.Resources.ResourceManager.GetObject("Noimage")));
}
else
{
data = (Byte[])(row["Poster"]);
Image image = Image.FromStream(new MemoryStream(data));
newGroupBox.setImage(newGroupBox.groupBox, image);
}
newGroupBox.setMovieInfo(newGroupBox.groupBox, movieInfo[0], movieInfo[1], movieInfo[2], releaseDate, addDate, movieInfo[5].ToString());
newGroupBox.SetChooseMovieButton(newGroupBox.groupBox, "Rent");
newGroupBox.SetIndex(newGroupBox.groupBox, i - 1);
newGroupBox.DeleteMovieFromListButton(newGroupBox.groupBox, "Delete");
newGroupBox.setUpDownButton(newGroupBox.groupBox);
empty = false;
}
if (empty == true)
{
Label emptyLabel = new Label();
emptyLabel.Location = new Point(100, 100);
emptyLabel.Font = new Font("Arial", 20);
emptyLabel.Text = "Wish List is empty.";
emptyLabel.AutoSize = true;
YourMoviePanel2.Controls.Add(emptyLabel);
}
}
private void createRentalHistory()
{
SqlConnection connection = new SqlConnection(Form4.connectionString);
connection.Open();
SqlDataAdapter a = new SqlDataAdapter("SELECT MovieName, Director, MovieType, ReleaseDate, AddDate, M.MID, Poster FROM [Order] O, Movie as M WHERE M.MID = O.MID and O.CID ='" + UC1.id + "'", connection);
DataTable t = new DataTable();
a.Fill(t);
int i = 1;
int x = 0;
foreach (DataRow row in t.Rows)
{
foreach (DataColumn column in t.Columns)
{
movieInfo[x] = row[column].ToString();
x++;
}
x = 0;
MovieGroupBox newGroupBox = new MovieGroupBox();
newGroupBox.setGroupBox(YourMoviePanel2, i);
i++;
var releaseDate = movieInfo[3].Substring(0, movieInfo[3].IndexOf(' '));
var addDate = movieInfo[4].Substring(0, movieInfo[4].IndexOf(' '));
Byte[] data = new Byte[0];
if (row["Poster"] == DBNull.Value)
{
newGroupBox.setImage(newGroupBox.groupBox, ((Image)Properties.Resources.ResourceManager.GetObject("Noimage")));
}
else
{
data = (Byte[])(row["Poster"]);
Image image = Image.FromStream(new MemoryStream(data));
newGroupBox.setImage(newGroupBox.groupBox, image);
}
newGroupBox.setMovieInfo(newGroupBox.groupBox, movieInfo[0], movieInfo[1], movieInfo[2], releaseDate, addDate, movieInfo[5].ToString());
list.Add(newGroupBox);
}
}
public void createCurrentRental()
{
YourMoviePanel2.Controls.Clear();
list.Clear();
Label plan = new Label();
plan.AutoSize = true;
string CustomerPlan = "";
SqlConnection connection = new SqlConnection(Form4.connectionString);
connection.Open();
SqlDataAdapter dataAdapter = new SqlDataAdapter("select AccountType from Customer C where C.CID =" + UC1.id, connection);
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
foreach (DataRow row in dataTable.Rows)
{
CustomerPlan = row["AccountType"].ToString().Trim();
}
plan.Text = "Customer Plan: " + CustomerPlan + " At most " + checkplan(CustomerPlan);
YourMoviePanel2.Controls.Add(plan);
//MessageBox.Show(dataTable.Rows.Count.ToString());
connection.Close();
connection = new SqlConnection(Form4.connectionString);
connection.Open();
SqlDataAdapter a = new SqlDataAdapter("SELECT MovieName, Director, MovieType, ReleaseDate, AddDate, M.MID, Poster FROM [Order] as O, Movie as M WHERE M.MID = O.MID and O.CID = '" + UC1.id + "' and O.ActualReturnDate is null", connection);
DataTable t = new DataTable();
a.Fill(t);
int i = 1;
int x = 0;
bool empty = true;
foreach (DataRow row in t.Rows)
{
foreach (DataColumn column in t.Columns)
{
movieInfo[x] = row[column].ToString();
x++;
}
x = 0;
MovieGroupBox newGroupBox = new MovieGroupBox();
newGroupBox.setGroupBox(YourMoviePanel2, i);
i++;
var releaseDate = movieInfo[3].Substring(0, movieInfo[3].IndexOf(' '));
var addDate = movieInfo[4].Substring(0, movieInfo[4].IndexOf(' '));
newGroupBox.SetReturnButton(newGroupBox.groupBox, "ReturnMovie");
Byte[] data = new Byte[0];
if (row["Poster"] == DBNull.Value)
{
newGroupBox.setImage(newGroupBox.groupBox, ((Image)Properties.Resources.ResourceManager.GetObject("Noimage")));
}
else
{
data = (Byte[])(row["Poster"]);
Image image = Image.FromStream(new MemoryStream(data));
newGroupBox.setImage(newGroupBox.groupBox, image);
}
newGroupBox.setMovieInfo(newGroupBox.groupBox, movieInfo[0], movieInfo[1], movieInfo[2], releaseDate, addDate, movieInfo[5].ToString());
list.Add(newGroupBox);
empty = false;
}
if (empty == true)
{
Label emptyLabel = new Label();
emptyLabel.Location = new Point(50, 100);
emptyLabel.Font = new Font("Segoe UI", 24);
emptyLabel.Text = "There is no rented movie currently.";
emptyLabel.AutoSize = true;
YourMoviePanel2.Controls.Add(emptyLabel);
}
}