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 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);
}
}
}
/// <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");
}
}
}
}
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
}
