/// <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>
/// Updates a Property record and returns the number of records affected
/// </summary>
public static int Update(PropertyDO DO)
{
SqlParameter _PropertyId = new SqlParameter("PropertyId", SqlDbType.Int);
SqlParameter _PageId = new SqlParameter("PageId", SqlDbType.Int);
SqlParameter _ArticleHtml = new SqlParameter("ArticleHtml", SqlDbType.VarChar);
SqlParameter _Lat = new SqlParameter("Lat", SqlDbType.VarChar);
SqlParameter _Long = new SqlParameter("Long", SqlDbType.VarChar);
SqlParameter _PhotoUrl = new SqlParameter("PhotoUrl", SqlDbType.VarChar);
SqlParameter _PhotoCaption = new SqlParameter("PhotoCaption", SqlDbType.VarChar);
SqlParameter _Price = new SqlParameter("Price", SqlDbType.VarChar);
SqlParameter _SoldDate = new SqlParameter("SoldDate", SqlDbType.VarChar);
SqlParameter _Zestimate = new SqlParameter("Zestimate", SqlDbType.VarChar);
SqlParameter _PriceSQFt = new SqlParameter("PriceSQFt", SqlDbType.VarChar);
SqlParameter _Address = new SqlParameter("Address", SqlDbType.VarChar);
SqlParameter _PropertyData = new SqlParameter("PropertyData", SqlDbType.VarChar);
SqlParameter _LotSize = new SqlParameter("LotSize", SqlDbType.VarChar);
SqlParameter _YearBuilt = new SqlParameter("YearBuilt", SqlDbType.VarChar);
_PropertyId.Value = DO.PropertyId;
_PageId.Value = DO.PageId;
_ArticleHtml.Value = DO.ArticleHtml;
_Lat.Value = DO.Lat;
_Long.Value = DO.Long;
_PhotoUrl.Value = DO.PhotoUrl;
_PhotoCaption.Value = DO.PhotoCaption;
_Price.Value = DO.Price;
_SoldDate.Value = DO.SoldDate;
_Zestimate.Value = DO.Zestimate;
_PriceSQFt.Value = DO.PriceSQFt;
_Address.Value = DO.Address;
_PropertyData.Value = DO.PropertyData;
_LotSize.Value = DO.LotSize;
_YearBuilt.Value = DO.YearBuilt;
SqlParameter[] _params = new SqlParameter[] {
_PropertyId,
_PageId,
_ArticleHtml,
_Lat,
_Long,
_PhotoUrl,
_PhotoCaption,
_Price,
_SoldDate,
_Zestimate,
_PriceSQFt,
_Address,
_PropertyData,
_LotSize,
_YearBuilt
};
return(DataCommon.ExecuteScalar("[dbo].[Property_Update]", _params, "dbo"));
}
/// <summary>
/// Deletes a Page record
/// </summary>
public static int Delete(PageDO DO)
{
SqlParameter _PageId = new SqlParameter("PageId", SqlDbType.Int);
_PageId.Value = DO.PageId;
SqlParameter[] _params = new SqlParameter[] {
_PageId
};
return(DataCommon.ExecuteScalar("[dbo].[Page_Delete]", _params, "dbo"));
}
/// <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>
/// Creates a new Page record
/// </summary>
public static int Create(PageDO DO)
{
SqlParameter _Url = new SqlParameter("Url", SqlDbType.VarChar);
SqlParameter _DownloadDate = new SqlParameter("DownloadDate", SqlDbType.DateTime);
SqlParameter _Html = new SqlParameter("Html", SqlDbType.VarChar);
_Url.Value = DO.Url;
_DownloadDate.Value = DO.DownloadDate;
_Html.Value = DO.Html;
SqlParameter[] _params = new SqlParameter[] {
_Url,
_DownloadDate,
_Html
};
return(DataCommon.ExecuteScalar("[dbo].[Page_Insert]", _params, "dbo"));
}
/// <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));
}
