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