public static SqlDataReader GetAllSignupEntries()
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_signup_all";
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null));
}
public static SqlDataReader GetCategory()
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_category";
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, null));
}
public static SqlDataReader GetAllMasterCountries()
{
string connectionString = ConfigHelper.GetMasterDBConnection();
String ProcName = "pr_get_all_country";
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 SqlDataReader GetBatchProcessOrders()
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_order_batchprocess";
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 void SavePath(string pathXml)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_pathlist";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@pathXML", pathXml);
BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters);
}
/// <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));
}
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 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 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 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 GetTemplate(int templateId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_template";
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[0] = new SqlParameter("@templateId", templateId);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}
//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 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));
}
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 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 SqlDataReader GetSCImportConfig()
{
string connectionString = ConfigHelper.GetMasterDBConnection();
String ProcName = "pr_get_configscimport";
SqlParameter[] ParamVal = new SqlParameter[0];
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}
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 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 GetSCSiteVersion(int siteId)
{
string connectionString = ConfigHelper.GetMasterDBConnection();
String ProcName = "pr_get_site_scversion";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@SiteId", siteId));
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, sqlParams.ToArray()));
}
public static SqlDataReader GetUpSalePath(int pathId, bool expired)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_path";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("pathId", pathId);
ParamVal[1] = new SqlParameter("active", (expired) ? 1 : 0);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}
public static SqlDataReader GetCustomerDetails(int CustomerId)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_get_customer_full";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@CustomerId", CustomerId);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters));
}
public static SqlDataReader GetSiteDetails(int siteId)
{
string connectionString = ConfigHelper.GetMasterDBConnection();
String ProcName = "pr_get_sites_details";
SqlParameter[] ParamVal = new SqlParameter[1];
ParamVal[1] = new SqlParameter("@SiteId", siteId);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}
public static void SaveCountryTax(Dictionary <int, decimal> Values)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_taxregion";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@TableParam", Values.ToTableType());
Parameters[0].SqlDbType = SqlDbType.Structured;
BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters);
}
public static SqlDataReader SaveFulfillmentHouseProvider(List <Triplet <int, int, int> > Values)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_fulfillmenthouseprovider";
SqlParameter[] Parameters = new SqlParameter[1];
Parameters[0] = new SqlParameter("@TableParam", Values.ToTableType());
Parameters[0].SqlDbType = SqlDbType.Structured;
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, Parameters));
}
public static SqlDataReader GetAllAttributeValuesExtended(string objectName, int objectItemId)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_get_item_attribute_values_ext";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("ObjectName", objectName);
parameters[1] = new SqlParameter("ObjectItemID", objectItemId);
return(BaseSqlHelper.ExecuteReader(connectionString, procName, parameters));
}
public static SqlDataReader DBGetCustomReport(DateTime?StartDate, DateTime?EndDate)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_report_order_Custom";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("@StartDate", StartDate.Value);
ParamVal[1] = new SqlParameter("@EndDate", EndDate.Value);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}
public static SqlDataReader GetData(string ProcName, DateTime?startDate, DateTime?endDate, bool includeArchiveData)
{
string connectionString = ConfigHelper.GetDBConnection();
//String ProcName = "pr_report_order_url_detail";
SqlParameter[] ParamVal = new SqlParameter[3];
ParamVal[0] = new SqlParameter("@startDate", startDate);
ParamVal[1] = new SqlParameter("@endDate", endDate);
ParamVal[2] = new SqlParameter("@includeArchiveData", includeArchiveData);
return(BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal));
}