public void ATB()
{
string movie = txt_MovieImage.Text;
if (movie.Contains(@"\"))
{
movie.Replace(@"\""", @"'\\\\'");
}
Promotion_Model = new Promotion_Model();
Promotion_Model.Movie_name = txt_MovieName.Text;
Promotion_Model.Movie_URL = movie;
Promotion_Model.Promotion_ID = dg_main.SelectedRows[0].Cells["Promotion_Id"].Value.ToString();
}
private void btn_Update_Click(object sender, EventArgs e)
{
Promotion_Model = new Promotion_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)
{
promotion_CRUDService = new Promotion_CRUDService();
if (promotion_CRUDService.Update(Promotion_Model))
{
MessageBox.Show("Data UPDATED !!");
displaydatagrid();
}
else
{
MessageBox.Show("Data FAILED UPDATED !!");
displaydatagrid();
}
}
}
}
public bool Update(Promotion_Model promotion_Model)
{
bool result = false;
query = @"UPDATE `promotion` SET `Name` = @movie_name,`Picture_URL` = @movie_URL WHERE `promotion_id` =@Promotion_Id '{2}'";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add("@movie_name", promotion_Model.Movie_name);
cmd.Parameters.Add("@movie_URL", promotion_Model.Movie_URL);
cmd.Parameters.Add("@Promotion_Id", promotion_Model.Promotion_ID);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(result = true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(result);
}
}
}
