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 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 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 void DeleteAttributeValues(string objectName, int itemId)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_remove_item_attribute_values";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("ObjectName", objectName));
parameters.Add(new SqlParameter("ObjectItemID", itemId));
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters.ToArray());
}
public static void DeleteSingleObjectAttribute(int objectId, int attributeId)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_remove_single_object_attribute";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("ObjectId", objectId));
parameters.Add(new SqlParameter("AttributeId", attributeId));
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters.ToArray());
}
public static int UpdateCustomer(int orderId, string custXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_customer";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[1] = new SqlParameter("orderId", orderId);
ParamVal[0] = new SqlParameter("custxml", custXML);
return(Convert.ToInt32(BaseSqlHelper.ExecuteScalar(connectionString, ProcName, ParamVal)));
}
public static void UpdateOrderAfterUpSell(int orderId, string orderXML)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_ordertotal";
SqlParameter[] ParamVal = new SqlParameter[2];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("orderXML", orderXML);
BaseSqlHelper.ExecuteScalar(connectionString, ProcName, ParamVal);
}
public static int SaveOrder(int orderId, string orderXML, string requestParam)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_update_order";
SqlParameter[] ParamVal = new SqlParameter[3];
ParamVal[0] = new SqlParameter("orderId", orderId);
ParamVal[1] = new SqlParameter("orderXML", orderXML);
ParamVal[2] = new SqlParameter("requestParam", requestParam);
return(Convert.ToInt32(BaseSqlHelper.ExecuteScalar(connectionString, ProcName, ParamVal)));
}
public static void SaveAttributeById(int attributeId, string attributeName, string description, string defaultValueTypeName)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_save_attribute_byid";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("AttributeId", attributeId));
parameters.Add(new SqlParameter("AttributeName", attributeName));
parameters.Add(new SqlParameter("Description", description));
parameters.Add(new SqlParameter("DefaultValueTypeName", defaultValueTypeName));
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters.ToArray());
}
public static void InsertMVISOrderLogixLog(int OrderID, int PostStatusID, string ErroMessage, int OrderID_MVIS)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_MVISOrderLogixlog";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@OrderID", OrderID));
parameters.Add(new SqlParameter("@PostStatusID", PostStatusID));
parameters.Add(new SqlParameter("@ErroMessage", ErroMessage));
parameters.Add(new SqlParameter("@OrderID_MVIS", OrderID_MVIS));
BaseSqlHelper.ExecuteScalar(connectionString, ProcName, parameters.ToArray());
}
public static void SaveObjectAttribute(int objectId, int attributeId, int objectAttributeTypeId, string description, string displayLabel)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_save_object_attribute";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("ObjectId", objectId));
parameters.Add(new SqlParameter("AttributeId", attributeId));
parameters.Add(new SqlParameter("ObjectAttributeTypeId", objectAttributeTypeId));
parameters.Add(new SqlParameter("Description", description));
parameters.Add(new SqlParameter("DisplayLabel", displayLabel));
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters.ToArray());
}
public static void InsertContact(string firstName, string lastName, string email, string phone, string message, string URL)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_insert_contact";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("FirstName", firstName));
parameters.Add(new SqlParameter("LastName", lastName));
parameters.Add(new SqlParameter("Email", email));
parameters.Add(new SqlParameter("Phone", phone));
parameters.Add(new SqlParameter("Message", message));
parameters.Add(new SqlParameter("URL", URL));
BaseSqlHelper.ExecuteScalar(connectionString, ProcName, parameters.ToArray());
}
public static int SaveAttribute(string attributeName, string description)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_save_attribute";
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("AttributeName", attributeName);
parameters[1] = new SqlParameter("Description", description);
parameters[2] = new SqlParameter()
{
ParameterName = "AttributeID", Direction = System.Data.ParameterDirection.Output, SqlDbType = System.Data.SqlDbType.Int, Size = 4
};
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters);
return(Convert.ToInt32(parameters[2].Value));
}
public static int SaveAttributeValue(string objectName, string attributeName, int itemId, string value)
{
string connectionString = ConfigHelper.GetDBConnection();
String procName = "pr_save_attribute_value";
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("ObjectName", objectName);
parameters[1] = new SqlParameter("AttributeName", attributeName);
parameters[2] = new SqlParameter("ObjectItemID", itemId);
parameters[3] = new SqlParameter("Value", value);
parameters[4] = new SqlParameter()
{
ParameterName = "ObjectAttributeValueID", Direction = System.Data.ParameterDirection.Output, SqlDbType = System.Data.SqlDbType.Int, Size = 4
};
BaseSqlHelper.ExecuteScalar(connectionString, procName, parameters);
return(Convert.ToInt32(parameters[4].Value));
}
public static void InsertContactMike(string firstName, string lastName, string email, string subject, string message, string schoolName,
string city, string state, string phoneNumber)
{
string connectionString = ConfigHelper.GetDBConnection();
String ProcName = "pr_custom_insert_contactmike";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("FirstName", firstName));
parameters.Add(new SqlParameter("LastName", lastName));
parameters.Add(new SqlParameter("Email", email));
parameters.Add(new SqlParameter("Subject", subject));
parameters.Add(new SqlParameter("Message", message));
parameters.Add(new SqlParameter("SchoolName", schoolName));
parameters.Add(new SqlParameter("City", city));
parameters.Add(new SqlParameter("State", state));
parameters.Add(new SqlParameter("PhoneNumber", phoneNumber));
BaseSqlHelper.ExecuteScalar(connectionString, ProcName, parameters.ToArray());
}