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); } }