// Button 'Save'
// Validate input and insert into database
private void buttonNewFolioConfirm_Click(object sender, EventArgs e)
{
Boolean folioexists = false;
// Validate that guest is selcted and folio has items
if (listBoxGuest.SelectedIndex > -1 && listBoxFolioItem.Items.Count > 0)
{
// Reference variables
int guestid = Convert.ToInt32(listBoxGuest.SelectedValue);
string adminid = UserInfo.AdminID;
// Check -> Folio does not exist
if (DBGetData.GetFolioExists(guestid) > 0)
{
folioexists = true;
}
if (folioexists)
{
MessageBox.Show("Guest already has an active folio, add any changes to existing.");
}
if (!folioexists)
{
// Create new folio
DBSetData.FolioAdd(guestid, adminid);
// Fetch newly created folioid
MySqlDataReader getFolioid = DBGetData.GetFolioid(guestid);
if (getFolioid.Read())
{
// Add folio items to folio
int folioid = getFolioid.GetInt32(0);
foreach (DataRowView drv in listBoxFolioItem.Items)
{
int billingitemid = int.Parse(drv.Row[listBoxFolioItem.ValueMember].ToString());
DBSetData.FolioItemAdd(folioid, billingitemid, adminid);
}
}
else
{
MessageBox.Show("Could not fetch newly created folioid, try again or contact administrator.");
}
getFolioid.Dispose();
// Refresh datagridview, close form and display new StatusMessage
folioForm.LoadDataFolio();
folioForm.Refresh();
this.Close();
new StatusMessage("Folio with " + listBoxFolioItem.Items.Count + " items added.");
}
}
}
