public static AspdnsfEventHandler Create(string EventName, string CalloutURL, string XmlPackage, bool Active, bool Debug)
{
var EventID = 0;
if (EventName.Trim().Length == 0)
{
return(null);
}
if (CalloutURL.Trim().Length == 0)
{
return(null);
}
if (XmlPackage.Trim().Length == 0)
{
return(null);
}
using (var cn = new SqlConnection(DB.GetDBConn()))
{
cn.Open();
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.aspdnsf_insEventHandler";
cmd.Parameters.Add(new SqlParameter("@EventName", SqlDbType.NVarChar, 20));
cmd.Parameters.Add(new SqlParameter("@CalloutURL", SqlDbType.VarChar, 200));
cmd.Parameters.Add(new SqlParameter("@XmlPackage", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit));
cmd.Parameters.Add(new SqlParameter("@Debug", SqlDbType.Bit));
cmd.Parameters.Add(new SqlParameter("@EventID", SqlDbType.Int, 4)).Direction = ParameterDirection.Output;
cmd.Parameters["@EventName"].Value = EventName;
cmd.Parameters["@CalloutURL"].Value = CalloutURL;
cmd.Parameters["@XmlPackage"].Value = XmlPackage;
cmd.Parameters["@Active"].Value = Active;
cmd.Parameters["@Debug"].Value = Debug;
try
{
cmd.ExecuteNonQuery();
EventID = Int32.Parse(cmd.Parameters["@EventID"].Value.ToString());
}
catch (Exception ex)
{
SysLog.LogException(ex, MessageTypeEnum.DatabaseException, MessageSeverityEnum.Error);
}
}
}
if (EventID > 0)
{
AspdnsfEventHandler a = new AspdnsfEventHandler(EventID);
return(a);
}
return(null);
}
public string Update(SqlParameter[] spa)
{
return(AspdnsfEventHandler.Update(this.EventID, spa));
}
/// <summary>
/// Creates a new EventHandler record and adds it to the collection
/// </summary>
public void Add(string EventName, string CalloutURL, string XmlPackage, bool Active, bool Debug)
{
this.Add(AspdnsfEventHandler.Create(EventName, CalloutURL.Trim(), XmlPackage.Trim(), Active, Debug));
}
public static AspdnsfEventHandler Create(string EventName, string CalloutURL, string XmlPackage, bool Active, bool Debug)
{
int EventID = 0;
if (EventName.Trim().Length == 0)
{
return(null);
}
if (CalloutURL.Trim().Length == 0)
{
return(null);
}
if (XmlPackage.Trim().Length == 0)
{
return(null);
}
string err = String.Empty;
SqlConnection cn = new SqlConnection(DB.GetDBConn());
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.aspdnsf_insEventHandler";
cmd.Parameters.Add(new SqlParameter("@EventName", SqlDbType.NVarChar, 20));
cmd.Parameters.Add(new SqlParameter("@CalloutURL", SqlDbType.VarChar, 200));
cmd.Parameters.Add(new SqlParameter("@XmlPackage", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit));
cmd.Parameters.Add(new SqlParameter("@Debug", SqlDbType.Bit));
cmd.Parameters.Add(new SqlParameter("@EventID", SqlDbType.Int, 4)).Direction = ParameterDirection.Output;
cmd.Parameters["@EventName"].Value = EventName;
cmd.Parameters["@CalloutURL"].Value = CalloutURL;
cmd.Parameters["@XmlPackage"].Value = XmlPackage;
cmd.Parameters["@Active"].Value = Active;
cmd.Parameters["@Debug"].Value = Debug;
try
{
cmd.ExecuteNonQuery();
EventID = Int32.Parse(cmd.Parameters["@EventID"].Value.ToString());
}
catch (Exception ex)
{
err = ex.Message;
}
cn.Close();
cmd.Dispose();
cn.Dispose();
if (EventID > 0)
{
AspdnsfEventHandler a = new AspdnsfEventHandler(EventID);
return(a);
}
return(null);
}
/// <summary>
/// Adds an existing EventHandlerClass object to the collection
/// </summary>
public void Add(AspdnsfEventHandler eventhandler)
{
m_EventHandlers.Add(eventhandler.EventName.ToLowerInvariant(), eventhandler);
}