public void DeleteARow(DTO_AmenityTicket amenityTicket) { try { string query = string.Format("delete from AmenitiesTickets where AmenityID like {0} and TicketID like {1}", amenityTicket.AmenityID, amenityTicket.TicketID); ExcuteNonQuery(query); } catch (Exception e) { return; } }
public void InsertARow(DTO_AmenityTicket amenityTicket) { try { string query = string.Format("EXEC proc_InsertAmenitiesTickets @amenityID = {0}, @ticketID = {1}", amenityTicket.AmenityID, amenityTicket.TicketID); ExcuteNonQuery(query); } catch (Exception e) { return; } }
public List <DTO_AmenityTicket> GetAmenitiesTicketListByTicketID(string ticketID) { List <DTO_AmenityTicket> lsAmenitiesTicket = new List <DTO_AmenityTicket>(); DataTable dt = dal_amenitiesTickets.GetAmenitiesTicketTableByTicketID(ticketID); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { DTO_AmenityTicket amenityTicket = new DTO_AmenityTicket(); amenityTicket.AmenityID = dr["AmenityID"].ToString(); amenityTicket.TicketID = dr["TicketID"].ToString(); amenityTicket.Price = double.Parse(dr["Price"].ToString()); lsAmenitiesTicket.Add(amenityTicket); } } return(lsAmenitiesTicket); }
private void SaveAmenitiesTicket() { string ticketID = cbFlights.SelectedValue.ToString(); BUS_AmenityTicket bus_amenityTicket = new BUS_AmenityTicket(); DTO_AmenityTicket amenityTicket = new DTO_AmenityTicket(); amenityTicket.TicketID = ticketID; foreach (Control control in gbAmenities.Controls) { CheckBox chkBox = (CheckBox)control; amenityTicket.AmenityID = amenityKeyValuePairs[chkBox.Text].ID; if (chkBox.Checked && chkBox.Enabled) { bus_amenityTicket.InsertARow(amenityTicket); } else if (!chkBox.Checked) { bus_amenityTicket.DeleteArow(amenityTicket); } } }
public void DeleteArow(DTO_AmenityTicket amenityTicket) { dal_amenitiesTickets.DeleteARow(amenityTicket); }
public void InsertARow(DTO_AmenityTicket amenityTicket) { dal_amenitiesTickets.InsertARow(amenityTicket); }