private void butXoa_Click(object sender, EventArgs e)
{
if (listRank.SelectedItems.Count > 0)
{
using (MotelManagerEntities data = new MotelManagerEntities())
{
DialogResult result = MessageBox.Show("Ban co chac xoa khach co ID = " + listRank.FocusedItem.Text + " khong? (tat ca cac du lieu lien quan deu se bi xoa!)", "WARNING", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);
switch (result)
{
case DialogResult.Cancel: return;
case DialogResult.Yes:
{
ROOMRANK temp = data.ROOMRANKs.Find(int.Parse(listRank.FocusedItem.Text));
data.ROOMRANKs.Remove(temp);
data.SaveChanges();
listRank.Clear();
loadData(0, soLuong);
dem = 0;
break;
}
case DialogResult.No: return;
default:
break;
}
}
}
else
{
MessageBox.Show("Hay chon khach can xoa tu danh sach!", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void loadRoom()
{
listRoom.Clear();
datePickerCheckOut.Value = DateTime.Now;
var listRent = (from a in data.REINTINFORs where a.CheckOutDate.Value.ToString() == "" select a).ToList();
listRoom.Columns.Add("ID", 100);
listRoom.Columns.Add("Tên Phòng", 150);
listRoom.Columns.Add("Trạng Thái", 120);
listRoom.Columns.Add("Loại phòng", 140);
listRoom.Columns.Add("Tên Khu Vực ", 200);
List <MOTELROOM> listMotel = new List <MOTELROOM>();
int dem = 0;
foreach (var a in listRent)
{
if (listMotel.Count > 0)
{
for (int i = 0; i < listMotel.Count; i++)
{
if (a.IDRoom.Equals(listMotel[i].ID))
{
dem = 1;
}
}
if (dem == 0)
{
MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom);
listMotel.Add(b);
}
}
else
{
MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom);
listMotel.Add(b);
}
dem = 0;
}
foreach (MOTELROOM b in listMotel)
{
ListViewItem item = new ListViewItem(b.ID.ToString());
item.SubItems.Add(b.RoomName);
if (b.StateRoom.Value == true)
{
item.SubItems.Add("phòng đã được thuê");
}
else
{
item.SubItems.Add("phòng trống");
}
ROOMRANK c = data.ROOMRANKs.Find(b.IDRoomRank);
item.SubItems.Add(c.RankName.ToString());
ROOMRANGE d = data.ROOMRANGEs.Find(b.IDRoomRange);
item.SubItems.Add(d.RangeName.ToString());
listRoom.Items.Add(item);
}
}
public void loadData(String a)
{
ROOMRANK c = data.ROOMRANKs.Find(int.Parse(a));
textRankName.Text = c.RankName;
textPrice.Text = c.Price.ToString();
textDeposit.Text = c.Deposits.ToString();
textAbout.Text = c.About;
}
public void saveDate()
{
ROOMRANK temp = new ROOMRANK()
{
RankName = textRankName.Text, Price = int.Parse(textPrice.Text), Deposits = int.Parse(textDeposit.Text), About = textAbout.Text
};
data.ROOMRANKs.Add(temp);
data.SaveChanges();
}
public void updateData()
{
ROOMRANK temp = data.ROOMRANKs.Find(int.Parse(labIDShow.Text));
temp.RankName = textRankName.Text;
decimal a = decimal.Parse(textPrice.Text);
temp.Price = a;
a = decimal.Parse(textDeposit.Text);
temp.Deposits = a;
temp.About = textAbout.Text;
data.SaveChanges();
}
public void loadRoom(int e, int f)
{
using (MotelManagerEntities data = new MotelManagerEntities())
{
listRoom.Columns.Add("ID Phòng", 100);
listRoom.Columns.Add("Tên Phòng", 150);
listRoom.Columns.Add("Trạng Thái", 120);
listRoom.Columns.Add("Loại phòng", 140);
listRoom.Columns.Add("Tên Khu Vực ", 200);
var list = (from d in data.USP_PageRoom(e, f) select d).ToList();
foreach (var c in list)
{
ListViewItem item = new ListViewItem(c.ID.ToString());
item.SubItems.Add(c.RoomName);
if (c.StateRoom.Value == true)
{
item.SubItems.Add("phòng đã được thuê");
}
else
{
item.SubItems.Add("phòng trống");
}
ROOMRANK a = data.ROOMRANKs.Find(c.IDRoomRank);
item.SubItems.Add(a.RankName.ToString());
ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange);
item.SubItems.Add(b.RangeName.ToString());
listRoom.Items.Add(item);
}
var temp2 = (from c in data.USP_CountRoom() select c).ToList();
tong = int.Parse(temp2[0].ToString());
if (tong % soLuong != 0)
{
tinh = tong / soLuong + 1;
}
else
{
tinh = tong / soLuong;
}
labPage.Text = "Trang 1/" + tinh;
}
}
private void textSearch_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
listRoom.Clear();
using (MotelManagerEntities data = new MotelManagerEntities())
{
String temp = textSearch.Text;
List <MOTELROOM> list = (from a in data.MOTELROOMs where a.RoomName.Contains(temp) || a.ID.ToString().Contains(temp) select a).ToList();
listRoom.Columns.Add("ID Phòng", 100);
listRoom.Columns.Add("Tên Phòng", 150);
listRoom.Columns.Add("Trạng Thái", 120);
listRoom.Columns.Add("Loại phòng", 140);
listRoom.Columns.Add("Tên Khu Vực ", 200);
foreach (MOTELROOM c in list)
{
ListViewItem item = new ListViewItem(c.ID.ToString());
item.SubItems.Add(c.RoomName);
if (c.StateRoom.Value == true)
{
item.SubItems.Add("phòng đã được thuê");
}
else
{
item.SubItems.Add("phòng trống");
}
ROOMRANK a = data.ROOMRANKs.Find(c.IDRoomRank);
item.SubItems.Add(a.RankName.ToString());
ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange);
item.SubItems.Add(b.RangeName.ToString());
listRoom.Items.Add(item);
}
labPage.Text = "Trang 1/1";
}
}
}
public void loadData(String a)
{
MOTELROOM c = data.MOTELROOMs.Find(int.Parse(a));
labIDRoomShow.Text = c.ID.ToString();
textRoomName.Text = c.RoomName;
if (c.StateRoom.Value == true)
{
labStateShow.Text = "phòng đã được thuê";
}
else
{
labStateShow.Text = "phòng trống";
}
comBoxIDRank.Text = c.IDRoomRank.ToString();
ROOMRANK d = data.ROOMRANKs.Find(c.IDRoomRank);
textRankName.Text = d.RankName;
comBoxIDRange.Text = c.IDRoomRange.ToString();
ROOMRANGE b = data.ROOMRANGEs.Find(c.IDRoomRange);
textRangeName.Text = b.RangeName;
}
private void textSearch_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Return)
{
listRoom.Clear();
using (MotelManagerEntities data = new MotelManagerEntities())
{
String temp = textSearch.Text;
List <REINTINFOR> listRent = (from a in data.REINTINFORs where a.CheckOutDate.Value.ToString() == "" select a).ToList();
listRoom.Columns.Add("ID", 100);
listRoom.Columns.Add("Tên Phòng", 150);
listRoom.Columns.Add("Trạng Thái", 120);
listRoom.Columns.Add("Loại phòng", 140);
listRoom.Columns.Add("Tên Khu Vực ", 200);
List <MOTELROOM> listMotel = new List <MOTELROOM>();
int dem = 0;
foreach (REINTINFOR a in listRent)
{
if (listMotel.Count > 0)
{
for (int i = 0; i < listMotel.Count; i++)
{
if (a.IDRoom.Equals(listMotel[i].ID))
{
dem = 1;
}
}
if (dem == 0)
{
MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom);
listMotel.Add(b);
}
}
else
{
MOTELROOM b = data.MOTELROOMs.Find(a.IDRoom);
listMotel.Add(b);
}
dem = 0;
}
List <MOTELROOM> listMotel2 = (from a in listMotel where a.RoomName.Contains(temp) || a.ID.ToString().Contains(temp) select a).ToList();
foreach (MOTELROOM b in listMotel2)
{
ListViewItem item = new ListViewItem(b.ID.ToString());
item.SubItems.Add(b.RoomName);
if (b.StateRoom.Value == true)
{
item.SubItems.Add("phòng đã được thuê");
}
else
{
item.SubItems.Add("phòng trống");
}
ROOMRANK c = data.ROOMRANKs.Find(b.IDRoomRank);
item.SubItems.Add(c.RankName.ToString());
ROOMRANGE d = data.ROOMRANGEs.Find(b.IDRoomRange);
item.SubItems.Add(d.RangeName.ToString());
listRoom.Items.Add(item);
}
}
}
}
private void comBoxIDRank_SelectedIndexChanged(object sender, EventArgs e)
{
ROOMRANK d = data.ROOMRANKs.Find(int.Parse(comBoxIDRank.Text));
textRankName.Text = d.RankName;
}
