public static int CreateAuditHistory(
Guid guid,
Guid workflowGuid,
Guid moduleGuid,
Guid userGuid,
DateTime createdDateUtc,
string status,
string notes,
bool active)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_ContentWorkflowAuditHistory ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("ContentWorkflowGuid, ");
sqlCommand.Append("ModuleGuid, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("CreatedDateUtc, ");
sqlCommand.Append("NewStatus, ");
sqlCommand.Append("Notes, ");
sqlCommand.Append("Active ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@ContentWorkflowGuid, ");
sqlCommand.Append("@ModuleGuid, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@CreatedDateUtc, ");
sqlCommand.Append("@NewStatus, ");
sqlCommand.Append("@Notes, ");
sqlCommand.Append("@Active ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[8];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@ContentWorkflowGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = workflowGuid;
arParams[2] = new SqlCeParameter("@ModuleGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = moduleGuid;
arParams[3] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = userGuid;
arParams[4] = new SqlCeParameter("@CreatedDateUtc", SqlDbType.DateTime);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = createdDateUtc;
arParams[5] = new SqlCeParameter("@NewStatus", SqlDbType.NVarChar, 20);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = status;
arParams[6] = new SqlCeParameter("@Notes", SqlDbType.NText);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = notes;
arParams[7] = new SqlCeParameter("@Active", SqlDbType.Bit);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = active;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Updates a row in the mp_ContentWorkflow table. Returns true if row updated.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="lastModUserGuid"> lastModUserGuid </param>
/// <param name="lastModUtc"> lastModUtc </param>
/// <param name="status"> status </param>
/// <param name="contentText"> contentText </param>
/// <param name="customData"> customData </param>
/// <param name="customReferenceNumber"> customReferenceNumber </param>
/// <param name="customReferenceGuid"> customReferenceGuid </param>
/// <returns>bool</returns>
public static int Update(
Guid guid,
Guid lastModUserGuid,
DateTime lastModUtc,
string contentText,
string customData,
int customReferenceNumber,
Guid customReferenceGuid,
string status)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_ContentWorkflow ");
sqlCommand.Append("SET ");
sqlCommand.Append("LastModUserGuid = @LastModUserGuid, ");
sqlCommand.Append("LastModUtc = @LastModUtc, ");
sqlCommand.Append("Status = @Status, ");
sqlCommand.Append("ContentText = @ContentText, ");
sqlCommand.Append("CustomData = @CustomData, ");
sqlCommand.Append("CustomReferenceNumber = @CustomReferenceNumber, ");
sqlCommand.Append("CustomReferenceGuid = @CustomReferenceGuid ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("Guid = @Guid ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[8];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@LastModUserGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = lastModUserGuid;
arParams[2] = new SqlCeParameter("@LastModUtc", SqlDbType.DateTime);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = lastModUtc;
arParams[3] = new SqlCeParameter("@Status", SqlDbType.NVarChar, 20);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = status;
arParams[4] = new SqlCeParameter("@ContentText", SqlDbType.NText);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = contentText;
arParams[5] = new SqlCeParameter("@CustomData", SqlDbType.NText);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = customData;
arParams[6] = new SqlCeParameter("@CustomReferenceNumber", SqlDbType.Int);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = customReferenceNumber;
arParams[7] = new SqlCeParameter("@CustomReferenceGuid", SqlDbType.UniqueIdentifier);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = customReferenceGuid;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Inserts a row in the mp_ContentWorkflow table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="moduleGuid"> moduleGuid </param>
/// <param name="createdDateUtc"> createdDateUtc </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="status"> status </param>
/// <param name="contentText"> contentText </param>
/// <param name="customData"> customData </param>
/// <param name="customReferenceNumber"> customReferenceNumber </param>
/// <param name="customReferenceGuid"> customReferenceGuid </param>
/// <returns>int</returns>
public static int Create(
Guid guid,
Guid siteGuid,
Guid moduleGuid,
Guid userGuid,
DateTime createdDateUtc,
string contentText,
string customData,
int customReferenceNumber,
Guid customReferenceGuid,
string status)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_ContentWorkflow ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("ModuleGuid, ");
sqlCommand.Append("CreatedDateUtc, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("LastModUserGuid, ");
sqlCommand.Append("LastModUtc, ");
sqlCommand.Append("Status, ");
sqlCommand.Append("ContentText, ");
sqlCommand.Append("CustomData, ");
sqlCommand.Append("CustomReferenceNumber, ");
sqlCommand.Append("CustomReferenceGuid ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@ModuleGuid, ");
sqlCommand.Append("@CreatedDateUtc, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@LastModUserGuid, ");
sqlCommand.Append("@LastModUtc, ");
sqlCommand.Append("@Status, ");
sqlCommand.Append("@ContentText, ");
sqlCommand.Append("@CustomData, ");
sqlCommand.Append("@CustomReferenceNumber, ");
sqlCommand.Append("@CustomReferenceGuid ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[12];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = siteGuid;
arParams[2] = new SqlCeParameter("@ModuleGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = moduleGuid;
arParams[3] = new SqlCeParameter("@CreatedDateUtc", SqlDbType.DateTime);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = createdDateUtc;
arParams[4] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = userGuid;
arParams[5] = new SqlCeParameter("@LastModUserGuid", SqlDbType.UniqueIdentifier);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = userGuid;
arParams[6] = new SqlCeParameter("@LastModUtc", SqlDbType.DateTime);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = createdDateUtc;
arParams[7] = new SqlCeParameter("@Status", SqlDbType.NVarChar, 20);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = status;
arParams[8] = new SqlCeParameter("@ContentText", SqlDbType.NText);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = contentText;
arParams[9] = new SqlCeParameter("@CustomData", SqlDbType.NText);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = customData;
arParams[10] = new SqlCeParameter("@CustomReferenceNumber", SqlDbType.Int);
arParams[10].Direction = ParameterDirection.Input;
arParams[10].Value = customReferenceNumber;
arParams[11] = new SqlCeParameter("@CustomReferenceGuid", SqlDbType.UniqueIdentifier);
arParams[11].Direction = ParameterDirection.Input;
arParams[11].Value = customReferenceGuid;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Inserts a row in the mp_ContentStyle table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="name"> name </param>
/// <param name="element"> element </param>
/// <param name="cssClass"> cssClass </param>
/// <param name="skinName"> skinName </param>
/// <param name="isActive"> isActive </param>
/// <param name="createdUtc"> createdUtc </param>
/// <param name="createdBy"> createdBy </param>
/// <returns>int</returns>
public static int Create(
Guid guid,
Guid siteGuid,
string name,
string element,
string cssClass,
string skinName,
bool isActive,
DateTime createdUtc,
Guid createdBy)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_ContentStyle ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("Name, ");
sqlCommand.Append("Element, ");
sqlCommand.Append("CssClass, ");
sqlCommand.Append("SkinName, ");
sqlCommand.Append("IsActive, ");
sqlCommand.Append("CreatedUtc, ");
sqlCommand.Append("LastModUtc, ");
sqlCommand.Append("CreatedBy, ");
sqlCommand.Append("LastModBy ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@Name, ");
sqlCommand.Append("@Element, ");
sqlCommand.Append("@CssClass, ");
sqlCommand.Append("@SkinName, ");
sqlCommand.Append("@IsActive, ");
sqlCommand.Append("@CreatedUtc, ");
sqlCommand.Append("@LastModUtc, ");
sqlCommand.Append("@CreatedBy, ");
sqlCommand.Append("@LastModBy ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[11];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = siteGuid;
arParams[2] = new SqlCeParameter("@Name", SqlDbType.NVarChar, 100);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = name;
arParams[3] = new SqlCeParameter("@Element", SqlDbType.NVarChar, 50);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = element;
arParams[4] = new SqlCeParameter("@CssClass", SqlDbType.NVarChar, 50);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = cssClass;
arParams[5] = new SqlCeParameter("@SkinName", SqlDbType.NVarChar, 100);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = skinName;
arParams[6] = new SqlCeParameter("@IsActive", SqlDbType.Bit);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = isActive;
arParams[7] = new SqlCeParameter("@CreatedUtc", SqlDbType.DateTime);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = createdUtc;
arParams[8] = new SqlCeParameter("@LastModUtc", SqlDbType.DateTime);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = createdUtc;
arParams[9] = new SqlCeParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = createdBy;
arParams[10] = new SqlCeParameter("@LastModBy", SqlDbType.UniqueIdentifier);
arParams[10].Direction = ParameterDirection.Input;
arParams[10].Value = createdBy;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Inserts a row in the mp_LetterSubscribe table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="letterInfoGuid"> letterInfoGuid </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="email"> email </param>
/// <param name="isVerified"> isVerified </param>
/// <param name="verifyGuid"> verifyGuid </param>
/// <param name="beginUtc"> beginUtc </param>
/// <param name="useHtml"> useHtml </param>
/// <returns>int</returns>
public static int Create(
Guid guid,
Guid siteGuid,
Guid letterInfoGuid,
Guid userGuid,
string email,
bool isVerified,
Guid verifyGuid,
DateTime beginUtc,
bool useHtml,
string ipAddress)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_LetterSubscribe ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("LetterInfoGuid, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("Email, ");
sqlCommand.Append("IsVerified, ");
sqlCommand.Append("VerifyGuid, ");
sqlCommand.Append("BeginUtc, ");
sqlCommand.Append("UseHtml, ");
sqlCommand.Append("IpAddress ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@LetterInfoGuid, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@Email, ");
sqlCommand.Append("@IsVerified, ");
sqlCommand.Append("@VerifyGuid, ");
sqlCommand.Append("@BeginUtc, ");
sqlCommand.Append("@UseHtml, ");
sqlCommand.Append("@IpAddress ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[10];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = siteGuid;
arParams[2] = new SqlCeParameter("@LetterInfoGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = letterInfoGuid;
arParams[3] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = userGuid;
arParams[4] = new SqlCeParameter("@Email", SqlDbType.NVarChar, 100);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = email;
arParams[5] = new SqlCeParameter("@IsVerified", SqlDbType.Bit);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = isVerified;
arParams[6] = new SqlCeParameter("@VerifyGuid", SqlDbType.UniqueIdentifier);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = verifyGuid;
arParams[7] = new SqlCeParameter("@BeginUtc", SqlDbType.DateTime);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = beginUtc;
arParams[8] = new SqlCeParameter("@UseHtml", SqlDbType.Bit);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = useHtml;
arParams[9] = new SqlCeParameter("@IpAddress", SqlDbType.NVarChar, 100);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = ipAddress;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Inserts a row in the mp_TagItem table. Returns rows affected count.
/// </summary>
/// <param name="guid"> guid </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="featureGuid"> featureGuid </param>
/// <param name="moduleGuid"> moduleGuid </param>
/// <param name="itemGuid"> itemGuid </param>
/// <param name="tagGuid"> tagGuid </param>
/// <param name="extraGuid"> extraGuid </param>
/// <param name="taggedBy"> taggedBy </param>
/// <returns>int</returns>
public static int Create(
Guid guid,
Guid siteGuid,
Guid featureGuid,
Guid moduleGuid,
Guid itemGuid,
Guid tagGuid,
Guid extraGuid,
Guid taggedBy)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_TagItem ");
sqlCommand.Append("(");
sqlCommand.Append("Guid, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("FeatureGuid, ");
sqlCommand.Append("ModuleGuid, ");
sqlCommand.Append("ItemGuid, ");
sqlCommand.Append("TagGuid, ");
sqlCommand.Append("ExtraGuid, ");
sqlCommand.Append("TaggedBy ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@Guid, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@FeatureGuid, ");
sqlCommand.Append("@ModuleGuid, ");
sqlCommand.Append("@ItemGuid, ");
sqlCommand.Append("@TagGuid, ");
sqlCommand.Append("@ExtraGuid, ");
sqlCommand.Append("@TaggedBy ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[8];
arParams[0] = new SqlCeParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = siteGuid;
arParams[2] = new SqlCeParameter("@FeatureGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = featureGuid;
arParams[3] = new SqlCeParameter("@ModuleGuid", SqlDbType.UniqueIdentifier);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = moduleGuid;
arParams[4] = new SqlCeParameter("@ItemGuid", SqlDbType.UniqueIdentifier);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = itemGuid;
arParams[5] = new SqlCeParameter("@TagGuid", SqlDbType.UniqueIdentifier);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = tagGuid;
arParams[6] = new SqlCeParameter("@ExtraGuid", SqlDbType.UniqueIdentifier);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = extraGuid;
arParams[7] = new SqlCeParameter("@TaggedBy", SqlDbType.UniqueIdentifier);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = taggedBy;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
/// <summary>
/// Inserts a row in the mp_PaymentLog table. Returns rows affected count.
/// </summary>
/// <param name="rowGuid"> rowGuid </param>
/// <param name="createdUtc"> createdUtc </param>
/// <param name="siteGuid"> siteGuid </param>
/// <param name="userGuid"> userGuid </param>
/// <param name="storeGuid"> storeGuid </param>
/// <param name="cartGuid"> cartGuid </param>
/// <param name="provider"> provider </param>
/// <param name="rawResponse"> rawResponse </param>
/// <param name="responseCode"> responseCode </param>
/// <param name="responseReasonCode"> responseReasonCode </param>
/// <param name="reason"> reason </param>
/// <param name="avsCode"> avsCode </param>
/// <param name="ccvCode"> ccvCode </param>
/// <param name="cavCode"> cavCode </param>
/// <param name="transactionId"> transactionId </param>
/// <param name="transactionType"> transactionType </param>
/// <param name="method"> method </param>
/// <param name="authCode"> authCode </param>
/// <param name="amount"> amount </param>
/// <param name="tax"> tax </param>
/// <param name="duty"> duty </param>
/// <param name="freight"> freight </param>
/// <returns>int</returns>
public static int Create(
Guid rowGuid,
DateTime createdUtc,
Guid siteGuid,
Guid userGuid,
Guid storeGuid,
Guid cartGuid,
string provider,
string rawResponse,
string responseCode,
string responseReasonCode,
string reason,
string avsCode,
string ccvCode,
string cavCode,
string transactionId,
string transactionType,
string method,
string authCode,
decimal amount,
decimal tax,
decimal duty,
decimal freight)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("INSERT INTO mp_PaymentLog ");
sqlCommand.Append("(");
sqlCommand.Append("RowGuid, ");
sqlCommand.Append("CreatedUtc, ");
sqlCommand.Append("SiteGuid, ");
sqlCommand.Append("UserGuid, ");
sqlCommand.Append("StoreGuid, ");
sqlCommand.Append("CartGuid, ");
sqlCommand.Append("Provider, ");
sqlCommand.Append("RawResponse, ");
sqlCommand.Append("ResponseCode, ");
sqlCommand.Append("ResponseReasonCode, ");
sqlCommand.Append("Reason, ");
sqlCommand.Append("AvsCode, ");
sqlCommand.Append("CcvCode, ");
sqlCommand.Append("CavCode, ");
sqlCommand.Append("TransactionId, ");
sqlCommand.Append("TransactionType, ");
sqlCommand.Append("Method, ");
sqlCommand.Append("AuthCode, ");
sqlCommand.Append("Amount, ");
sqlCommand.Append("Tax, ");
sqlCommand.Append("Duty, ");
sqlCommand.Append("Freight ");
sqlCommand.Append(")");
sqlCommand.Append(" VALUES ");
sqlCommand.Append("(");
sqlCommand.Append("@RowGuid, ");
sqlCommand.Append("@CreatedUtc, ");
sqlCommand.Append("@SiteGuid, ");
sqlCommand.Append("@UserGuid, ");
sqlCommand.Append("@StoreGuid, ");
sqlCommand.Append("@CartGuid, ");
sqlCommand.Append("@Provider, ");
sqlCommand.Append("@RawResponse, ");
sqlCommand.Append("@ResponseCode, ");
sqlCommand.Append("@ResponseReasonCode, ");
sqlCommand.Append("@Reason, ");
sqlCommand.Append("@AvsCode, ");
sqlCommand.Append("@CcvCode, ");
sqlCommand.Append("@CavCode, ");
sqlCommand.Append("@TransactionId, ");
sqlCommand.Append("@TransactionType, ");
sqlCommand.Append("@Method, ");
sqlCommand.Append("@AuthCode, ");
sqlCommand.Append("@Amount, ");
sqlCommand.Append("@Tax, ");
sqlCommand.Append("@Duty, ");
sqlCommand.Append("@Freight ");
sqlCommand.Append(")");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[22];
arParams[0] = new SqlCeParameter("@RowGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = rowGuid;
arParams[1] = new SqlCeParameter("@CreatedUtc", SqlDbType.DateTime);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = createdUtc;
arParams[2] = new SqlCeParameter("@SiteGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = siteGuid;
arParams[3] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = userGuid;
arParams[4] = new SqlCeParameter("@StoreGuid", SqlDbType.UniqueIdentifier);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = storeGuid;
arParams[5] = new SqlCeParameter("@CartGuid", SqlDbType.UniqueIdentifier);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = cartGuid;
arParams[6] = new SqlCeParameter("@RawResponse", SqlDbType.NText);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = rawResponse;
arParams[7] = new SqlCeParameter("@ResponseCode", SqlDbType.NChar, 1);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = responseCode;
arParams[8] = new SqlCeParameter("@ResponseReasonCode", SqlDbType.NVarChar, 20);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = responseReasonCode;
arParams[9] = new SqlCeParameter("@Reason", SqlDbType.NText);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = reason;
arParams[10] = new SqlCeParameter("@AvsCode", SqlDbType.NVarChar, 50);
arParams[10].Direction = ParameterDirection.Input;
arParams[10].Value = avsCode;
arParams[11] = new SqlCeParameter("@CcvCode", SqlDbType.NChar, 1);
arParams[11].Direction = ParameterDirection.Input;
arParams[11].Value = ccvCode;
arParams[12] = new SqlCeParameter("@CavCode", SqlDbType.NChar, 1);
arParams[12].Direction = ParameterDirection.Input;
arParams[12].Value = cavCode;
arParams[13] = new SqlCeParameter("@TransactionId", SqlDbType.NVarChar, 50);
arParams[13].Direction = ParameterDirection.Input;
arParams[13].Value = transactionId;
arParams[14] = new SqlCeParameter("@TransactionType", SqlDbType.NVarChar, 50);
arParams[14].Direction = ParameterDirection.Input;
arParams[14].Value = transactionType;
arParams[15] = new SqlCeParameter("@Method", SqlDbType.NVarChar, 20);
arParams[15].Direction = ParameterDirection.Input;
arParams[15].Value = method;
arParams[16] = new SqlCeParameter("@AuthCode", SqlDbType.NVarChar, 50);
arParams[16].Direction = ParameterDirection.Input;
arParams[16].Value = authCode;
arParams[17] = new SqlCeParameter("@Amount", SqlDbType.Decimal);
arParams[17].Direction = ParameterDirection.Input;
arParams[17].Value = amount;
arParams[18] = new SqlCeParameter("@Tax", SqlDbType.Decimal);
arParams[18].Direction = ParameterDirection.Input;
arParams[18].Value = tax;
arParams[19] = new SqlCeParameter("@Duty", SqlDbType.Decimal);
arParams[19].Direction = ParameterDirection.Input;
arParams[19].Value = duty;
arParams[20] = new SqlCeParameter("@Freight", SqlDbType.Decimal);
arParams[20].Direction = ParameterDirection.Input;
arParams[20].Value = freight;
arParams[21] = new SqlCeParameter("@Provider", SqlDbType.NVarChar, 100);
arParams[21].Direction = ParameterDirection.Input;
arParams[21].Value = provider;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected);
}
public static bool UpdateSharedFile(
int itemId,
int moduleId,
int uploadUserId,
string friendlyName,
string originalFileName,
string serverFileName,
int sizeInKB,
DateTime uploadDate,
int folderId,
Guid folderGuid,
Guid userGuid,
string description)
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append("UPDATE mp_SharedFiles ");
sqlCommand.Append("SET ");
//sqlCommand.Append("ModuleID = @ModuleID, ");
sqlCommand.Append("UploadUserID = @UploadUserID, ");
sqlCommand.Append("FriendlyName = @FriendlyName, ");
sqlCommand.Append("OriginalFileName = @OriginalFileName, ");
sqlCommand.Append("ServerFileName = @ServerFileName, ");
sqlCommand.Append("SizeInKB = @SizeInKB, ");
sqlCommand.Append("UploadDate = @UploadDate, ");
sqlCommand.Append("FolderID = @FolderID, ");
sqlCommand.Append("UserGuid = @UserGuid, ");
sqlCommand.Append("FolderGuid = @FolderGuid, ");
sqlCommand.Append("Description = @Description ");
sqlCommand.Append("WHERE ");
sqlCommand.Append("ItemID = @ItemID ");
sqlCommand.Append(";");
SqlCeParameter[] arParams = new SqlCeParameter[12];
arParams[0] = new SqlCeParameter("@ItemID", SqlDbType.Int);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = itemId;
arParams[1] = new SqlCeParameter("@ModuleID", SqlDbType.Int);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = moduleId;
arParams[2] = new SqlCeParameter("@UploadUserID", SqlDbType.Int);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = uploadUserId;
arParams[3] = new SqlCeParameter("@FriendlyName", SqlDbType.NVarChar, 255);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = friendlyName;
arParams[4] = new SqlCeParameter("@OriginalFileName", SqlDbType.NVarChar, 255);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = originalFileName;
arParams[5] = new SqlCeParameter("@ServerFileName", SqlDbType.NVarChar, 255);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = serverFileName;
arParams[6] = new SqlCeParameter("@SizeInKB", SqlDbType.Int);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = sizeInKB;
arParams[7] = new SqlCeParameter("@UploadDate", SqlDbType.DateTime);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = uploadDate;
arParams[8] = new SqlCeParameter("@FolderID", SqlDbType.Int);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = folderId;
arParams[9] = new SqlCeParameter("@UserGuid", SqlDbType.UniqueIdentifier);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = userGuid;
arParams[10] = new SqlCeParameter("@FolderGuid", SqlDbType.UniqueIdentifier);
arParams[10].Direction = ParameterDirection.Input;
arParams[10].Value = folderGuid;
arParams[11] = new SqlCeParameter("@Description", SqlDbType.NVarChar);
arParams[11].Direction = ParameterDirection.Input;
arParams[11].Value = description;
int rowsAffected = SqlHelper.ExecuteNonQuery(
GetConnectionString(),
CommandType.Text,
sqlCommand.ToString(),
arParams);
return(rowsAffected > -1);
}
