/* Delete Booking */
private void button2_Click(object sender, EventArgs e)
{
// Check selection
if (bookingsView.SelectedCells.Count < 1)
{
MessageBox.Show("No valid selection.");
return;
}
// Get selected row
DataGridViewRow selectedRow = bookingsView.Rows[bookingsView.SelectedCells[0].RowIndex];
// Get selected Booking ID
string bid = selectedRow.Cells["BID"].Value.ToString();
// Ask user if data should be deleted
DialogResult dialogResult = MessageBox.Show(string.Format("Are you sure you want to delete booking {0} ?", bid), "Delete?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.No)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
// Delete data
var adapter = new Database_adapter();
var blidList = adapter.get_List(string.Format("select blid from booking_lines where bid = {0};", bid));
foreach (string blid in blidList)
{
adapter.set(string.Format("delete from booking_entries where blid = {0};", blid));
// Check out
var checkedObjects = adapter.get_List(string.Format("select name from rent_objects where currentUser = {0};", blid));
foreach (string name in checkedObjects)
{
adapter.set(string.Format("update rent_objects set currentUser = 0 where name = '{0}';", name));
}
}
adapter.set(string.Format("delete from booking_lines where bid = {0};", bid));
adapter.set(string.Format("delete from bookings where bid = {0};", bid));
adapter.set(string.Format("delete from transfers where bid = {0};", bid));
adapter.set(string.Format("delete from alerts where bid = {0};", bid));
adapter.close();
Cursor.Current = Cursors.Default;
// Update table
fill_Table();
}
/* Remove button clicked */
private void removeButton_Click(object sender, EventArgs e)
{
string blid = get_SelectedBlid();
if (blid == null)
{
return;
}
var adapter = new Database_adapter();
// Check out
var checkedObjects = adapter.get_List(string.Format("select name from rent_objects where currentUser = {0};", blid));
foreach (string name in checkedObjects)
{
adapter.set(string.Format("update rent_objects set currentUser = 0 where name = '{0}';", name));
}
adapter.set("delete from booking_entries where blid = " + blid + ";");
adapter.set("delete from booking_lines where blid = " + blid + ";");
adapter.close();
fill_BookingLineTable();
fill_Overview();
}
private bool cancel()
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to cancel this booking?", "Cancel?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.No)
{
return(false);
}
var adapter = new Database_adapter();
var blidList = adapter.get_List(string.Format("select blid from booking_lines where bid = {0};", bid));
foreach (string blid in blidList)
{
adapter.set(string.Format("delete from booking_entries where blid = {0};", blid));
}
adapter.set(string.Format("delete from booking_lines where bid = {0};", bid));
adapter.set(string.Format("delete from bookings where bid = {0};", bid));
adapter.set(string.Format("delete from alerts where bid = {0};", bid));
adapter.close();
return(true);
}
private void ObjectDeleter_Shown(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
var adapter = new Database_adapter();
var roID = adapter.get_Value(string.Format("select roID from rent_objects where name = '{0}';", name));
var count = Int32.Parse(adapter.get_Value(string.Format("select count(name) name from rent_objects where roID = {0}", roID)));
var dates = adapter.get_List(string.Format(@"
select date
from booking_entries
where roID = {0}
and date >= '{1}'
group by date
order by date DESC;
", roID, DateTime.Now.ToString("yyyy-MM-dd")));
deleteBar.Maximum = dates.Count;
deleteBar.Step = 1;
deleteBar.Value = 0;
var booked = "Could not delete object. Fully booked at:\r\n";
var delete = true;
foreach (var date in dates)
{
var bookedAtDate = adapter.get_Value(string.Format("select count(beID) from booking_entries where date = '{0}' and roID = {1};", DateTime.Parse(date).ToString("yyyy-MM-dd"), roID));
if (count - Int32.Parse(bookedAtDate) <= 0)
{
delete = false;
booked += DateTime.Parse(date).ToString("dd.MM.yy, ");
}
deleteBar.Value += 1;
}
Cursor.Current = Cursors.Default;
if (delete)
{
DialogResult dialogResult = MessageBox.Show(string.Format("Are you sure you want to delete {0}", name), "Delete?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
adapter.set(string.Format("delete from rent_objects where name = '{0}';", name));
}
}
else
{
MessageBox.Show(booked);
}
adapter.close();
this.Close();
}
private bool cancel()
{
DialogResult dialogResult = MessageBox.Show("Are you sure you want to cancel this booking?", "Cancel?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.No)
{
return(false);
}
Cursor.Current = Cursors.WaitCursor;
var adapter = new Database_adapter();
var blidList = adapter.get_List(string.Format("select blid from booking_lines where bid = {0};", bid));
foreach (string blid in blidList)
{
adapter.set(string.Format("delete from booking_entries where blid = {0};", blid));
// Check out
var checkedObjects = adapter.get_List(string.Format("select name from rent_objects where currentUser = {0};", blid));
foreach (string name in checkedObjects)
{
adapter.set(string.Format("update rent_objects set currentUser = 0 where name = '{0}';", name));
}
}
adapter.set(string.Format("delete from booking_lines where bid = {0};", bid));
adapter.set(string.Format("delete from bookings where bid = {0};", bid));
adapter.set(string.Format("delete from transfers where bid = {0};", bid));
adapter.set(string.Format("delete from alerts where bid = {0};", bid));
adapter.close();
Cursor.Current = Cursors.Default;
return(true);
}