public int SuaThongTinLoaiPhong(LoaiPhongDTO loai)
{
Provider provider = new Provider();
int n = 0;
try
{
provider.Connect();
string sql = "update LOAIPHONG set LOAIPHONG.MaLoaiPhong = @MaLoaiPhong, LOAIPHONG.DonGia = @DonGia, LOAIPHONG.SoLuongPhong = @SoLuongPhong where MaLoaiPhong = @MaLoaiPhong";
n = provider.ExecuteNonQuery(CommandType.Text, sql,
new SqlParameter {
ParameterName = "@DonGia", Value = loai.DonGia
},
new SqlParameter {
ParameterName = "@SoLuongPhong", Value = loai.SoLuong
},
new SqlParameter {
ParameterName = "@MaLoaiPhong", Value = loai.MaLoaiPhong
}
);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
provider.DisConnect();
}
return(n);
}
public static bool SuaLoaiPhong(LoaiPhongDTO lp)
{
try
{
string procname = "SuaLoaiPhong";
conn = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand(procname);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
//Truyền tham số.
cmd.Parameters.Add("@malp", SqlDbType.Char);
cmd.Parameters.Add("@TenLP", SqlDbType.NVarChar);
cmd.Parameters.Add("@MaKS", SqlDbType.Char);
cmd.Parameters.Add("@DonGia", SqlDbType.Float);
cmd.Parameters.Add("@sltrong", SqlDbType.Int);
cmd.Parameters.Add("@mota", SqlDbType.NVarChar);
//Truyền giá trị vào tham số.
cmd.Parameters["@malp"].Value = lp.MaLoaiPhong;
cmd.Parameters["@TenLP"].Value = lp.TenLoaiPhong;
cmd.Parameters["@MaKS"].Value = lp.MaKS;
cmd.Parameters["@DonGia"].Value = lp.DonGia;
cmd.Parameters["@sltrong"].Value = lp.SlTrong;
cmd.Parameters["@mota"].Value = lp.MoTa;
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(conn);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void btnThemLoaiPhong_Click(object sender, EventArgs e)
{
if (kiemtra())
{
lpDTO = new LoaiPhongDTO();
lpDTO.Maloai = txtMaloai.Text;
lpDTO.Gia = decimal.Parse(txtGia.Text);
lpDTO.Songuoi = int.Parse(txtSonguoi.Text);
lpBUS = new LoaiPhongBUS();
if (lpBUS.insertLoaiPhong(lpDTO) == 1)
{
Show_loaiphong();
txtMaloai.Clear();
txtGia.Clear();
txtSonguoi.Clear();
}
else
{
MessageBox.Show("Mã loại phòng đã có!");
txtMaloai.SelectAll();
txtMaloai.Focus();
return;
}
}
}
private void trvPhong_AfterSelect(object sender, TreeViewEventArgs e)
{
lsvPhong.Items.Clear();
string maphong = trvPhong.SelectedNode.Tag.ToString();
PhongDTO p = pBUS.getPhongByID(maphong);
if (p != null)
{
LoaiPhongDTO lp = lpBUS.getLoaiPhongByID(p.Maloai);
IList <ChiTietVatTuDTO> lispctvt = ctvtBUS.getListChiTietVatTuByMaLP(lp.Maloai);
foreach (ChiTietVatTuDTO ctvt in lispctvt)
{
IList <VatTuDTO> listvt = vtBUS.getLikeVatTuByID(ctvt.Mavattu);
foreach (VatTuDTO vt in listvt)
{
int i = lsvPhong.Items.Count;
lsvPhong.Items.Add(p.Maphong);
lsvPhong.Items[i].SubItems.Add(vt.Tenvattu);
lsvPhong.Items[i].SubItems.Add(ctvt.Soluong.ToString());
lsvPhong.Items[i].SubItems.Add(Math.Round(lp.Gia, 0).ToString());
}
}
}
}
public static int KiemTra(LoaiPhongDTO lp)
{
conn = DataProvider.OpenConnection();
string que1 = "select * from LoaiPhong where maLoaiPhong = '" + lp.MaLoaiPhong + "' ";
SqlCommand cmd1 = new SqlCommand(que1, conn);
cmd1.Connection = conn;
cmd1.ExecuteNonQuery();
DataTable dt1 = DataProvider.GetDataTable(que1, conn);
if (dt1.Rows.Count > 0)
{
return(1);
}
string que2 = "select * from KhachSan where maKS = '" + lp.MaKS + "' ";
SqlCommand cmd2 = new SqlCommand(que2, conn);
cmd1.Connection = conn;
cmd1.ExecuteNonQuery();
DataTable dt2 = DataProvider.GetDataTable(que2, conn);
DataProvider.CloseConnection(conn);
if (dt2.Rows.Count == 0)
{
return(2);
}
return(0);
}
public static LoaiPhongDTO LaylPhong(int MLP)
{
OleDbConnection link = null;
LoaiPhongDTO lphg = new LoaiPhongDTO();
try
{
link = KetNoi();
string chuoiLenh = "Select * from LoaiPhong where MaLoaiPhong=@MLP ";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MLP", OleDbType.Integer);
thamso.Value = MLP;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
Doc.Read();
lphg.MaLoaiPhong = Doc.GetInt32(0);
lphg.TenLoaiPhong = Doc.GetString(1);
lphg.DonGia = Doc.GetInt32(2);
lphg.SLKhachToiDa = Doc.GetInt32(3);
lphg.Daxoa = Doc.GetString(4);
}
catch
{
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(lphg);
}
public static List <LoaiPhongDTO> LayDSLoaiPhong()
{
OleDbConnection link = null;
List <LoaiPhongDTO> dsPhong = new List <LoaiPhongDTO>();
try
{
link = KetNoi();
string chuoiLenh = "Select * From LoaiPhong ";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
LoaiPhongDTO lphg = new LoaiPhongDTO();
lphg.MaLoaiPhong = Doc.GetInt32(0);
lphg.TenLoaiPhong = Doc.GetString(1);
lphg.DonGia = Doc.GetInt32(2);
lphg.SLKhachToiDa = Doc.GetInt32(3);
lphg.Daxoa = Doc.GetString(4);
dsPhong.Add(lphg);
}
}
catch (Exception ex)
{
dsPhong = new List <LoaiPhongDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsPhong);
}
public bool XoaLoaiPhong(string Id)
{
LoaiPhongDTO loaiPhong = new LoaiPhongDTO();
loaiPhong.Id = int.Parse(Id);
return(LoaiPhongDAO.Instance.XoaLoaiPhong(loaiPhong));
}
private void show_Phong()
{
lsvPhong.Items.Clear();
tienphong = 0;
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO ptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(ptp.Maphieudat);
ctdpBUS = new ChiTietDatPhongBUS();
IList <ChiTietDatPhongDTO> list = ctdpBUS.getChiTietDatPhongByID(pdp.Maphieudat);
pBUS = new PhongBUS();
lpBUS = new LoaiPhongBUS();
foreach (ChiTietDatPhongDTO ctdp in list)
{
int i = lsvPhong.Items.Count;
PhongDTO p = pBUS.getPhongByID(ctdp.Maphong);
LoaiPhongDTO lp = lpBUS.getLoaiPhongByID(p.Maloai);
lsvPhong.Items.Add(ctdp.Maphong);
lsvPhong.Items[i].SubItems.Add(lp.Gia.ToString("0,0"));
lsvPhong.Items[i].SubItems.Add(pdp.Ngayden.ToShortDateString());
lsvPhong.Items[i].SubItems.Add(pdp.Ngaydi.ToShortDateString());
TimeSpan sno = pdp.Ngaydi.Date.AddDays(1) - pdp.Ngayden.Date;
lsvPhong.Items[i].SubItems.Add(sno.Days.ToString());
decimal tp = lp.Gia * sno.Days;
lsvPhong.Items[i].SubItems.Add(tp.ToString("0,0"));
tienphong += tp;
}
labTP.Text = tienphong.ToString("0,0");
}
public List <LoaiPhongDTO> LayDanhSachLoaiPhongTheoKhachSan(int MaKS)
{
using (SqlConnection con = Connect())
{
con.Open();
string strQuery = string.Format("select maLoaiPhong, tenLoaiPhong, slTrong from LoaiPhong where maKS = {0}", MaKS);
SqlCommand cmd = new SqlCommand(strQuery, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
List <LoaiPhongDTO> DanhSachLoaiPhong = new List <LoaiPhongDTO>();
foreach (DataRow r in dt.Rows)
{
LoaiPhongDTO lp = new LoaiPhongDTO();
lp.MaLoaiPhong = (int)r["maLoaiPhong"];
lp.TenloaiPhong = r["tenLoaiPhong"].ToString();
lp.SlTrong = (int)r["slTrong"];
DanhSachLoaiPhong.Add(lp);
}
con.Close();
return(DanhSachLoaiPhong);
}
}
public bool XoaLoaiPhong(LoaiPhongDTO loaiPhong)
{
//string[] param = { "@ID" };
//object[] values = { loaiPhong.Id };
//string query = "Delete LoaiPhong Where ID=@ID";
//return DataProvider.Instance.ExecuteNonQueryPara(query, param, values);
return(true);
}
public void setUp()
{
phongBUS = new PhongBUS();
phongDTO = new PhongDTO();
phongDAO = new PhongDAO();
loaiPhongBUS = new LoaiPhongBUS();
loaiPhongDTO = new LoaiPhongDTO();
}
public bool ThemLoaiPhong(LoaiPhongDTO loaiPhong)
{
//string[] param = { "@Ten", "@Gia", "@TienPhuThu", "@SoGiuong" };
//object[] values = { loaiPhong.Ten, loaiPhong.Gia, loaiPhong.TienPhuThu, loaiPhong.SoGiuong };
//string query = "Insert Into LoaiPhong Values(@Ten,@Gia,@TienPhuThu,@SoGiuong)";
//return DataProvider.Instance.ExecuteNonQueryPara(query, param, values);
return(true);
}
public bool SuaLoaiPhong(LoaiPhongDTO loaiPhong)
{
//string[] param = { "@ID", "@Ten", "@Gia", "@TienPhuThu", "@SoGiuong" };
//object[] values = { loaiPhong.Id, loaiPhong.Ten, loaiPhong.Gia, loaiPhong.TienPhuThu, loaiPhong.SoGiuong };
//string query = "Update LoaiPhong Set Ten=@Ten, Gia=@Gia, TienPhuThu=@TienPhuThu, SoGiuong=@SoGiuong Where ID=@ID";
//return DataProvider.Instance.ExecuteNonQueryPara(query, param, values);
return(true);
}
private void btn_lamMoi_Click(object sender, EventArgs e)
{
if (trThai != 2)
{
loaiPhong = null;
Bind();
}
}
//Sửa loại phòng
public void updateLoaiPhong(LoaiPhongDTO lpDTO)
{
var querry = (from lp in htDataContext.loaiphongs
where lp.maloai == lpDTO.Maloai
select lp).FirstOrDefault <loaiphong>();
querry.gia = (decimal)lpDTO.Gia;
querry.songuoi = (int)lpDTO.Songuoi;
htDataContext.SubmitChanges();
}
/*//Lấy danh sách gần đúng tất cả các loại phòng có tên được nhập vào
* public IList<LoaiPhongDTO> getListLikeLoaiPhongByName(string name)
* {
* var querry = (from lp in htDataContext.LoaiPhongs
* where SqlMethods.Like(lp.tenLoaiPhong, "%" + name + "%")
* select new LoaiPhongDTO
* {
* MaLoaiPhong = lp.maLoaiPhong,
* TenLoaiPhong = lp.tenLoaiPhong,
* Phai = (Boolean)lp.phai,
* Ngaysinh = (DateTime)lp.ngaysinh,
* Phone = lp.phone,
* Diachi = lp.diachi,
* Chucvu = lp.chucvu,
* }).Distinct<LoaiPhongDTO>();
* if (querry.Count() == 0)
* {
* return null;
* }
* else
* {
* return querry.ToList<LoaiPhongDTO>();
* }
* }*/
//Thêm loại phòng
public void insertLoaiPhong(LoaiPhongDTO lpDTO)
{
loaiphong lp = new loaiphong();
lp.maloai = lpDTO.Maloai;
lp.gia = (decimal)lpDTO.Gia;
lp.songuoi = (int)lpDTO.Songuoi;
htDataContext.loaiphongs.InsertOnSubmit(lp);
htDataContext.SubmitChanges();
}
public static List <PhieuThueDTO> layDSPT()
{
OleDbConnection link = null;
List <PhieuThueDTO> dsPhieu = new List <PhieuThueDTO>();
try
{
link = KetNoi();
string chuoiLenh = "select * from PhieuThue,Phong,LoaiPhong where PhieuThue.MaPhong=Phong.MaPhong and Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
PhieuThueDTO phieu = new PhieuThueDTO();
phieu.MaPhieuThue = Doc.GetString(0);
phieu.NgayThue = Doc.GetDateTime(2);
phieu.TienDV = Doc.GetInt32(3);
phieu.DaThanhToan = Doc.GetString(4);
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(5);
phg.TenPhong = Doc.GetString(6);
phg.GhiChu = Doc.GetString(8);
phg.TinhTrang = Doc.GetString(9);
phg.SLKhach = Doc.GetInt32(10);
LoaiPhongDTO loai = new LoaiPhongDTO();
loai.MaLoaiPhong = Doc.GetInt32(11);
loai.TenLoaiPhong = Doc.GetString(12);
loai.DonGia = Doc.GetInt32(13);
loai.SLKhachToiDa = Doc.GetInt32(14);
phg.LoaiPhong = loai;
phieu.Phong = phg;
dsPhieu.Add(phieu);
}
for (int i = 0; i < dsPhieu.Count; i++)
{
List <KhachHangDTO> dskh = new List <KhachHangDTO>();
dskh = PhieuThueDAO.NhapDSKhach(dsPhieu[i].MaPhieuThue);
dsPhieu[i].DsKH = dskh;
}
}
catch (Exception ex)
{
dsPhieu = new List <PhieuThueDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsPhieu);
}
public List <LoaiPhongDTO> SearchLP(string str)
{
List <LoaiPhongDTO> LpList = new List <LoaiPhongDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC SP_LOAIPHONG_TIMKIEM @SEARCHVALUE ", new object[] { str });
foreach (DataRow item in data.Rows)
{
LoaiPhongDTO LoaiPhong = new LoaiPhongDTO(item);
LpList.Add(LoaiPhong);
}
return(LpList);
}
public int updateLoaiPhong(LoaiPhongDTO lpDTO)
{
try
{
lpDAO.updateLoaiPhong(lpDTO);
return(1);
}
catch
{
return(0);
}
}
public static bool XoaLoaiPhong(LoaiPhongDTO loaiPhongDTO)
{
try
{
DAL.DataProvider.ExecuseNonQuery("DELETE FROM quanlykaraoke.loaiphong WHERE quanlykaraoke.loaiphong.MaLP = '" + loaiPhongDTO.MaLoaiPhong + "';");
return(true);
}
catch (Exception e)
{
return(false);
}
}
public List <LoaiPhongDTO> GetLP()
{
List <LoaiPhongDTO> list = new List <LoaiPhongDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("dbo.SP_LOAIPHONG_GETALL");
foreach (DataRow item in data.Rows)
{
LoaiPhongDTO lp = new LoaiPhongDTO(item);
list.Add(lp);
}
return(list);
}
public static List <PhongDTO> LayDSPhong()
{
OleDbConnection link = null;
List <PhongDTO> dsPhong = new List <PhongDTO>();
try
{
link = KetNoi();
string chuoiLenh = "Select MaPhong,TenPhong,Phong.MaLoaiPhong,TenLoaiPhong,SLKhachToiDa,DonGia,GhiChu,TinhTrang,SLKhach from Phong , LoaiPhong Where Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong order by MaPhong";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(0);
phg.TenPhong = Doc.GetString(1);
LoaiPhongDTO Loai = new LoaiPhongDTO();
Loai.MaLoaiPhong = Doc.GetInt32(2);
Loai.TenLoaiPhong = Doc.GetString(3);
Loai.SLKhachToiDa = Doc.GetInt32(4);
Loai.DonGia = Doc.GetInt32(5);
phg.LoaiPhong = Loai;
if (!Doc.IsDBNull(7))
{
phg.TinhTrang = Doc.GetString(7);
}
if (!Doc.IsDBNull(6))
{
phg.GhiChu = Doc.GetString(6);
}
if (!Doc.IsDBNull(8))
{
phg.SLKhach = Doc.GetInt32(8);
}
dsPhong.Add(phg);
}
}
catch (Exception ex)
{
dsPhong = new List <PhongDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsPhong);
}
public static PhieuThueDTO layPT(string MPT)
{
OleDbConnection link = null;
PhieuThueDTO Phieu = new PhieuThueDTO();
try
{
link = KetNoi();
string chuoiLenh = "select * from PhieuThue,Phong,LoaiPhong where PhieuThue.MaPhong=Phong.MaPhong and Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong and MaPhieuThue=@MPT";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MPT", OleDbType.LongVarChar);
thamso.Value = MPT;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
Doc.Read();
Phieu.MaPhieuThue = Doc.GetString(0);
Phieu.NgayThue = Doc.GetDateTime(2);
Phieu.TienDV = Doc.GetInt32(3);
Phieu.DaThanhToan = Doc.GetString(4);
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(5);
phg.TenPhong = Doc.GetString(6);
phg.GhiChu = Doc.GetString(8);
phg.TinhTrang = Doc.GetString(9);
phg.SLKhach = Doc.GetInt32(10);
LoaiPhongDTO loai = new LoaiPhongDTO();
loai.MaLoaiPhong = Doc.GetInt32(11);
loai.TenLoaiPhong = Doc.GetString(12);
loai.DonGia = Doc.GetInt32(13);
loai.SLKhachToiDa = Doc.GetInt32(14);
phg.LoaiPhong = loai;
Phieu.Phong = phg;
List <KhachHangDTO> dskh = new List <KhachHangDTO>();
dskh = PhieuThueDAO.NhapDSKhach(Phieu.MaPhieuThue);
Phieu.DsKH = dskh;
}
catch (Exception ex)
{
Phieu = new PhieuThueDTO();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(Phieu);
}
public DataTable ConvertLoaiPhongDTOToDataTable(LoaiPhongDTO[] lpDTOArr)
{
DataTable dt = new DataTable();
int row = lpDTOArr.Length;
dt.Columns.Add("MaLoaiPhong", typeof(string));
dt.Columns.Add("TenLoaiPhong", typeof(string));
dt.Columns.Add("DonGia", typeof(int));
for (int i = 0; i < row; i++)
{
dt.Rows.Add(lpDTOArr[i].MaLoaiPhong, lpDTOArr[i].TenLoaiPhong, lpDTOArr[i].DonGia);
}
return dt;
}
public int insertLoaiPhong(LoaiPhongDTO lpDTO)
{
try
{
lpDAO.insertLoaiPhong(lpDTO);
return(1);
}
catch
{
return(0);
//throw new Exception("Không thêm được dữ liệu!");
}
}
//Show tất cả các phòng lên listview ở tabphong
public void Show_phong()
{
lsvPhong.Items.Clear();
IList <PhongDTO> listPDTO = phong.getListPhongAll();
foreach (PhongDTO p in listPDTO)
{
int i = lsvPhong.Items.Count;
lsvPhong.Items.Add(p.Maphong);
LoaiPhongDTO lpdto = lphong.getLoaiPhongByID(p.Maloai);
lsvPhong.Items[i].SubItems.Add(lpdto.Maloai);
lsvPhong.Items[i].SubItems.Add(lpdto.Songuoi.ToString());
lsvPhong.Items[i].SubItems.Add(lpdto.Gia.ToString("0,0"));
}
}
public static Dictionary <string, DonGiaTheoNgay> LayDonGia(LoaiPhongDTO loaiPhongDTO)
{
DataTable dt = DataProvider.ExecuseQuery("SELECT * FROM quanlykaraoke.dongia_loaiphong WHERE quanlykaraoke.dongia_loaiphong.MaLoaiPhong = '" + loaiPhongDTO.MaLoaiPhong + "'");
Dictionary <string, DonGiaTheoNgay> res = new Dictionary <string, DonGiaTheoNgay>();
foreach (DataRow row in dt.Rows)
{
if (!res.Keys.Contains(row["Thu"]))
{
res.Add(row["Thu"].ToString(), new DonGiaTheoNgay(row["Thu"].ToString()));
}
res[row["Thu"].ToString()].listDonGiaTheoKhoangThoiGian.Add(new DonGiaTheoKhoangThoiGian(new ThongTinThanhToanTheoNgay.Gio((TimeSpan)row["GioBatDau"]), new ThongTinThanhToanTheoNgay.Gio((TimeSpan)row["GioKetThuc"]), (double)row["DonGia"]));
}
return(res);
}
private void dgv_loaiphong_SelectionChanged(object sender, EventArgs e)
{
if (dgv_loaiphong.SelectedRows.Count > 0)
{
trThai = 1;
TrangThai();
btn_capNhat.Enabled = true;
loaiPhong = (LoaiPhongDTO)dgv_loaiphong.SelectedRows[0].DataBoundItem; // dgvSinhVien.CurrentRow
}
else
{
btn_capNhat.Enabled = false;
loaiPhong = null;
}
Bind();
}
public static PhongDTO LayPhong(string MP)
{
OleDbConnection link = null;
PhongDTO phg = new PhongDTO();
try
{
link = KetNoi();
string chuoiLenh = "Select * from Phong , LoaiPhong Where Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong and MaPhong=@MP";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamSo = new OleDbParameter("@MP", OleDbType.LongVarChar);
thamSo.Value = MP;
lenh.Parameters.Add(thamSo);
OleDbDataReader Doc = lenh.ExecuteReader();
if (Doc.Read())
{
phg.MaPhong = Doc.GetString(0);
phg.TenPhong = Doc.GetString(1);
LoaiPhongDTO loai = new LoaiPhongDTO();
loai.MaLoaiPhong = Doc.GetInt32(2);
loai.TenLoaiPhong = Doc.GetString(7);
loai.DonGia = Doc.GetInt32(8);
loai.SLKhachToiDa = Doc.GetInt32(9);
phg.LoaiPhong = loai;
phg.GhiChu = Doc.GetString(3);
phg.TinhTrang = Doc.GetString(4);
phg.SLKhach = Doc.GetInt32(5);
}
else
{
phg.GhiChu = "Phong khong ton tai";
}
}
catch (Exception ex)
{
phg = new PhongDTO();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(phg);
}
public bool ThemLoaiPhong(string TenLoaiPhong, string SoGiuong, string Gia, string TienPhuThu)
{
LoaiPhongDTO loaiPhong = new LoaiPhongDTO();
try
{
loaiPhong.Ten = TenLoaiPhong;
loaiPhong.SoGiuong = int.Parse(SoGiuong);
loaiPhong.Gia = int.Parse(Gia);
loaiPhong.TienPhuThu = int.Parse(TienPhuThu);
}
catch (Exception)
{
return(false);
}
return(LoaiPhongDAO.Instance.ThemLoaiPhong(loaiPhong));
}
private void btnThemLoaiPhong_Click(object sender, EventArgs e)
{
if (kiemtra())
{
lpDTO = new LoaiPhongDTO();
lpDTO.Maloai = txtMaloai.Text;
lpDTO.Gia = decimal.Parse(txtGia.Text);
lpDTO.Songuoi = int.Parse(txtSonguoi.Text);
if (lphong.insertLoaiPhong(lpDTO)==1)
{
Show_loaiphong();
txtMaloai.Clear();
txtGia.Clear();
txtSonguoi.Clear();
}
else
{
MessageBox.Show("Mã loại phòng đã có!");
txtMaloai.SelectAll();
txtMaloai.Focus();
return;
}
}
}
private void btnSuaLoaiPhong_Click(object sender, EventArgs e)
{
if (lsvLoaiPhong.SelectedItems.Count <= 0)
return;
if (gia() && songuoi())
{
lpDTO = new LoaiPhongDTO();
lpDTO.Maloai = lsvLoaiPhong.SelectedItems[0].SubItems[0].Text;
lpDTO.Gia =decimal.Parse( txtGia.Text);
lpDTO.Songuoi = int.Parse(txtSonguoi.Text);
lphong.updateLoaiPhong(lpDTO);
Show_loaiphong();
txtMaloai.Clear();
txtGia.Clear();
txtSonguoi.Clear();
}
}
public int update(LoaiPhongDTO dtoLP)
{
return ws.UpdateLoaiPhong(dtoLP);
}
public int KiemTra_MaLP(LoaiPhongDTO dtoLP)
{
return ws.KiemTra_MaLP(dtoLP);
}
public int insertLoaiPhong(LoaiPhongDTO dtoLP)
{
return ws.insertLoaiPhong(dtoLP);
}
