Exemple #1
0
        public static void emps2List()
        {
            dbh       = MSSQLWrapper.getConnection();
            employees = new List <Employee>();

            string sql = "";

            sql += "select id, firstname, lastname, title, hiredate, reportsto";
            sql += " from employee";
            dbh.open();
            try {
                dbh.setCommand(sql);
                SqlDataReader res = dbh.select();
                while (res.Read())
                {
                    Employee e = new Employee(Convert.ToInt32(res["id"])
                                              , res["firstname"].ToString()
                                              , res["lastname"].ToString()
                                              , res["title"].ToString()
                                              , Convert.ToDateTime(res["hiredate"])
                                              , Convert.ToInt32(res["reportsto"]));
                    employees.Add(e);
                }
            } catch (Exception ex) {
                throw ex;
            }
            dbh.close();
        }
Exemple #2
0
        public byte[] getImageData()
        {
            dbh = MSSQLWrapper.getConnection();
            string sql = string.Format("SELECT photo FROM employee WHERE id = {0}", this.id);

            dbh.setCommand(sql);
            dbh.open();
            object value = dbh.getCommand().ExecuteScalar(); // returns row 1, col 1 from rs

            dbh.close();
            if (value != null)
            {
                return((byte[])value);
            }
            return(null);
        }
Exemple #3
0
        public void emp2Db()
        {
            // insert into db
            dbh = MSSQLWrapper.getConnection();
            dbh.open();
            string sql = "";

            sql += "insert into employee (firstname, lastname, title, hiredate, reportsto, photo) ";
            sql += "values (@fn, @ln, @ti, @hi, @re, @photo)";
            try {
                dbh.setCommand(sql);

                SqlParameter fnP = new SqlParameter("@fn", SqlDbType.Text, 32);
                fnP.Value = this.firstname;
                dbh.addParam(fnP);
                SqlParameter lnP = new SqlParameter("@ln", SqlDbType.Text, 32);
                lnP.Value = this.lastname;
                dbh.addParam(lnP);
                SqlParameter tiP = new SqlParameter("@ti", SqlDbType.Text, 32);
                tiP.Value = this.title;
                dbh.addParam(tiP);
                SqlParameter hiP = new SqlParameter("@hi", SqlDbType.DateTime);
                hiP.Value = this.hiredate;
                dbh.addParam(hiP);
                SqlParameter reP = new SqlParameter("@re", SqlDbType.Int);
                reP.Value = this.reportsto;
                dbh.addParam(reP);

                SqlParameter phP = new SqlParameter("@Photo", SqlDbType.Image, photo.Length);
                phP.Value = this.photo;
                dbh.addParam(phP);

                dbh.prepare();
                dbh.otherQuery();
            } catch (Exception ex) {
                Console.WriteLine(sql);
                Console.WriteLine(this.reportsto);
                throw ex;
            }
            dbh.close();
        }