public bool Update(Ticket_Model ticket_Model)
{
bool result = false;
try
{
DBCon = new DBConnection();
query = string.Format(@"UPDATE `ticket`
SET
`Type` = '{0}',
`DayCode` = '{1}',
`Price` = '{2}'
WHERE `Code` = '{3}';",
ticket_Model.Type,
ticket_Model.DayCode,
ticket_Model.Price,
ticket_Model.ticketid);
DBCon.ConnectionOpen();
cmd = new MySqlCommand(query, DBCon.Connection);
result = cmd.ExecuteNonQuery() == 1;
DBCon.ConnectionClose();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(result);
}
public bool Insert(Ticket_Model ticket_Model)
{
bool result = false;
query = "INSERT INTO `ticket`(`type`,`daycode`,`price`)" +
"VALUES(@type,@daycode,@price)";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add("@type", ticket_Model.Type);
cmd.Parameters.Add("@daycode", ticket_Model.DayCode);
cmd.Parameters.Add("@price", ticket_Model.Price);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(result = true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(result);
}
}
}
private void btn_Update_Click(object sender, EventArgs e)
{
ticket_Model = new Ticket_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)
{
ticketCRUD = new Ticket_CRUDService();
if (ticketCRUD.Update(ticket_Model))
{
MessageBox.Show("Data UPDATED !!");
this.Close();
}
else
{
MessageBox.Show("Data FAILED UPDATED !!");
this.Close();
}
}
else
{
MessageBox.Show("Wrong Password !!");
}
((FrmEditTickets)f).displaydatagrid();
}
}
public void LoadForm()
{
ticket_Model = new Ticket_Model();
txt_DayCode.Text = ((FrmEditTickets)f).txt_DayCode.Text;
txt_Price.Text = ((FrmEditTickets)f).txt_Price.Text;
txt_Type.Text = ((FrmEditTickets)f).txt_Type.Text;
}
public void ATB()
{
ticket_Model = new Ticket_Model();
ticket_Model.DayCode = txt_DayCode.Text;
ticket_Model.Price = txt_Price.Text;
ticket_Model.Type = txt_Type.Text;
}
public void ATB()
{
ticket_Model = new Ticket_Model();
ticket_Model.DayCode = txt_DayCode.Text;
ticket_Model.Price = txt_Price.Text;
ticket_Model.Type = txt_Type.Text;
ticket_Model.ticketid = ((FrmEditTickets)f).ticketid;
}
