/// <summary>
/// Updates a DemoRegistration record and returns the number of records affected
/// </summary>
public static int Update(DemoRegistrationDO DO, DalapiTransaction Transaction)
{
SqlParameter _DemoRegistrationId = new SqlParameter("DemoRegistrationId", SqlDbType.Int);
SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar);
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar);
SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar);
SqlParameter _Submitted = new SqlParameter("Submitted", SqlDbType.DateTime);
SqlParameter _Code = new SqlParameter("Code", SqlDbType.VarChar);
_DemoRegistrationId.Value = DO.DemoRegistrationId;
_CompanyName.Value = DO.CompanyName;
_Name.Value = DO.Name;
_Email.Value = DO.Email;
_Phone.Value = DO.Phone;
_Submitted.Value = DO.Submitted;
_Code.Value = DO.Code;
SqlParameter[] _params = new SqlParameter[] {
_DemoRegistrationId,
_CompanyName,
_Name,
_Email,
_Phone,
_Submitted,
_Code
};
string pid = ConfigurationManager.AppSettings["PID"];
return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Update]", pid), _params, pid, Transaction));
}
/// <summary>
/// Creates a new DemoRegistration record
/// </summary>
public int Create(DemoRegistrationDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyName = new SqlParameter("CompanyName", SqlDbType.VarChar);
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _Email = new SqlParameter("Email", SqlDbType.VarChar);
SqlParameter _Phone = new SqlParameter("Phone", SqlDbType.VarChar);
SqlParameter _Submitted = new SqlParameter("Submitted", SqlDbType.DateTime);
SqlParameter _Code = new SqlParameter("Code", SqlDbType.VarChar);
_CompanyName.Value = DO.CompanyName;
_Name.Value = DO.Name;
_Email.Value = DO.Email;
_Phone.Value = DO.Phone;
_Submitted.Value = DO.Submitted;
_Code.Value = DO.Code;
SqlParameter[] _params = new SqlParameter[] {
_CompanyName,
_Name,
_Email,
_Phone,
_Submitted,
_Code
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Insert]", pid), _params, pid, Transaction));
}
/// <summary>
/// Deletes a Company record
/// </summary>
public int Delete(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
_CompanyId.Value = DO.CompanyId;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Delete]", pid), _params, pid, Transaction));
}
/// <summary>
/// Deletes a DemoRegistration record
/// </summary>
public int Delete(DemoRegistrationDO DO, DalapiTransaction Transaction)
{
SqlParameter _DemoRegistrationId = new SqlParameter("DemoRegistrationId", SqlDbType.Int);
_DemoRegistrationId.Value = DO.DemoRegistrationId;
SqlParameter[] _params = new SqlParameter[] {
_DemoRegistrationId
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[DemoRegistration_Delete]", pid), _params, pid, Transaction));
}
/// <summary>
/// Deletes a Company record
/// </summary>
public static int Delete(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
_CompanyId.Value = DO.CompanyId;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId
};
string pid = ConfigurationManager.AppSettings["PID"];
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Delete]", pid), _params, pid, Transaction));
}
/// <summary>
/// Creates a new Company record
/// </summary>
public int Create(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _PhoneNumber = new SqlParameter("PhoneNumber", SqlDbType.VarChar);
_Name.Value = DO.Name;
_PhoneNumber.Value = DO.PhoneNumber;
SqlParameter[] _params = new SqlParameter[] {
_Name,
_PhoneNumber
};
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Insert]", pid), _params, pid, Transaction));
}
/// <summary>
/// Updates a Company record and returns the number of records affected
/// </summary>
public static int Update(CompanyDO DO, DalapiTransaction Transaction)
{
SqlParameter _CompanyId = new SqlParameter("CompanyId", SqlDbType.Int);
SqlParameter _Name = new SqlParameter("Name", SqlDbType.VarChar);
SqlParameter _PhoneNumber = new SqlParameter("PhoneNumber", SqlDbType.VarChar);
_CompanyId.Value = DO.CompanyId;
_Name.Value = DO.Name;
_PhoneNumber.Value = DO.PhoneNumber;
SqlParameter[] _params = new SqlParameter[] {
_CompanyId,
_Name,
_PhoneNumber
};
string pid = ConfigurationManager.AppSettings["PID"];
return(DataCommon.ExecuteScalar(String.Format("[{0}].[Company_Update]", pid), _params, pid, Transaction));
}
/// <summary>
/// Truncates the Company Table
/// </summary>
public static void Truncate(DalapiTransaction Transaction)
{
string pid = ConfigurationManager.AppSettings["PID"];
DataCommon.TruncateTable(pid, "Company", Transaction);
}
/// <summary>
/// Truncates the Company Table
/// </summary>
public void Truncate(DalapiTransaction Transaction)
{
DataCommon.TruncateTable(pid, "Company", Transaction);
}
/// <summary>
/// Truncates the DemoRegistration Table
/// </summary>
public void Truncate(DalapiTransaction Transaction)
{
DataCommon.TruncateTable(pid, "DemoRegistration", Transaction);
}
