private void btnEditTicket_Click(object sender, EventArgs e) { string id = idTicket.Text; string cdt = cdtTicket.Text; string price = priceTicket.Text; TicketType_DTO ticket = new TicketType_DTO(id, cdt, price); TicketType_BUS.EditTicketType(ticket); }
private void btnAddType_Click(object sender, EventArgs e) { string id = idAddTicketType.Text; string condition = conditionAddTicketType.Text; string price = priceAddTicketType.Text; TicketType_DTO ticket = new TicketType_DTO(id, condition, price); TicketType_BUS.AddTicketType(ticket); MessageBox.Show("Complete!", "Add TicketType", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Close(); }
//Add a ticket type public static void AddTicketType(TicketType_DTO ticketType) { SqlConnection connecter = sqlConnectionData.Connecter(); SqlCommand commander = new SqlCommand("AddTicketType", connecter); commander.CommandType = CommandType.StoredProcedure; commander.Parameters.Add("@id", SqlDbType.Char, 10).Value = ticketType.Id; commander.Parameters.Add("@cdt", SqlDbType.NVarChar, 500).Value = ticketType.Condition; commander.Parameters.Add("@price", SqlDbType.Int).Value = ticketType.Price; connecter.Open(); commander.ExecuteNonQuery(); connecter.Close(); }
//Edit info ticket type public static void EditTicketType(TicketType_DTO ticket) { TicketType_DAO.EditTicketType(ticket); }
//Add a ticket type public static void AddTicketType(TicketType_DTO ticket) { TicketType_DAO.AddTicketType(ticket); }