Ejemplo n.º 1
0
        public void ThemCV(ChucVu cv)
        {
            DAL_ChucVu dal_ChucVu = new DAL_ChucVu();

            dal_ChucVu.Open();
            string     insertString = "insert into ChucVu(MaCV,TenCV,LuongCB) values(" + cv.MaCV + ",'" + cv.TenCV + "'," + cv.LuongCB + "')";
            SqlCommand cmd          = new SqlCommand(insertString, dal_ChucVu.conn);

            cmd.ExecuteNonQuery();
            cmd.Dispose();
            dal_ChucVu.Close();
        }
Ejemplo n.º 2
0
        public void XoaCV(string MaCV)
        {
            DAL_ChucVu dal_ChucVu = new DAL_ChucVu();

            dal_ChucVu.Open();
            string     deleteString = "XOACV";
            SqlCommand cmd          = new SqlCommand(deleteString, dal_ChucVu.conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@MaCV", SqlDbType.Int).Value = MaCV;
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            dal_ChucVu.Close();
        }
Ejemplo n.º 3
0
        public int LayMaCV()
        {
            DAL_ChucVu dal_ChucVu = new DAL_ChucVu();

            dal_ChucVu.Open();
            string        selectString = "select top 1 MaCV from ChucVu order by MaCV desc";
            SqlCommand    cmd          = new SqlCommand(selectString, dal_ChucVu.conn);
            SqlDataReader reader       = cmd.ExecuteReader();

            reader.Read();
            int Mapc = reader.GetInt32(0);

            reader.Dispose();
            dal_ChucVu.Close();
            return(Mapc + 1);
        }
Ejemplo n.º 4
0
        public void CapNhatCV(ChucVu cv)
        {
            DAL_ChucVu dal_ChucVu = new DAL_ChucVu();

            dal_ChucVu.Open();
            string     updateString = "SUAPB";
            SqlCommand cmd          = new SqlCommand(updateString, dal_ChucVu.conn);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@MaCV", SqlDbType.Text).Value     = cv.MaCV;
            cmd.Parameters.Add("@TenCV", SqlDbType.Text).Value    = cv.TenCV;
            cmd.Parameters.Add("@LuongCB", SqlDbType.Money).Value = cv.LuongCB;
            cmd.ExecuteNonQuery();
            cmd.Dispose();
            dal_ChucVu.Close();
        }
Ejemplo n.º 5
0
        public ChucVu LayThongTinNhanVien(string username)
        {
            DAL_ChucVu dal_ChucVu = new DAL_ChucVu();

            dal_ChucVu.Open();
            string        qry     = "select NhanVien.HoTen, NhanVien.GioiTinh, NhanVien.DiaChi, NhanVien.NamSinh, NhanVien.SoCMND, NhanVien.SDT, NhanVien.Email, PhongBan.TenPB, ChucVu.TenCV from NhanVien, PhongBan, ChucVu where (NhanVien.MaPB=PhongBan.MaPB) AND (NhanVien.MaCV=ChucVu.MaCV) AND (NhanVien.MaNV = '" + username + "')";
            SqlCommand    cmd1    = new SqlCommand(qry, dal_ChucVu.conn);
            SqlDataReader reader1 = cmd1.ExecuteReader();
            ChucVu        cv      = new ChucVu();

            if (reader1.HasRows)
            {
                reader1.Read();
                cv.TenCV = (string)reader1["TenCV"];
            }
            reader1.Dispose();
            cmd1.Dispose();
            dal_ChucVu.Close();

            return(cv);
        }