public void PrintLisеSoonFilmAdmin(AdminControl adminControl1)
{
OleDbCommand command = new OleDbCommand("SELECT * FROM [SoonFilm]", myConnection);
myConnection.Open();
OleDbDataReader reader = command.ExecuteReader();
adminControl1.flowLayoutPanel2.Controls.Clear();
while (reader.Read())
{
ListFS Item = new ListFS();
byte[] Photo = (byte[])(reader[0]);
MemoryStream memoryStream = new MemoryStream(Photo);
Item.PictureBox.Image = Image.FromStream(memoryStream);
Item.gunaLabel1.Text = reader[1].ToString();
Item.Size = new Size(374, 41);
Item.pLine.Size = new Size(360, 10);
Item.btnDeleteSoonFilm.Location = new Point(350, 12);
Item.Data.Visible = true;
Item.Data.Text = reader[12].ToString();
Item.btnDeleteSoonFilm.Visible = true;
adminControl1.flowLayoutPanel2.Controls.Add(Item);
}
reader.Close();
myConnection.Close();
}
public void btnAdmin_Click(object sender, EventArgs e)
{
PanelSearch.Location = new Point(26, 11);
btnBack.Visible = false;
_obj = this;
gunaPanel2.Controls.RemoveAt(0);
AdminControl adminControl1 = new AdminControl();
gunaPanel2.Controls.Add(adminControl1);
adminControl1.Dock = DockStyle.Fill;
adminControl1.BringToFront();
PrintListFilmAdmin(adminControl1);
PrintLisеSoonFilmAdmin(adminControl1);
PrintListUserAdmin(adminControl1);
CountParamAdmin(adminControl1);
}
public void CountParamAdmin(AdminControl adminControl1)
{
OleDbCommand command = new OleDbCommand("SELECT COUNT(*) FROM Film", myConnection);
myConnection.Open();
adminControl1.CountFilm.Text = "0" + command.ExecuteScalar().ToString();
myConnection.Close();
command = new OleDbCommand("SELECT COUNT(*) FROM SoonFilm", myConnection);
myConnection.Open();
adminControl1.CountSoonFilm.Text = "0" + command.ExecuteScalar().ToString();
myConnection.Close();
command = new OleDbCommand("SELECT COUNT(*) FROM Users", myConnection);
myConnection.Open();
adminControl1.CountUsers.Text = "0" + command.ExecuteScalar().ToString();
myConnection.Close();
adminControl1.DataTime.Text = DateTime.Now.Day.ToString() + "." + DateTime.Now.Month.ToString() + "." + DateTime.Now.Year.ToString();
}
public void PrintListUserAdmin(AdminControl adminControl1)
{
OleDbCommand command = new OleDbCommand("SELECT * FROM [Users]", myConnection);
myConnection.Open();
OleDbDataReader reader = command.ExecuteReader();
adminControl1.flowLayoutPanel3.Controls.Clear();
Random random = new Random();
while (reader.Read())
{
ListUsers Item = new ListUsers();
Item.gunaLabel4.Text = reader[0].ToString();
Item.gunaLabel5.Text = reader[1].ToString();
Item.gunaLabel6.Text = reader[2].ToString();
Item.gunaLabel7.Text = random.Next(1, 50).ToString();
adminControl1.flowLayoutPanel3.Controls.Add(Item);
}
reader.Close();
myConnection.Close();
}
