public AdminMovieUpdate(AdminMovieContent content, int movie_no)
{
InitializeComponent();
this.content = content;
dbuse = new DBUSE();
Movie_tbl movie_Tbl = new Movie_tbl();
movie_Tbl = dbuse.MovieSelect(movie_no);
DTP_playdate.Format = DateTimePickerFormat.Custom;
DTP_playdate.CustomFormat = "yyyy-MM-dd";
DTP_time.Format = DateTimePickerFormat.Custom;
DTP_time.CustomFormat = "HH:mm";
MessageBox.Show(movie_Tbl.Movie_No + "/" + movie_Tbl.Title + "/" + movie_Tbl.genre + "/" + movie_Tbl.playdate + "/" + movie_Tbl.time);
TB_MovieNo.Text = movie_Tbl.Movie_No.ToString();
TB_MovieTitle.Text = movie_Tbl.Title;
TB_MovieGenre.Text = movie_Tbl.genre;
DTP_playdate.MinDate = movie_Tbl.playdate;
DTP_time.MinDate = movie_Tbl.time;
pictureBox1.Image = new Bitmap(new MemoryStream(movie_Tbl.ImageFile, 0, movie_Tbl.ImageFile.Length));
openFileDialog1.FileName = pictureBox1.ImageLocation;
}
private void Insert_Movie(object sender, EventArgs e)
{
Movie_tbl movie_Tbl = new Movie_tbl();
try
{
movie_Tbl.Movie_No = Convert.ToInt32(TB_MovieNo.Text);
}
catch (Exception ex) { Console.WriteLine(ex); }
movie_Tbl.Title = TB_MovieTitle.Text;
movie_Tbl.genre = TB_MovieGenre.Text;
movie_Tbl.playdate = DTP_playdate.Value;
movie_Tbl.time = DTP_time.Value;
movie_Tbl.Image = openFileDialog1.FileName;
DBUSE dbuse = new DBUSE();
int chk = dbuse.MovieInsert(movie_Tbl);
if (chk == 0)
{
content.selectList();
this.Close();
}
}
private void BT_SignUp_Click(object sender, EventArgs e)
{
Member_tbl memberTbl = new Member_tbl();
memberTbl.id = TB_Id.Text;
memberTbl.password = TB_password.Text;
memberTbl.name = TB_Name.Text;
memberTbl.phone = TB_phone.Text;
memberTbl.address = TB_address.Text;
DBUSE dbuse = new DBUSE();
dbuse.SignUp(memberTbl);
}
public AdminMovieContent()
{
InitializeComponent();
dbuse = new DBUSE();
selectList();
}
