/// <summary>
/// Inserts a row in the mp_SystemLog table. Returns new integer id.
/// </summary>
/// <param name="logDate"> logDate </param>
/// <param name="ipAddress"> ipAddress </param>
/// <param name="culture"> culture </param>
/// <param name="url"> url </param>
/// <param name="shortUrl"> shortUrl </param>
/// <param name="thread"> thread </param>
/// <param name="logLevel"> logLevel </param>
/// <param name="logger"> logger </param>
/// <param name="message"> message </param>
/// <returns>int</returns>
public int Create(
DateTime logDate,
string ipAddress,
string culture,
string url,
string shortUrl,
string thread,
string logLevel,
string logger,
string message)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SystemLog_Insert",
9);
sph.DefineSqlParameter("@LogDate", SqlDbType.DateTime, ParameterDirection.Input, logDate);
sph.DefineSqlParameter("@IpAddress", SqlDbType.NVarChar, 50, ParameterDirection.Input, ipAddress);
sph.DefineSqlParameter("@Culture", SqlDbType.NVarChar, 10, ParameterDirection.Input, culture);
sph.DefineSqlParameter("@Url", SqlDbType.NVarChar, -1, ParameterDirection.Input, url);
sph.DefineSqlParameter("@ShortUrl", SqlDbType.NVarChar, 255, ParameterDirection.Input, shortUrl);
sph.DefineSqlParameter("@Thread", SqlDbType.NVarChar, 255, ParameterDirection.Input, thread);
sph.DefineSqlParameter("@LogLevel", SqlDbType.NVarChar, 20, ParameterDirection.Input, logLevel);
sph.DefineSqlParameter("@Logger", SqlDbType.NVarChar, 255, ParameterDirection.Input, logger);
sph.DefineSqlParameter("@Message", SqlDbType.NVarChar, -1, ParameterDirection.Input, message);
int newID = Convert.ToInt32(sph.ExecuteScalar());
return newID;
}
//public DbDataReader GetSmartDropDownData(int siteId, string query, int rowsToGet)
//{
// SqlParameterHelper sph = new SqlParameterHelper(
// logFactory,
// readConnectionString,
// "mp_Users_SmartDropDown",
// 3);
// sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
// sph.DefineSqlParameter("@Query", SqlDbType.NVarChar, 50, ParameterDirection.Input, query);
// sph.DefineSqlParameter("@RowsToGet", SqlDbType.Int, ParameterDirection.Input, rowsToGet);
// return sph.ExecuteReader();
//}
public DbDataReader EmailLookup(int siteId, string query, int rowsToGet)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_EmailLookup",
3);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@Query", SqlDbType.NVarChar, 50, ParameterDirection.Input, query);
sph.DefineSqlParameter("@RowsToGet", SqlDbType.Int, ParameterDirection.Input, rowsToGet);
return sph.ExecuteReader();
}
public async Task<bool> Update(int roleId, string roleName)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Roles_Update",
2);
sph.DefineSqlParameter("@RoleID", SqlDbType.Int, ParameterDirection.Input, roleId);
sph.DefineSqlParameter("@RoleName", SqlDbType.NVarChar, 50, ParameterDirection.Input, roleName);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > -1);
}
public async Task<bool> DeleteByUser(int siteId, string userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserClaims_DeleteByUser",
2);
sph.DefineSqlParameter("@UserId", SqlDbType.NVarChar, 128, ParameterDirection.Input, userId);
sph.DefineSqlParameter("@SiteId", SqlDbType.Int, ParameterDirection.Input, siteId);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > 0);
}
/// <summary>
/// Deletes a row from the mp_UserLogins table. Returns true if row deleted.
/// </summary>
/// <param name="loginProvider"> loginProvider </param>
/// <param name="providerKey"> providerKey </param>
/// <param name="userId"> userId </param>
/// <returns>bool</returns>
public async Task<bool> Delete(int siteId, string loginProvider, string providerKey, string userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserLogins_Delete",
4);
sph.DefineSqlParameter("@LoginProvider", SqlDbType.NVarChar, 128, ParameterDirection.Input, loginProvider);
sph.DefineSqlParameter("@ProviderKey", SqlDbType.NVarChar, 128, ParameterDirection.Input, providerKey);
sph.DefineSqlParameter("@UserId", SqlDbType.NVarChar, 128, ParameterDirection.Input, userId);
sph.DefineSqlParameter("@SiteId", SqlDbType.Int, ParameterDirection.Input, siteId);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > 0);
}
public async Task<bool> Update(
Guid guid,
Guid siteGuid,
string folderName)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SiteFolders_Update",
3);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@FolderName", SqlDbType.NVarChar, 255, ParameterDirection.Input, folderName);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > -1);
}
/// <summary>
/// Inserts a row in the mp_BannedIPAddresses table. Returns new integer id.
/// </summary>
/// <param name="bannedIP"> bannedIP </param>
/// <param name="bannedUTC"> bannedUTC </param>
/// <param name="bannedReason"> bannedReason </param>
/// <returns>int</returns>
public int Add(
string bannedIP,
DateTime bannedUtc,
string bannedReason)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_BannedIPAddresses_Insert",
3);
sph.DefineSqlParameter("@BannedIP", SqlDbType.NVarChar, 50, ParameterDirection.Input, bannedIP);
sph.DefineSqlParameter("@BannedUTC", SqlDbType.DateTime, ParameterDirection.Input, bannedUtc);
sph.DefineSqlParameter("@BannedReason", SqlDbType.NVarChar, 255, ParameterDirection.Input, bannedReason);
int newID = Convert.ToInt32(sph.ExecuteScalar());
return newID;
}
/// <summary>
/// Inserts a row in the mp_RedirectList table. Returns rows affected count.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="siteID"> siteID </param>
/// <param name="oldUrl"> oldUrl </param>
/// <param name="newUrl"> newUrl </param>
/// <param name="createdUtc"> createdUtc </param>
/// <param name="expireUtc"> expireUtc </param>
/// <returns>int</returns>
public int Create(
Guid rowGuid,
Guid siteGuid,
int siteID,
string oldUrl,
string newUrl,
DateTime createdUtc,
DateTime expireUtc)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_RedirectList_Insert",
7);
sph.DefineSqlParameter("@RowGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, rowGuid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteID);
sph.DefineSqlParameter("@OldUrl", SqlDbType.NVarChar, 255, ParameterDirection.Input, oldUrl);
sph.DefineSqlParameter("@NewUrl", SqlDbType.NVarChar, 255, ParameterDirection.Input, newUrl);
sph.DefineSqlParameter("@CreatedUtc", SqlDbType.DateTime, ParameterDirection.Input, createdUtc);
sph.DefineSqlParameter("@ExpireUtc", SqlDbType.DateTime, ParameterDirection.Input, expireUtc);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
/// <summary>
/// Inserts a row in the mp_UserLocation table. Returns rows affected count.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="iPAddress"> iPAddress </param>
/// <param name="iPAddressLong"> iPAddressLong </param>
/// <param name="hostname"> hostname </param>
/// <param name="longitude"> longitude </param>
/// <param name="latitude"> latitude </param>
/// <param name="iSP"> iSP </param>
/// <param name="continent"> continent </param>
/// <param name="country"> country </param>
/// <param name="region"> region </param>
/// <param name="city"> city </param>
/// <param name="timeZone"> timeZone </param>
/// <param name="captureCount"> captureCount </param>
/// <param name="firstCaptureUTC"> firstCaptureUTC </param>
/// <param name="lastCaptureUTC"> lastCaptureUTC </param>
/// <returns>int</returns>
public int Create(
Guid rowID,
Guid userGuid,
Guid siteGuid,
string iPAddress,
long iPAddressLong,
string hostname,
double longitude,
double latitude,
string iSP,
string continent,
string country,
string region,
string city,
string timeZone,
int captureCount,
DateTime firstCaptureUTC,
DateTime lastCaptureUTC)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserLocation_Insert",
17);
sph.DefineSqlParameter("@RowID", SqlDbType.UniqueIdentifier, ParameterDirection.Input, rowID);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@IPAddress", SqlDbType.NVarChar, 50, ParameterDirection.Input, iPAddress);
sph.DefineSqlParameter("@IPAddressLong", SqlDbType.BigInt, ParameterDirection.Input, iPAddressLong);
sph.DefineSqlParameter("@Hostname", SqlDbType.NVarChar, 255, ParameterDirection.Input, hostname);
sph.DefineSqlParameter("@Longitude", SqlDbType.Float, ParameterDirection.Input, longitude);
sph.DefineSqlParameter("@Latitude", SqlDbType.Float, ParameterDirection.Input, latitude);
sph.DefineSqlParameter("@ISP", SqlDbType.NVarChar, 255, ParameterDirection.Input, iSP);
sph.DefineSqlParameter("@Continent", SqlDbType.NVarChar, 255, ParameterDirection.Input, continent);
sph.DefineSqlParameter("@Country", SqlDbType.NVarChar, 255, ParameterDirection.Input, country);
sph.DefineSqlParameter("@Region", SqlDbType.NVarChar, 255, ParameterDirection.Input, region);
sph.DefineSqlParameter("@City", SqlDbType.NVarChar, 255, ParameterDirection.Input, city);
sph.DefineSqlParameter("@TimeZone", SqlDbType.NVarChar, 255, ParameterDirection.Input, timeZone);
sph.DefineSqlParameter("@CaptureCount", SqlDbType.Int, ParameterDirection.Input, captureCount);
sph.DefineSqlParameter("@FirstCaptureUTC", SqlDbType.DateTime, ParameterDirection.Input, firstCaptureUTC);
sph.DefineSqlParameter("@LastCaptureUTC", SqlDbType.DateTime, ParameterDirection.Input, lastCaptureUTC);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
public async Task<bool> Add(
Guid guid,
Guid siteGuid,
string folderName,
CancellationToken cancellationToken)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SiteFolders_Insert",
3);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@FolderName", SqlDbType.NVarChar, 255, ParameterDirection.Input, folderName);
int rowsAffected = await sph.ExecuteNonQueryAsync(cancellationToken);
return rowsAffected > 0;
}
/// <summary>
/// Updates a row in the mp_BannedIPAddresses table. Returns true if row updated.
/// </summary>
/// <param name="rowID"> rowID </param>
/// <param name="bannedIP"> bannedIP </param>
/// <param name="bannedUTC"> bannedUTC </param>
/// <param name="bannedReason"> bannedReason </param>
/// <returns>bool</returns>
public bool Update(
int rowId,
string bannedIP,
DateTime bannedUtc,
string bannedReason)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_BannedIPAddresses_Update",
4);
sph.DefineSqlParameter("@RowID", SqlDbType.Int, ParameterDirection.Input, rowId);
sph.DefineSqlParameter("@BannedIP", SqlDbType.NVarChar, 50, ParameterDirection.Input, bannedIP);
sph.DefineSqlParameter("@BannedUTC", SqlDbType.DateTime, ParameterDirection.Input, bannedUtc);
sph.DefineSqlParameter("@BannedReason", SqlDbType.NVarChar, 255, ParameterDirection.Input, bannedReason);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);
}
public async Task<int> RoleCreate(
Guid roleGuid,
Guid siteGuid,
int siteId,
string roleName)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Roles_Insert",
4);
sph.DefineSqlParameter("@RoleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, roleGuid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@RoleName", SqlDbType.NVarChar, 50, ParameterDirection.Input, roleName);
object result = await sph.ExecuteScalarAsync();
int newID = Convert.ToInt32(result);
return newID;
}
public DbDataReader GetSiteSettingsExList(int siteId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_SiteSettingsEx_SelectAll",
1);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
return sph.ExecuteReader();
}
/// <summary>
/// Inserts a row in the mp_Language table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="name"> name </param>
/// <param name="code"> code </param>
/// <param name="sort"> sort </param>
/// <returns>int</returns>
public async Task<bool> Create(
Guid guid,
string name,
string code,
int sort)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Language_Insert",
4);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 255, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Code", SqlDbType.NChar, 2, ParameterDirection.Input, code);
sph.DefineSqlParameter("@Sort", SqlDbType.Int, ParameterDirection.Input, sort);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return rowsAffected > 0;
}
/// <summary>
/// Updates a row in the mp_GeoZone table. Returns true if row updated.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="countryGuid"> countryGuid </param>
/// <param name="name"> name </param>
/// <param name="code"> code </param>
/// <returns>bool</returns>
public async Task<bool> Update(
Guid guid,
Guid countryGuid,
string name,
string code)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_GeoZone_Update",
4);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@CountryGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, countryGuid);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 255, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Code", SqlDbType.NVarChar, 255, ParameterDirection.Input, code);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the mp_GeoCountry table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="name"> name </param>
/// <param name="iSOCode2"> iSOCode2 </param>
/// <param name="iSOCode3"> iSOCode3 </param>
/// <returns>int</returns>
public async Task<bool> Create(
Guid guid,
string name,
string iSOCode2,
string iSOCode3)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_GeoCountry_Insert",
4);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 255, ParameterDirection.Input, name);
sph.DefineSqlParameter("@ISOCode2", SqlDbType.NChar, 2, ParameterDirection.Input, iSOCode2);
sph.DefineSqlParameter("@ISOCode3", SqlDbType.NChar, 3, ParameterDirection.Input, iSOCode3);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return rowsAffected > 0;
}
public DbDataReader GetUserCountByYearMonth(int siteId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_GetCountByMonthYear",
1);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
return sph.ExecuteReader();
}
public async Task<int> Create(
int siteId,
string userId,
string claimType,
string claimValue)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserClaims_Insert",
4);
sph.DefineSqlParameter("@UserId", SqlDbType.NVarChar, 128, ParameterDirection.Input, userId);
sph.DefineSqlParameter("@ClaimType", SqlDbType.NVarChar, -1, ParameterDirection.Input, claimType);
sph.DefineSqlParameter("@ClaimValue", SqlDbType.NVarChar, -1, ParameterDirection.Input, claimValue);
sph.DefineSqlParameter("@SiteId", SqlDbType.Int, ParameterDirection.Input, siteId);
object result = await sph.ExecuteScalarAsync();
int newID = Convert.ToInt32(result);
return newID;
}
public async Task<bool> Delete(Guid guid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SiteFolders_Delete",
1);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > -1);
}
public async Task<bool> Delete(int id)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserClaims_Delete",
1);
sph.DefineSqlParameter("@Id", SqlDbType.Int, ParameterDirection.Input, id);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > 0);
}
public bool SaveExpandoProperty(
int siteId,
Guid siteGuid,
string groupName,
string keyName,
string keyValue)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SiteSettingsEx_Save",
5);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@KeyName", SqlDbType.NVarChar, 128, ParameterDirection.Input, keyName);
sph.DefineSqlParameter("@KeyValue", SqlDbType.NVarChar, -1, ParameterDirection.Input, keyValue);
sph.DefineSqlParameter("@GroupName", SqlDbType.NVarChar, 255, ParameterDirection.Input, keyName);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > -1);
}
/// <summary>
/// Inserts a row in the mp_UserLogins table. Returns new integer id.
/// </summary>
/// <returns>int</returns>
public async Task<bool> Create(
int siteId,
string loginProvider,
string providerKey,
string providerDisplayName,
string userId,
CancellationToken cancellationToken)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_UserLogins_Insert",
5);
sph.DefineSqlParameter("@LoginProvider", SqlDbType.NVarChar, 128, ParameterDirection.Input, loginProvider);
sph.DefineSqlParameter("@ProviderKey", SqlDbType.NVarChar, 128, ParameterDirection.Input, providerKey);
sph.DefineSqlParameter("@UserId", SqlDbType.NVarChar, 128, ParameterDirection.Input, userId);
sph.DefineSqlParameter("@SiteId", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@ProviderDisplayName", SqlDbType.NVarChar, 100, ParameterDirection.Input, providerDisplayName);
int rowsAffected = await sph.ExecuteNonQueryAsync(cancellationToken);
return (rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the mp_TaskQueue table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="queuedBy"> queuedBy </param>
/// <param name="taskName"> taskName </param>
/// <param name="notifyOnCompletion"> notifyOnCompletion </param>
/// <param name="notificationToEmail"> notificationToEmail </param>
/// <param name="notificationFromEmail"> notificationFromEmail </param>
/// <param name="notificationSubject"> notificationSubject </param>
/// <param name="taskCompleteMessage"> taskCompleteMessage </param>
/// <param name="canStop"> canStop </param>
/// <param name="canResume"> canResume </param>
/// <param name="updateFrequency"> updateFrequency </param>
/// <param name="queuedUTC"> queuedUTC </param>
/// <param name="completeRatio"> completeRatio </param>
/// <param name="status"> status </param>
/// <param name="serializedTaskObject"> serializedTaskObject </param>
/// <param name="serializedTaskType"> serializedTaskType </param>
/// <returns>int</returns>
public int Create(
Guid guid,
Guid siteGuid,
Guid queuedBy,
string taskName,
bool notifyOnCompletion,
string notificationToEmail,
string notificationFromEmail,
string notificationSubject,
string taskCompleteMessage,
bool canStop,
bool canResume,
int updateFrequency,
DateTime queuedUTC,
double completeRatio,
string status,
string serializedTaskObject,
string serializedTaskType)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_TaskQueue_Insert",
17);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@QueuedBy", SqlDbType.UniqueIdentifier, ParameterDirection.Input, queuedBy);
sph.DefineSqlParameter("@TaskName", SqlDbType.NVarChar, 255, ParameterDirection.Input, taskName);
sph.DefineSqlParameter("@NotifyOnCompletion", SqlDbType.Bit, ParameterDirection.Input, notifyOnCompletion);
sph.DefineSqlParameter("@NotificationToEmail", SqlDbType.NVarChar, 255, ParameterDirection.Input, notificationToEmail);
sph.DefineSqlParameter("@NotificationFromEmail", SqlDbType.NVarChar, 255, ParameterDirection.Input, notificationFromEmail);
sph.DefineSqlParameter("@NotificationSubject", SqlDbType.NVarChar, 255, ParameterDirection.Input, notificationSubject);
sph.DefineSqlParameter("@TaskCompleteMessage", SqlDbType.NVarChar, -1, ParameterDirection.Input, taskCompleteMessage);
sph.DefineSqlParameter("@CanStop", SqlDbType.Bit, ParameterDirection.Input, canStop);
sph.DefineSqlParameter("@CanResume", SqlDbType.Bit, ParameterDirection.Input, canResume);
sph.DefineSqlParameter("@UpdateFrequency", SqlDbType.Int, ParameterDirection.Input, updateFrequency);
sph.DefineSqlParameter("@QueuedUTC", SqlDbType.DateTime, ParameterDirection.Input, queuedUTC);
sph.DefineSqlParameter("@CompleteRatio", SqlDbType.Float, ParameterDirection.Input, completeRatio);
sph.DefineSqlParameter("@Status", SqlDbType.NVarChar, 255, ParameterDirection.Input, status);
sph.DefineSqlParameter("@SerializedTaskObject", SqlDbType.NVarChar, -1, ParameterDirection.Input, serializedTaskObject);
sph.DefineSqlParameter("@SerializedTaskType", SqlDbType.NVarChar, 255, ParameterDirection.Input, serializedTaskType);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
public static IDataReader GetPageByAuthor(
int pageNumber,
int pageSize,
out int totalPages, int AuthorID, string keyword, bool isdraft, bool isapoproved, bool all)
{
totalPages = 1;
int totalRows
= GetCountByAuthor(AuthorID);
if (pageSize > 0)
{
totalPages = totalRows / pageSize;
}
if (totalRows <= pageSize)
{
totalPages = 1;
}
else
{
int remainder;
Math.DivRem(totalRows, pageSize, out remainder);
if (remainder > 0)
{
totalPages += 1;
}
}
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_KLNews_SelectPageByAuthorID", 7);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
sph.DefineSqlParameter("@Authorid", SqlDbType.Int, ParameterDirection.Input, AuthorID);
sph.DefineSqlParameter("@Keyword", SqlDbType.NVarChar, 100, ParameterDirection.Input, keyword);
sph.DefineSqlParameter("@all", SqlDbType.Bit, ParameterDirection.Input, all);
sph.DefineSqlParameter("@Isapproved", SqlDbType.Bit, ParameterDirection.Input, isapoproved);
sph.DefineSqlParameter("@Isdraft", SqlDbType.Bit, ParameterDirection.Input, isdraft);
return(sph.ExecuteReader());
}
public static bool Update(
Guid productGuid,
string fileName,
byte[] fileImage,
string serverFileName,
int byteLength,
DateTime created,
Guid createdBy)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_ProductFile_Update", 7);
sph.DefineSqlParameter("@ProductGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, productGuid);
sph.DefineSqlParameter("@FileName", SqlDbType.NVarChar, 255, ParameterDirection.Input, fileName);
sph.DefineSqlParameter("@FileImage", SqlDbType.Image, ParameterDirection.Input, fileImage);
sph.DefineSqlParameter("@ServerFileName", SqlDbType.NVarChar, 255, ParameterDirection.Input, serverFileName);
sph.DefineSqlParameter("@ByteLength", SqlDbType.Int, ParameterDirection.Input, byteLength);
sph.DefineSqlParameter("@Created", SqlDbType.DateTime, ParameterDirection.Input, created);
sph.DefineSqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier, ParameterDirection.Input, createdBy);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Updates a row in the doan_MediaTracks table.
/// </summary>
/// <param name="trackID">The ID of the track.</param>
/// <param name="playerID">The ID of the player instance.</param>
/// <param name="trackType">The type of the track.</param>
/// <param name="trackOrder">The order position of the Media Track.</param>
/// <param name="name">The name of the Media Track.</param>
/// <param name="artist">The artist of the Media Track.</param>
/// <param name="userGuid">The Guid of the user who added the Media Track.</param>
/// <returns>True if the row is successfully updated.</returns>
public static bool Update(
int trackId,
int playerId,
string trackType,
int trackOrder,
string name,
string artist,
Guid userGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "mp_MediaTrack_Update", 7);
sph.DefineSqlParameter("@TrackID", SqlDbType.Int, ParameterDirection.Input, trackId);
sph.DefineSqlParameter("@PlayerID", SqlDbType.Int, ParameterDirection.Input, playerId);
sph.DefineSqlParameter("@TrackType", SqlDbType.NVarChar, 10, ParameterDirection.Input, trackType);
sph.DefineSqlParameter("@TrackOrder", SqlDbType.Int, ParameterDirection.Input, trackOrder);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Artist", SqlDbType.NVarChar, 100, ParameterDirection.Input, artist);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static bool Update(
Guid guid,
int productID,
int customFieldID,
int customFieldOptionID,
string customValue,
int stockQuantity,
decimal overriddenPrice)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "gb_ProductProperties_Update", 7);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@ProductID", SqlDbType.Int, ParameterDirection.Input, productID);
sph.DefineSqlParameter("@CustomFieldID", SqlDbType.Int, ParameterDirection.Input, customFieldID);
sph.DefineSqlParameter("@CustomFieldOptionID", SqlDbType.Int, ParameterDirection.Input, customFieldOptionID);
sph.DefineSqlParameter("@CustomValue", SqlDbType.NVarChar, -1, ParameterDirection.Input, customValue);
sph.DefineSqlParameter("@StockQuantity", SqlDbType.Int, ParameterDirection.Input, stockQuantity);
sph.DefineSqlParameter("@OverriddenPrice", SqlDbType.Decimal, ParameterDirection.Input, overriddenPrice);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the i7_sflexi_values table. Returns rows affected count.
/// </summary>
/// <param name="valueGuid"> valueGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="featureGuid"> featureGuid </param>
/// <param name="moduleGuid"> moduleGuid </param>
/// <param name="itemGuid"> itemGuid </param>
/// <param name="fieldGuid"> fieldGuid </param>
/// <param name="fieldValue"> fieldValue </param>
/// <returns>int</returns>
public static int Create(
Guid valueGuid,
Guid siteGuid,
Guid featureGuid,
Guid moduleGuid,
Guid itemGuid,
Guid fieldGuid,
string fieldValue)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "i7_sflexi_values_Insert", 7);
sph.DefineSqlParameter("@ValueGuid", MyMySqlDbType.Guid, ParameterDirection.Input, valueGuid);
sph.DefineSqlParameter("@SiteGuid", MyMySqlDbType.Guid, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@FeatureGuid", MyMySqlDbType.Guid, ParameterDirection.Input, featureGuid);
sph.DefineSqlParameter("@ModuleGuid", MyMySqlDbType.Guid, ParameterDirection.Input, moduleGuid);
sph.DefineSqlParameter("@ItemGuid", MyMySqlDbType.Guid, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@FieldGuid", MyMySqlDbType.Guid, ParameterDirection.Input, fieldGuid);
sph.DefineSqlParameter("@FieldValue", MySqlDbType.Text, ParameterDirection.Input, fieldValue);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected);
}
public static bool Update(
Guid guid,
Guid orderGuid,
Guid offerGuid,
Guid productGuid,
byte fullfillType,
Guid fullfillTermsGuid,
DateTime created)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_OrderOfferProduct_Update", 7);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@OrderGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, orderGuid);
sph.DefineSqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, offerGuid);
sph.DefineSqlParameter("@ProductGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, productGuid);
sph.DefineSqlParameter("@FullfillType", SqlDbType.TinyInt, ParameterDirection.Input, fullfillType);
sph.DefineSqlParameter("@FullfillTermsGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fullfillTermsGuid);
sph.DefineSqlParameter("@Created", SqlDbType.DateTime, ParameterDirection.Input, created);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static bool Update(
Guid questionGuid,
Guid surveyPageGuid,
string questionText,
int questionTypeId,
bool answerIsRequired,
int questionOrder,
string validationMessage)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "mp_SurveyQuestions_Update", 7);
sph.DefineSqlParameter("@QuestionGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, questionGuid);
sph.DefineSqlParameter("@PageGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, surveyPageGuid);
sph.DefineSqlParameter("@QuestionText", SqlDbType.NVarChar, -1, ParameterDirection.Input, questionText);
sph.DefineSqlParameter("@QuestionTypeId", SqlDbType.Int, ParameterDirection.Input, questionTypeId);
sph.DefineSqlParameter("@AnswerIsRequired", SqlDbType.Bit, ParameterDirection.Input, answerIsRequired);
sph.DefineSqlParameter("@QuestionOrder", SqlDbType.Int, ParameterDirection.Input, questionOrder);
sph.DefineSqlParameter("@ValidationMessage", SqlDbType.NVarChar, 255, ParameterDirection.Input, validationMessage);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > -1);
}
/// <summary>
/// Updates a row in the i7_sflexi_values table. Returns true if row updated.
/// </summary>
/// <param name="valueGuid"> valueGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="featureGuid"> featureGuid </param>
/// <param name="moduleGuid"> moduleGuid </param>
/// <param name="itemGuid"> itemGuid </param>
/// <param name="fieldGuid"> fieldGuid </param>
/// <param name="fieldValue"> fieldValue </param>
/// <returns>bool</returns>
public static bool Update(
Guid valueGuid,
Guid siteGuid,
Guid featureGuid,
Guid moduleGuid,
Guid itemGuid,
Guid fieldGuid,
string fieldValue)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "i7_sflexi_values_Update", 7);
sph.DefineSqlParameter("@ValueGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, valueGuid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@FeatureGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, featureGuid);
sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@FieldGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fieldGuid);
sph.DefineSqlParameter("@FieldValue", SqlDbType.NVarChar, -1, ParameterDirection.Input, fieldValue);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static bool Update(
Guid itemGuid,
Guid orderGuid,
Guid offerGuid,
Guid taxClassGuid,
decimal offerPrice,
DateTime addedToCart,
int quantity)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_OrderOffers_Update", 7);
sph.DefineSqlParameter("@ItemGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, itemGuid);
sph.DefineSqlParameter("@OrderGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, orderGuid);
sph.DefineSqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, offerGuid);
sph.DefineSqlParameter("@TaxClassGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, taxClassGuid);
sph.DefineSqlParameter("@OfferPrice", SqlDbType.Decimal, ParameterDirection.Input, offerPrice);
sph.DefineSqlParameter("@AddedToCart", SqlDbType.DateTime, ParameterDirection.Input, addedToCart);
sph.DefineSqlParameter("@Quantity", SqlDbType.Int, ParameterDirection.Input, quantity);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Gets and IDataReader for a page of items for a module
/// </summary>
/// <param name="moduleId"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="totalPages"></param>
/// <param name="searchTerm"></param>
/// <param name="searchField"></param>
/// <param name="sortField"></param>
/// <param name="descending"></param>
/// <returns></returns>
public static IDataReader GetPageOfModuleItems(
Guid moduleGuid,
int pageNumber,
int pageSize,
string searchTerm = "",
string searchField = "",
//string sortField = "",
bool descending = false)
{
SqlParameterHelper sph = null;
if (String.IsNullOrWhiteSpace(searchField) && !String.IsNullOrWhiteSpace(searchTerm))
{
sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectPageForModuleWithTerm", 5);
sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
sph.DefineSqlParameter("@SearchTerm", SqlDbType.NVarChar, -1, ParameterDirection.Input, searchTerm);
//sph.DefineSqlParameter("@sortField", SqlDbType.NVarChar, -1, ParameterDirection.Input, sortField);
sph.DefineSqlParameter("@SortDirection", SqlDbType.VarChar, 4, ParameterDirection.Input, descending ? "desc" : "asc");
}
else if (!String.IsNullOrWhiteSpace(searchField) && !String.IsNullOrWhiteSpace(searchTerm))
{
sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectPageForModuleWithTermAndField", 6);
sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
sph.DefineSqlParameter("@SearchTerm", SqlDbType.NVarChar, -1, ParameterDirection.Input, searchTerm);
sph.DefineSqlParameter("@SearchField", SqlDbType.NVarChar, -1, ParameterDirection.Input, searchField);
//sph.DefineSqlParameter("@sortField", SqlDbType.NVarChar, -1, ParameterDirection.Input, sortField);
sph.DefineSqlParameter("@SortDirection", SqlDbType.VarChar, 4, ParameterDirection.Input, descending ? "desc" : "asc");
}
else
{
sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "i7_sflexi_items_SelectPageForModule", 4);
sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
//sph.DefineSqlParameter("@sortField", SqlDbType.NVarChar, -1, ParameterDirection.Input, sortField);
sph.DefineSqlParameter("@SortDirection", SqlDbType.VarChar, 4, ParameterDirection.Input, descending ? "desc" : "asc");
}
return(sph.ExecuteReader());
}
public static IDataReader GetPageByAuthor(
int pageNumber,
int pageSize,
out int totalPages, int authorid, int isapproved, int newtype, int newsid, int parentid)
{
totalPages = 1;
int totalRows
= GetCount();
if (pageSize > 0)
{
totalPages = totalRows / pageSize;
}
if (totalRows <= pageSize)
{
totalPages = 1;
}
else
{
int remainder;
Math.DivRem(totalRows, pageSize, out remainder);
if (remainder > 0)
{
totalPages += 1;
}
}
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_KLNewsComment_SelectPageByAuthor", 7);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
sph.DefineSqlParameter("@AuthorID", SqlDbType.Int, ParameterDirection.Input, authorid);
sph.DefineSqlParameter("@isapproved", SqlDbType.Int, ParameterDirection.Input, isapproved);
sph.DefineSqlParameter("@NewType", SqlDbType.Int, ParameterDirection.Input, newtype);
sph.DefineSqlParameter("@NewsID", SqlDbType.Int, ParameterDirection.Input, newsid);
sph.DefineSqlParameter("@ParentID", SqlDbType.Int, ParameterDirection.Input, parentid);
return(sph.ExecuteReader());
}
/// <summary>
/// Updates a row in the doan_MediaPlayers table.
/// </summary>
/// <param name="playerID">The ID of the player.</param>
/// <param name="moduleID">The ID of the Module.</param>
/// <param name="playerType">The Player Type.</param>
/// <param name="userGuid">The Guid of the user that created the Media Player.</param>
/// <param name="moduleGuid">The Guid of the Module.</param>
/// <returns>True if the update was successful.</returns>
public static bool Update(
int playerId,
int moduleId,
string playerType,
String skin,
Guid userGuid,
Guid moduleGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "mp_MediaPlayer_Update", 6);
sph.DefineSqlParameter("@PlayerID", SqlDbType.Int, ParameterDirection.Input, playerId);
sph.DefineSqlParameter("@ModuleID", SqlDbType.Int, ParameterDirection.Input, moduleId);
sph.DefineSqlParameter("@PlayerType", SqlDbType.NVarChar, 10, ParameterDirection.Input, playerType);
sph.DefineSqlParameter("@Skin", SqlDbType.NVarChar, 50, ParameterDirection.Input, skin);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@ModuleGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, moduleGuid);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the doan_MediaTracks table.
/// </summary>
/// <param name="playerID">The ID of the player to which the Media Track is being added.</param>
/// <param name="trackType">The type of the track.</param>
/// <param name="trackOrder">The order position of the Media Track.</param>
/// <param name="name">The name of the Media Track.</param>
/// <param name="artist">The artist of the Media Track.</param>
/// <param name="userGuid">The Guid of the user who added the Media Track.</param>
/// <returns>The ID of the Media Track in the doan_MediaTracks table.</returns>
public static int Insert(
int playerId,
string trackType,
int trackOrder,
string name,
string artist,
Guid userGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "mp_MediaTrack_Insert", 6);
sph.DefineSqlParameter("@PlayerID", SqlDbType.Int, ParameterDirection.Input, playerId);
sph.DefineSqlParameter("@TrackType", SqlDbType.NVarChar, 10, ParameterDirection.Input, trackType);
sph.DefineSqlParameter("@TrackOrder", SqlDbType.Int, ParameterDirection.Input, trackOrder);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Artist", SqlDbType.NVarChar, 100, ParameterDirection.Input, artist);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
int newID = Convert.ToInt32(sph.ExecuteScalar());
return(newID);
}
/// <summary>
/// Updates a row in the mp_Surveys table. Returns true if row updated.
/// </summary>
/// <param name="surveyGuid"> surveyGuid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="surveyName"> surveyName </param>
/// <param name="creationDate"> creationDate </param>
/// <param name="startPageText"> startPageText </param>
/// <param name="endPageText"> endPageText </param>
/// <returns>bool</returns>
public static bool Update(
Guid surveyGuid,
Guid siteGuid,
string surveyName,
DateTime creationDate,
string startPageText,
string endPageText)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "mp_Survey_Update", 6);
sph.DefineSqlParameter("@SurveyGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, surveyGuid);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@SurveyName", SqlDbType.NVarChar, 255, ParameterDirection.Input, surveyName);
sph.DefineSqlParameter("@CreationDate", SqlDbType.DateTime, ParameterDirection.Input, creationDate);
sph.DefineSqlParameter("@StartPageText", SqlDbType.NVarChar, -1, ParameterDirection.Input, startPageText);
sph.DefineSqlParameter("@EndPageText", SqlDbType.NVarChar, -1, ParameterDirection.Input, endPageText);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Updates a row in the gb_KLGratitude table. Returns true if row updated.
/// </summary>
/// <param name="guestID"> guestID </param>
/// <param name="name"> name </param>
/// <param name="avatar"> avatar </param>
/// <param name="authorID"> authorID </param>
/// <param name="createUtc"> createUtc </param>
/// <param name="comment"> comment </param>
/// <returns>bool</returns>
public static bool Update(
int guestID,
string name,
string avatar,
int authorID,
DateTime createUtc,
string comment)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "gb_KLGratitude_Update", 6);
sph.DefineSqlParameter("@GuestID", SqlDbType.Int, ParameterDirection.Input, guestID);
sph.DefineSqlParameter("@Name", SqlDbType.NChar, 10, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Avatar", SqlDbType.NVarChar, 255, ParameterDirection.Input, avatar);
sph.DefineSqlParameter("@AuthorID", SqlDbType.Int, ParameterDirection.Input, authorID);
sph.DefineSqlParameter("@CreateUtc", SqlDbType.DateTime, ParameterDirection.Input, createUtc);
sph.DefineSqlParameter("@Comment", SqlDbType.NVarChar, -1, ParameterDirection.Input, comment);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static int Add(
Guid guid,
Guid referenceGuid,
Guid storeGuid,
string imageUrl,
int displayOrder,
string alt,
string title)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_Images_Insert", 7);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@ReferenceGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, referenceGuid);
sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
sph.DefineSqlParameter("@ImageUrl", SqlDbType.NVarChar, 255, ParameterDirection.Input, imageUrl);
sph.DefineSqlParameter("@DisplayOrder", SqlDbType.Int, ParameterDirection.Input, displayOrder);
sph.DefineSqlParameter("@Alt", SqlDbType.NVarChar, 255, ParameterDirection.Input, alt);
sph.DefineSqlParameter("@Title", SqlDbType.NVarChar, 255, ParameterDirection.Input, title);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected);
}
public static IDataReader GetPageProductOther(
int zoneId,
int productId,
DateTime currentTime,
int languageId,
int pageNumber,
int pageSize,
out int totalPages)
{
totalPages = 1;
int totalRows = GetCountProductOther(zoneId, productId, currentTime, languageId);
if (pageSize > 0)
{
totalPages = totalRows / pageSize;
}
if (totalRows <= pageSize)
{
totalPages = 1;
}
else if (pageSize > 0)
{
int remainder;
Math.DivRem(totalRows, pageSize, out remainder);
if (remainder > 0)
{
totalPages += 1;
}
}
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Product_SelectPageProductOther", 6);
sph.DefineSqlParameter("@ZoneID", SqlDbType.Int, ParameterDirection.Input, zoneId);
sph.DefineSqlParameter("@ProductID", SqlDbType.Int, ParameterDirection.Input, productId);
sph.DefineSqlParameter("@CurrentTime", SqlDbType.DateTime, ParameterDirection.Input, currentTime);
sph.DefineSqlParameter("@LanguageID", SqlDbType.Int, ParameterDirection.Input, languageId);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return(sph.ExecuteReader());
}
public bool UpdateSchemaVersion(
Guid applicationId,
string applicationName,
int major,
int minor,
int build,
int revision)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_SchemaVersion_Update",
6);
sph.DefineSqlParameter("@ApplicationID", SqlDbType.UniqueIdentifier, ParameterDirection.Input, applicationId);
sph.DefineSqlParameter("@ApplicationName", SqlDbType.NVarChar, ParameterDirection.Input, applicationName);
sph.DefineSqlParameter("@Major", SqlDbType.Int, ParameterDirection.Input, major);
sph.DefineSqlParameter("@Minor", SqlDbType.Int, ParameterDirection.Input, minor);
sph.DefineSqlParameter("@Build", SqlDbType.Int, ParameterDirection.Input, build);
sph.DefineSqlParameter("@Revision", SqlDbType.Int, ParameterDirection.Input, revision);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public async Task<DbDataReader> GetSingleUser(int siteId, string email)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_SelectByEmail",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@Email", SqlDbType.NVarChar, 100, ParameterDirection.Input, email);
return await sph.ExecuteReaderAsync();
}
public async Task<int> CountUsers(int siteId, String userNameBeginsWith)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_CountByFirstLetter",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@UserNameBeginsWith", SqlDbType.NVarChar, 1, ParameterDirection.Input, userNameBeginsWith);
object result = await sph.ExecuteScalarAsync();
int count = Convert.ToInt32(result);
return count;
}
public async Task<DbDataReader> GetUserByRegistrationGuid(int siteId, Guid registerConfirmGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_SelectByRegisterGuid",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@RegisterConfirmGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, registerConfirmGuid);
return await sph.ExecuteReaderAsync();
}
public async Task<DbDataReader> GetRolesByUser(int siteId, int userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
readConnectionString,
"mp_Users_GetUserRoles",
2);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userId);
return await sph.ExecuteReaderAsync();
}
public bool DecrementTotalPosts(int userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Users_DecrementTotalPosts",
1);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userId);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > -1);
}
public static int Add(
Guid cartGuid,
string customerFirstName,
string customerLastName,
string customerCompany,
string customerAddressLine1,
string customerAddressLine2,
string customerSuburb,
string customerCity,
string customerPostalCode,
string customerState,
string customerCountry,
string customerTelephoneDay,
string customerTelephoneNight,
string customerEmail,
bool customerEmailVerified,
string deliveryFirstName,
string deliveryLastName,
string deliveryCompany,
string deliveryAddress1,
string deliveryAddress2,
string deliverySuburb,
string deliveryCity,
string deliveryPostalCode,
string deliveryState,
string deliveryCountry,
string billingFirstName,
string billingLastName,
string billingCompany,
string billingAddress1,
string billingAddress2,
string billingSuburb,
string billingCity,
string billingPostalCode,
string billingState,
string billingCountry,
Guid cardTypeGuid,
string cardOwner,
string cardNumber,
string cardExpires,
string cardSecurityCode,
DateTime completed,
string completedFromIP,
Guid taxZoneGuid)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_CartOrderInfo_Insert", 43);
sph.DefineSqlParameter("@CartGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, cartGuid);
sph.DefineSqlParameter("@CustomerFirstName", SqlDbType.NVarChar, 100, ParameterDirection.Input, customerFirstName);
sph.DefineSqlParameter("@CustomerLastName", SqlDbType.NVarChar, 100, ParameterDirection.Input, customerLastName);
sph.DefineSqlParameter("@CustomerCompany", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerCompany);
sph.DefineSqlParameter("@CustomerAddressLine1", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerAddressLine1);
sph.DefineSqlParameter("@CustomerAddressLine2", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerAddressLine2);
sph.DefineSqlParameter("@CustomerSuburb", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerSuburb);
sph.DefineSqlParameter("@CustomerCity", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerCity);
sph.DefineSqlParameter("@CustomerPostalCode", SqlDbType.NVarChar, 20, ParameterDirection.Input, customerPostalCode);
sph.DefineSqlParameter("@CustomerState", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerState);
sph.DefineSqlParameter("@CustomerCountry", SqlDbType.NVarChar, 255, ParameterDirection.Input, customerCountry);
sph.DefineSqlParameter("@CustomerTelephoneDay", SqlDbType.NVarChar, 32, ParameterDirection.Input, customerTelephoneDay);
sph.DefineSqlParameter("@CustomerTelephoneNight", SqlDbType.NVarChar, 32, ParameterDirection.Input, customerTelephoneNight);
sph.DefineSqlParameter("@CustomerEmail", SqlDbType.NVarChar, 96, ParameterDirection.Input, customerEmail);
sph.DefineSqlParameter("@CustomerEmailVerified", SqlDbType.Bit, ParameterDirection.Input, customerEmailVerified);
sph.DefineSqlParameter("@DeliveryFirstName", SqlDbType.NVarChar, 100, ParameterDirection.Input, deliveryFirstName);
sph.DefineSqlParameter("@DeliveryLastName", SqlDbType.NVarChar, 100, ParameterDirection.Input, deliveryLastName);
sph.DefineSqlParameter("@DeliveryCompany", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryCompany);
sph.DefineSqlParameter("@DeliveryAddress1", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryAddress1);
sph.DefineSqlParameter("@DeliveryAddress2", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryAddress2);
sph.DefineSqlParameter("@DeliverySuburb", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliverySuburb);
sph.DefineSqlParameter("@DeliveryCity", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryCity);
sph.DefineSqlParameter("@DeliveryPostalCode", SqlDbType.NVarChar, 20, ParameterDirection.Input, deliveryPostalCode);
sph.DefineSqlParameter("@DeliveryState", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryState);
sph.DefineSqlParameter("@DeliveryCountry", SqlDbType.NVarChar, 255, ParameterDirection.Input, deliveryCountry);
sph.DefineSqlParameter("@BillingFirstName", SqlDbType.NVarChar, 100, ParameterDirection.Input, billingFirstName);
sph.DefineSqlParameter("@BillingLastName", SqlDbType.NVarChar, 100, ParameterDirection.Input, billingLastName);
sph.DefineSqlParameter("@BillingCompany", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingCompany);
sph.DefineSqlParameter("@BillingAddress1", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingAddress1);
sph.DefineSqlParameter("@BillingAddress2", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingAddress2);
sph.DefineSqlParameter("@BillingSuburb", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingSuburb);
sph.DefineSqlParameter("@BillingCity", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingCity);
sph.DefineSqlParameter("@BillingPostalCode", SqlDbType.NVarChar, 20, ParameterDirection.Input, billingPostalCode);
sph.DefineSqlParameter("@BillingState", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingState);
sph.DefineSqlParameter("@BillingCountry", SqlDbType.NVarChar, 255, ParameterDirection.Input, billingCountry);
sph.DefineSqlParameter("@CardTypeGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, cardTypeGuid);
sph.DefineSqlParameter("@CardOwner", SqlDbType.NVarChar, 100, ParameterDirection.Input, cardOwner);
sph.DefineSqlParameter("@CardNumber", SqlDbType.NVarChar, 255, ParameterDirection.Input, cardNumber);
sph.DefineSqlParameter("@CardExpires", SqlDbType.NVarChar, 6, ParameterDirection.Input, cardExpires);
sph.DefineSqlParameter("@CardSecurityCode", SqlDbType.NVarChar, 50, ParameterDirection.Input, cardSecurityCode);
sph.DefineSqlParameter("@Completed", SqlDbType.DateTime, ParameterDirection.Input, completed);
sph.DefineSqlParameter("@CompletedFromIP", SqlDbType.NVarChar, 255, ParameterDirection.Input, completedFromIP);
sph.DefineSqlParameter("@TaxZoneGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, taxZoneGuid);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected);
}
public static IDataReader GetPageBySearch(
int pageNumber = 1,
int pageSize = 32767,
int siteId = -1,
string zoneIds = null,
int publishStatus = -1,
int languageId = -1,
int manufactureId = -1,
int productType = -1,
decimal?priceMin = null,
decimal?priceMax = null,
int position = -1,
int showOption = -1,
string propertyCondition = null,
string productIds = null,
string keyword = null,
bool searchCode = true,
string stateIds = null,
int orderBy = 0)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Product_SelectPageBySearch", 18);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@ZoneIDs", SqlDbType.NVarChar, ParameterDirection.Input, zoneIds);
sph.DefineSqlParameter("@PublishStatus", SqlDbType.Int, ParameterDirection.Input, publishStatus);
sph.DefineSqlParameter("@LanguageID", SqlDbType.Int, ParameterDirection.Input, languageId);
sph.DefineSqlParameter("@ManufactureID", SqlDbType.Int, ParameterDirection.Input, manufactureId);
sph.DefineSqlParameter("@ProductType", SqlDbType.Int, ParameterDirection.Input, productType);
sph.DefineSqlParameter("@PriceMin", SqlDbType.Decimal, ParameterDirection.Input, priceMin);
sph.DefineSqlParameter("@PriceMax", SqlDbType.Decimal, ParameterDirection.Input, priceMax);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, position);
sph.DefineSqlParameter("@ShowOption", SqlDbType.Int, ParameterDirection.Input, showOption);
sph.DefineSqlParameter("@PropertyCondition", SqlDbType.NVarChar, ParameterDirection.Input, propertyCondition);
sph.DefineSqlParameter("@ProductIDs", SqlDbType.NVarChar, ParameterDirection.Input, productIds);
sph.DefineSqlParameter("@Keyword", SqlDbType.NVarChar, 255, ParameterDirection.Input, keyword);
sph.DefineSqlParameter("@SearchCode", SqlDbType.Bit, ParameterDirection.Input, searchCode);
sph.DefineSqlParameter("@StateIDs", SqlDbType.NVarChar, ParameterDirection.Input, stateIds);
sph.DefineSqlParameter("@OrderBy", SqlDbType.Int, ParameterDirection.Input, orderBy);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return(sph.ExecuteReader());
}
/// <summary>
/// Updates a row in the gb_KLAuthor table. Returns true if row updated.
/// </summary>
/// <param name="authorID"> authorID </param>
/// <param name="userID"> userID </param>
/// <param name="name"> name </param>
/// <param name="avatar"> avatar </param>
/// <param name="levelAuthor"> levelAuthor </param>
/// <param name="linkFacebook"> linkFacebook </param>
/// <param name="linkTwitter"> linkTwitter </param>
/// <param name="linkPinterest"> linkPinterest </param>
/// <param name="linkInstagram"> linkInstagram </param>
/// <param name="joinDate"> joinDate </param>
/// <param name="articleCount"> articleCount </param>
/// <param name="isDel"> isDel </param>
/// <param name="isActive"> isActive </param>
/// <returns>bool</returns>
public static bool Update(
int authorID,
int userID,
string name,
string avatar,
string levelAuthor,
string linkFacebook,
string linkTwitter,
string linkPinterest,
string linkInstagram,
DateTime joinDate,
int articleCount,
bool isDel,
bool isActive)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "gb_KLAuthor_Update", 13);
sph.DefineSqlParameter("@AuthorID", SqlDbType.Int, ParameterDirection.Input, authorID);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userID);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 100, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Avatar", SqlDbType.NVarChar, 255, ParameterDirection.Input, avatar);
sph.DefineSqlParameter("@LevelAuthor", SqlDbType.NVarChar, 100, ParameterDirection.Input, levelAuthor);
sph.DefineSqlParameter("@LinkFacebook", SqlDbType.NVarChar, 100, ParameterDirection.Input, linkFacebook);
sph.DefineSqlParameter("@LinkTwitter", SqlDbType.NVarChar, 100, ParameterDirection.Input, linkTwitter);
sph.DefineSqlParameter("@LinkPinterest", SqlDbType.NVarChar, 100, ParameterDirection.Input, linkPinterest);
sph.DefineSqlParameter("@LinkInstagram", SqlDbType.NVarChar, 100, ParameterDirection.Input, linkInstagram);
sph.DefineSqlParameter("@JoinDate", SqlDbType.DateTime, ParameterDirection.Input, joinDate);
sph.DefineSqlParameter("@ArticleCount", SqlDbType.Int, ParameterDirection.Input, articleCount);
sph.DefineSqlParameter("@IsDel", SqlDbType.Bit, ParameterDirection.Input, isDel);
sph.DefineSqlParameter("@IsActive", SqlDbType.Bit, ParameterDirection.Input, isActive);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static bool Update(
Guid guid,
string name,
string description,
string ownerName,
string ownerEmail,
string salesEmail,
string supportEmail,
string emailFrom,
string orderBccEmail,
string phone,
string fax,
string address,
string city,
Guid zoneGuid,
string postalCode,
Guid countryGuid,
bool isClosed,
string closedMessage)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_Store_Update", 18);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 255, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Description", SqlDbType.NText, ParameterDirection.Input, description);
sph.DefineSqlParameter("@OwnerName", SqlDbType.NVarChar, 255, ParameterDirection.Input, ownerName);
sph.DefineSqlParameter("@OwnerEmail", SqlDbType.NVarChar, 100, ParameterDirection.Input, ownerEmail);
sph.DefineSqlParameter("@SalesEmail", SqlDbType.NVarChar, 100, ParameterDirection.Input, salesEmail);
sph.DefineSqlParameter("@SupportEmail", SqlDbType.NVarChar, 100, ParameterDirection.Input, supportEmail);
sph.DefineSqlParameter("@EmailFrom", SqlDbType.NVarChar, 100, ParameterDirection.Input, emailFrom);
sph.DefineSqlParameter("@OrderBCCEmail", SqlDbType.NVarChar, 100, ParameterDirection.Input, orderBccEmail);
sph.DefineSqlParameter("@Phone", SqlDbType.NVarChar, 32, ParameterDirection.Input, phone);
sph.DefineSqlParameter("@Fax", SqlDbType.NVarChar, 32, ParameterDirection.Input, fax);
sph.DefineSqlParameter("@Address", SqlDbType.NVarChar, 255, ParameterDirection.Input, address);
sph.DefineSqlParameter("@City", SqlDbType.NVarChar, 255, ParameterDirection.Input, city);
sph.DefineSqlParameter("@ZoneGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, zoneGuid);
sph.DefineSqlParameter("@PostalCode", SqlDbType.NVarChar, 50, ParameterDirection.Input, postalCode);
sph.DefineSqlParameter("@CountryGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, countryGuid);
sph.DefineSqlParameter("@IsClosed", SqlDbType.Bit, ParameterDirection.Input, isClosed);
sph.DefineSqlParameter("@ClosedMessage", SqlDbType.NText, ParameterDirection.Input, closedMessage);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static int AddHistory(
Guid guid,
Guid productGuid,
Guid storeGuid,
Guid taxClassGuid,
string sku,
byte status,
byte fullfillmentType,
decimal weight,
int quantityOnHand,
string imageFileName,
byte[] imageFileBytes,
DateTime created,
Guid createdBy,
DateTime lastModified,
Guid lastModifedBy,
DateTime logTime,
decimal shippingAmount)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_ProductHistory_Insert", 17);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@ProductGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, productGuid);
sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
sph.DefineSqlParameter("@TaxClassGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, taxClassGuid);
sph.DefineSqlParameter("@Sku", SqlDbType.NVarChar, 255, ParameterDirection.Input, sku);
sph.DefineSqlParameter("@Status", SqlDbType.TinyInt, ParameterDirection.Input, status);
sph.DefineSqlParameter("@FullfillmentType", SqlDbType.TinyInt, ParameterDirection.Input, fullfillmentType);
sph.DefineSqlParameter("@Weight", SqlDbType.Decimal, ParameterDirection.Input, weight);
sph.DefineSqlParameter("@QuantityOnHand", SqlDbType.Int, ParameterDirection.Input, quantityOnHand);
sph.DefineSqlParameter("@ImageFileName", SqlDbType.NVarChar, 255, ParameterDirection.Input, imageFileName);
sph.DefineSqlParameter("@ImageFileBytes", SqlDbType.VarBinary, -1, ParameterDirection.Input, imageFileBytes);
sph.DefineSqlParameter("@Created", SqlDbType.DateTime, ParameterDirection.Input, created);
sph.DefineSqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier, ParameterDirection.Input, createdBy);
sph.DefineSqlParameter("@LastModified", SqlDbType.DateTime, ParameterDirection.Input, lastModified);
sph.DefineSqlParameter("@LastModifedBy", SqlDbType.UniqueIdentifier, ParameterDirection.Input, lastModifedBy);
sph.DefineSqlParameter("@LogTime", SqlDbType.DateTime, ParameterDirection.Input, logTime);
sph.DefineSqlParameter("@ShippingAmount", SqlDbType.Decimal, ParameterDirection.Input, shippingAmount);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected);
}
public static DataTable GetPage(
Guid storeGuid,
int pageNumber,
int pageSize,
out int totalPages)
{
totalPages = 1;
int totalRows = GetCount(storeGuid);
if (pageSize > 0)
{
totalPages = totalRows / pageSize;
}
if (totalRows <= pageSize)
{
totalPages = 1;
}
else
{
int remainder;
Math.DivRem(totalRows, pageSize, out remainder);
if (remainder > 0)
{
totalPages += 1;
}
}
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetReadConnectionString(), "ws_Product_SelectPage", 3);
sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
DataTable dataTable = GetProductEmptyTable();
using (IDataReader reader = sph.ExecuteReader())
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["Guid"] = new Guid(reader["Guid"].ToString());
//row["StoreGuid"] = new Guid(reader["StoreGuid"].ToString());
//row["TaxClassGuid"] = new Guid(reader["TaxClassGuid"].ToString());
row["ModelNumber"] = reader["ModelNumber"];
// doh! actual field is mis-spelled as FullFillmentType
row["FulFillmentType"] = Convert.ToInt32(reader["FullFillmentType"]);
row["Weight"] = Convert.ToDecimal(reader["Weight"]);
//row["RetailPrice"] = Convert.ToDecimal(reader["RetailPrice"]);
row["Url"] = reader["Url"];
row["Name"] = reader["Name"];
row["Abstract"] = reader["Abstract"];
row["Description"] = reader["Description"];
row["EnableRating"] = Convert.ToBoolean(reader["EnableRating"]);
row["TeaserFile"] = reader["TeaserFile"];
row["TeaserFileLink"] = reader["TeaserFileLink"];
if (reader["ShippingAmount"] != DBNull.Value)
{
row["ShippingAmount"] = Convert.ToDecimal(reader["ShippingAmount"]);
}
else
{
row["ShippingAmount"] = 0;
}
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
public static bool Update(
int commentID,
int parentID,
int productID,
string title,
string contentText,
string fullName,
string email,
bool isApproved,
int rating,
int helpfulYesTotal,
int helpfulNoTotal,
int userID,
DateTime createdUtc,
int status,
Guid?userGuid,
int position,
string createdFromIP,
bool isModerator,
string moderationReason)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "gb_ProductComments_Update", 19);
sph.DefineSqlParameter("@CommentID", SqlDbType.Int, ParameterDirection.Input, commentID);
sph.DefineSqlParameter("@ParentID", SqlDbType.Int, ParameterDirection.Input, parentID);
sph.DefineSqlParameter("@ProductID", SqlDbType.Int, ParameterDirection.Input, productID);
sph.DefineSqlParameter("@Title", SqlDbType.NVarChar, 255, ParameterDirection.Input, title);
sph.DefineSqlParameter("@ContentText", SqlDbType.NVarChar, -1, ParameterDirection.Input, contentText);
sph.DefineSqlParameter("@FullName", SqlDbType.NVarChar, 255, ParameterDirection.Input, fullName);
sph.DefineSqlParameter("@Email", SqlDbType.NVarChar, 255, ParameterDirection.Input, email);
sph.DefineSqlParameter("@IsApproved", SqlDbType.Bit, ParameterDirection.Input, isApproved);
sph.DefineSqlParameter("@Rating", SqlDbType.Int, ParameterDirection.Input, rating);
sph.DefineSqlParameter("@HelpfulYesTotal", SqlDbType.Int, ParameterDirection.Input, helpfulYesTotal);
sph.DefineSqlParameter("@HelpfulNoTotal", SqlDbType.Int, ParameterDirection.Input, helpfulNoTotal);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userID);
sph.DefineSqlParameter("@CreatedUtc", SqlDbType.DateTime, ParameterDirection.Input, createdUtc);
sph.DefineSqlParameter("@Status", SqlDbType.Int, ParameterDirection.Input, status);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, position);
sph.DefineSqlParameter("@CreatedFromIP", SqlDbType.NVarChar, 50, ParameterDirection.Input, createdFromIP);
sph.DefineSqlParameter("@IsModerator", SqlDbType.Bit, ParameterDirection.Input, isModerator);
sph.DefineSqlParameter("@ModerationReason", SqlDbType.NVarChar, 255, ParameterDirection.Input, moderationReason);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
public static IDataReader GetPage(
int siteId,
int productId,
int commentType,
int approvedStatus,
int parentId,
int position,
DateTime?fromDate,
DateTime?toDate,
string keyword,
int orderBy,
int pageNumber,
int pageSize)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_ProductComments_SelectPage", 12);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@ProductID", SqlDbType.Int, ParameterDirection.Input, productId);
sph.DefineSqlParameter("@CommentType", SqlDbType.Int, ParameterDirection.Input, commentType);
sph.DefineSqlParameter("@ApprovedStatus", SqlDbType.Int, ParameterDirection.Input, approvedStatus);
sph.DefineSqlParameter("@ParentID", SqlDbType.Int, ParameterDirection.Input, parentId);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, position);
sph.DefineSqlParameter("@FromDate", SqlDbType.Int, ParameterDirection.Input, fromDate);
sph.DefineSqlParameter("@ToDate", SqlDbType.Int, ParameterDirection.Input, toDate);
sph.DefineSqlParameter("@Keyword", SqlDbType.NVarChar, 50, ParameterDirection.Input, keyword);
sph.DefineSqlParameter("@OrderBy", SqlDbType.Int, ParameterDirection.Input, orderBy);
sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
return(sph.ExecuteReader());
}
public static int Create(
int siteID,
int zoneID,
string title,
string subTitle,
string url,
string code,
string briefContent,
string fullContent,
int productType,
bool openInNewWindow,
int position,
int showOption,
bool isPublished,
DateTime startDate,
DateTime endDate,
int displayOrder,
decimal price,
decimal oldPrice,
decimal specialPrice,
DateTime?specialPriceStartDate,
DateTime?specialPriceEndDate,
int viewCount,
int commentCount,
string metaTitle,
string metaKeywords,
string metaDescription,
string additionalMetaTags,
string compiledMeta,
int manufacturerID,
int stockQuantity,
bool disableBuyButton,
string fileAttachment,
Guid productGuid,
Guid userGuid,
DateTime createdUtc,
DateTime lastModUtc,
Guid lastModUserGuid,
bool isDeleted)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "gb_Product_Insert", 38);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteID);
sph.DefineSqlParameter("@ZoneID", SqlDbType.Int, ParameterDirection.Input, zoneID);
sph.DefineSqlParameter("@Title", SqlDbType.NVarChar, 255, ParameterDirection.Input, title);
sph.DefineSqlParameter("@SubTitle", SqlDbType.NVarChar, 255, ParameterDirection.Input, subTitle);
sph.DefineSqlParameter("@Url", SqlDbType.NVarChar, 255, ParameterDirection.Input, url);
sph.DefineSqlParameter("@Code", SqlDbType.NVarChar, 255, ParameterDirection.Input, code);
sph.DefineSqlParameter("@BriefContent", SqlDbType.NVarChar, -1, ParameterDirection.Input, briefContent);
sph.DefineSqlParameter("@FullContent", SqlDbType.NVarChar, -1, ParameterDirection.Input, fullContent);
sph.DefineSqlParameter("@ProductType", SqlDbType.Int, ParameterDirection.Input, productType);
sph.DefineSqlParameter("@OpenInNewWindow", SqlDbType.Bit, ParameterDirection.Input, openInNewWindow);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, position);
sph.DefineSqlParameter("@ShowOption", SqlDbType.Int, ParameterDirection.Input, showOption);
sph.DefineSqlParameter("@IsPublished", SqlDbType.Bit, ParameterDirection.Input, isPublished);
sph.DefineSqlParameter("@StartDate", SqlDbType.DateTime, ParameterDirection.Input, startDate);
if (endDate < DateTime.MaxValue)
{
sph.DefineSqlParameter("@EndDate", SqlDbType.DateTime, ParameterDirection.Input, endDate);
}
else
{
sph.DefineSqlParameter("@EndDate", SqlDbType.DateTime, ParameterDirection.Input, DBNull.Value);
}
sph.DefineSqlParameter("@DisplayOrder", SqlDbType.Int, ParameterDirection.Input, displayOrder);
sph.DefineSqlParameter("@Price", SqlDbType.Decimal, ParameterDirection.Input, price);
sph.DefineSqlParameter("@OldPrice", SqlDbType.Decimal, ParameterDirection.Input, oldPrice);
sph.DefineSqlParameter("@SpecialPrice", SqlDbType.Decimal, ParameterDirection.Input, specialPrice);
sph.DefineSqlParameter("@SpecialPriceStartDate", SqlDbType.DateTime, ParameterDirection.Input, specialPriceStartDate);
sph.DefineSqlParameter("@SpecialPriceEndDate", SqlDbType.DateTime, ParameterDirection.Input, specialPriceEndDate);
sph.DefineSqlParameter("@ViewCount", SqlDbType.Int, ParameterDirection.Input, viewCount);
sph.DefineSqlParameter("@CommentCount", SqlDbType.Int, ParameterDirection.Input, commentCount);
sph.DefineSqlParameter("@MetaTitle", SqlDbType.NVarChar, 255, ParameterDirection.Input, metaTitle);
sph.DefineSqlParameter("@MetaKeywords", SqlDbType.NVarChar, 255, ParameterDirection.Input, metaKeywords);
sph.DefineSqlParameter("@MetaDescription", SqlDbType.NVarChar, 255, ParameterDirection.Input, metaDescription);
sph.DefineSqlParameter("@AdditionalMetaTags", SqlDbType.NVarChar, -1, ParameterDirection.Input, additionalMetaTags);
sph.DefineSqlParameter("@CompiledMeta", SqlDbType.NVarChar, -1, ParameterDirection.Input, compiledMeta);
sph.DefineSqlParameter("@ManufacturerID", SqlDbType.Int, ParameterDirection.Input, manufacturerID);
sph.DefineSqlParameter("@StockQuantity", SqlDbType.Int, ParameterDirection.Input, stockQuantity);
sph.DefineSqlParameter("@DisableBuyButton", SqlDbType.Bit, ParameterDirection.Input, disableBuyButton);
sph.DefineSqlParameter("@FileAttachment", SqlDbType.NVarChar, 255, ParameterDirection.Input, fileAttachment);
sph.DefineSqlParameter("@ProductGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, productGuid);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@CreatedUtc", SqlDbType.DateTime, ParameterDirection.Input, createdUtc);
sph.DefineSqlParameter("@LastModUtc", SqlDbType.DateTime, ParameterDirection.Input, lastModUtc);
sph.DefineSqlParameter("@LastModUserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, lastModUserGuid);
sph.DefineSqlParameter("@IsDeleted", SqlDbType.Bit, ParameterDirection.Input, isDeleted);
int newID = Convert.ToInt32(sph.ExecuteScalar());
return(newID);
}
//public bool UpdatePasswordAndSalt(
// int userId,
// int pwdFormat,
// string password,
// string passwordSalt)
//{
// SqlParameterHelper sph = new SqlParameterHelper(
// logFactory,
// writeConnectionString,
// "mp_Users_UpdatePasswordAndSalt",
// 4);
// sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userId);
// sph.DefineSqlParameter("@Password", SqlDbType.NVarChar, 1000, ParameterDirection.Input, password);
// sph.DefineSqlParameter("@PasswordSalt", SqlDbType.NVarChar, 128, ParameterDirection.Input, passwordSalt);
// sph.DefineSqlParameter("@PwdFormat", SqlDbType.Int, ParameterDirection.Input, pwdFormat);
// int rowsAffected = sph.ExecuteNonQuery();
// return (rowsAffected > -1);
//}
public bool UpdatePasswordQuestionAndAnswer(
Guid userGuid,
String passwordQuestion,
String passwordAnswer)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Users_UpdatePasswordQuestionAndAnswer",
3);
sph.DefineSqlParameter("@UserGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, userGuid);
sph.DefineSqlParameter("@PasswordQuestion", SqlDbType.NVarChar, 255, ParameterDirection.Input, passwordQuestion);
sph.DefineSqlParameter("@PasswordAnswer", SqlDbType.NVarChar, 255, ParameterDirection.Input, passwordAnswer);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > -1);
}
public static int GetCountBySearch(
int siteId = -1,
string zoneIds = null,
int publishStatus = -1,
int languageId = -1,
int manufactureId = -1,
int productType = -1,
decimal?priceMin = null,
decimal?priceMax = null,
int position = -1,
int showOption = -1,
string propertyCondition = null,
string productIds = null,
string keyword = null,
bool searchCode = true,
string stateIds = null,
int orderBy = 0)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(), "gb_Product_GetCountBySearch", 15);
sph.DefineSqlParameter("@SiteID", SqlDbType.Int, ParameterDirection.Input, siteId);
sph.DefineSqlParameter("@ZoneIDs", SqlDbType.NVarChar, ParameterDirection.Input, zoneIds);
sph.DefineSqlParameter("@PublishStatus", SqlDbType.Int, ParameterDirection.Input, publishStatus);
sph.DefineSqlParameter("@LanguageID", SqlDbType.Int, ParameterDirection.Input, languageId);
sph.DefineSqlParameter("@ManufactureID", SqlDbType.Int, ParameterDirection.Input, manufactureId);
sph.DefineSqlParameter("@ProductType", SqlDbType.Int, ParameterDirection.Input, productType);
sph.DefineSqlParameter("@PriceMin", SqlDbType.Decimal, ParameterDirection.Input, priceMin);
sph.DefineSqlParameter("@PriceMax", SqlDbType.Decimal, ParameterDirection.Input, priceMax);
sph.DefineSqlParameter("@Position", SqlDbType.Int, ParameterDirection.Input, position);
sph.DefineSqlParameter("@ShowOption", SqlDbType.Int, ParameterDirection.Input, showOption);
sph.DefineSqlParameter("@PropertyCondition", SqlDbType.NVarChar, ParameterDirection.Input, propertyCondition);
sph.DefineSqlParameter("@ProductIDs", SqlDbType.NVarChar, ParameterDirection.Input, productIds);
sph.DefineSqlParameter("@Keyword", SqlDbType.NVarChar, 255, ParameterDirection.Input, keyword);
sph.DefineSqlParameter("@SearchCode", SqlDbType.Bit, ParameterDirection.Input, searchCode);
sph.DefineSqlParameter("@StateIDs", SqlDbType.NVarChar, ParameterDirection.Input, stateIds);
return(Convert.ToInt32(sph.ExecuteScalar()));
}
public async Task<bool> FlagAsNotDeleted(int userId)
{
SqlParameterHelper sph = new SqlParameterHelper(
logFactory,
writeConnectionString,
"mp_Users_FlagAsNotDeleted",
1);
sph.DefineSqlParameter("@UserID", SqlDbType.Int, ParameterDirection.Input, userId);
int rowsAffected = await sph.ExecuteNonQueryAsync();
return (rowsAffected > -1);
}
public static bool Update(
Guid guid,
Guid taxClassGuid,
string modelNumber,
byte status,
byte fullfillmentType,
decimal weight,
int quantityOnHand,
string imageFileName,
byte[] imageFileBytes,
DateTime lastModified,
Guid lastModifedBy,
string url,
string name,
string description,
string teaser,
bool showInProductList,
bool enableRating,
string metaDescription,
string metaKeywords,
int sortRank1,
int sortRank2,
string teaserFile,
string teaserFileLink,
string compiledMeta,
decimal shippingAmount)
{
SqlParameterHelper sph = new SqlParameterHelper(WebStoreConnectionString.GetWriteConnectionString(), "ws_Product_Update", 25);
sph.DefineSqlParameter("@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, guid);
sph.DefineSqlParameter("@TaxClassGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, taxClassGuid);
sph.DefineSqlParameter("@ModelNumber", SqlDbType.NVarChar, 255, ParameterDirection.Input, modelNumber);
sph.DefineSqlParameter("@Status", SqlDbType.TinyInt, ParameterDirection.Input, status);
sph.DefineSqlParameter("@FullfillmentType", SqlDbType.TinyInt, ParameterDirection.Input, fullfillmentType);
sph.DefineSqlParameter("@Weight", SqlDbType.Decimal, ParameterDirection.Input, weight);
sph.DefineSqlParameter("@QuantityOnHand", SqlDbType.Int, ParameterDirection.Input, quantityOnHand);
sph.DefineSqlParameter("@ImageFileName", SqlDbType.NVarChar, 255, ParameterDirection.Input, imageFileName);
sph.DefineSqlParameter("@ImageFileBytes", SqlDbType.Image, ParameterDirection.Input, imageFileBytes);
sph.DefineSqlParameter("@LastModified", SqlDbType.DateTime, ParameterDirection.Input, lastModified);
sph.DefineSqlParameter("@LastModifedBy", SqlDbType.UniqueIdentifier, ParameterDirection.Input, lastModifedBy);
sph.DefineSqlParameter("@Url", SqlDbType.NVarChar, 255, ParameterDirection.Input, url);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 255, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Description", SqlDbType.NVarChar, -1, ParameterDirection.Input, description);
sph.DefineSqlParameter("@Abstract", SqlDbType.NVarChar, -1, ParameterDirection.Input, teaser);
sph.DefineSqlParameter("@ShowInProductList", SqlDbType.Bit, ParameterDirection.Input, showInProductList);
sph.DefineSqlParameter("@EnableRating", SqlDbType.Bit, ParameterDirection.Input, enableRating);
sph.DefineSqlParameter("@MetaDescription", SqlDbType.NVarChar, 255, ParameterDirection.Input, metaDescription);
sph.DefineSqlParameter("@MetaKeywords", SqlDbType.NVarChar, 255, ParameterDirection.Input, metaKeywords);
sph.DefineSqlParameter("@SortRank1", SqlDbType.Int, ParameterDirection.Input, sortRank1);
sph.DefineSqlParameter("@SortRank2", SqlDbType.Int, ParameterDirection.Input, sortRank2);
sph.DefineSqlParameter("@TeaserFile", SqlDbType.NVarChar, 255, ParameterDirection.Input, teaserFile);
sph.DefineSqlParameter("@TeaserFileLink", SqlDbType.NVarChar, 255, ParameterDirection.Input, teaserFileLink);
sph.DefineSqlParameter("@CompiledMeta", SqlDbType.NVarChar, -1, ParameterDirection.Input, compiledMeta);
sph.DefineSqlParameter("@ShippingAmount", SqlDbType.Decimal, ParameterDirection.Input, shippingAmount);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected > 0);
}
/// <summary>
/// Inserts a row in the i7_sflexi_fields table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public static int Create(
Guid siteGuid,
Guid featureGuid,
Guid definitionGuid,
Guid fieldGuid,
string definitionName,
string name,
string label,
string defaultValue,
string controlType,
string controlSrc,
int sortOrder,
string helpKey,
bool required,
string requiredMessageFormat,
string regex,
string regexMessageFormat,
string token,
string preTokenString,
string postTokenString,
bool searchable,
string editPageControlWrapperCssClass,
string editPageLabelCssClass,
string editPageControlCssClass,
bool datePickerIncludeTimeForDate,
bool datePickerShowMonthList,
bool datePickerShowYearList,
string datePickerYearRange,
string imageBrowserEmptyUrl,
string options,
bool checkBoxReturnBool,
string checkBoxReturnValueWhenTrue,
string checkBoxReturnValueWhenFalse,
string dateFormat,
string textBoxMode,
string attributes,
bool isGlobal)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetWriteConnectionString(), "i7_sflexi_fields_Insert", 36);
sph.DefineSqlParameter("@SiteGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, siteGuid);
sph.DefineSqlParameter("@FeatureGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, featureGuid);
sph.DefineSqlParameter("@DefinitionGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, definitionGuid);
sph.DefineSqlParameter("@FieldGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, fieldGuid);
sph.DefineSqlParameter("@DefinitionName", SqlDbType.NVarChar, 50, ParameterDirection.Input, definitionName);
sph.DefineSqlParameter("@Name", SqlDbType.NVarChar, 50, ParameterDirection.Input, name);
sph.DefineSqlParameter("@Label", SqlDbType.NVarChar, 255, ParameterDirection.Input, label);
sph.DefineSqlParameter("@DefaultValue", SqlDbType.NVarChar, -1, ParameterDirection.Input, defaultValue);
sph.DefineSqlParameter("@ControlType", SqlDbType.NVarChar, 25, ParameterDirection.Input, controlType);
sph.DefineSqlParameter("@ControlSrc", SqlDbType.NVarChar, -1, ParameterDirection.Input, controlSrc);
sph.DefineSqlParameter("@SortOrder", SqlDbType.Int, ParameterDirection.Input, sortOrder);
sph.DefineSqlParameter("@HelpKey", SqlDbType.NVarChar, 255, ParameterDirection.Input, helpKey);
sph.DefineSqlParameter("@Required", SqlDbType.Bit, ParameterDirection.Input, required);
sph.DefineSqlParameter("@RequiredMessageFormat", SqlDbType.NVarChar, -1, ParameterDirection.Input, requiredMessageFormat);
sph.DefineSqlParameter("@Regex", SqlDbType.NVarChar, -1, ParameterDirection.Input, regex);
sph.DefineSqlParameter("@RegexMessageFormat", SqlDbType.NVarChar, -1, ParameterDirection.Input, regexMessageFormat);
sph.DefineSqlParameter("@Token", SqlDbType.NVarChar, -1, ParameterDirection.Input, token);
sph.DefineSqlParameter("@PreTokenString", SqlDbType.NVarChar, -1, ParameterDirection.Input, preTokenString);
sph.DefineSqlParameter("@PostTokenString", SqlDbType.NVarChar, -1, ParameterDirection.Input, postTokenString);
sph.DefineSqlParameter("@Searchable", SqlDbType.Bit, ParameterDirection.Input, searchable);
sph.DefineSqlParameter("@EditPageControlWrapperCssClass", SqlDbType.NVarChar, 50, ParameterDirection.Input, editPageControlWrapperCssClass);
sph.DefineSqlParameter("@EditPageLabelCssClass", SqlDbType.NVarChar, 50, ParameterDirection.Input, editPageLabelCssClass);
sph.DefineSqlParameter("@EditPageControlCssClass", SqlDbType.NVarChar, 50, ParameterDirection.Input, editPageControlCssClass);
sph.DefineSqlParameter("@DatePickerIncludeTimeForDate", SqlDbType.Bit, ParameterDirection.Input, datePickerIncludeTimeForDate);
sph.DefineSqlParameter("@DatePickerShowMonthList", SqlDbType.Bit, ParameterDirection.Input, datePickerShowMonthList);
sph.DefineSqlParameter("@DatePickerShowYearList", SqlDbType.Bit, ParameterDirection.Input, datePickerShowYearList);
sph.DefineSqlParameter("@DatePickerYearRange", SqlDbType.NVarChar, 10, ParameterDirection.Input, datePickerYearRange);
sph.DefineSqlParameter("@ImageBrowserEmptyUrl", SqlDbType.NVarChar, -1, ParameterDirection.Input, imageBrowserEmptyUrl);
sph.DefineSqlParameter("@Options", SqlDbType.NVarChar, -1, ParameterDirection.Input, options);
sph.DefineSqlParameter("@CheckBoxReturnBool", SqlDbType.Bit, ParameterDirection.Input, checkBoxReturnBool);
sph.DefineSqlParameter("@CheckBoxReturnValueWhenTrue", SqlDbType.NVarChar, -1, ParameterDirection.Input, checkBoxReturnValueWhenTrue);
sph.DefineSqlParameter("@CheckBoxReturnValueWhenFalse", SqlDbType.NVarChar, -1, ParameterDirection.Input, checkBoxReturnValueWhenFalse);
sph.DefineSqlParameter("@DateFormat", SqlDbType.NVarChar, -1, ParameterDirection.Input, dateFormat);
sph.DefineSqlParameter("@TextBoxMode", SqlDbType.NVarChar, 25, ParameterDirection.Input, textBoxMode);
sph.DefineSqlParameter("@Attributes", SqlDbType.NVarChar, 100, ParameterDirection.Input, attributes);
sph.DefineSqlParameter("@IsGlobal", SqlDbType.Bit, ParameterDirection.Input, isGlobal);
int rowsAffected = sph.ExecuteNonQuery();
return(rowsAffected);
}