public bool DeleteOrder(Order order, /*int personId, int ticketId,*/ DateTime givingDate)
{
string personNameFilter = "Parent(FK_Main_Person).name Like '%" + order.PersonName + "%'";
string ticketNamefilter = "Parent(FK_Main_Ticket).ticket_name Like '%" + order.TicketName + "%'";
string filter = personNameFilter + " AND " + ticketNamefilter + " AND " + "month ='" + givingDate.ToString() + "'";
DataRow[] OrdersRows = ticketsDataSet.Main.Select(filter);
Tr_Tick_DBDataSet.MainRow row = null;
if (OrdersRows.Length == 0 || OrdersRows == null)
{
return(false);
}
else
{
foreach (DataRow tmpSearchedOrder in
OrdersRows)
{
row = ticketsDataSet.Main.FindBym_id(Convert.ToInt32(tmpSearchedOrder["m_id"].ToString()));
//order.ID = Convert.ToInt32(tmpSearchedOrder["m_id"].ToString());
}
//Tr_Tick_DBDataSet.MainRow row = ticketsDataSet.Main.FindBym_id(Convert.ToInt32(tmpSearchedOrder["m_id"].ToString()));
row.Delete();
provider.UpdateAllData();
return(true);
}
}
public bool AddOrder(Order order, int personId, int ticketId)
{
bool canAdd = IsUniqueOrder(order, personId, ticketId);
if (canAdd == true)
{
Tr_Tick_DBDataSet.MainRow orderRow =
ticketsDataSet.Main.AddMainRow(ticketsDataSet.Person.FindByppers_id(personId),
ticketsDataSet.Ticket.FindBytticket_id(ticketId), order.Date, order.Amount, order.Pledge);
provider.UpdateAllData();
return(true);
}
return(false);
}
