public static void SaveTaxRegion(int countryId, int stateId, decimal value)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_taxregion";
try
{
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@countryId", countryId);
if (stateId == 0)
{
Parameters[1] = new SqlParameter("@stateId", System.DBNull.Value);
}
else
{
Parameters[1] = new SqlParameter("@stateId", stateId);
}
Parameters[2] = new SqlParameter("@value", value);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
catch (Exception ex)
{
throw new ApplicationException("CreateCountry() error: " + ex.Message, ex);
}
}
public static void SaveCreditCardInfo(int customerId, string cardHolderName, string cardNumber, int cardTypeId, int expiryMonth, int expiryYear, int cvsNumber, int addressId, int createdBy)
{
string connString = ConfigHelper.GetDBConnection();
string proc = "pr_credit_card_type_get";
BaseSqlHelper.ExecuteNonQuery(connString, proc);
}
public static void GetCreditCardInfo()
{
string connString = ConfigHelper.GetDBConnection();
string proc = "pr_credit_card_type_get";
BaseSqlHelper.ExecuteNonQuery(connString, proc);
}
public static void RemoveVersionCategory(int categoryId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_remove_versioncategory";
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("categoryId", categoryId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void RemoveEmail(int emailId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_remove_email";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@emailId", emailId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void RemoveCoupon(int couponId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_remove_coupon";
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("couponId", couponId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void SaveStates(string stateXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_states";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@statexml", stateXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void RemoveTemplate(int templateId)
{
string connectionString = ConfigHelper.GetDBConnection();
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("@templateId", templateId);
String ProcName = "pr_remove_template";
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void UpdateUser(int customerId, string custXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_user";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("customerId", customerId);
ParamVal[1] = new SqlParameter("custXML", custXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void RemoveOrder(int orderId)
{
string connectionString = ConfigHelper.GetDBConnection();
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("@orderId", orderId);
String ProcName = "pr_remove_order";
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void RemoveFulfillmentHouseProvider(int providerId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_remove_fulfillmenthouseprovider";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@providerId", providerId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void UpdateOrderTax(int orderId, decimal taxAmount)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_order_tax";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("@orderId", orderId);
ParamVal[1] = new SqlParameter("@taxAmount", taxAmount);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void UpdateOrderStatus(int orderId, int orderStatusId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_order_status";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("orderStatusId", orderStatusId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
//public static int SaveOrder(string orderXML)
//{
// return SaveOrder(orderXML, String.Empty);
//}
public static void SaveOrderPath(int orderId, int pathId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_order_path";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("@orderId", orderId);
ParamVal[1] = new SqlParameter("@pathId", pathId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void InsertSku(int skuId, string skuXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_sku";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("skuId", skuId);
ParamVal[1] = new SqlParameter("skuXML", skuXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void RemoveShippingRegion(int prefId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_remove_shippingRegion";
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("prefId", prefId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void InsertSignupEntry(string email, string Name)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_signup";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("Email", email);
ParamVal[1] = new SqlParameter("Name", Name);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void SaveFulfillmentHouseProvider(int providerId, string providerName, string providerXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_fulfillmenthouseprovider";
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@providerId", providerId);
Parameters[1] = new SqlParameter("@providerName", providerName);
Parameters[2] = new SqlParameter("@providerXml", providerXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void CopySku(int skuId, string objectName)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_copy_sku";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("skuId", skuId);
ParamVal[1] = new SqlParameter("ObjectName", objectName);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void SaveOrder(int orderId, string transactionCode, string authCode, int orderStatusId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_order_trans";
SqlParameter[] ParamVal = new SqlParameter[4];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("transactionCode", transactionCode);
ParamVal[2] = new SqlParameter("authCode", authCode);
ParamVal[3] = new SqlParameter("orderStatusId", orderStatusId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void SaveOrderInfo(int orderId, int orderStatusId, string fullfillmentRequest, string fullfillResponse)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_order_update_orderInfo";
SqlParameter[] ParamVal = new SqlParameter[4];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("orderStatuId", orderStatusId);
ParamVal[2] = new SqlParameter("fullfillRequest", fullfillmentRequest);
ParamVal[3] = new SqlParameter("fullfillResponse", fullfillResponse);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void UpdateCategory(int categoryId, string Name, bool active, int orderNo)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_category";
SqlParameter[] ParamVal = new SqlParameter[4];
ParamVal[0] = new SqlParameter("CategoryId", categoryId);
ParamVal[1] = new SqlParameter("Title", Name);
ParamVal[2] = new SqlParameter("Active", (active) ? 1 : 0);
ParamVal[3] = new SqlParameter("OrderNo", orderNo);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void InsertTnTCampaign(int versionId, int tntCampaignId, int tntExperienceId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_tnt_campaign";
SqlParameter[] ParamVal = new SqlParameter[3];
ParamVal[0] = new SqlParameter("@VersionId", versionId);
ParamVal[1] = new SqlParameter("@CampaignId", tntCampaignId);
ParamVal[2] = new SqlParameter("@ExperienceId", tntExperienceId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void FireEmailLog(int orderId, string email, string subject, string body, DateTime processDate)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_emaillog";
SqlParameter[] ParamVal = new SqlParameter[5];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("email", email);
ParamVal[2] = new SqlParameter("subject", subject);
ParamVal[3] = new SqlParameter("body", body);
ParamVal[4] = new SqlParameter("processDate", processDate);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
public static void UpdateVersion(int versionId, string Name, string shortName, bool active, int categoryId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_version";
SqlParameter[] ParamVal = new SqlParameter[5];
ParamVal[0] = new SqlParameter("versionId", versionId);
ParamVal[1] = new SqlParameter("title", Name);
ParamVal[2] = new SqlParameter("shortName", shortName);
ParamVal[3] = new SqlParameter("active", (active) ? 1 : 0);
ParamVal[4] = new SqlParameter("categoryId", categoryId);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, ParamVal);
}
private int DoInsert(string sql)
{
try
{
sql = "INSERT INTO nginxapplog(`hour`,`isfront`,`app`,`num`, `day`)VALUES" + sql;
return(sqlHelper.ExecuteNonQuery(sql));
}
catch (Exception exp)
{
logger.Error(exp.Message + "\r\n" + sql);
return(0);
}
}
public static void SaveUpsalePath(int pathId, string title, string code, decimal weight, string templateXML, string versionXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_path";
SqlParameter[] Parameters = new SqlParameter[6];
Parameters[0] = new SqlParameter("@pathId", pathId);
Parameters[1] = new SqlParameter("@title", title);
Parameters[2] = new SqlParameter("@code", code);
Parameters[3] = new SqlParameter("@weight", weight);
Parameters[4] = new SqlParameter("@templateXML", templateXML);
Parameters[5] = new SqlParameter("@versionXML", versionXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void SaveEmail(int emailId, string title, string fromAddress, string toAddress, string subject, string body)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_email";
SqlParameter[] Parameters = new SqlParameter[6];
Parameters[0] = new SqlParameter("@emailId", emailId);
Parameters[1] = new SqlParameter("@title", title);
Parameters[2] = new SqlParameter("@subject", subject);
Parameters[3] = new SqlParameter("@fromAddress", fromAddress);
Parameters[4] = new SqlParameter("@toAddress", toAddress);
Parameters[5] = new SqlParameter("@body", body);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void SaveTemplate(int templateId, string title, string body, string script, string tag, string uriLabel, DateTime?expireDate, string templateItemXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_template";
SqlParameter[] Parameters = new SqlParameter[8];
Parameters[0] = new SqlParameter("@templateId", templateId);
Parameters[1] = new SqlParameter("@title", title);
Parameters[2] = new SqlParameter("@body", body);
Parameters[3] = new SqlParameter("@script", script);
Parameters[4] = new SqlParameter("@tag", tag);
Parameters[5] = new SqlParameter("@expireDate", expireDate);
Parameters[6] = new SqlParameter("@templateItemXML", templateItemXML);
Parameters[7] = new SqlParameter("@uriLabel", uriLabel);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
public static void CreateCountry(string countryXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_country";
try
{
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@countryXML", countryXML);
BaseSqlHelper.ExecuteNonQuery(connectionString, ProcName, Parameters);
}
catch (Exception ex)
{
throw new ApplicationException("CreateCountry() error: " + ex.Message, ex);
}
}
