//Load danh sách phòng theo loại phòng
public List <DTO_Phong> loadDanhSachPhongTheoLoaiPhong(string a)
{
List <DTO_Phong> listPhong = new List <DTO_Phong>();
string query = "SELECT * FROM PHONG WHERE MALOAIPHONG='" + a + "'";
DataTable data = DBConnect.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DTO_Phong info = new DTO_Phong(item);
listPhong.Add(info);
}
return(listPhong);
}
public List <DTO_Phong> getPhongList(string tenlp)
{
string query = string.Format("SELECT * FROM dbo.PHONG JOIN dbo.LOAIPHONG ON PHONG.MALOAIPHONG = LOAIPHONG.MALOAIPHONG AND LOAIPHONG.TENLOAIPHONG = N'{0}'", tenlp);
List <DTO_Phong> list = new List <DTO_Phong>();
DataTable dt = DBConnect.Instance.ExecuteQuery(query);
foreach (DataRow item in dt.Rows)
{
DTO_Phong phong = new DTO_Phong(item);
list.Add(phong);
}
return(list);
}
public List <DTO_Phong> layDanhSachPhongCoNguoi()
{
string query = string.Format("SELECT * FROM PHONG WHERE TINHTRANG = 1");
List <DTO_Phong> list = new List <DTO_Phong>();
DataTable dt = DBConnect.Instance.ExecuteQuery(query);
foreach (DataRow item in dt.Rows)
{
DTO_Phong phong = new DTO_Phong(item);
list.Add(phong);
}
return(list);
}
private void cbP_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem == null)
{
return;
}
DTO_Phong selected = cb.SelectedItem as DTO_Phong;
id = selected.PHONG_MAPHONG.ToString();
mp1 = Convert.ToInt32(id);
dgvPT.DataSource = busHotel.getPhieuthue(Convert.ToInt32(id));
}
public void showPhong(bool buttonClicked)
{
flpPhong.Controls.Clear();
flpPhong.HorizontalScroll.Maximum = 0;
flpPhong.AutoScroll = false;
flpPhong.VerticalScroll.Visible = false;
flpPhong.AutoScroll = true;
List <DTO_Phong> phongList = busPhong.getPhongList(loaiPhong.Text);
string tinhTrang;
foreach (DTO_Phong phong in phongList)
{
Button btn = new Button()
{
Width = 100, Height = 100
};
btn.Margin = new Padding(20, 5, 0, 20);
btn.Tag = phong;
btn.FlatStyle = FlatStyle.Flat;
btn.FlatAppearance.BorderSize = 5;
if (phong.PHONG_TINHTRANG == 1)
{
tinhTrang = "Có người";
btn.FlatAppearance.BorderColor = Color.Red;
}
else
{
tinhTrang = "Còn trống";
btn.FlatAppearance.BorderColor = Color.Green;
}
btn.Text = phong.PHONG_TENPHONG + "\n" + tinhTrang;
flpPhong.Controls.Add(btn);
btn.Click += (sender, EventArgs) => { Btn_Click(sender, EventArgs, phong.PHONG_MAPHONG, phong.PHONG_TENPHONG, phong.PHONG_GHICHU); };
}
if (phongList.Any() && buttonClicked == false)
{
DTO_Phong firstPhong = phongList.First();
tenPhong.Text = firstPhong.PHONG_TENPHONG;
ghiChu = firstPhong.PHONG_GHICHU;
ghiChuPhong.Text = firstPhong.PHONG_GHICHU;
mp = maPhong.Text = firstPhong.PHONG_MAPHONG.ToString();
lblTenPhong.Text = firstPhong.PHONG_TENPHONG;
}
else
{
tenPhong.Text = ghiChuPhong.Text = maPhong.Text = "";
}
}
public async Task <DTO_Phong> GetPhongById(string strMaPhong)
{
if (strMaPhong == null)
{
return(null);
}
DTO_Phong res = null;
using (var context = new SQLServerDBContext())
{
res = await context.Phong.SqlQuery("select top 1 * from PHONG p where p.MaPhong=@id",
new SqlParameter("@id", strMaPhong)).FirstOrDefaultAsync();
}
return(res);
}
private void btnXoa_Click(object sender, EventArgs e)
{
DTO_Phong phong = new DTO_Phong(txtMa_phong.Text, txtTen_phong.Text, cmbLoai_phong.Text, cmbTinh_trang.Text);
// thêm
if (bus_phong.xoaPhong(phong))
{
MessageBox.Show("xóa thành công");
dvgPhong.DataSource = bus_phong.getPhong();
}
else
{
MessageBox.Show("xóa không thành công");
}
}
public bool UpdatePhong(DTO_Phong phong, string tenPhongMoi)
{
using (var context = new SQLServerDBContext())
{
var phongMatch = context.Phong.Where(t => t.TenPhong.Equals(tenPhongMoi, StringComparison.OrdinalIgnoreCase));
if (phongMatch == null)
{
return(false);
}
phong.TenPhong = tenPhongMoi;
return(true);
}
}
public bool themPhong(DTO_Phong obj)
{
int paraNumber = 4;
string[] paraName = new string[paraNumber];
object[] values = new object[paraNumber];
paraName[0] = "MAPHONG";
paraName[1] = "MALOAIPHONG";
paraName[2] = "TINHTRANG";
paraName[3] = "SDT";
values[0] = obj.Maphong;
values[1] = obj.Maloaiphong;
values[2] = obj.Tinhtrang;
values[3] = obj.Sodienthoai;
return(Update("SP_Phong_Them", paraName, values, paraNumber));
}
private void cbPCu_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem == null)
{
return;
}
DTO_Phong selected = cb.SelectedItem as DTO_Phong;
id1 = selected.PHONG_MAPHONG.ToString();
mpcu = Convert.ToInt32(id1);
string lmpt = busHotel.loadMaPhieuThue(mpcu);
mpt = Convert.ToInt32(lmpt);
}
public string selectAllBySophong(List <DTO_Phong> lsObj, int sophong)
{
string query = string.Empty;
query += " SELECT [SOPHONG], [TINHTRANG], [MALP]";
query += " FROM [TBL_PHONG]";
query += " WHERE ";
query += " [SOPHONG] = @SOPHONG ";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@SOPHONG", sophong);
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows == true)
{
lsObj.Clear();
while (reader.Read())
{
DTO_Phong obj = new DTO_Phong();
obj.Sophong = reader["SOPHONG"].ToString();
obj.Status = reader["TINHTRANG"].ToString();
obj.Malp = reader["MALP"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Selecting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
private void listView1_ItemActivate(object sender, EventArgs e)
{
DTO_Phong dto_phong = new DTO_Phong();
ListViewItem item = listView1.FocusedItem;
frm_ThanhToan.maphong = item.Text;
frm_dangkiphong.maphong = item.Text;
if (String.Compare(phong.getTinhTrang(item.Text).Rows[0]["TINHTRANG"].ToString(), "TRỐNG", true) == 0)
{
frm_dangkiphong dkphong = new frm_dangkiphong();
dkphong.ShowDialog();
}
else
{
frm_ThanhToan frmThanhToan = new frm_ThanhToan();
frmThanhToan.ShowDialog();
}
}
public string search(string kq, List <DTO_Phong> lsObj)
{
string query = string.Empty;
query += " EXEC USP_GETROOMNUMBER ";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = query;
comm.Parameters.AddWithValue("@MAKH", "%" + kq.ToString() + "%");
comm.Parameters.AddWithValue("@TENKH", "%" + kq.ToString() + "%");
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows == true)
{
lsObj.Clear();
while (reader.Read())
{
DTO_Phong obj = new DTO_Phong();
obj.Sophong = reader["SOPHONG"].ToString();
obj.Status = reader["TINHTRANG"].ToString();
obj.Malp = reader["MALP"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Searching fail fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
public string selectAll(List <DTO_Phong> lsObj)
{
string query = string.Empty;
query += "USP_GETROOM";
using (SqlConnection conn = new SqlConnection(connectionSTR))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = query;
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.HasRows == true)
{
lsObj.Clear();
while (reader.Read())
{
DTO_Phong obj = new DTO_Phong();
obj.Sophong = reader["SOPHONG"].ToString();
obj.Status = reader["TINHTRANG"].ToString();
obj.Malp = reader["MALP"].ToString();
lsObj.Add(obj);
}
}
}
catch (Exception ex)
{
conn.Close();
return("Selecting fails\n" + ex.Message + "\n" + ex.StackTrace);
}
}
}
return("0");
}
// liên quan phòng
private void button2_Click(object sender, EventArgs e)
{
if (txtMa_phong.Text != " " && txtTen_phong.Text != " " && cmbLoai_phong.Text != " " && cmbTinh_trang.Text != " ")
{
DTO_Phong phong = new DTO_Phong(txtMa_phong.Text, txtTen_phong.Text, cmbLoai_phong.Text, cmbTinh_trang.Text);
// thêm
if (bus_phong.themPhong(phong))
{
MessageBox.Show("thêm thành công");
dvgPhong.DataSource = bus_phong.getPhong();
}
else
{
MessageBox.Show("thêm không thành công");
}
}
else
{
MessageBox.Show("xin vui lòng nhập đủ thông tin");
}
}
public async Task <string> AddPhongAsync(DTO_Phong phong)
{
using (var context = new SQLServerDBContext())
{
string res = null;
try
{
var tenPhong = new SqlParameter("@1", System.Data.SqlDbType.NVarChar);
tenPhong.Value = phong.TenPhong;
res = await context.Database.SqlQuery <string>("exec proc_Phong_insert @1",
new SqlParameter[]
{
tenPhong
}).FirstOrDefaultAsync();
}
catch (Exception e)
{
Debug.WriteLine("[ERROR] " + e.Message);
}
return(res);
}
}
private void load_phong()
{
listView1.Items.Clear();
foreach (DataRow dr in phong.GetPhong().Rows)
{
DTO_Phong dto_phong = new DTO_Phong();
dto_phong.Maloaiphong = (string)dr.ItemArray[1];
dto_phong.Maphong = (string)dr.ItemArray[0];
dto_phong.Tinhtrang = (string)dr.ItemArray[2];
tinhtrang = dto_phong.Tinhtrang;
ListViewItem item = new ListViewItem(dto_phong.Maphong);
if (String.Compare(dto_phong.Tinhtrang, "TRỐNG", true) == 0)
{
item.ImageIndex = 0;
}
else if (String.Compare(dto_phong.Tinhtrang, "KHÔNG TRỐNG", true) == 0)
{
item.ImageIndex = 1;
}
listView1.Items.Add(item);
}
}
public bool xoaPhong(DTO_Phong p)
{
try
{
conn.Open();
string SQL = string.Format("DELETE dbo.PHONG WHERE MAPHONG='{0}'", p.MA_PHONG);
SqlCommand cmd = new SqlCommand(SQL, conn);
int kq = cmd.ExecuteNonQuery();
if (kq > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(false);
}
private void DS_Phong_Load()
{
DTO_HoaDon thanhtien = new DTO_HoaDon();
thanhtien.SoDienThoai = sdt;
BO_DSPhongDaDat Tong = new BO_DSPhongDaDat();
DataSet tong = Tong.TongTien(thanhtien);
for (int i = 0; i < tong.Tables[0].Rows.Count; i++)
{
tongtien += int.Parse(tong.Tables[0].Rows[i][0].ToString());
}
txtTongTien.Text = tongtien.ToString();
DTO_HoaDon hoadon1 = new DTO_HoaDon();
hoadon1.SoDienThoai = sdt;
BO_DSPhongDaDat ds = new BO_DSPhongDaDat();
DataSet result = ds.DSPhong(hoadon1);
//gán vị trị khởi tạo user control
if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0)
{
Point vitribandau = new Point(5, 5);
for (int i = 0; i < result.Tables[0].Rows.Count; i++)
{
DateTime ngaydat = new DateTime(int.Parse("20" + result.Tables[0].Rows[i][8].ToString().Substring(6, 2)), int.Parse(result.Tables[0].Rows[i][8].ToString().Substring(3, 2)), int.Parse(result.Tables[0].Rows[i][8].ToString().Substring(0, 2)));
DateTime ngaytra = new DateTime(int.Parse("20" + result.Tables[0].Rows[i][9].ToString().Substring(6, 2)), int.Parse(result.Tables[0].Rows[i][9].ToString().Substring(3, 2)), int.Parse(result.Tables[0].Rows[i][9].ToString().Substring(0, 2)));
TimeSpan ts = new TimeSpan();
ts = ngaytra - ngaydat;
for (int j = 0; j < ts.TotalDays + 1; j++)
{
DemThoiGian.Add(ngaydat);
ngaydat = ngaydat.AddDays(1);
}
int count = 0;
foreach (DateTime songaytrung in DemThoiGian)
{
if (songaytrung.ToShortDateString() == DateTime.Now.ToShortDateString())
{
count++;
}
}
if (count > 0)
{
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = result.Tables[0].Rows[i][5].ToString();
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_DSPhongDaDat loaiphong = new BO_DSPhongDaDat();
DataSet table = new DataSet();
table = loaiphong.HienThiPhong(phong);
if (table.Tables.Count > 0 && table.Tables[0].Rows.Count > 0)
{
if (table.Tables[0].Rows[0][3].ToString() == "Giường Đơn" && table.Tables[0].Rows[0][4].ToString() == "2")
{
giuongdon2nguoi hienthi = new giuongdon2nguoi();
hienthi.SDT = sdt;
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.MACHINHANH = table.Tables[0].Rows[0][1].ToString();
hienthi.MAPHONG = table.Tables[0].Rows[0][0].ToString();
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.OPTIONS = "TuyChon";
hienthi.MAHD = result.Tables[0].Rows[i][3].ToString();
hienthi.Location = vitribandau;
pl_phong.Controls.Add(hienthi);
vitribandau.Y += 220;
}
else
{
if (table.Tables[0].Rows[0][3].ToString() == "Giường Đôi" && table.Tables[0].Rows[0][4].ToString() == "2")
{
giuongdoi2nguoi hienthi = new giuongdoi2nguoi();
hienthi.SDT = sdt;
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.MACHINHANH = table.Tables[0].Rows[0][1].ToString();
hienthi.MAPHONG = table.Tables[0].Rows[0][0].ToString();
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.OPTIONS = "TuyChon";
hienthi.MAHD = result.Tables[0].Rows[i][3].ToString();
hienthi.Location = vitribandau;
pl_phong.Controls.Add(hienthi);
vitribandau.Y += 220;
}
else
{
if (table.Tables[0].Rows[0][3].ToString() == "Giường Đơn" && table.Tables[0].Rows[0][4].ToString() == "4")
{
giuongdon4nguoi hienthi = new giuongdon4nguoi();
hienthi.SDT = sdt;
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.MACHINHANH = table.Tables[0].Rows[0][1].ToString();
hienthi.MAPHONG = table.Tables[0].Rows[0][0].ToString();
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.OPTIONS = "TuyChon";
hienthi.MAHD = result.Tables[0].Rows[i][3].ToString();
hienthi.Location = vitribandau;
pl_phong.Controls.Add(hienthi);
vitribandau.Y += 220;
}
else
{
if (table.Tables[0].Rows[0][3].ToString() == "Giường Đôi" && table.Tables[0].Rows[0][4].ToString() == "4")
{
giuongdoi4nguoi hienthi = new giuongdoi4nguoi();
hienthi.SDT = sdt;
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.MACHINHANH = table.Tables[0].Rows[0][1].ToString();
hienthi.MAPHONG = table.Tables[0].Rows[0][0].ToString();
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.OPTIONS = "TuyChon";
hienthi.MAHD = result.Tables[0].Rows[i][3].ToString();
hienthi.Location = vitribandau;
pl_phong.Controls.Add(hienthi);
vitribandau.Y += 220;
}
else
{
if (table.Tables[0].Rows[0][3].ToString() == "Giường Đôi" && table.Tables[0].Rows[0][4].ToString() == "6")
{
giuongdoi6nguoi hienthi = new giuongdoi6nguoi();
hienthi.SDT = sdt;
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.MACHINHANH = table.Tables[0].Rows[0][1].ToString();
hienthi.MAPHONG = table.Tables[0].Rows[0][0].ToString();
hienthi.TENPHONG = table.Tables[0].Rows[0][2].ToString();
hienthi.OPTIONS = "TuyChon";
hienthi.MAHD = result.Tables[0].Rows[i][3].ToString();
hienthi.Location = vitribandau;
pl_phong.Controls.Add(hienthi);
vitribandau.Y += 220;
}
}
}
}
}
}
DemThoiGian.Clear();
}
}
}
}
public bool suaPhong(DTO_Phong p)
{
return(dao_phong.suaPhong(p));
}
public bool xoaPhong(DTO_Phong p)
{
return(dao_phong.xoaPhong(p));
}
public bool xoaPhong(DTO_Phong obj)
{
return(Phong.xoaPhong(obj));
}
public bool themPhong(DTO_Phong p)
{
return(dao_phong.themPhong(p));
}
public bool UpdatePhong(DTO_Phong phong, string tenPhongMoi)
{
return(DALManager.PhongDAL.UpdatePhong(phong, tenPhongMoi));
}
private void BT_Chuyen_Click(object sender, EventArgs e)
{
DTO_CTHD obj_cthd = new DTO_CTHD();
obj_cthd.Macthd = get_MACTHD;
if (dropDown_Phong.selectedIndex != -1)
{
obj_cthd.Sophong = dropDown_Phong.selectedValue;
}
else
{
MessageBox.Show("Chưa chọn phòng chuyển đến", "Erro");
return;
}
if (bus_cthd.Update(obj_cthd) != "0")
{
MessageBox.Show("Chuyển phòng thất bại");
return;
}
List <DTO_LoaiPhong> lsobj_lp = new List <DTO_LoaiPhong>();
List <DTO_Phong> lsobj_p = new List <DTO_Phong>();
string result = bus_p.SelectAll(lsobj_p);
string result1 = bus_lp.SelectAll(lsobj_lp);
var Malp = from x in lsobj_p
join y in lsobj_lp on x.Malp equals y.Malp
where x.Sophong == txb_SoPhong.Text
select new
{
SoPhong = x.Sophong,
TrangThai = "EMPTY",
MaLP = x.Malp,
};
DTO_Phong objp = new DTO_Phong();
foreach (var x in Malp)
{
objp.Sophong = x.SoPhong;
objp.Malp = x.MaLP;
objp.Status = x.TrangThai;
}
bus_p.Update(objp);
var Malp1 = from x in lsobj_p
join y in lsobj_lp on x.Malp equals y.Malp
where x.Sophong == dropDown_Phong.selectedValue
select new
{
SoPhong = x.Sophong,
TrangThai = "USED",
MaLP = x.Malp,
};
DTO_Phong objp1 = new DTO_Phong();
foreach (var x in Malp1)
{
objp1.Sophong = x.SoPhong;
objp1.Malp = x.MaLP;
objp1.Status = x.TrangThai;
}
bus_p.Update(objp1);
MessageBox.Show("Chuyển phòng thành công, từ phòng " + txb_SoPhong.Text + " đến " + dropDown_Phong.selectedValue);
}
private void load()
{
lb_TenChiNhanh.Text = tenchinhanh;
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.MaChiNhanh = machinhanh;
BO_QuanLiChiNhanh yeucau = new BO_QuanLiChiNhanh();
DataSet result = yeucau.HienThiYeuCau(hoadon);
Point vitridau = new Point(20, 20);
if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0)
{
int demyeucau = result.Tables[0].Rows.Count;
for (int i = 0; i < demyeucau; i++)
{
if (i == 5)
{
YeuCau request = new YeuCau();
request.MAPHONG = result.Tables[0].Rows[i][6].ToString();
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = machinhanh;
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = quanli.LayTenPhong(phong);
request.TENPHONG = table.Tables[0].Rows[0][2].ToString();
request.TENCHINHANH = tenchinhanh;
request.MACHINHANH = machinhanh;
request.TENDV = result.Tables[0].Rows[i][0].ToString();
request.SOLUONG = result.Tables[0].Rows[i][1].ToString();
request.TENNV = tennv;
request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString());
request.MAHD = result.Tables[0].Rows[i][3].ToString();
request.MANV = manv;
request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString());
pl_YeuCau.Controls.Add(request);
vitridau.X = 20;
vitridau.Y = 150;
request.Location = vitridau;
vitridau.X += 165;
danhsach.Add(request);
}
else
{
if (i == 10)
{
YeuCau request = new YeuCau();
request.MAPHONG = result.Tables[0].Rows[i][6].ToString();
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = machinhanh;
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = quanli.LayTenPhong(phong);
request.TENPHONG = table.Tables[0].Rows[0][2].ToString();
request.TENCHINHANH = tenchinhanh;
request.MAHD = result.Tables[0].Rows[i][3].ToString();
request.MACHINHANH = machinhanh;
request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString());
request.TENDV = result.Tables[0].Rows[i][0].ToString();
request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString());
request.SOLUONG = result.Tables[0].Rows[i][1].ToString();
request.TENNV = tennv;
request.MANV = manv;
pl_YeuCau.Controls.Add(request);
vitridau.X = 20;
vitridau.Y = 280;
request.Location = vitridau;
vitridau.X += 165;
danhsach.Add(request);
}
else
{
if (i == 15)
{
YeuCau request = new YeuCau();
request.MAPHONG = result.Tables[0].Rows[i][6].ToString();
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = machinhanh;
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = quanli.LayTenPhong(phong);
request.TENPHONG = table.Tables[0].Rows[0][2].ToString();
request.MAHD = result.Tables[0].Rows[i][3].ToString();
request.TENCHINHANH = tenchinhanh;
request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString());
request.MACHINHANH = machinhanh;
request.TENDV = result.Tables[0].Rows[i][0].ToString();
request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString());
request.SOLUONG = result.Tables[0].Rows[i][1].ToString();
request.TENNV = tennv;
request.MANV = manv;
pl_YeuCau.Controls.Add(request);
vitridau.X = 20;
vitridau.Y = 410;
request.Location = vitridau;
vitridau.X += 165;
danhsach.Add(request);
}
else
{
if (i == 20)
{
YeuCau request = new YeuCau();
request.MAPHONG = result.Tables[0].Rows[i][6].ToString();
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = machinhanh;
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = quanli.LayTenPhong(phong);
request.TENPHONG = table.Tables[0].Rows[0][2].ToString();
request.TENCHINHANH = tenchinhanh;
request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString());
request.TENDV = result.Tables[0].Rows[i][0].ToString();
request.MAHD = result.Tables[0].Rows[i][3].ToString();
request.SOLUONG = result.Tables[0].Rows[i][1].ToString();
request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString());
request.MACHINHANH = machinhanh;
request.TENNV = tennv;
request.MANV = manv;
pl_YeuCau.Controls.Add(request);
vitridau.X = 20;
vitridau.Y = 540;
request.Location = vitridau;
vitridau.X += 165;
danhsach.Add(request);
}
else
{
YeuCau request = new YeuCau();
request.MAPHONG = result.Tables[0].Rows[i][6].ToString();
DTO_Phong phong = new DTO_Phong();
phong.MaChiNhanh = machinhanh;
phong.MaPhong = result.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = quanli.LayTenPhong(phong);
request.TENPHONG = table.Tables[0].Rows[0][2].ToString();
request.TENCHINHANH = tenchinhanh;
request.THOIGIAN = DateTime.Parse(result.Tables[0].Rows[i][13].ToString());
request.TENDV = result.Tables[0].Rows[i][0].ToString();
request.MAHD = result.Tables[0].Rows[i][3].ToString();
request.STT = int.Parse(result.Tables[0].Rows[i][4].ToString());
request.SOLUONG = result.Tables[0].Rows[i][1].ToString();
request.MACHINHANH = machinhanh;
request.TENNV = tennv;
request.MANV = manv;
pl_YeuCau.Controls.Add(request);
request.Location = vitridau;
vitridau.X += 165;
danhsach.Add(request);
}
}
}
}
}
}
}
public bool xoaPhong(DTO_Phong phong, string map)
{
return(dalPhong.xoaPhong(phong, map));
}
public bool addPhong(DTO_Phong phong)
{
return(dalPhong.addPhong(phong));
}
public void load()
{
Point vitribandau = new Point(20, 20);
DTO_HoaDon hoadon = new DTO_HoaDon();
hoadon.MaChiNhanh = machinhanh;
BO_QuanLiChiNhanh hienthi = new BO_QuanLiChiNhanh();
DataSet table = new DataSet();
table = hienthi.HienThiPhongChuaDatCoc(hoadon);
if (table.Tables.Count > 0 && table.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < table.Tables[0].Rows.Count; i++)
{
if (i == 5)
{
PhongChuaDatCoc phong = new PhongChuaDatCoc();
phong.MAHD = table.Tables[0].Rows[i][3].ToString();
phong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
DataSet laytenphong = new DataSet();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
laytenphong = hienthi.LayTenPhong(phong1);
phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString();
DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2)));
phong.THOIGIANTHUCHIEN = ngaythuchien;
pl_phong.Controls.Add(phong);
vitribandau.X = 20;
vitribandau.Y = 150;
phong.Location = vitribandau;
vitribandau.Y += 165;
}
else
{
if (i == 10)
{
PhongChuaDatCoc phong = new PhongChuaDatCoc();
phong.MAHD = table.Tables[0].Rows[i][3].ToString();
phong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
DataSet laytenphong = new DataSet();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
laytenphong = hienthi.LayTenPhong(phong1);
phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString();
DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2)));
phong.THOIGIANTHUCHIEN = ngaythuchien;
pl_phong.Controls.Add(phong);
vitribandau.X = 20;
vitribandau.Y = 230;
phong.Location = vitribandau;
vitribandau.Y += 165;
}
else
{
if (i == 15)
{
PhongChuaDatCoc phong = new PhongChuaDatCoc();
phong.MAHD = table.Tables[0].Rows[i][3].ToString();
phong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
DataSet laytenphong = new DataSet();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
laytenphong = hienthi.LayTenPhong(phong1);
phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString();
DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2)));
phong.THOIGIANTHUCHIEN = ngaythuchien;
pl_phong.Controls.Add(phong);
vitribandau.X = 20;
vitribandau.Y = 360;
phong.Location = vitribandau;
vitribandau.Y += 165;
}
else
{
PhongChuaDatCoc phong = new PhongChuaDatCoc();
phong.MAHD = table.Tables[0].Rows[i][3].ToString();
phong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
DataSet laytenphong = new DataSet();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
laytenphong = hienthi.LayTenPhong(phong1);
phong.TENPHONG = laytenphong.Tables[0].Rows[0][2].ToString();
DateTime ngaythuchien = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][13].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][13].ToString().Substring(15, 2)));
phong.THOIGIANTHUCHIEN = ngaythuchien;
pl_phong.Controls.Add(phong);
phong.Location = vitribandau;
vitribandau.Y += 165;
}
}
}
}
}
}
private void load()
{
lbTen.Text = tennv;
lbTenChiNhanh.Text = tenchinhanh;
DTO_HoaDon phong = new DTO_HoaDon();
phong.MaChiNhanh = machinhanh;
BO_QuanLiChiNhanh quanli = new BO_QuanLiChiNhanh();
DataSet table = new DataSet();
table = quanli.HienThiDSPhongDaDatCuaKhachHang(phong);
if (table.Tables.Count > 0 && table.Tables[0].Rows.Count > 0)
{
Point vitridau = new Point(20, 20);
for (int i = 0; i < table.Tables[0].Rows.Count; i++)
{
if (i == 5)
{
PhongCuaKhach dsphong = new PhongCuaKhach();
dsphong.MACHINHANH = machinhanh;
dsphong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli1 = new BO_QuanLiChiNhanh();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
DataSet KQ = quanli1.LayTenPhong(phong1);
dsphong.TENPHONG = KQ.Tables[0].Rows[0][2].ToString();
dsphong.SDT = table.Tables[0].Rows[i][7].ToString();
dsphong.TENCHINHANH = tenchinhanh;
dsphong.TENNV = tennv;
dsphong.MANV = manv;
DateTime ngaydat = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][8].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(15, 2)));
dsphong.NGAYDAT = ngaydat;
dsphong.MAHD = table.Tables[0].Rows[i][3].ToString();
vitridau.X = 20;
vitridau.Y = 150;
dsphong.Location = vitridau;
pl_phong.Controls.Add(dsphong);
vitridau.X += 165;
}
else
{
PhongCuaKhach dsphong = new PhongCuaKhach();
dsphong.MACHINHANH = machinhanh;
dsphong.MAPHONG = table.Tables[0].Rows[i][6].ToString();
BO_QuanLiChiNhanh quanli1 = new BO_QuanLiChiNhanh();
DTO_Phong phong1 = new DTO_Phong();
phong1.MaPhong = table.Tables[0].Rows[i][6].ToString();
phong1.MaChiNhanh = machinhanh;
DataSet KQ = quanli1.LayTenPhong(phong1);
dsphong.TENPHONG = KQ.Tables[0].Rows[0][2].ToString();
dsphong.SDT = table.Tables[0].Rows[i][7].ToString();
dsphong.TENCHINHANH = tenchinhanh;
DateTime ngaydat = new DateTime(int.Parse("20" + table.Tables[0].Rows[i][8].ToString().Substring(6, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(3, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(0, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(9, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(12, 2)), int.Parse(table.Tables[0].Rows[i][8].ToString().Substring(15, 2)));
dsphong.NGAYDAT = ngaydat;
dsphong.TENNV = tennv;
dsphong.MANV = manv;
dsphong.MAHD = table.Tables[0].Rows[i][3].ToString();
dsphong.Location = vitridau;
pl_phong.Controls.Add(dsphong);
vitridau.X += 165;
}
}
}
}
