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