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