public static List <Business.EventArtist> Load(Guid?Id, string Name, int?Type, string CountryISOCode, string Region, string ZIP, string City, int amount)
{
SqlDataReader sqlReader = null;
List <Business.EventArtist> list = new List <_4screen.CSB.DataAccess.Business.EventArtist>();
try
{
sqlReader = GetReaderAll(Id, Name, Type, CountryISOCode, Region, ZIP, City, amount);
while (sqlReader.Read())
{
Business.EventArtist item = new Business.EventArtist();
FillObject(item, sqlReader);
list.Add(item);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(list);
}
public static List <Business.EventArtist> LoadAttached(Guid EventId, int amount)
{
SqlDataReader sqlReader = null;
List <Business.EventArtist> list = new List <_4screen.CSB.DataAccess.Business.EventArtist>();
try
{
sqlReader = GetReaderAttached(EventId, amount);
while (sqlReader.Read())
{
Business.EventArtist item = new Business.EventArtist();
FillObject(item, sqlReader);
list.Add(item);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(list);
}
public static Business.EventArtist Get(Guid Id)
{
SqlDataReader sqlReader = null;
Business.EventArtist objEventArtist = null;
try
{
sqlReader = GetReaderAll(Id, null, null, null, null, null, null, 1);
if (sqlReader.Read())
{
objEventArtist = new Business.EventArtist();
FillObject(objEventArtist, sqlReader);
}
}
finally
{
if (sqlReader != null)
{
sqlReader.Close();
}
sqlReader = null;
}
return(objEventArtist);
}
internal static void Update(Business.EventArtist 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_Artist_Update";
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_ID", SqlDbType.UniqueIdentifier, item.ID.Value));
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Name", SqlDbType.NVarChar, 50, item.Name));
GetData.Parameters.Add(SqlHelper.AddParameter("@EAT_Typ", SqlDbType.Int, item.Type));
if (!string.IsNullOrEmpty(item.CountryISOCode))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Country_ISO", SqlDbType.NVarChar, 5, item.CountryISOCode));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Country_ISO", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.Region))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Region", SqlDbType.NVarChar, 25, item.Region));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Region", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.ZIP))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Zip", SqlDbType.NVarChar, 8, item.ZIP));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Zip", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.City))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_City", SqlDbType.NVarChar, 50, item.City));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_City", SqlDbType.NVarChar));
}
if (item.GeoLat != null && item.GeoLat != double.MinValue)
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Geo_Lat", SqlDbType.Float, item.GeoLat.Value));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Geo_Lat", SqlDbType.Float));
}
if (item.GeoLong != null && item.GeoLong != double.MinValue)
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Geo_Long", SqlDbType.Float, item.GeoLong.Value));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_Geo_Long", SqlDbType.Float));
}
if (!string.IsNullOrEmpty(item.URL))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_URL", SqlDbType.NVarChar, 250, item.URL));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_URL", SqlDbType.NVarChar));
}
if (!string.IsNullOrEmpty(item.CommunityURL))
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_CTYURL", SqlDbType.NVarChar, 250, item.CommunityURL));
}
else
{
GetData.Parameters.Add(SqlHelper.AddParameter("@ART_CTYURL", SqlDbType.NVarChar));
}
Conn.Open();
GetData.ExecuteNonQuery();
}
finally
{
Conn.Close();
}
}
