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 }