public List <QI_USER_REC> GetQiUsersCollection(Guid facilityId) { List <QI_USER_REC> userCollection = new List <QI_USER_REC>(); userCollection.Clear(); using (SqlConnection dbConn = m_SqlHelpers.GetDbConnection(m_AwareDbConnString)) { string sqlText = "usp_SelectUserRecsByFacID"; SqlCommand sqlCmd = new SqlCommand(sqlText, dbConn); sqlCmd.CommandType = System.Data.CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@FacilityId", facilityId); SqlDataReader dr = sqlCmd.ExecuteReader(); while (dr.Read()) { QI_USER_REC rec = new QI_USER_REC(); try { rec.UserID = dr.GetGuid(0); try{ rec.UserName = dr.GetString(1); } catch (SqlNullValueException ex) { rec.UserName = string.Empty; } try { rec.FacilityId = dr.GetGuid(2); } catch (SqlNullValueException ex) { rec.FacilityId = new Guid(); } userCollection.Add(rec); } catch (InvalidCastException ex) { } } dr.Close(); dbConn.Close(); } return(userCollection); }
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 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); }