public List <SP_SEL_ENCRYPT_NHANVIEN_Result> getNV() { using (QLSV_CANHANEntities db = new QLSV_CANHANEntities()) { List <SP_SEL_ENCRYPT_NHANVIEN_Result> list = new List <SP_SEL_ENCRYPT_NHANVIEN_Result>(); var tempList = db.SP_SEL_ENCRYPT_NHANVIEN(); foreach (var i in tempList) { i.LUONG = DecryptStringFromBytes_Aes(Convert.FromBase64String(i.LUONG), key, IV); list.Add(i); } return(list); } }
public static void update_NV(string maNV, string hoTen, string email, string luong, string tenDN, string matKhau) { using (QLSV_CANHANEntities db = new QLSV_CANHANEntities()) { SHA1Managed sha1 = new SHA1Managed(); sha1.ComputeHash(Encoding.UTF8.GetBytes(matKhau)); byte[] hashMK = sha1.Hash; StringBuilder buildMK = new StringBuilder(); for (int i = 0; i < hashMK.Length; i++) { buildMK.Append(hashMK[i].ToString()); } string finalMk = buildMK.ToString(); byte[] encryptedLuong = EncryptStringToBytes_Aes(luong, key, IV); string finalLuong = Convert.ToBase64String(encryptedLuong); db.UPDATE_NV(maNV, hoTen, email, finalLuong, tenDN, finalMk); } }
public void insertSV(string maSV, string hoTen, string ngaySinh, string diaChi, string maLop, string tenDN, string matKhau) { MD5 md5 = new MD5CryptoServiceProvider(); md5.ComputeHash(Encoding.UTF8.GetBytes(matKhau)); byte[] hashMatKhau = md5.Hash; StringBuilder buildMK = new StringBuilder(); for (int i = 0; i < hashMatKhau.Length; i++) { buildMK.Append(hashMatKhau[i].ToString()); } string finalMK = buildMK.ToString(); using (QLSV_CANHANEntities db = new QLSV_CANHANEntities()) { DateTime ngaySinhDate = Convert.ToDateTime(ngaySinh); db.SP_INS_ENCRYPT_SINHVIEN(maSV, hoTen, ngaySinhDate, diaChi, maLop, tenDN, finalMK); } }