コード例 #1
0
        //can code the
        public static Account getAccountByUsernameDetail(string username)
        {
            Account ac  = new Account();
            string  sql = "SELECT * FROM dbo.Account  WHERE  userName = @username ";

            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@username", SqlDbType.NVarChar)
            };
            param[0].Value = username;

            DataTable a = DataAccess.ReadDataBySQLWithParameter(sql, param);

            foreach (DataRow dr in a.Rows)
            {
                ac.Name         = dr["name"].ToString();
                ac.UserName     = dr["userName"].ToString();
                ac.PassWord     = dr["passWord"].ToString();
                ac.MoneyBuy     = float.Parse((string.IsNullOrEmpty(dr["moneyBuy"].ToString()))?"0": dr["moneyBuy"].ToString());
                ac.Place        = dr["diaChi"].ToString();
                ac.Phone        = dr["phone"].ToString();
                ac.Gmail        = dr["gmail"].ToString();
                ac.Gender       = Convert.ToBoolean(dr["gender"].ToString());
                ac.DOB          = Convert.ToDateTime(dr["DOB"].ToString());
                ac.Thearts      = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
                ac.Areax        = AreaDAO.getAreaByID(Convert.ToInt32(dr["idKhuVuc"].ToString()));
                ac.GroupMemBerx = GroupMemberDAO.getGroupMemberById(Convert.ToInt32(dr["idNhomThanhVien"].ToString()));
            }

            return(ac);
        }
コード例 #2
0
        public static List <Theart_Room> getAllRapPhong()
        {
            List <Theart_Room> list = new List <Theart_Room>();
            string             sql  = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong ";
            DataTable          dt   = DataAccess.ReadDataBySQL(sql);

            foreach (DataRow dr in dt.Rows)
            {
                Theart_Room tr = new Theart_Room();
                tr.Theartx       = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
                tr.Roomx         = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString()));
                tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString());
                tr.Note          = dr["note"].ToString();
                tr.SeatTypes     = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID);
                list.Add(tr);
            }
            return(list);
        }
コード例 #3
0
        public static Theart_Room getAllRapPhongByID(int idRap, int idPhong)
        {
            string sql = "SELECT rp.idRap,rp.idPhong,rp.numberMaxGhe,rp.note FROM dbo.Rap_Phong AS rp" +
                         " WHERE rp.idRap = @idRap AND rp.idPhong = @idPhong";

            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@idRap", SqlDbType.Int),
                new SqlParameter("@idPhong", SqlDbType.Int)
            };
            param[0].Value = idRap;
            param[1].Value = idPhong;
            DataTable   dt = DataAccess.ReadDataBySQLWithParameter(sql, param);
            Theart_Room tr = new Theart_Room();

            foreach (DataRow dr in dt.Rows)
            {
                tr.Theartx       = TheartDAO.getTheartByID(Convert.ToInt32(dr["idRap"].ToString()));
                tr.Roomx         = RoomDAO.getRoomByID(Convert.ToInt32(dr["idPhong"].ToString()));
                tr.NumberMaxSeat = Convert.ToInt32(dr["numberMaxGhe"].ToString());
                tr.Note          = dr["note"].ToString();
                tr.SeatTypes     = SeatTypeDAO.getAllSeatTypeByIdRapIdPhong(tr.Theartx.ID, tr.Roomx.ID);
            }
            return(tr);
        }