/// <summary>
/// Creates a BOUserObject from the ASPNet User GUID
/// </summary>
/// <param name="GUID">ASPNet User GUID</param>
/// <returns>BOUser</returns>
public static BOUser GetByGUID(string GUID)
{
logger.Trace("GetByGUID");
BOUser a = new BOUser();
SqlConnection con = new SqlConnection(GetConnectionString());
con.Open();
try
{
SqlCommand cmd = new SqlCommand("P_User_GetbyGUID", con);
cmd.CommandType = CommandType.StoredProcedure;
SetVarCharParameter(cmd.Parameters, "@USR_GUID", 50, GUID, false);
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult);
try
{
if (rdr.Read())
a.PopulateFromReader(rdr);
else
return null;
}
catch (Exception ex)
{
logger.ErrorException("Failed to fetch record", ex);
return null;
}
finally
{
rdr.Close();
}
}
finally
{
con.Close();
}
return a;
}
