Example #1
0
        public List <uspCheckGuest> checkguest(string guest)
        {
            List <uspCheckGuest> list = new List <uspCheckGuest>();

            SqlParameter[] pars = new SqlParameter[]
            {
                new SqlParameter("@guest", guest)
            };

            using (DataTable dt = DBHelper.ParamSelect("uspCheckGuest", CommandType.StoredProcedure, pars))
            {
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        uspCheckGuest g = new uspCheckGuest
                        {
                            PersonnelID = Convert.ToString(row["PersonnelID"])
                        };
                        list.Add(g);
                    }
                }
                else
                {
                    list = null;
                }
            }
            return(list);
        }
Example #2
0
        // Get Guest
        public uspCheckGuest CheckGuest(string guest)
        {
            uspCheckGuest cg = null;

            SqlParameter[] pars = new SqlParameter[]
            {
                new SqlParameter("@guest", guest)
            };
            using (DataTable table = DBHelper.ParamSelect("uspCheckGuest",
                                                          CommandType.StoredProcedure, pars))
            {
                if (table.Rows.Count == 1)
                {
                    DataRow row = table.Rows[0];
                    cg = new uspCheckGuest
                    {
                        PersonnelID = Convert.ToString(row["PersonnelID"])
                    };
                }
            }
            return(cg);
        }