public ServicesForm(HotelCrownContext db)
{
this.db = db;
InitializeComponent();
ListServices();
lstAvailableServices.SelectedIndex = -1;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
btnAlloteRoom.Visible = true;
btnEdit.Visible = true;
btnDelete.Enabled = true;
btnUpdate.Visible = false;
btnCancel.Visible = false;
string fullName = txtFullName.Text;
int identityNo = int.Parse(txtIdentityNumber.Text);
int mobileNo = int.Parse(txtMobileNo.Text);
Gender gender = (Gender)cboGender.SelectedValue;
DateTime birthDate = dtBirthDate.Value;
string description = rtxtDescriptions.Text;
Customer selectedCustomer = (Customer)dgvCustomers.SelectedRows[0].DataBoundItem;
using (HotelCrownContext db = new HotelCrownContext())
{
var editingPerson = db.Customers.FirstOrDefault(x => x.Id == selectedCustomer.Id);
editingPerson.FullName = fullName;
editingPerson.IdentityNumber = identityNo;
editingPerson.PhoneNumber = mobileNo;
editingPerson.Gender = gender;
editingPerson.BirthDate = birthDate;
editingPerson.Description = description;
db.SaveChanges();
}
ListCustomers();
ClearForm();
}
private void btnAlloteRoom_Click(object sender, EventArgs e)
{
string fullName = txtFullName.Text;
int identityNo = int.Parse(txtIdentityNumber.Text);
int mobileNo = int.Parse(txtMobileNo.Text);
Gender gender = (Gender)cboGender.SelectedValue;
DateTime birthDate = dtBirthDate.Value;
string description = rtxtDescriptions.Text;
using (HotelCrownContext db = new HotelCrownContext())
{
db.Customers.Add(new Customer()
{
FullName = fullName,
IdentityNumber = identityNo,
PhoneNumber = mobileNo,
Gender = gender,
BirthDate = birthDate,
Description = description
});
db.SaveChanges();
}
ListCustomers();
ClearForm();
}
private void ListFeatures()
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvServices.DataSource = db.ReservationServices.ToList();
}
}
private void ListCustomers()
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvCustomers.DataSource = db.Customers.ToList();
}
}
private void ListCapacity()
{
using (HotelCrownContext db = new HotelCrownContext())
{
cboBed.DataSource = db.Rooms.ToList();
}
}
private void ListRooms()
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvNewRoom.DataSource = db.Rooms.ToList();
}
}
private void BtnEditMode_Click(object sender, EventArgs e)
{
using (HotelCrownContext db = new HotelCrownContext())
{
int selectedId = int.Parse(dgvReservations.SelectedRows[0].Cells["Id"].Value.ToString());
Reservation editingOne = db.Reservations.FirstOrDefault(x => x.Id == selectedId);
editingOne.CheckOutDate = dtExtendOut.Value;
int quantity = (int)nudQuantity.Value;
ReservationService reservationService = new ReservationService
{
ServiceName = editingOne.ReservationServices + cboServices.Text,
Quantity = quantity
};
editingOne.ReservationServices = new List <ReservationService> {
reservationService
};
db.SaveChanges();
ListResarvation();
}
ListResarvation();
btnNewReservation.Visible = true;
btnEdit.Visible = true;
btnDelete.Visible = true;
dtExtendOut.Visible = false;
cboServices.Visible = false;
nudQuantity.Visible = false;
BtnEditMode.Visible = false;
PanelControls.Visible = true;
PanelEdit.Visible = false;
}
public FeaturesForm(HotelCrownContext db)
{
this.db = db;
InitializeComponent();
ListFeature();
lstAvailableFeatures.DataSource = db.Features.ToList();
}
private void ListFeatures()
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvFeatures.DataSource = db.Features.ToList();
}
}
private void btnAddRoom_Click_1(object sender, EventArgs e)
{
if (txtRoomNo.Text == "" || txtPrice.Text == "" || cboBed.Text == "")
{
MessageBox.Show("Fill All Fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int roomNo = int.Parse(txtRoomNo.Text);
List <Feature> features = clbFeatures.CheckedItems.OfType <Feature>().ToList();
int price = int.Parse(txtPrice.Text);
string bedNumber = cboBed.Text;
using (HotelCrownContext db = new HotelCrownContext())
{
db.Rooms.Add(new Room
{
RoomNo = roomNo,
Capacity = bedNumber,
Price = price,
Features = features
});
db.SaveChanges();
}
ListRooms();
Clear();
}
private void ListFeatures()
{
using (HotelCrownContext db = new HotelCrownContext())
{
clbFeatures.DataSource = db.Features.ToList();
}
clbFeatures.DisplayMember = "FeatureName";
clbFeatures.ValueMember = "FeatureId";
}
public RoomsForm(HotelCrownContext db)
{
this.db = db;
InitializeComponent();
ListRooms();
lstAvailableRooms.SelectedIndex = -1;
this.Height = 341;
cboFeatures.DataSource = db.Features.ToList();
cboFeatures.SelectedIndex = -1;
}
private void btnAddCustomer_Click(object sender, EventArgs e)
{
using (HotelCrownContext db = new HotelCrownContext())
{
int key = int.Parse(dgvRooms.SelectedRows[0].Cells[0].Value.ToString());
CustomerRegistration frm = new CustomerRegistration(key);
frm.ChangesDone += Frm_ChangesDone;
frm.ShowDialog();
}
}
public ReservationForm(HotelCrownContext db)
{
this.db = db;
InitializeComponent();
dtpCheckInDate.Format = DateTimePickerFormat.Custom;
dtpCheckInDate.CustomFormat = "yyyy/MM/dd hh:mm:ss";
dtpCheckOutDate.Format = DateTimePickerFormat.Custom;
dtpCheckOutDate.CustomFormat = "yyyy/MM/dd";
lstCustomers.DataSource = db.Customers.Where(x => x.Reservation == null).ToList();
lstCustomers.SelectedIndex = -1;
lstRooms.DataSource = db.Rooms.Where(x => x.Reservations.All(r => r.CheckOutDate <= dtpCheckInDate.Value || r.CheckInDate >= dtpCheckOutDate.Value)).ToList();
lstRooms.SelectedIndex = -1;
}
public EditRezervationForm(HotelCrownContext db, Reservation reservation)
{
this.db = db;
this.reservation = reservation;
InitializeComponent();
dgvReservationInfo.AutoGenerateColumns = false;
dgvReservationInfo.DataSource = db.Reservations.Where(x => x.Id == reservation.Id).ToList();
ListRooms();
cboRooms.SelectedIndex = -1;
lstServices.DataSource = db.Services.ToList();
lstServices.SelectedIndex = -1;
this.Width = 1051;
lstReservationsOldServices.DataSource = reservation.ServiceDetails.Select(x => x.ServiceAndQuantity).ToList();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string feature = txtFeatureName.Text;
using (HotelCrownContext db = new HotelCrownContext())
{
db.Features.Add(new Feature()
{
FeatureName = feature
});
db.SaveChanges();
}
ListFeatures();
ClearForm();
}
private void ListAdditionalRooms()
{
using (HotelCrownContext db = new HotelCrownContext())
{
//Rezervasyon için müsait olan odaları listele
dgvRooms.DataSource = db.Rooms.SelectMany(x => db.Reservations.Where(y => y.CheckInDate >= checkOut || y.CheckOutDate <= checkIn).Where(a => a.Id == x.RoomId), (x, y) =>
new
{
x.RoomId,
x.RoomNo,
x.Price,
y.CheckInDate,
y.CheckOutDate
}).Distinct().ToList();
}
}
private void btnAlloteRoom_Click(object sender, EventArgs e)
{
Customer alloteCustomer = (Customer)dgvCustomers.SelectedRows[0].DataBoundItem;
DateTime controlIn = new DateTime(2020, 12, 6, 12, 04, 00);
DateTime controlOut = new DateTime(2020, 12, 6, 12, 04, 00);
DateTime checkInDate = dtCheckInDate.Value;
DateTime checkOutDate = dtCheckOutDate.Value;
DateTime checkedInTime = dtCheckInTime.Value;
DateTime checkedOutTime = dtCheckOutTime.Value;
string service = cboServices.Text;
int quantity = int.Parse(nudQuantity.Text);
int customerId = alloteCustomer.Id;
//int roomId = reservation.RoomId;
string checkedIn = (cbxCheckedIn.Checked) ? "Yes" : "No";
string checkedOut = (cbxCheckedOut.Checked) ? "Yes" : "No";
using (HotelCrownContext db = new HotelCrownContext())
{
string serveCustomer = cboServices.Text;
Room addRoom = (Room)db.Rooms.FirstOrDefault(x => x.RoomId == reservation);
ReservationService serviceCustomer = db.ReservationServices.FirstOrDefault(x => x.ServiceName == serveCustomer);
Customer reserveCustomer = db.Customers.FirstOrDefault(x => x.Id == customerId);
db.Reservations.Add(new Reservation()
{
RoomId = reservation,
CheckInDate = checkInDate,
CheckOutDate = checkOutDate,
CheckedInTime = checkedInTime,
CheckedOutTime = checkedOutTime,
CheckedIn = checkedIn,
CheckedOut = checkedOut,
Room = addRoom,
Customers = new List <Customer> {
reserveCustomer
},
ReservationServices = new List <ReservationService> {
serviceCustomer
}
});
db.SaveChanges();
}
WhenChangesDone(EventArgs.Empty);
Close();
}
private void btnAdd_Click(object sender, EventArgs e)
{
string service = txtServiceName.Text;
string price = txtPrice.Text;
using (HotelCrownContext db = new HotelCrownContext())
{
db.ReservationServices.Add(new ReservationService()
{
ServiceName = service,
UnitPrice = int.Parse(price)
});
db.SaveChanges();
}
ListFeatures();
ClearForm();
}
private void btnOutNo_Click_1(object sender, EventArgs e)
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvReservations.DataSource = db.Reservations.Where(a => a.CheckedOut == "No").SelectMany(x => db.Customers.Select(y => y), (x, y) =>
new
{
x.Id,
x.Room.RoomNo,
x.CheckInDate,
x.CheckOutDate,
x.CheckedIn,
x.CheckedOut,
//y.FullName
}).Distinct().ToList();
}
}
private void ListResarvationbyDate()
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvReservations.DataSource = db.Reservations.Where(a => a.CheckInDate >= checkOut || a.CheckOutDate <= checkIn).SelectMany(x => db.Customers.Select(y => y), (x, y) =>
new
{
x.Id,
x.Room.RoomNo,
x.CheckInDate,
x.CheckOutDate,
x.CheckedIn,
x.CheckedOut,
//y.FullName
}).Distinct().ToList();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvReservations.SelectedRows.Count == 0)
{
return;
}
int selectedId = int.Parse(dgvReservations.SelectedRows[0].Cells["Id"].Value.ToString());
using (HotelCrownContext db = new HotelCrownContext())
{
Reservation deletingReservation = db.Reservations.FirstOrDefault(x => x.Id == selectedId);
db.Reservations.Attach(deletingReservation);
db.Reservations.Remove(deletingReservation);
db.SaveChanges();
}
ListResarvation();
}
private void btnOutYes_Click(object sender, EventArgs e)
{
using (HotelCrownContext db = new HotelCrownContext())
{
dgvReservations.DataSource = db.Reservations.Where(a => a.CheckedOut == "Yes").SelectMany(x => db.Customers.Select(y => y), (x, y) =>
new
{
x.Id,
x.Room.RoomNo,
x.CheckInDate,
x.CheckOutDate,
x.CheckedIn,
x.CheckedOut,
//y.FullName
}).Distinct().ToList();
//x.AllCustomers : Classta bu objenin değerleri anlamadığım bir şekilde null geliyor
}
}
private void txtSearchBox_TextChanged(object sender, EventArgs e)
{
string contain = txtSearchBox.Text;
using (HotelCrownContext db = new HotelCrownContext())
{
dgvReservations.DataSource = db.Reservations.SelectMany(x => db.Customers.Where(y => y.FullName.Contains(contain)), (x, y) =>
new
{
x.Id,
x.Room.RoomNo,
x.CheckInDate,
x.CheckOutDate,
x.CheckedIn,
x.CheckedOut,
//y.FullName
}).Distinct().ToList();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvServices.SelectedRows.Count == 0)
{
return;
}
int selectedIndex = dgvServices.SelectedRows[0].Index;
ReservationService deletingService = (ReservationService)dgvServices.SelectedRows[0].DataBoundItem;
using (HotelCrownContext db = new HotelCrownContext())
{
db.ReservationServices.Attach(deletingService);
db.ReservationServices.Remove(deletingService);
db.SaveChanges();
}
ListFeatures();
ClearForm();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvCustomers.SelectedRows.Count == 0)
{
return;
}
int selectedIndex = dgvCustomers.SelectedRows[0].Index;
Customer deletingCustomer = (Customer)dgvCustomers.SelectedRows[0].DataBoundItem;
using (HotelCrownContext db = new HotelCrownContext())
{
db.Customers.Attach(deletingCustomer);
db.Customers.Remove(deletingCustomer);
db.SaveChanges();
}
ListCustomers();
ClearForm();
}
private void btnEdit_Click(object sender, EventArgs e)
{
btnAlloteRoom.Visible = false;
btnEdit.Visible = false;
btnDelete.Enabled = false;
btnUpdate.Visible = true;
btnCancel.Visible = true;
Customer selectedCustomer = (Customer)dgvCustomers.SelectedRows[0].DataBoundItem;
using (HotelCrownContext db = new HotelCrownContext())
{
var editingPerson = db.Customers.FirstOrDefault(x => x.Id == selectedCustomer.Id);
txtFullName.Text = editingPerson.FullName;
txtIdentityNumber.Text = editingPerson.IdentityNumber.ToString();
txtMobileNo.Text = editingPerson.IdentityNumber.ToString();
//cboGender.SelectedValue = editingPerson.Gender;
dtBirthDate.Value = (DateTime)editingPerson.BirthDate;
rtxtDescriptions.Text = editingPerson.Description;
db.SaveChanges();
}
}
private void ListServices()
{
using (HotelCrownContext db = new HotelCrownContext())
cboServices.DataSource = db.Services.ToList();
}
public CustomersForm(HotelCrownContext db)
{
this.db = db;
InitializeComponent();
ListCustomer();
}
