private async void Delete_button_Click(object sender, EventArgs e)
{
if (MessageBox.Show("This action is irreversible!!", "Are you sure? ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
using (var db = new Session2Entities())
{
try
{
var list = dgvlist[dataGridView1.SelectedRows[0].Index];
var item = (from i in db.Packages
where i.packageId == list.ID
select i).First();
var booking = (from c in db.Bookings
where c.packageIdFK == item.packageId
where c.userIdFK == UserID
select c).First();
db.Bookings.Remove(booking);
await db.SaveChangesAsync();
}
catch
{
}
}
dgvlist.RemoveAt(dataGridView1.SelectedRows[0].Index);
UpdateUI();
}
}
private async void Approve_button_Click(object sender, EventArgs e)
{
using (var db = new Session2Entities())
{
var id = dgvlist[dataGridView1.SelectedRows[0].Index].ID;
var name = dgvlist[dataGridView1.SelectedRows[0].Index].PackageName;
var booking = (from d in db.Bookings
where d.bookingId == id
select d).First();
var package = (from p in db.Packages
where p.packageName == name
select p).First();
if (package.packageQuantity >= booking.quantityBooked)
{
package.packageQuantity -= booking.quantityBooked;
booking.status = "Approved";
await db.SaveChangesAsync();
}
else
{
MessageBox.Show("Insufficient quantity");
}
}
UpdateUI();
}
private async Task addPackage()
{
using (var db = new Session2Entities())
{
int packageid = (from d in db.Packages
orderby d.packageId descending
select d.packageId).First() + 1;
if (Online.Checked)
{
var benefits = new Benefit()
{
packageIdFK = packageid,
benefitId = (from d in db.Benefits
orderby d.benefitId descending
select d.benefitId).First() + 1,
benefitName = "Online"
};
db.Benefits.Add(benefits);
}
if (Flyers.Checked)
{
var benefits = new Benefit()
{
packageIdFK = packageid,
benefitId = (from d in db.Benefits
orderby d.benefitId descending
select d.benefitId).First() + 1,
benefitName = "Flyers"
};
db.Benefits.Add(benefits);
}
if (Banner.Checked)
{
var benefits = new Benefit()
{
packageIdFK = packageid,
benefitId = (from d in db.Benefits
orderby d.benefitId descending
select d.benefitId).First() + 1,
benefitName = "Banner"
};
db.Benefits.Add(benefits);
}
var pa = new Package()
{
packageId = packageid,
packageName = package_box.Text,
packageQuantity = (int)quantity_updown.Value,
packageTier = tier_combo.SelectedItem.ToString(),
packageValue = (int)value_updown.Value
};
db.Packages.Add(pa);
await db.SaveChangesAsync();
}
}
private async void Reject_button_Click(object sender, EventArgs e)
{
using (var db = new Session2Entities())
{
var id = dgvlist[dataGridView1.SelectedRows[0].Index].ID;
var booking = (from d in db.Bookings
where d.bookingId == id
select d).First();
db.Bookings.Remove(booking);
booking.status = "Rejected";
await db.SaveChangesAsync();
}
UpdateUI();
}
private async void book_button_Click(object sender, EventArgs e)
{
if (desired_updown.Value == 0)
{
MessageBox.Show("Please select a quantity greater than zero");
}
else
{
if (desired_updown.Value <= int.Parse(dataGridView1.SelectedRows[0].Cells[4].Value.ToString()))
{
using (var db = new Session2Entities())
{
try
{
var booking = new Booking()
{
bookingId = (from b in db.Bookings
orderby b.bookingId descending
select b.bookingId).First() + 1,
packageIdFK = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString()),
userIdFK = UserID,
quantityBooked = (int)desired_updown.Value,
status = "Pending"
};
db.Bookings.Add(booking);
}
catch
{
var booking = new Booking()
{
bookingId = 1,
packageIdFK = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString()),
userIdFK = UserID,
quantityBooked = (int)desired_updown.Value,
status = "Pending"
};
db.Bookings.Add(booking);
}
await db.SaveChangesAsync();
MessageBox.Show("DONE!");
}
}
else
{
MessageBox.Show("Not enough stock!");
}
}
}
private async Task AddUser()
{
using (var db = new Session2Entities())
{
var user = new User()
{
userId = user_box.Text,
name = company_box.Text,
passwd = password_box.Text,
userTypeIdFK = 2
};
db.Users.Add(user);
await db.SaveChangesAsync();
}
}
private async void Update_button_Click(object sender, EventArgs e)
{
if (MessageBox.Show("This action is irreversible!!", "Are you sure? ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
using (var db = new Session2Entities())
{
if (quantity_updown.Value > 0)
{
try
{
var list = dgvlist[dataGridView1.SelectedRows[0].Index];
var item = (from i in db.Packages
where i.packageId == list.ID
select i).First();
if (item.packageQuantity < list.QuantityBooked)
{
MessageBox.Show("Insufficient Quantity!!!");
}
else
{
dgvlist[dataGridView1.SelectedRows[0].Index].QuantityBooked = (int)quantity_updown.Value;
UpdateUI();
var booking = (from c in db.Bookings
where c.packageIdFK == item.packageId
where c.userIdFK == UserID
select c).First();
booking.quantityBooked = (int)quantity_updown.Value;
await db.SaveChangesAsync();
}
}
catch
{
}
}
else
{
MessageBox.Show("Please choose a value greater than zero!!");
}
}
}
}
