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