public static List <Business.EventLocation> Load(Guid?Id, string Name, int?Type, string CountryISOCode, string Region, string ZIP, string City, int amount)
{
SqlDataReader sqlReader = null;
List <Business.EventLocation> list = new List <_4screen.CSB.DataAccess.Business.EventLocation>();
try
{
sqlReader = GetReaderAll(Id, Name, Type, CountryISOCode, Region, ZIP, City, amount);
while (sqlReader.Read())
{
Business.EventLocation item = new Business.EventLocation();
FillObject(item, sqlReader);
list.Add(item);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(list);
}
public static List <Business.EventLocation> LoadAttached(Guid EventId, int amount)
{
SqlDataReader sqlReader = null;
List <Business.EventLocation> list = new List <_4screen.CSB.DataAccess.Business.EventLocation>();
try
{
sqlReader = GetReaderAttached(EventId, amount);
while (sqlReader.Read())
{
Business.EventLocation item = new Business.EventLocation();
FillObject(item, sqlReader);
list.Add(item);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(list);
}
public static Business.EventLocation Get(Guid Id)
{
SqlDataReader sqlReader = null;
Business.EventLocation objEventLocation = null;
try
{
sqlReader = GetReaderAll(Id, null, null, null, null, null, null, 1);
if (sqlReader.Read())
{
objEventLocation = new Business.EventLocation();
FillObject(objEventLocation, sqlReader);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(objEventLocation);
}
internal static void Update(Business.EventLocation item)
{
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString;
SqlConnection Conn = new SqlConnection(strConn);
try
{
SqlCommand GetData = new SqlCommand();
GetData.Connection = Conn;
GetData.CommandType = CommandType.StoredProcedure;
GetData.CommandText = "hisp_Event_Location_Update";
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_ID", SqlDbType.UniqueIdentifier, item.ID.Value));
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Name", SqlDbType.NVarChar, 50, item.Name));
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Typ", SqlDbType.Int, item.Type));
if (!string.IsNullOrEmpty(item.CountryISOCode))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Country_ISO", SqlDbType.NVarChar, 5, item.CountryISOCode));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Country_ISO", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.Region))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Region", SqlDbType.NVarChar, 25, item.Region));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Region", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.ZIP))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Zip", SqlDbType.NVarChar, 8, item.ZIP));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Zip", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.City))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_City", SqlDbType.NVarChar, 50, item.City));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_City", SqlDbType.NVarChar));
}
if (item.GeoLat != null && item.GeoLat != double.MinValue)
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Geo_Lat", SqlDbType.Float, item.GeoLat.Value));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Geo_Lat", SqlDbType.Float));
}
if (item.GeoLong != null && item.GeoLong != double.MinValue)
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Geo_Long", SqlDbType.Float, item.GeoLong.Value));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_Geo_Long", SqlDbType.Float));
}
if (!string.IsNullOrEmpty(item.URL))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_URL", SqlDbType.NVarChar, 250, item.URL));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_URL", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.CommunityURL))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_CTYURL", SqlDbType.NVarChar, 250, item.CommunityURL));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@LOC_CTYURL", SqlDbType.NVarChar));
}
Conn.Open();
GetData.ExecuteNonQuery();
}
finally
{
Conn.Close();
}
}
