public System.Data.SqlClient.SqlParameter[] Parameters()
{
System.Data.SqlClient.SqlParameter[] retVal = new System.Data.SqlClient.SqlParameter[4];
if (MaxLong != 0.0m)
{
retVal[0] = new System.Data.SqlClient.SqlParameter("maxlong", MaxLong);
retVal[1] = new System.Data.SqlClient.SqlParameter("minLong", MinLong);
retVal[2] = new System.Data.SqlClient.SqlParameter("maxlat", MaxLat);
retVal[3] = new System.Data.SqlClient.SqlParameter("minlat", MinLat);
}
else
{
retVal = GeoBox.NullParameters();
}
return(retVal);
}
public static IList <UserDetails> GetUsers(int key, string eventID, GeoBox box)
{
IList <UserDetails> retVal;
System.Data.SqlClient.SqlConnection conn = ObtainDatabaseConnection();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.CommandText = "usp_getUserDetails";
object oKey;
if (key == 0)
{
oKey = null;
}
else
{
oKey = key;
}
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("UserKey", oKey));
if (eventID == "")
{
eventID = null;
}
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("eventId", eventID));
if (box == null)
{
cmd.Parameters.AddRange(GeoBox.NullParameters());
}
else
{
cmd.Parameters.AddRange(box.Parameters());
}
conn.Open();
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
retVal = buildUsers(ds);
return(retVal);;
}
public static IList<UserDetails> GetUsers(int key, string eventID, GeoBox box)
{
IList<UserDetails> retVal;
System.Data.SqlClient.SqlConnection conn = ObtainDatabaseConnection();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.CommandText = "usp_getUserDetails";
object oKey;
if (key == 0)
{
oKey = null;
}
else
{
oKey = key;
}
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("UserKey", oKey));
if (eventID == "")
{
eventID = null;
}
cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("eventId", eventID));
if (box == null)
{
cmd.Parameters.AddRange(GeoBox.NullParameters());
}
else
{
cmd.Parameters.AddRange(box.Parameters());
}
conn.Open();
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
retVal = buildUsers(ds);
return retVal; ;
}
