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());
        }
示例#2
0
        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);
        }
示例#3
0
        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());
        }
示例#6
0
        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)));
        }
示例#7
0
        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);
        }
示例#8
0
        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());
        }
示例#12
0
        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));
        }
示例#15
0
        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());
        }