private bool ValidateAVCodes()
{
bool isValid = false;
HAR_StringEncrypter encrypter = new HAR_StringEncrypter();
AwareAppSettings appSettings = new AwareAppSettings();
AwareHelpers awHelpers = new AwareHelpers(appSettings.GetAwareDbConnectionString);
if (true == awHelpers.AwareSecurity.VerifyUserCredentials(tboxUserName.Text, encrypter.EncryptString(tboxPassword.Text)))
{
isValid = true;
}
return(isValid);
}
public void UpdateUser(ref QI_USER_REC userRec)
{
using (SqlConnection awareDbConn = m_SqlHelpers.GetDbConnection(m_AwareDbConnString))
{
HAR_StringEncrypter encrypter = new HAR_StringEncrypter();
string sqlText = "usp_UpdateUser";
SqlCommand sqlCmd = new SqlCommand(sqlText, awareDbConn);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@UserName", userRec.UserName);
sqlCmd.Parameters.AddWithValue("@FacilityId", userRec.FacilityId);
sqlCmd.Parameters.AddWithValue("@VerifyCode", encrypter.EncryptString(userRec.VerifyCode));
sqlCmd.Parameters.AddWithValue("@UserId", userRec.UserID);
sqlCmd.ExecuteNonQuery();
awareDbConn.Close();
}
}
public bool IsGroupPermittedAccess(string grpName)
{
bool permitted = false;
using (SqlConnection awareDbConn = m_SqlHelpers.GetDbConnection(m_AwareDbConnString))
{
HAR_StringEncrypter encrypter = new HAR_StringEncrypter();
string sqlText = "usp_IsGroupPermittedAccess";
SqlCommand sqlCmd = new SqlCommand(sqlText, awareDbConn);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@GrpName", grpName);
int cnt = (int)sqlCmd.ExecuteScalar();
awareDbConn.Close();
if (cnt > 0)
{
permitted = true;
}
}
return(permitted);
}
public Guid AddUser(string UserName, Guid FacilityId, string verifyCode)
{
Guid guid = new Guid();
using (SqlConnection awareDbConn = m_SqlHelpers.GetDbConnection(m_AwareDbConnString))
{
HAR_StringEncrypter encrypter = new HAR_StringEncrypter();
string sqlText = "usp_AddUser";
SqlCommand sqlCmd = new SqlCommand(sqlText, awareDbConn);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@UserName", UserName);
sqlCmd.Parameters.AddWithValue("@FacilityId", FacilityId);
sqlCmd.Parameters.AddWithValue("@VerifyCode", encrypter.EncryptString(verifyCode));
sqlCmd.ExecuteNonQuery();
awareDbConn.Close();
if (true == DoesUserExist(UserName, FacilityId))
{
guid = GetUsersId(UserName, FacilityId);
}
}
return(guid);
}
public QI_USER_REC GetUserRecordById(Guid UserId)
{
QI_USER_REC user = new QI_USER_REC();
using (SqlConnection awareDbConn = m_SqlHelpers.GetDbConnection(m_AwareDbConnString))
{
HAR_StringEncrypter m_Encrypter = new HAR_StringEncrypter();
string sqlText = "usp_SelectUserRecsByUserID";
SqlCommand sqlCmd = new SqlCommand(sqlText, awareDbConn);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@UserId", UserId);
SqlDataReader dr = sqlCmd.ExecuteReader();
while (dr.Read())
{
try
{
try { user.UserID = dr.GetGuid(0); }
catch (SqlNullValueException Exception) { user.UserID = new Guid(); }
try { user.UserName = dr.GetString(1); }
catch (SqlNullValueException ex) { user.UserName = string.Empty; }
try { user.FacilityId = dr.GetGuid(2); }
catch (SqlNullValueException ex) { user.FacilityId = new Guid(); }
try { user.VerifyCode = m_Encrypter.DecryptString(dr.GetString(3)); }
catch (SqlNullValueException ex) { user.VerifyCode = string.Empty; }
}
catch (InvalidCastException ex)
{
}
}
dr.Close();
awareDbConn.Close();
}
return(user);
}
