public void SetPassword(long kadrPK, string password, long whoChangePassword)
{
var strCommand = "exec dbo.usp_Kadry_spr_ofKadr_upd_new " +
" @IdKadr=" + kadrPK +
", @ControlName='TxtUs_psw_confirm'" +
", @ControlValue='" + cryptStr(password) + "'" +
", @LastUserEdit='" + lastUserEdit() + "'" +
", @IdKadr_us=" + whoChangePassword + "";
using (IDbConnection db = new SqlConnection(connectionString))
{
db.Execute(strCommand);
}
using (MD5 md5Hash = MD5.Create())
{
string passMD5 = ServiceCommon.GetMd5Hash(md5Hash, password);
strCommand = "exec dbo.usp_Kadry_spr_ofKadr_upd_new " +
" @IdKadr=" + kadrPK +
", @ControlName='TxtUs_psw_md5_confirm'" +
", @ControlValue='" + passMD5 + "'" +
", @LastUserEdit='" + lastUserEdit() + "'" +
", @IdKadr_us=" + whoChangePassword + "";
using (IDbConnection db = new SqlConnection(connectionString))
{
db.Execute(strCommand);
}
}
}
