private async void A_EditRoomData_Load(object sender, EventArgs e)
{
using (var db = new HotelWinFormsDbContext())
{
roomBindingSource.DataSource = await db.Rooms.ToListAsync();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
using (var db = new HotelWinFormsDbContext())
{
List <Room> roomId = db.Rooms.ToList();
var isd = roomId[indexRow].RoomId;
var vp = db.Rooms.Where(o => o.RoomId == isd).SingleOrDefault();
db.Rooms.Remove(vp);
int result = db.SaveChanges();
if (result > 0)
{
roomBindingSource.DataSource = db.Rooms.ToList();
dataGridView1.Update();
dataGridView1.Refresh(); //this.roomsTableAdapter.Fill(this.roomsDataSet.Rooms);
MessageBox.Show("Room deleted", "Succeed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed");
}
}
}
private async void btnOrder_Click(object sender, EventArgs e)
{
if (LoginForm.RoomId != 1)
{
if (cbTowels.Text != "" || cbCleening.Checked != false)
{
using (var db = new HotelWinFormsDbContext())
{
ServRoomOrder servRoom = new ServRoomOrder();
servRoom.Cleening = cbCleening.Checked;
servRoom.Towels = cbTowels.Text;
servRoom.RoomId = LoginForm.RoomId;
this.Close();
MainForm form = new MainForm(LoginForm.LoginedRole);
form.openChildForm(new ResultTrue());
db.ServiceRoom.Add(servRoom);
await db.SaveChangesAsync();
}
}
else
{
MessageBox.Show("Choose something", "Order cannot be null", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("You loginned as guest");
}
}
private async void btnOrder_Click(object sender, EventArgs e)
{
if (LoginForm.RoomId != 0)
{
if (cbBurger.Text != "" || cbCake.Text != "" || cbPizza.Text != "")
{
using (var db = new HotelWinFormsDbContext())
{
ServFoodOrder servFood = new ServFoodOrder();
servFood.Burger = cbBurger.Text;
servFood.Cake = cbCake.Text;
servFood.Pizza = cbPizza.Text;
servFood.RoomId = LoginForm.RoomId;
MainForm form = new MainForm(LoginForm.LoginedRole);
form.openChildForm(new ResultTrue());
db.ServiceFood.Add(servFood);
await db.SaveChangesAsync();
}
}
else
{
MessageBox.Show("Choose something", "Order cannot be null", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("You loginned as guest");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
using (var db = new HotelWinFormsDbContext())
{
try
{
if (db.Rooms.All(x => x.RoomNumber != txtRoomNumb.Text.Replace(" ", string.Empty).ToUpper()))
{
Room room = new Room();
room.Description = richTextBox1.Text;
room.PricePerWeek = Convert.ToDouble(txtPricePerWeek.Text);
room.RoomImage = (txtImgSource.Text);
if (radioAvailable.Checked == true)
{
room.IsAvailable = "Available";
}
if (radioOrdered.Checked == true)
{
room.IsAvailable = "Ordered";
}
room.RoomType = cbRoomType.Text;
room.RoomNumber = (txtRoomNumb.Text.Replace(" ", string.Empty).ToUpper());
db.Rooms.Add(room);
var result = db.SaveChanges();
if (result > 0)
{
MessageBox.Show("Room created", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
roomBindingSource.DataSource = db.Rooms.ToList();
dataGridView1.Update();
dataGridView1.Refresh();
//this.roomsTableAdapter.Fill(this.roomsDataSet.Rooms);
}
else
{
MessageBox.Show("Failed");
}
}
else
{
MessageBox.Show("Room with same number already exist", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show("Fields can`t be empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private async void A_OrderForm_Load(object sender, EventArgs e)
{
using (var db = new HotelWinFormsDbContext())
{
cbRoomNumber.DataSource = await(db.Rooms.Where(x => x.IsAvailable == "Available").ToListAsync());
}
dateDepartureDate.MinDate = DateTime.Today.AddDays(1);
dateDepartureDate.MaxDate = DateTime.Today.AddMonths(13);
dateEntryDate.MinDate = DateTime.Today;
dateEntryDate.MaxDate = DateTime.Today.AddMonths(5);
dateBDay.MinDate = DateTime.Today.AddYears(-150);
dateBDay.MaxDate = DateTime.Today.AddYears(-16);
}
/// <summary>
/// updating order and client data
/// </summary>
/// <param name="sender"></param>
/// <param name="e">selected row</param>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (indexRow >= 0 && indexRow <= dataGridView1.Rows.Count)
{
using (var db = new HotelWinFormsDbContext())
{
var ordersList = db.Orders.ToList();
Order order = new Order();
//id is not changing
order.OrderId = ordersList[indexRow].OrderId;
order.ClientName = txtName.Text;
order.BirthDay = dataBDay.Value;
order.Phone = Convert.ToInt32(txtPhone.Text);
order.Email = txtEmail.Text;
if (radioMale.Checked == true)
{
order.Gender = "Male";
}
if (radioFemale.Checked == true)
{
order.Gender = "Female";
}
order.Passport = txtPassport.Text;
order.EntryDate = dateEntryDate.Value;
order.DepartureDate = dateDepartureDate.Value;
order.RoomNumber = txtRoomNumber.Text;
order.TotalCosting = Convert.ToDouble(txtTotalCost.Text);
db.Orders.AddOrUpdate(order);
int result = db.SaveChanges();
if (result > 0)
{
//this.ordersTableAdapter.Fill(this.ordersDataSet.Orders);
MessageBox.Show("Order updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed");
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (indexRow >= 0 && indexRow <= dataGridView1.Rows.Count)
{
using (var db = new HotelWinFormsDbContext())
{
List <Room> roomId = db.Rooms.ToList();
Room room = new Room();
room.RoomId = roomId[indexRow].RoomId;
room.Description = richTextBox1.Text;
room.PricePerWeek = Convert.ToDouble(txtPricePerWeek.Text);
room.RoomImage = txtImgSource.Text;
room.RoomNumber = txtRoomNumb.Text;
if (radioAvailable.Checked == true)
{
room.IsAvailable = "Available";
}
if (radioOrdered.Checked == true)
{
room.IsAvailable = "Ordered";
}
room.RoomType = cbRoomType.Text;
db.Rooms.AddOrUpdate(room);
int result = db.SaveChanges();
if (result > 0)
{
//dataGridView1.Update();
//dataGridView1.Refresh();
roomBindingSource.DataSource = db.Rooms.ToList();
MessageBox.Show("Room updated", "Succeed", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed");
}
}
}
}
private async void LoginMethod()
{
string login = txtLogin.Text;
string password = txtPassword.Text;
if (login == "" && password == "")
{
this.Hide();
MainForm f = new MainForm("Guest");
f.Show();
}
else
{
using (var db = new HotelWinFormsDbContext())
{
var t = await db.Users.ToListAsync();
var userLogin = db.Users.Where(x => x.Login == login).Where(x => x.Password == password).FirstOrDefault();
if (userLogin == null)
{
MessageBox.Show("Provide correct username and password");
}
else
{
LoginedRole = userLogin.UserRole.UserRoleName;
if (LoginedRole.ToLower() == "employee" || LoginedRole.ToLower() == "admin")
{
}
else
{
RoomId = userLogin.RoomUser.RoomId;
}
this.Hide();
MainForm f = new MainForm(LoginedRole);
f.Show();
}
}
}
}
public void BindGridView()
{
using (var db = new HotelWinFormsDbContext())
{
try
{
Order order = new Order();
var daysCount = dateDepartureDate.Value - dateEntryDate.Value;
order.ClientName = txtName.Text;
order.EntryDate = dateEntryDate.Value;
order.DepartureDate = dateDepartureDate.Value;
order.BirthDay = dateBDay.Value;
order.Email = txtEmail.Text;
order.Passport = txtPassport.Text;
if (radioMale.Checked)
{
order.Gender = radioMale.Text;
}
if (radioFemale.Checked)
{
order.Gender = radioFemale.Text;
}
order.Phone = Convert.ToInt32(txtPhone.Text);
order.RoomNumber = cbRoomNumber.Text;
db.Rooms.Where(x => x.RoomNumber == cbRoomNumber.Text).FirstOrDefault().IsAvailable = "Ordered";
double price = (from p in db.Rooms where p.RoomNumber.ToLower().Replace(" ", string.Empty) == cbRoomNumber.Text select p.PricePerWeek).FirstOrDefault();
price = price * daysCount.Days / 7;
order.TotalCosting = (price);
fTotalCosting = price.ToString();
db.Orders.Add(order);
int result = db.SaveChanges();
if (result > 0)
{
MessageBox.Show("Order created", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed");
}
}
catch (Exception ex)
{
MessageBox.Show("Fields cannot be blank", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
#region Passing data to view result
fName = txtName.Text;
fEmail = txtEmail.Text;
fPassport = txtPassport.Text;
fPhone = txtPhone.Text;
fRoomNumber = cbRoomNumber.Text;
fentryDate = dateEntryDate.Value.ToLongDateString().ToString();
fdepartureDate = dateDepartureDate.Value.ToLongDateString().ToString();
fBirthDay = dateBDay.Value.ToLongDateString().ToString();
if (radioMale.Checked)
{
fGender = radioMale.Text;
}
if (radioFemale.Checked)
{
fGender = radioFemale.Text;
}
#endregion
}
