private void Btn_Update_Click(object sender, EventArgs e)
{
movie_Model = new Movie_Model();
if (PerformValidation(groupBox1))
{
ATB();
bool DialogDel = MessageBox.Show("Are you sure to EDIT this Data", "EDIT", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes;
if (DialogDel)
{
movie_CRUDService = new Movie_CRUDService();
if (movie_CRUDService.Update(movie_Model))
{
MessageBox.Show("Data UPDATED !!");
this.Close();
}
else
{
MessageBox.Show("Data FAILED UPDATED !!");
this.Close();
}
}
else
{
MessageBox.Show("Wrong Password !!");
}
((FrmEditMovie)f).displaydatagrid();
}
}
public void ATB()
{
//string slide = txt_SlideImage.Text;
//if (slide.Contains(@"\"))
//{
// slide.Replace(@"\""", @"'\\'");
//}
//string movie = txt_MovieImage.Text;
//if (movie.Contains(@"\"))
//{
// movie.Replace(@"\""", @"'\\\\'");
//}
movie_Model = new Movie_Model();
movie_Model.MovieName = txt_MovieName.Text;
movie_Model.MovieIMDB = txt_MovieIMDB.Text;
movie_Model.MovieDescription = txt_MovieDescription.Text;
//movie_Model.MovieImage = movie;
//movie_Model.SlideImage = slide;
movie_Model.Duration = txt_Duration.Text;
movie_Model.ReleasedDate = dtp_ReleaseDate.Value.ToString("yyyy-MM-dd");
if (txt_IsReleased.Text == "True")
{
movie_Model.IsReleased = "1";
}
else
{
movie_Model.IsReleased = "0";
};
movie_Model.MovieID = ((FrmEditMovie)f).Movie_Id;
}
public void LoadForm()
{
movie_Model = new Movie_Model();
txt_MovieName.Text = ((FrmEditMovie)f).txt_MovieName.Text;
txt_MovieIMDB.Text = ((FrmEditMovie)f).txt_MovieIMDB.Text;
txt_MovieDescription.Text = ((FrmEditMovie)f).txt_MovieDescription.Text;
//txt_MovieImage.Text = ((FrmEditMovie)f).txt_MovieImage.Text;
//txt_SlideImage.Text = ((FrmEditMovie)f).txt_SlideImage.Text;
txt_Duration.Text = ((FrmEditMovie)f).txt_Duration.Text;
dtp_ReleaseDate.Value = ((FrmEditMovie)f).dtp_ReleaseDate.Value;
txt_IsReleased.Text = ((FrmEditMovie)f).txt_IsReleased.Text;
}
public bool Insert(Movie_Model movie_model)
{
bool result = false;
//{
// DBCon = new DBConnection();
// query = string.Format(@"INSERT INTO `movies`(`movie_name`,`movie_imdb`,`movie_description`,`slide_image`,`movie_image`,`Duration`,`Release_Date`,`isReleased`)
// VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}');",movie_model.MovieName,movie_model.MovieIMDB,movie_model.MovieDescription,movie_model.SlideImage,movie_model.MovieImage,movie_model.Duration,movie_model.ReleasedDate,movie_model.IsReleased);
// DBCon.ConnectionOpen();
// cmd = new MySqlCommand(query, DBCon.Connection);
// cmd.BeginExecuteNonQuery();
// DBCon.ConnectionClose();
//}
//catch (Exception ex) { Console.WriteLine(ex); }
//return result;
query = "INSERT INTO `movies`(`movie_name`,`movie_imdb`,`movie_description`,`slide_image`,`movie_image`,`Duration`,`Release_Date`,`isReleased`)" +
"VALUES(@movie_name,@movie_imdb,@movie_description,@slide_image,@movie_image,@Duration,@Release_Date,@isReleased)";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add("@movie_name", movie_model.MovieName);
cmd.Parameters.Add("@movie_imdb", movie_model.MovieIMDB);
cmd.Parameters.Add("@movie_description", movie_model.MovieDescription);
cmd.Parameters.Add("@slide_image", movie_model.SlideImage);
cmd.Parameters.Add("@movie_image", movie_model.MovieImage);
cmd.Parameters.Add("@Duration", movie_model.Duration);
cmd.Parameters.Add("@Release_Date", movie_model.ReleasedDate);
cmd.Parameters.Add("@isReleased", movie_model.IsReleased);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(result = true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(result);
}
}
}
public bool Update(Movie_Model movie_Model)
{
bool result = false;
try
{
DBCon = new DBConnection();
query = string.Format(@"UPDATE `movies` SET `movie_name` = '{0}',`movie_imdb` = '{1}',`movie_description` = '{2}',`Duration` = '{3}',`Release_Date` = '{4}',`IsReleased` = '{5}'WHERE `movie_id` = '{6}';",
movie_Model.MovieName, movie_Model.MovieIMDB, movie_Model.MovieDescription, movie_Model.Duration, movie_Model.ReleasedDate, movie_Model.IsReleased, movie_Model.MovieID);
DBCon.ConnectionOpen();
cmd = new MySqlCommand(query, DBCon.Connection);
result = cmd.ExecuteNonQuery() == 1;
DBCon.ConnectionClose();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(result);
}
