Ejemplo n.º 1
0
        public static DataSet GetFromSearch(Hashtable searchParams)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();
            string  query;

            try
            {
                query  = "procSearchCustomers ";
                query += "'" + searchParams["firstName"] + "',";
                query += "'" + searchParams["lastName"] + "',";
                query += "'" + searchParams["billingAddr"] + "',";
                query += "'" + searchParams["billingState"] + "',";
                query += "'" + searchParams["billingCity"] + "',";
                query += "'" + searchParams["billingZip"] + "',";
                query += "'" + searchParams["servAddr"] + "',";
                query += "'" + searchParams["servCity"] + "',";
                query += "'" + searchParams["servZip"] + "',";
                query += "'" + searchParams["servState"] + "',";
                query += "'" + searchParams["wtn"] + "',";
                query += "'" + searchParams["company"] + "',";
                query += searchParams["campaignID"];
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblCustomer", query, conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 2
0
        public static DataSet GetNextCustomer(long campaignID, string fileName, long dispositionID, string state, string tzidList, string user, long langID)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();
            string  query;

            try
            {
                query  = "proctblCustomerSELNextCustomer ";
                query += campaignID.ToString() + ",";
                query += "'" + fileName + "',";
                query += dispositionID.ToString() + ",";
                query += "'" + state + "',";
                query += "'" + tzidList + "',";
                query += "'" + user + "',";
                query += langID.ToString();
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblCustomerCampaign", query, conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 3
0
        public static DataSet GetByID(long cust_camp_id)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();

            try
            {
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblCustomerCampaign", "proctblCustomerCampaignSEL " + cust_camp_id.ToString(), conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 4
0
        public static DataSet GetAll()
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();

            try
            {
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblProdType", "proctblProdTypeSELALL", conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 5
0
        public static DataSet GetByCurrentPlanID(long plan_id)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();

            try
            {
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblCurrentPlanDetail", "proctblCurrentPlanDetailSELBYCurrentPlanID " + plan_id.ToString(), conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 6
0
        public static DataSet GetByAccountID(long acct_id)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();

            try
            {
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds, "tblWTN", "proctblWTNSELByAccountID " + acct_id.ToString(), conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }
Ejemplo n.º 7
0
        public static DataSet GetByQuestionID(long question_id)
        {
            DataSet ds             = new DataSet();
            string  connect_string = DataTierHelpers.GetConnectionString();

            try
            {
                SqlConnection conn = new SqlConnection(connect_string);
                conn.Open();
                DataTierHelpers.CreateDataTable(ds,
                                                "tblAvailableLookupInfo",
                                                "proctblAvailableLookupInfoSELBYQuestionID " + question_id.ToString(),
                                                conn);
                conn.Close();
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
            return(ds);
        }