示例#1
0
        private void showInforCus()
        {
            htEntities context = new htEntities();

            ObjectParameter MaKH   = new ObjectParameter("MaKH", typeof(string));
            ObjectParameter tenkh  = new ObjectParameter("tenkh", typeof(string));
            ObjectParameter soCMND = new ObjectParameter("soCMND", typeof(string));
            ObjectParameter diachi = new ObjectParameter("diachi", typeof(string));
            ObjectParameter sdt    = new ObjectParameter("sdt", typeof(string));
            ObjectParameter tennv  = new ObjectParameter("tennv", typeof(string));

            context.getCusFrPhieuThue3(textBoxMaPhieuThue.Text, MaKH, tenkh, soCMND, diachi, sdt, tennv);

            labelmaKH.Text   = MaKH.Value.ToString();
            labeltenKH.Text  = tenkh.Value.ToString();
            labelsoCMND.Text = soCMND.Value.ToString();
            labelDiaChi.Text = diachi.Value.ToString();
            labelSDT.Text    = sdt.Value.ToString();

            labelnvLap.Text = tennv.Value.ToString();
            if (labelnvLap.Text == "")
            {
                labelnvLap.Text = "Nhân viên đã nghỉ";
            }
        }
示例#2
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            Encrypt         enc     = new Encrypt();
            htEntities      context = new htEntities();
            List <NhanVien> list    = getPass();

            username = textBoxUserName.Text;
            password = enc.MaHoa(textBoxPassWord.Text);

            var check = list.Where(item => item.TenTk != null && item.TenTk.Equals(username)).ToList();

            if (check.Count > 0)
            {
                if (check[0].MatKhau.Equals(password))
                {
                    MessageBox.Show("Đăng nhập thành công");
                    this.Close();
                    th = new Thread(openMainForm);
                    th.SetApartmentState(ApartmentState.STA);
                    th.Start();
                }
                else
                {
                    MessageBox.Show("Mật khẩu không chính xác");
                }
            }
            else
            {
                MessageBox.Show("Không tồn tại tài khoản này");
            }
        }
示例#3
0
 private void MainForm_Load(object sender, EventArgs e)
 {
     using (htEntities context = new htEntities())
     {
         string tenNV = context.wellCome(LoginForm.username, LoginForm.password).FirstOrDefault();
         labelWellCome.Text = "Xin chào,\n" + tenNV;
     }
 }
示例#4
0
        private void showtienDvDetail(DataGridView dgv)
        {
            htEntities context = new htEntities();

            dgv.DataSource          = context.tienDvDetail(textBoxMaPhieuThue.Text);
            dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            dgv.AutoSizeRowsMode    = DataGridViewAutoSizeRowsMode.AllCells;
        }
示例#5
0
        private void showListBill(DataGridView dgv)
        {
            htEntities context = new htEntities();

            dgv.DataSource          = context.getlistBill();
            dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            dgv.AutoSizeRowsMode    = DataGridViewAutoSizeRowsMode.AllCells;
        }
示例#6
0
        void showTienTheoPhong(DataGridView dgv1, DataGridView dgv2)
        {
            htEntities context = new htEntities();

            dgv1.DataSource          = context.ViewTienPhong(dtpNgayVao.Value, dtpNgaydi.Value);
            dgv2.DataSource          = context.ViewTienDV(dtpNgayVao.Value, dtpNgaydi.Value);
            dgv2.AutoSizeColumnsMode = dgv1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            dgv2.AutoSizeRowsMode    = dgv1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
        }
示例#7
0
 private void MainForm_Load(object sender, EventArgs e)
 {
     using (htEntities context = new htEntities())
     {
         string tenNV = context.wellCome(LoginForm.username, LoginForm.password).FirstOrDefault();
         labelWellCome.Text = "Xin chào,\n" + tenNV;
         quyen = Convert.ToByte(context.getPermission(LoginForm.username, LoginForm.password).FirstOrDefault());
         if (quyen == 0)
         {
             btnNhanVien.Visible = btnNguoiDung.Visible = btnPhong.Visible = btnLoaiPhong.Visible = bntDichVu.Visible = btnLoaiDV.Visible = false;
             panelQuanLy.Size    = new System.Drawing.Size(183, 40);
         }
     }
 }
示例#8
0
        private void btnThanhToan_Click(object sender, EventArgs e)
        {
            string maphieuthue = "";

            for (int i = 0; i < dgvListBill.Rows.Count; i++)
            {
                maphieuthue = dgvListBill.Rows[i].Cells[7].Value.ToString();
            }

            htEntities context = new htEntities();

            if (btncreateBill.Text == "Tạo Hóa Đơn")
            {
                if (textBoxMaPhieuThue.Text != maphieuthue)
                {
                    context.creatBill(labelIdHD.Text, Convert.ToInt32(labelTP.Text), Convert.ToInt32(labelTDV.Text), Convert.ToInt32(labeltongT.Text), dateTimePickerNgayTT.Value, textBoxghiChu.Text, textBoxMaPhieuThue.Text, labelMaHTTT.Text);
                    try
                    {
                        DialogResult result = MessageBox.Show("Tạo hóa đơn thành công, bạn có muốn in hóa đơn hay không?", "Thông báo", MessageBoxButtons.YesNo);
                        if (result == DialogResult.Yes)
                        {
                            passData();
                            showTableinReport();
                            showListBill(dgvListBill);
                            //ExportBill asd = new ExportBill();
                            //asd.Show();
                        }
                        else if (result == DialogResult.No)
                        {
                        }
                        comboBoxHTTT.Text = "";
                        //btncreateBill.Enabled = false;
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
                else
                {
                    MessageBox.Show("phiếu thuê phòng này đã được tạo hóa đơn!!!");
                }
            }
            else if (btncreateBill.Text == "In Hóa Đơn")
            {
                passData();
                showTableinReport();
            }
        }
示例#9
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            htEntities context = new htEntities();

            if (textBoxMaPhong.Text != "Nhập mã phòng")
            {
                textBoxMaPhieuThue.Text = context.getIdPTFromMaPhong(textBoxMaPhong.Text).FirstOrDefault().ToString();
                btncreateBill.Text      = "Tạo Hóa Đơn";
            }
            else
            {
                MessageBox.Show("Bạn chưa nhập mã phòng");
            }
            implementID();
        }
示例#10
0
        private void btnThanhToan_Click(object sender, EventArgs e)
        {
            htEntities context = new htEntities();

            if (btncreateBill.Text == "Tạo Hóa Đơn")
            {
                if (comboBoxHTTT.Text == "Thẻ")
                {
                    comboBoxHTTT.Text = "True";
                }
                else
                {
                    comboBoxHTTT.Text = "False";
                }
                context.creatBill(labelIdHD.Text, Convert.ToInt32(labelTP.Text), Convert.ToInt32(labelTDV.Text), Convert.ToInt32(labeltongT.Text), Convert.ToBoolean(comboBoxHTTT.Text), dateTimePickerNgayTT.Value, textBoxghiChu.Text, textBoxMaPhieuThue.Text);
                try
                {
                    DialogResult result = MessageBox.Show("Tạo hóa đơn thành công, bạn có muốn in hóa đơn hay không?", "Thông báo", MessageBoxButtons.YesNo);
                    if (result == DialogResult.Yes)
                    {
                        passData();
                        showTableinReport();
                        //ExportBill asd = new ExportBill();
                        //asd.Show();
                    }
                    else if (result == DialogResult.No)
                    {
                    }
                    comboBoxHTTT.Text = "";
                    //btncreateBill.Enabled = false;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else if (btncreateBill.Text == "In Hóa Đơn")
            {
                passData();
                showTableinReport();
            }
        }
示例#11
0
        private void btntiep_Click(object sender, EventArgs e)
        {
            status = true;
            htEntities context = new htEntities();

            context.addPhieuThuePhong(lableIdPT.Text, textBoxNote.Text, comboBoxMKH.Text, textBoxMaNV.Text);
            try
            {
                DialogResult result = MessageBox.Show("Thêm phiếu thuê phòng thành công !!! Bạn có muốn thêm phòng cho khách hàng luôn?", "Thông báo", MessageBoxButtons.YesNo);
                context.SaveChanges();
                if (result == DialogResult.Yes)
                {
                    openChildForm(new ChiTietDatPhongForm());
                }
                else
                {
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
示例#12
0
 private void btnSave_Click(object sender, EventArgs e)
 {
     using (htEntities context = new htEntities())
     {
         if (textBoxMkCu.Text == LoginForm.password && textBoxMkMoi.Text == textBoxMkMoiR.Text)
         {
             string idEmp = context.getIdNV(LoginForm.username, LoginForm.password).FirstOrDefault();
             context.changePass(textBoxMkMoi.Text, idEmp);
             try
             {
                 MessageBox.Show("doi mk thanh cong");
                 context.SaveChanges();
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }
             textBoxMkCu.Text = textBoxMkMoi.Text = textBoxMkMoiR.Text = "";
         }
         else if (textBoxMkCu.Text == "")
         {
             MessageBox.Show("vui long nhap mk cu");
         }
         else if (textBoxMkMoi.Text == "")
         {
             MessageBox.Show("vui long nhap mk moi");
         }
         else if (textBoxMkMoi.Text != textBoxMkMoiR.Text)
         {
             MessageBox.Show("mk khong khop");
         }
         else
         {
             MessageBox.Show("mk cu khong chinh xac");
         }
     }
 }
示例#13
0
        //private void FillComboboxMPT()
        //{
        //    htEntities context = new htEntities();
        //    var getIdMptList = from PhieuThuePhong in context.PhieuThuePhongs
        //                       select PhieuThuePhong;
        //    comboBoxMaPT.DataSource = getIdMptList.ToList();
        //    comboBoxMaPT.DisplayMember = "MaPhieuThuePhong";
        //comboBoxMaPT.ValueMember = "MaSD";
        //    comboBoxMaPT.Items.Add("select one");
        //    foreach (var item in getIdMptList)
        //    {
        //        comboBoxMaPT.Items.Add(Contains(item));
        //    }
        //}
        //}

        private void FillComboboxHTTT()
        {
            htEntities context = new htEntities();

            comboBoxHTTT.DataSource = context.getHTTT();
        }
示例#14
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            htEntities context = new htEntities();

            textBoxMaPhieuThue.Text = context.getIdPTFromMaPhong(textBoxMaPhong.Text).FirstOrDefault().ToString();
        }
示例#15
0
        public List <NhanVien> getPass()
        {
            htEntities context = new htEntities();

            return(context.NhanViens.ToList());
        }
        private void comboBoxPhongsdDV_TextChanged(object sender, EventArgs e)
        {
            htEntities DVRoom = new htEntities();

            lableIdCTPT.Text = DVRoom.TKidCTPTofRoom(comboBoxPhongsdDV.Text).FirstOrDefault().ToString();
        }
示例#17
0
        private void textBoxMaPhieuThue_TextChanged(object sender, EventArgs e)
        {
            showtienphongDetail(dgvTienPhongDetail);
            showtienDvDetail(dgvTienDvDetail);
            showTien();
            htEntities context = new htEntities();

            //string mpt = Convert.ToString(comboBoxMaPT.Text);
            //var result = context.KhachHangs.Select(p => p.MaKH).FirstOrDefault();
            //labelmaKH.Text = result;
            var result = from c in context.PhieuThuePhongs
                         where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                         select c.MaKH;
            var result1 = from c in context.PhieuThuePhongs
                          where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                          select new { c.NhanVien.HoTen };
            var result2 = from c in context.PhieuThuePhongs
                          where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                          select new { c.KhachHang.TenKH };
            var result3 = from c in context.PhieuThuePhongs
                          where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                          select new { c.KhachHang.SoCMND };
            var result4 = from c in context.PhieuThuePhongs
                          where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                          select new { c.KhachHang.DiaChi };
            var result5 = from c in context.PhieuThuePhongs
                          where c.MaPhieuThuePhong == textBoxMaPhieuThue.Text
                          select new { c.KhachHang.SDT };

            labelmaKH.Text = result.FirstOrDefault();

            string nvlap  = result1.FirstOrDefault().ToString();
            string nvlap2 = nvlap.Substring(10);

            string[] arr = nvlap2.Split(new char[] { '}' });
            labelnvLap.Text = arr[0];

            string tenkh  = result2.FirstOrDefault().ToString();
            string tenkh2 = tenkh.Substring(10);

            string[] arr2 = tenkh2.Split(new char[] { '}' });
            labeltenKH.Text = arr2[0];

            string soCM  = result3.FirstOrDefault().ToString();
            string soCM2 = soCM.Substring(11);

            string[] arr3 = soCM2.Split(new char[] { '}' });
            labelsoCMND.Text = arr3[0];

            string dc  = result4.FirstOrDefault().ToString();
            string dc2 = dc.Substring(11);

            string[] arr4 = dc2.Split(new char[] { '}' });
            labelDiaChi.Text = arr4[0];

            string sdt  = result5.FirstOrDefault().ToString();
            string sdt2 = sdt.Substring(8);

            string[] arr5 = sdt2.Split(new char[] { '}' });
            labelSDT.Text = arr5[0];
        }