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