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 GetCreditCardInfo() { string connString = ConfigHelper.GetDBConnection(); string proc = "pr_credit_card_type_get"; BaseSqlHelper.ExecuteNonQuery(connString, proc); }
public static SqlDataReader GetCategory() { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_category"; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null)); }
public static SqlDataReader GetCreditCardTypes() { string connString = ConfigHelper.GetDBConnection(); string proc = "pr_credit_card_type_get"; return(BaseSqlHelper.ExecuteReader(connString, proc)); }
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 SqlDataReader GetAllSignupEntries() { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_signup_all"; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null)); }
public static SqlDataReader GetBatchProcessOrders() { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_order_batchprocess"; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null)); }
public static DataTable GetAllOrders(DateTime?startDate, DateTime?endDate, bool includeArchiveData, int startRec, int endRec, string firstName, string lastName, string email, out int totalCount) { DataTable dtTable = new DataTable(); string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_all_orders"; SqlParameter[] ParamVal = new SqlParameter[9]; ParamVal[0] = new SqlParameter("@startDate", startDate); ParamVal[1] = new SqlParameter("@endDate", endDate); ParamVal[2] = new SqlParameter("@includeArchiveData", includeArchiveData); ParamVal[3] = new SqlParameter("@startRec", startRec); ParamVal[4] = new SqlParameter("@endRec", endRec); ParamVal[5] = new SqlParameter("@firstName", firstName); ParamVal[6] = new SqlParameter("@lastName", lastName); ParamVal[7] = new SqlParameter("@email", email); SqlParameter paramter1 = new SqlParameter("@totalCount", SqlDbType.Int); paramter1.Direction = ParameterDirection.Output; ParamVal[8] = paramter1; BaseSqlHelper.Execute(connectionString, ProcName, ParamVal, dtTable, false); totalCount = Convert.ToInt32(ParamVal[8].Value); return(dtTable); }
public static SqlDataReader GetAllMasterCountries() { string connectionString = ConfigHelper.GetMasterDBConnection(); String ProcName = "pr_get_all_country"; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null)); }
public static SqlDataReader GetPathOrderProcess() { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_path_count"; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null)); }
public static SqlDataReader GetAllObjectAttributeTypes() { string connectionString = ConfigHelper.GetDBConnection(); String procName = "pr_get_all_object_attribute_types"; List <SqlParameter> parameters = new List <SqlParameter>(); return(BaseSqlHelper.ExecuteReader(connectionString, procName, parameters.ToArray())); }
public static SqlDataReader GetSignupEntry(string email) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_signup_email"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("Email", email); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal)); }
public static SqlDataReader GetTnTCampaigns() { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_tnt_campaigns"; SqlParameter[] ParamVal = new SqlParameter[0]; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal)); }
public static int InsertCartAbandonment(string cartAbandonmentXML) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_insert_cartAbandonment"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("cartAbandonmentXML", cartAbandonmentXML); return(Convert.ToInt32(BaseSqlHelper.ExecuteScalar(connectionString, ProcName, ParamVal))); }
public static SqlDataReader GetBatchProcessOrders(int orderId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_order_batch"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("orderId", orderId); return(BaseSqlHelper.ExecuteReader(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 RemoveCartAbandonment(int cartAbandonmentId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_remove_cartAbandonment"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("cartAbandonmentId", cartAbandonmentId); BaseSqlHelper.ExecuteScalar(connectionString, ProcName, ParamVal); }
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); }
/// <summary> /// Gets list of Objects associated to given attribute. /// </summary> /// <param name="attributeName"></param> /// <returns></returns> public static SqlDataReader GetAttributeObjects(string attributeName) { string connectionString = ConfigHelper.GetDBConnection(); String procName = "pr_get_attribute_objects"; SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("AttributeName", attributeName); return(BaseSqlHelper.ExecuteReader(connectionString, procName, parameters)); }
//Sri Comment: Make sure to set Parameter to helper class public static SqlDataReader GetAllFulfillmentHouseProviders(bool active) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_all_fulfillmenthouseprovider"; SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@active", active); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters)); }
public static SqlDataReader GetCoupon(int couponId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_coupon"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("couponId", couponId); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal)); }
public static SqlDataReader GetAllTemplates(bool includeExpired) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_all_templates"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("@includeExpired", (includeExpired) ? 1 : 0); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal)); }
public static SqlDataReader GetAllEmailList(int emailId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_all_emails"; SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@emailId", emailId); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters)); }
public static void RemoveResource(int resourceId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_remove_resource"; SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@resourceId", resourceId); BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters); }
public static SqlDataReader GetSCImportConfig() { string connectionString = ConfigHelper.GetMasterDBConnection(); String ProcName = "pr_get_configscimport"; SqlParameter[] ParamVal = new SqlParameter[0]; return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal)); }
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 DeleteAttribute(string attributeName) { string connectionString = ConfigHelper.GetDBConnection(); String procName = "pr_remove_attribute"; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("Name", attributeName)); BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters.ToArray()); }
public static SqlDataReader GetPrepaidCard(int cardNo) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_prepaidcard"; SqlParameter[] ParamVal = new SqlParameter[1]; ParamVal[0] = new SqlParameter("@card", cardNo); return(BaseSqlHelper.ExecuteReader(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 SqlDataReader GetAllStates(int countryId) { string connectionString = ConfigHelper.GetDBConnection(); String ProcName = "pr_get_all_states"; SqlParameter[] Parameters = new SqlParameter[1]; Parameters[0] = new SqlParameter("@countryId", countryId); return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters)); }