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);
}
