private void SaveSinhVienHandler(SinhVien item)
{
item.MaLop = (lopBindingSource.Current as Lop).MaLop;
var existItem = DbLib.GetOne <SinhVien>(String.Format("select convert(varchar(500),MatKhau) as MatKhau from SinhVien where MaSV ='{0}'", item.MaSV));
if (existItem != null)
{
if (item.MatKhau != existItem.MatKhau)
{
item.MatKhau = item.MatKhau.GetSHA1Hash();
}
var parameters = item.ToSqlParameter();
DbLib.ExecuteNonQuery("SP_UPD_ENCRYPTED_SINHVIEN", parameters);
}
else
{
item.MatKhau = item.MatKhau.GetSHA1Hash();
DbLib.ExecuteNonQuery("SP_INS_ENCRYPTED_SINHVIEN", item.ToSqlParameter());
}
}