public virtual IABazaar.Core.Entities.EventHandler UpdateEventHandler(IABazaar.Core.Entities.EventHandler entity)
{
if (entity.IsTransient())
{
return(entity);
}
IABazaar.Core.Entities.EventHandler other = GetEventHandler(entity.EventId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update EventHandler set [EventName]=@EventName
, [CalloutURL]=@CalloutURL
, [XmlPackage]=@XmlPackage
, [Debug]=@Debug
, [Active]=@Active
where EventID=@EventID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@EventID", entity.EventId)
, new SqlParameter("@EventName", entity.EventName)
, new SqlParameter("@CalloutURL", entity.CalloutUrl)
, new SqlParameter("@XmlPackage", entity.XmlPackage)
, new SqlParameter("@Debug", entity.Debug)
, new SqlParameter("@Active", entity.Active)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetEventHandler(entity.EventId));
}
public virtual IABazaar.Core.Entities.EventHandler InsertEventHandler(IABazaar.Core.Entities.EventHandler entity)
{
IABazaar.Core.Entities.EventHandler other = new IABazaar.Core.Entities.EventHandler();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into EventHandler ( [EventName]
,[CalloutURL]
,[XmlPackage]
,[Debug]
,[Active] )
Values
( @EventName
, @CalloutURL
, @XmlPackage
, @Debug
, @Active );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@EventID", entity.EventId)
, new SqlParameter("@EventName", entity.EventName)
, new SqlParameter("@CalloutURL", entity.CalloutUrl)
, new SqlParameter("@XmlPackage", entity.XmlPackage)
, new SqlParameter("@Debug", entity.Debug)
, new SqlParameter("@Active", entity.Active)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetEventHandler(Convert.ToInt32(identity)));
}
return(entity);
}
