public static List <BanDatDTO> LayDanhSachBanDat()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachBanDat";

            DataTable        dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <BanDatDTO> list = new List <BanDatDTO>();

            if (dt != null)
            {
                int maThongTinKhachHang;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    BanDatDTO banDat = new BanDatDTO();
                    banDat.MaLichBan  = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString());
                    banDat.MaBan      = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
                    banDat.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString());
                    banDat.MaBuoi     = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString());
                    if (Int32.TryParse(dt.Rows[i]["MaThongTinKhachHang"].ToString(), out maThongTinKhachHang))
                    {
                        banDat.MaThongTinKhachHang = maThongTinKhachHang;
                    }
                    banDat.SoLuong      = Int32.Parse(dt.Rows[i]["SoLuong"].ToString());
                    banDat.TinhTrangBan = Boolean.Parse(dt.Rows[i]["TinhTrangBan"].ToString());

                    list.Add(banDat);
                }
            }
            return(list);
        }
        public static List <ThongTinBanDTO> LayDanhSachThongTinBan(int maKhuVuc)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachThongTinBan";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaKhuVuc";
            if (maKhuVuc == 0)
            {
                param.Value = DBNull.Value;
            }
            else
            {
                param.Value = maKhuVuc;
            }
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);
            DataTable             dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <ThongTinBanDTO> list = new List <ThongTinBanDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ThongTinBanDTO thongTinBan = new ThongTinBanDTO();
                    thongTinBan.MaBan    = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
                    thongTinBan.MaKhuVuc = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString());
                    thongTinBan.TenBan   = dt.Rows[i]["TenBan"].ToString();
                    thongTinBan.SucChua  = Int32.Parse(dt.Rows[i]["SucChua"].ToString());
                    list.Add(thongTinBan);
                }
            }
            return(list);
        }
예제 #3
0
        public static ArrayList layDanhSachMonAnTheoPhanLoaiMonAn(LoaiMonAnDTO loaiMonAn, int maNhaHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachMonAnTheoPhanLoaiMonAn";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@MaLoaiMonAn";
            param.Value         = loaiMonAn.MaLoaiMonAn;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    PhanLoaiMonAnDTO plMA = new PhanLoaiMonAnDTO();
                    plMA.LoaiMonAn.MaLoaiMonAn = Convert.ToInt32(dt.Rows[i]["MaLoaiMonAn"]);
                    plMA.MonAn.MaMonAn         = Convert.ToInt32(dt.Rows[i]["MaMonAn"]);
                    plMA.MonAn.TenMonAn        = dt.Rows[i]["TenMonAn"].ToString();
                    plMA.NhaHang.MaNhaHang     = maNhaHang;
                    list.Add(plMA);
                }
            }
            return(list);
        }
        public static DataTable ThongTinKhachVaBanDat()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.ThongTinKhachVaBanDat";

            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);

            //List<BanDatDTO> list = new List<BanDatDTO>();
            //if (dt != null)
            //{
            //    for (int i = 0; i < dt.Rows.Count; i++)
            //    {
            //        BanDatDTO bd = new BanDatDTO();
            //        //bd.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
            //        bd.HoTen = dt.Rows[i]["HoTen"].ToString();
            //        bd.Cmnd = dt.Rows[i]["CMND"].ToString();
            //        bd.DienThoai = dt.Rows[i]["DienThoai"].ToString();
            //        bd.MaBan = Int32.Parse(dt.Rows[i]["MaBan"].ToString());
            //        bd.NgayDatBan = DateTime.Parse(dt.Rows[i]["NgayDatBan"].ToString());
            //        bd.MaBuoi = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString());
            //        bd.SoLuong = Int32.Parse(dt.Rows[i]["SoLuong"].ToString());
            //        bd.MaThongTinKhachHang = Int32.Parse(dt.Rows[i]["MaThongTinKhachHang"].ToString());
            //        bd.MaLichBan = Int32.Parse(dt.Rows[i]["MaLichBan"].ToString());
            //        list.Add(bd);
            //    }

            //}
            if (dt == null)
            {
                dt = new DataTable();
            }
            return(dt);
        }
예제 #5
0
        // cấp phát
        public static DataTable LayBangNguoiDung()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayTaiKhoan";
            return(DataAccessCode.ExecuteSelectCommand(command));
        }
        public static KhoHang_NguyenLieuDTO layChiTietKhoHangNguyenLieu(int maNhaHang, NguyenLieuDTO nguyenLieuCanTim)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.layChiTietKhoHangNguyenLieu";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaNguyenLieu";
            param.Value         = nguyenLieuCanTim.MaNguyenLieu;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@MaNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            DataTable             dt  = DataAccessCode.ExecuteSelectCommand(command);
            KhoHang_NguyenLieuDTO dto = new KhoHang_NguyenLieuDTO();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    dto.NguyenLieu.MaNguyenLieu  = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]);
                    dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString();
                    dto.NguyenLieu.DonViTinh     = dt.Rows[i]["DonViTinh"].ToString();
                    dto.SoLuongTon     = Convert.ToInt32(dt.Rows[i]["SoLuongTon"]);
                    dto.SucChua        = Convert.ToInt32(dt.Rows[i]["SucChua"]);
                    dto.MucTonToiThieu = Convert.ToInt32(dt.Rows[i]["MucChuaToiThieu"]);
                }
            }
            return(dto);
        }
        public static ArrayList traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(string sqlFROM)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@sqlFROM";
            param.Value         = sqlFROM;
            param.DbType        = DbType.String;
            command.Parameters.Add(param);

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    NhaCungCapDTO dto = new NhaCungCapDTO();
                    dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
                    dto.SoLuongNguyenLieuToiDaPhuHopYeuCauDatHang = Convert.ToInt32(dt.Rows[i]["SoLuongNguyenLieuDapUng"]);
                    dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
                    list.Add(dto);
                }
            }
            return(list);
        }
        public static DataTable LayBangNhaHang()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachNhaHang";
            return(DataAccessCode.ExecuteSelectCommand(command));
        }
        public static List <KhuVucDTO> LayDanhSachKhuVuc(int maNhaHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachKhuVuc";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaNhaHang";
            if (maNhaHang == 0)
            {
                param.Value = DBNull.Value;
            }
            else
            {
                param.Value = maNhaHang;
            }
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);
            DataTable        dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <KhuVucDTO> list = new List <KhuVucDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    KhuVucDTO khuVuc = new KhuVucDTO();
                    khuVuc.MaKhuVuc  = Int32.Parse(dt.Rows[i]["MaKhuVuc"].ToString());
                    khuVuc.TenKhuVuc = dt.Rows[i]["TenKhuVuc"].ToString();
                    khuVuc.GiaBan    = Decimal.Parse(dt.Rows[i]["GiaBan"].ToString());
                    list.Add(khuVuc);
                }
            }
            return(list);
        }
        internal static List <LichLamViecDTO> LoadLichLamViec()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachLichLamViec";

            DataTable             dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <LichLamViecDTO> list = new List <LichLamViecDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    LichLamViecDTO lich = new LichLamViecDTO();
                    lich.MaNhanVien  = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
                    lich.HoNhanVien  = dt.Rows[i]["HoNhanVien"].ToString();
                    lich.TenNhanVien = dt.Rows[i]["TenNhanVien"].ToString();
                    lich.Thu         = Int32.Parse(dt.Rows[i]["Thu"].ToString());
                    lich.Ca          = Int32.Parse(dt.Rows[i]["Ca"].ToString());

                    list.Add(lich);
                }
            }
            return(list);
        }
예제 #11
0
        public static int layMaThongTinHangNhap(DateTime ngayGioNhap, int maKhoHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.layIDThongTinHangNhap";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@ngayGioNhap";
            param.Value         = ngayGioNhap;
            param.DbType        = DbType.DateTime;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@maKhoHang";
            param.Value         = maKhoHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);


            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
            int       id = -1;

            if (dt != null)
            {
                id = Convert.ToInt32(dt.Rows[0]["MaThongTinHangNhap"]);
            }
            return(id);
        }
예제 #12
0
        private void button1_Click(object sender, EventArgs e)
        {
            RestaurantConfiguration.command = DataAccessCode.CreateCommand();
            if (isDirtyRead)
            {
                RestaurantConfiguration.command.CommandText = "dbo.T1DirtyRead";
            }
            else
            {
                RestaurantConfiguration.command.CommandText = "dbo.T1ResolvedDirtyRead";
            }

            DataTable dt = DataAccessCode.ExecuteSelectCommand(RestaurantConfiguration.command);
            List <ThongTinNhanVienDTO> list = new List <ThongTinNhanVienDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ThongTinNhanVienDTO thongTinNhanVien = new ThongTinNhanVienDTO();
                    thongTinNhanVien.MaNhanVien = Int32.Parse(dt.Rows[i]["MaNhanVien"].ToString());
                    //thongTinNhanVien.MaNhaHang = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
                    list.Add(thongTinNhanVien);
                }
            }
            dgvData.DataSource = list;
        }
    public static DataTable GetTables()
    {
        DbCommand command = DataAccessCode.CreateCommand();

        command.CommandText = "SP_GETTABLES";
        return(DataAccessCode.ExecuteSelectCommand(command));
    }
예제 #14
0
        public static List <ChiTietThucDonDTO> LayDanhSachMonAnTheoNhaHang(int maNhaHang, DateTime ngay)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachMonAnTheoNhaHang";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@Ngay";
            param.Value         = ngay;
            param.DbType        = DbType.DateTime;
            command.Parameters.Add(param);

            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
            List <ChiTietThucDonDTO> list = new List <ChiTietThucDonDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ChiTietThucDonDTO chiTietThucDon = new ChiTietThucDonDTO();
                    chiTietThucDon.MaChiTietThucDon = Int32.Parse(dt.Rows[i]["MaChiTietThucDon"].ToString());
                    chiTietThucDon.MaMonAn          = Int32.Parse(dt.Rows[i]["MaMonAn"].ToString());
                    chiTietThucDon.TenMonAn         = dt.Rows[i]["TenMonAn"].ToString();
                    chiTietThucDon.DonGia           = Decimal.Parse(dt.Rows[i]["DonGia"].ToString());
                    list.Add(chiTietThucDon);
                }
            }
            return(list);
        }
        public static List <LoaiNhanVienCNDTO> LayLoaiNhanVien()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayLoaiNhanVien";

            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
            List <LoaiNhanVienCNDTO> list = new List <LoaiNhanVienCNDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    //LoaiNhanVienDTO loaiNV = new LoaiNhanVienDTO();
                    int               maLoaiNhanVien  = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString());
                    string            tenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString();
                    double            luong           = Int32.Parse(dt.Rows[i]["Luong"].ToString());
                    LoaiNhanVienCNDTO loaiNV          = new LoaiNhanVienCNDTO(maLoaiNhanVien, tenLoaiNhanVien, luong);
                    list.Add(loaiNV);
                    //NhaHangDTO nhaHang = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai);
                    //list.Add(nhaHang);
                }
            }
            return(list);
        }
        public static DataTable TTNhanVien()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayNhanVien";
            return(DataAccessCode.ExecuteSelectCommand(command));
        }
        public static ArrayList layDanhSachNguyenLieuTheoMonAn(MonAnDTO monAn)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachNguyenLieuTheoMonAn";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaMonAn";
            param.Value         = monAn.MaMonAn;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    MonAn_NguyenLieuDTO dto = new MonAn_NguyenLieuDTO();
                    dto.NguyenLieu.MaNguyenLieu  = Convert.ToInt32(dt.Rows[i]["MaNguyenLieu"]);
                    dto.NguyenLieu.TenNguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString();
                    dto.NguyenLieu.DonViTinh     = dt.Rows[i]["DonViTinh"].ToString();
                    dto.SoLuong = Convert.ToInt32(dt.Rows[i]["SoLuong"]);
                    list.Add(dto);
                }
            }
            return(list);
        }
        public static ArrayList timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung(string ten, int tinhTrangGiaoDich, int maNhaHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            //command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
            //phantom read
            //command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";
            //dirty
            //command.CommandText = "dbo.DirtyReadSolvedT1TimKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichNgungGiaoDich";
            //unrepeat
            command.CommandText = "dbo.timKiemNhaCungCapTheoTenVaTheoTinhTrangGiaoDichCoHoacNgung";


            DbParameter param = command.CreateParameter();

            param.ParameterName = "@ten";
            param.Value         = ten;
            param.DbType        = DbType.String;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@tinhTrangGiaoDich";
            param.Value         = tinhTrangGiaoDich;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@maNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    NhaCungCapDTO dto = new NhaCungCapDTO();
                    dto.MaNhaCungCap  = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
                    dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
                    dto.DienThoai     = dt.Rows[i]["DienThoai"].ToString();
                    dto.SoTaiKhoan    = dt.Rows[i]["SoTaiKhoan"].ToString();
                    if (dt.Rows[i]["TongNo"].ToString() != "")
                    {
                        dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]);
                    }

                    list.Add(dto);
                }
            }
            return(list);
        }
        public static ArrayList layDanhSachNhaCungCap(int maNhaHang, string ten)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.layDanhSachNhaCungCap";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@maNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);

            param = command.CreateParameter();
            param.ParameterName = "@ten";
            param.Value         = ten;
            param.DbType        = DbType.String;
            command.Parameters.Add(param);

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    NhaCungCapDTO dto = new NhaCungCapDTO();
                    dto.MaNhaCungCap  = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
                    dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
                    dto.DienThoai     = dt.Rows[i]["DienThoai"].ToString();
                    dto.SoTaiKhoan    = dt.Rows[i]["SoTaiKhoan"].ToString();
                    if (dt.Rows[i]["TinhTrang"].ToString() != "")
                    {
                        dto.TinhTrangGiaoDich = Convert.ToInt16(dt.Rows[i]["TinhTrang"]);
                    }
                    string a = dt.Rows[i]["TongNo"].ToString();
                    if (dt.Rows[i]["TongNo"].ToString() != "")
                    {
                        dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]);
                    }
                    list.Add(dto);
                }
            }
            return(list);
        }
        internal static int SumNhanVien(int maNH, int loaiTruyXuat)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            if (loaiTruyXuat == 3)
            {
                command.CommandText = "dbo.T58DirtyReadSumNhanVien";
            }
            else if (loaiTruyXuat == 4)
            {
                command.CommandText = "dbo.T58DirtyReadSolvedSumNhanVien";
            }
            else
            {
                command.CommandText = "dbo.T58SumNhanVien";
            }

            //// create a new parameter
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@MaNhaHang";
            if (maNH == 0)
            {
                param.Value = 0;
            }
            else if (maNH == -1)
            {
                param.Value = -1;
            }
            else
            {
                param.Value = maNH;
            }
            param.DbType = DbType.Int32;
            command.Parameters.Add(param);


            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);

            return(Int32.Parse(dt.Rows[0]["Tong"].ToString()));
        }
        public static DataTable LayThongTinNhanVien(/*int maNhaHang*/)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachNhanVien";

            //DbParameter para = command.CreateParameter();
            //para.ParameterName = "@maNhaHang";
            //para.Value = maNhaHang;
            //para.DbType = DbType.Int32;
            //command.Parameters.Add(para);

            //para = command.CreateParameter();
            //para.ParameterName = "@maLoaiNhanVien";
            //para.Value = maLoaiNhanVien;
            //para.DbType = DbType.Int32;
            //command.Parameters.Add(para);
            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);

            return(dt);
        }
        public static ArrayList layDanhSachLoaiMonAn()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachLoaiMonAn";

            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    LoaiMonAnDTO r = new LoaiMonAnDTO();
                    r.MaLoaiMonAn  = Int32.Parse(dt.Rows[i]["MaLoaiMonAn"].ToString());
                    r.TenLoaiMonAn = dt.Rows[i]["TenLoaiMonAn"].ToString();

                    list.Add(r);
                }
            }
            return(list);
        }
예제 #23
0
        public static List <BuoiDTO> LayDanhSachBuoi()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachBuoi";

            DataTable      dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <BuoiDTO> list = new List <BuoiDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    BuoiDTO buoi = new BuoiDTO();
                    buoi.MaBuoi  = Int32.Parse(dt.Rows[i]["MaBuoi"].ToString());
                    buoi.TenBuoi = dt.Rows[i]["TenBuoi"].ToString();

                    list.Add(buoi);
                }
            }
            return(list);
        }
        public static List <NhaHangDTO> LayDanhSachNhaHang()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachNhaHang";
            DataTable         dt   = DataAccessCode.ExecuteSelectCommand(command);
            List <NhaHangDTO> list = new List <NhaHangDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    int        maNhaHang  = Int32.Parse(dt.Rows[i]["MaNhaHang"].ToString());
                    string     tenNhaHang = dt.Rows[i]["TenNhaHang"].ToString();
                    string     diaChi     = dt.Rows[i]["DiaChi"].ToString();
                    string     dienThoai  = dt.Rows[i]["DienThoai"].ToString();
                    NhaHangDTO nhaHang    = new NhaHangDTO(maNhaHang, tenNhaHang, diaChi, dienThoai);
                    list.Add(nhaHang);
                }
            }
            return(list);
        }
예제 #25
0
        public static ThongTinTaiKhoanDTO KiemTraDangNhap(string tenDangNhap, string matKhau)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayThongTinTaiKhoan";
            // create parameter UserName
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@UserName";
            param.Value         = tenDangNhap;
            param.DbType        = DbType.String;
            command.Parameters.Add(param);
            //create Parameter Pass
            param = command.CreateParameter();
            param.ParameterName = "@Pass";
            param.Value         = matKhau;
            param.DbType        = DbType.String;
            command.Parameters.Add(param);
            DataTable           dt       = DataAccessCode.ExecuteSelectCommand(command); //Cho nay ne, neu nhu username hoac pass ko dung thi no tra ve null ak
            ThongTinTaiKhoanDTO taiKhoan = new ThongTinTaiKhoanDTO();

            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    taiKhoan.ID           = Int32.Parse(dt.Rows[i]["ID"].ToString());
                    taiKhoan.TenDangNhap  = dt.Rows[i]["TenDangNhap"].ToString();
                    taiKhoan.MatKhau      = dt.Rows[i]["MatKhau"].ToString();
                    taiKhoan.LoaiNhanVien = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString());
                    taiKhoan.MaNhaHang    = dt.Rows[i]["MaNhaHang"].ToString();
                    //taiKhoan.CMND = (dt.Rows[i]["CMND"].ToString());
                }
                return(taiKhoan);
            }
            return(null);
            //Tuc la neu user no nhap ko dung pass hoac username thi minh se tra ve null
            //=> cai form dang nhap ak,  if kq == null thi xa messsagebox ra thui
        }
        public static ArrayList layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoThoiDiemThanhToan(int maNhaHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoThoiDiemThanhToan";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@maNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);


            DataTable dt   = DataAccessCode.ExecuteSelectCommand(command);
            ArrayList list = new ArrayList();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    NhaCungCapDTO dto = new NhaCungCapDTO();
                    dto.MaNhaCungCap        = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
                    dto.TenNhaCungCap       = dt.Rows[i]["TenNhaCungCap"].ToString();
                    dto.DienThoai           = dt.Rows[i]["DienThoai"].ToString();
                    dto.SoTaiKhoan          = dt.Rows[i]["SoTaiKhoan"].ToString();
                    dto.ThoiDiemThanhToan   = dt.Rows[i]["ThoiDiemThanhToan"].ToString();
                    dto.MaThoiDiemThanhToan = Convert.ToInt32(dt.Rows[i]["MaThoiDiemThanhToan"]);
                    dto.GiaTriDinhMucNo     = 0;//hien thi NULL
                    if (dt.Rows[i]["TongNo"].ToString() != "")
                    {
                        dto.TongNo = Convert.ToDecimal(dt.Rows[i]["TongNo"]);
                    }

                    list.Add(dto);
                }
            }
            return(list);
        }
예제 #27
0
        public static List <LoaiNhanVienDTO> LayDanhSachLoaiNhanVien()
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayDanhSachLoaiNhanVien";

            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
            List <LoaiNhanVienDTO> list = new List <LoaiNhanVienDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    LoaiNhanVienDTO loaiNhanVien = new LoaiNhanVienDTO();
                    loaiNhanVien.MaLoaiNhanVien  = Int32.Parse(dt.Rows[i]["MaLoaiNhanVien"].ToString());
                    loaiNhanVien.TenLoaiNhanVien = dt.Rows[i]["TenLoaiNhanVien"].ToString();
                    loaiNhanVien.Luong           = Decimal.Parse(dt.Rows[i]["Luong"].ToString());

                    list.Add(loaiNhanVien);
                }
            }
            return(list);
        }
        public static KhoHangDTO layThongTinKhoHangTheoNhaHang(int maNhaHang)
        {
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.layThongTinKhoHangTheoNhaHang";
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@maNhaHang";
            param.Value         = maNhaHang;
            param.DbType        = DbType.Int32;
            command.Parameters.Add(param);


            DataTable  dt  = DataAccessCode.ExecuteSelectCommand(command);
            KhoHangDTO dto = new KhoHangDTO();

            if (dt != null)
            {
                dto.MaKhoHang  = Convert.ToInt32(dt.Rows[0]["MaKhoHang"]);
                dto.TenKhoHang = dt.Rows[0]["TenKhoHang"].ToString();
            }
            return(dto);
        }
예제 #29
0
        public static List <ThongTinTaiKhoanDTO> LayThongTinTaiKhoan(string user, string pass)
        {
            // using Data.Common
            DbCommand command = DataAccessCode.CreateCommand();

            command.CommandText = "dbo.LayThongTinTaiKhoan";
            // create parameter UserName
            DbParameter param = command.CreateParameter();

            param.ParameterName = "@UserName";
            param.DbType        = DbType.String;
            command.Parameters.Add(param);
            // create Parameter Pass
            param = command.CreateParameter();
            param.ParameterName = "@Pass";
            param.DbType        = DbType.String;
            command.Parameters.Add(param);

            DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
            // tạo ra list thông tài khoản để lưu các thông tin :
            List <ThongTinTaiKhoanDTO> list = new List <ThongTinTaiKhoanDTO>();

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ThongTinTaiKhoanDTO taiKhoan = new ThongTinTaiKhoanDTO();
                    taiKhoan.ID           = Int32.Parse(dt.Rows[i]["ID"].ToString());
                    taiKhoan.TenDangNhap  = dt.Rows[i]["TenDangNhap"].ToString();
                    taiKhoan.MatKhau      = dt.Rows[i]["MatKhau"].ToString();
                    taiKhoan.LoaiNhanVien = Int32.Parse(dt.Rows[i]["LoaiNhanVien"].ToString());
                    taiKhoan.MaNhaHang    = (dt.Rows[i]["MaNhaHang"].ToString());
                }
            }
            return(list);
        }
    public static TableDetails GetTableDetails(string departmentId)
    {
        DbCommand comm = DataAccessCode.CreateCommand();

        comm.CommandText = "GetTableDetails";

        DbParameter param = comm.CreateParameter();

        param.ParameterName = "@MaBan";
        param.Value         = departmentId;
        param.DbType        = DbType.Int32;
        comm.Parameters.Add(param);

        DataTable table = DataAccessCode.ExecuteSelectCommand(comm);

        TableDetails details = new TableDetails();

        if (table.Rows.Count > 0)
        {
            details.MaBan  = table.Rows[0]["MaBan"].ToString();
            details.TenBan = table.Rows[0]["TenBan"].ToString();
        }
        return(details);
    }