Example #1
0
        public bool nhanvien_update(nhanvien data)
        {
            try
            {
                using (SqlConnection conn = getConnect())
                {
                    SqlCommand cmd = new SqlCommand("NhanVien_Update", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@MANV", data.manv));
                    cmd.Parameters.Add(new SqlParameter("@TEN", data.tennv));
                    cmd.Parameters.Add(new SqlParameter("@HO", data.honv));
                    cmd.Parameters.Add(new SqlParameter("@DIACHI", data.diachi));
                    cmd.Parameters.Add(new SqlParameter("@NGAYSINH", data.ngaysinh));
                    cmd.Parameters.Add(new SqlParameter("@GIOITINH", data.gioitinh));
                    cmd.Parameters.Add(new SqlParameter("@DIENTHOAI", data.dienthoai));
                    cmd.Parameters.Add(new SqlParameter("@USERNAME", data.taikhoan));
                    cmd.Parameters.Add(new SqlParameter("@PASSWORDS", data.matkhau));
                    cmd.Parameters.Add(new SqlParameter("@LOAINV", data.loainv));

                    cmd.ExecuteNonQuery();
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
Example #2
0
        public bool nhanvien_delete(nhanvien data)
        {
            try
            {
                using (SqlConnection conn = getConnect())
                {
                    SqlCommand cmd = new SqlCommand("NhanVien_Delete", conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@MANV", data.manv));


                    cmd.ExecuteNonQuery();
                }
                return(true);
            }
            catch
            {
                return(false);
            }
        }
Example #3
0
        public List <nhanvien> nhanvien_getAll()
        {
            List <nhanvien> lst = new List <nhanvien>();

            using (SqlConnection conn = getConnect())
            {
                SqlCommand cmd = new SqlCommand("NhanVien_Select", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        nhanvien obj = new nhanvien();
                        obj.nhanvien_datareader(dr);
                        lst.Add(obj);
                    }
                }
            }
            return(lst);
        }