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; ; }