private static void subAddItem(ref System.Windows.Forms.ComboBox _cboAddTo, long _lngIDToAdd, string _strItem)
{
clsCboItem cboNew = new clsCboItem(_lngIDToAdd, _strItem);
_cboAddTo.Items.Add(cboNew);
}
private void subRefreshCalendars(ComboBox _cboToRefresh)
{
Cursor.Current = Cursors.WaitCursor;
try
{
_cboToRefresh.Items.Clear();
CalendarList lstCals = svcCTCal.CalendarList.List().Fetch();
foreach (CalendarListEntry cntCalendar in lstCals.Items)
{
clsCboItem itmNew = new clsCboItem(cntCalendar.Id,cntCalendar.Summary);
_cboToRefresh.Items.Add(itmNew);
}
}
catch (Exception ex)
{
MessageBox.Show("There was an error refreshing the calendar list: " + ex.Message);
}
Cursor.Current = Cursors.Default;
}
public static void subFillTitleCbo(ref System.Windows.Forms.ComboBox _cboToFill)
{
clsCboItem cboNew = new clsCboItem("", "");
_cboToFill.Items.Add(cboNew);
cboNew = new clsCboItem("Mr.", "Mr.");
_cboToFill.Items.Add(cboNew);
cboNew = new clsCboItem("Mrs.", "Mrs.");
_cboToFill.Items.Add(cboNew);
cboNew = new clsCboItem("Dr.", "Dr.");
_cboToFill.Items.Add(cboNew);
cboNew = new clsCboItem("Miss", "Miss");
_cboToFill.Items.Add(cboNew);
cboNew = new clsCboItem("Ms.", "Ms.");
_cboToFill.Items.Add(cboNew);
}
private void frmSystemSetup_Load(object sender, EventArgs e)
{
string strSQL = "";
clsCboItem cboCCMethodID;
//-------------------settings tab init --------------------
txtStationID.Text = Settings.Default.lngWSID.ToString();
//----------------Connect Tab init --------------------------------
txtCTConnection.Text = Settings.Default.MainPath;
txtSQLServer.Text = Settings.Default.SQLServer;
txtSQLDatabase.Text = Settings.Default.SQLDatabase;
txtSQLUsername.Text = Settings.Default.SQLUserName;
txtSQLPassword.Text = Settings.Default.SQLPassword;
if (CTWebMgmt.blnUseSQLServer)
{
radSQLServer.Checked = true;
radMSAccess.Checked = false;
}
else
{
radSQLServer.Checked = false;
radMSAccess.Checked = true;
}
subSetCtlVisibility();
if (txtCTConnection.Text == "D:\\projects\\CampTrak\\Data\\ctmain_b.mdb")
btnDev.Visible = true;
else
btnDev.Visible = false;
//------------------cc setup----------------------
foreach (int lngCCMethod in Enum.GetValues(typeof(clsGlobalEnum.conLIVECHARGE)))
{
cboCCMethodID = new clsCboItem(lngCCMethod, Enum.GetName(typeof(clsGlobalEnum.conLIVECHARGE), lngCCMethod));
cboCCMethod.Items.Add(cboCCMethodID);
}
txtXChargePath.Text = clsAppSettings.GetAppSettings().strXChargePath;
txtCashLinqUser.Text = clsAppSettings.GetAppSettings().strCashLinqUName;
txtCashLinqPW.Text = clsAppSettings.GetAppSettings().strCashLinqPW;
txtCashLinqCQUser.Text = clsAppSettings.GetAppSettings().strCashLinqCQUser;
txtCashLinqCQPW.Text = clsAppSettings.GetAppSettings().strCashLinqCQPW;
txtCashLinqCQMerchantID.Text = clsAppSettings.GetAppSettings().strCashLinqCQMerchantID;
lblXChargePath.Visible = false;
txtXChargePath.Visible = false;
btnSetXChargePath.Visible = false;
lblCashLinqUser.Visible = false;
txtCashLinqUser.Visible = false;
lblCashLinqPW.Visible = false;
txtCashLinqPW.Visible = false;
lblCashLinqCQUser.Visible = false;
lblCashLinqCQPW.Visible = false;
lblCashLinqCQMerchantID.Visible = false;
txtCashLinqCQUser.Visible = false;
txtCashLinqCQPW.Visible = false;
txtCashLinqCQMerchantID.Visible = false;
if (clsAppSettings.GetAppSettings().lngLiveCharge == clsGlobalEnum.conLIVECHARGE.XCharge)
{
txtXChargePath.Visible = true;
btnSetXChargePath.Visible = true;
lblXChargePath.Visible = true;
}
else if (clsAppSettings.GetAppSettings().lngLiveCharge == clsGlobalEnum.conLIVECHARGE.CashLinq)
{
txtCashLinqUser.Visible = true;
txtCashLinqPW.Visible = true;
lblCashLinqUser.Visible = true;
lblCashLinqPW.Visible = true;
lblCashLinqCQUser.Visible = true;
lblCashLinqCQPW.Visible = true;
lblCashLinqCQMerchantID.Visible = true;
txtCashLinqCQUser.Visible = true;
txtCashLinqCQPW.Visible = true;
txtCashLinqCQMerchantID.Visible = true;
}
else if (clsAppSettings.GetAppSettings().lngLiveCharge == clsGlobalEnum.conLIVECHARGE.XChargeXML)
{
lblXChargeXWebID.Visible = true;
txtXChargeXWebID.Visible = true;
lblXChargeAuthKey.Visible = true;
lblXChargeXWebID.Visible = true;
}
try
{
//campaign codes
using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn))
{
conDB.Open();
strSQL = "SELECT tlkpCampaignCodes.lngCampaignID, " +
"tlkpCampaignCodes.strCampaignCode " +
"FROM tlkpCampaignCodes " +
"WHERE tlkpCampaignCodes.blnActive=True " +
"ORDER BY tlkpCampaignCodes.strCampaignCode";
using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB))
{
using (OleDbDataReader drCampaigns = cmdDB.ExecuteReader())
{
while (drCampaigns.Read())
{
clsCboItem cboNew = new clsCboItem(Convert.ToInt32(drCampaigns["lngCampaignID"]), Convert.ToString(drCampaigns["strCampaignCode"]));
cboDefaultCampaign.Items.Add(cboNew);
cboDXCampaign.Items.Add(new clsCboItem(cboNew.ID, cboNew.Item));
}
drCampaigns.Close();
}
strSQL = "SELECT tblGiftCategory.lngGiftCategoryID, " +
"[strGiftCategoryChoice] & \", \" & [strGiftAllocation] & IIf(Not ([strGiftSubAllocation]=\"None\"),\", \" & [strGiftSubAllocation]) AS strGiftCat " +
"FROM ((tblGiftCategory " +
"LEFT JOIN tlkpGiftCategoryChoice ON tblGiftCategory.lngGiftCategoryChoiceID = tlkpGiftCategoryChoice.lngGiftCategoryChoiceID) " +
"LEFT JOIN tlkpGiftAllocation ON tblGiftCategory.lngGiftAllocation = tlkpGiftAllocation.lngGiftAllocation) " +
"LEFT JOIN tlkpGiftSubAllocation ON tblGiftCategory.lngGiftSubAllocation = tlkpGiftSubAllocation.lngGiftSubAllocation " +
"ORDER BY tlkpGiftCategoryChoice.strGiftCategoryChoice, tlkpGiftAllocation.strGiftAllocation, tlkpGiftSubAllocation.strGiftSubAllocation";
cmdDB.CommandText = strSQL;
cmdDB.Parameters.Clear();
using (OleDbDataReader drGiftCat = cmdDB.ExecuteReader())
{
while (drGiftCat.Read())
{
clsCboItem cboNew = new clsCboItem(Convert.ToInt32(drGiftCat["lngGiftCategoryID"]), Convert.ToString(drGiftCat["strGiftCat"]));
cboIndRegCategory.Items.Add(cboNew);
cboDXCategory.Items.Add(new clsCboItem(cboNew.ID, cboNew.Item));
}
drGiftCat.Close();
}
strSQL = "SELECT lngLiveCharge, lngOLGiftCampaign, lngOLGiftCategoryID, lngDXCampaignID, lngDXCategoryID, " +
"strXChargeWebID, strXChargeAuthKey, strEncPassPhrase, strTextClientID, strMDCustomerID " +
"FROM tblCampDefaults";
cmdDB.CommandText = strSQL;
using (OleDbDataReader drDef = cmdDB.ExecuteReader())
{
if (drDef.Read())
{
try
{
txtClientID.Text = Convert.ToString(drDef["strTextClientID"]);
for (int intI = 0; intI < cboCCMethod.Items.Count; intI++)
{
if (((clsCboItem)cboCCMethod.Items[intI]).ID == Convert.ToInt32(drDef["lngLiveCharge"]))
cboCCMethod.SelectedIndex = intI;
}
txtXChargeXWebID.Text = Convert.ToString(drDef["strXChargeWebID"]);
txtXChargeAuthKey.Text = Convert.ToString(drDef["strXChargeAuthKey"]);
txtMDCustomerID.Text = Convert.ToString(drDef["strMDCustomerID"]);
long lngOLGiftCampaign = 0;
long lngOLGiftCategoryID = 0;
long lngDXCampaignID = 0;
long lngDXCategoryID = 0;
try { lngOLGiftCampaign = Convert.ToInt32(drDef["lngOLGiftCampaign"]); }
catch { lngOLGiftCampaign = 0; }
try { lngOLGiftCategoryID = Convert.ToInt32(drDef["lngOLGiftCategoryID"]); }
catch { lngOLGiftCategoryID = 0; }
try { lngDXCampaignID = Convert.ToInt32(drDef["lngDXCampaignID"]); }
catch { lngDXCampaignID = 0; }
try { lngDXCategoryID = Convert.ToInt32(drDef["lngDXCategoryID"]); }
catch { lngDXCategoryID = 0; }
clsCboItem.subSetSelectedIndex(ref cboDefaultCampaign, lngOLGiftCampaign);
clsCboItem.subSetSelectedIndex(ref cboIndRegCategory, lngOLGiftCategoryID);
clsCboItem.subSetSelectedIndex(ref cboDXCampaign, lngDXCampaignID);
clsCboItem.subSetSelectedIndex(ref cboDXCategory, lngDXCategoryID);
}
catch (Exception ex) { clsErr.subLogErr("frmSystemSetup.Load", ex); }
}
drDef.Close();
}
try
{
//load trans types
strSQL = "SELECT tlkpTransType.lngTransTypeID, " +
"IIf(IsNull([tblCustomTransType].[strCustomTransTypeLabel]),[tlkpTransType].[strTransType],[tblCustomTransType].[strCustomTransTypeLabel]) AS strTransType " +
"FROM tlkpTransType " +
"LEFT JOIN tblCustomTransType ON tlkpTransType.lngTransTypeID = tblCustomTransType.lngCustomTransTypeID " +
"WHERE tlkpTransType.blnDebitCredit = 0";
cmdDB.CommandText = strSQL;
cmdDB.Parameters.Clear();
using (OleDbDataReader drTrans = cmdDB.ExecuteReader())
{
cboTransTypeForCustomRegFlagCharge.Items.Add(new clsCboItem(0, ""));
while (drTrans.Read())
{
clsCboItem itmNew = new clsCboItem(Convert.ToInt32(drTrans["lngTransTypeID"]), Convert.ToString(drTrans["strTransType"]));
cboTransTypeForCustomRegFlagCharge.Items.Add(itmNew);
}
drTrans.Close();
}
//get current trans type
bool blnCapsWebProcessing = false;
long lngDefCustRegFlagTransType = 0;
strSQL = "SELECT blnCapsWebProcessing, " +
"lngDefCustRegFlagTransType " +
"FROM tblCampDefaults";
cmdDB.CommandText = strSQL;
cmdDB.Parameters.Clear();
using (OleDbDataReader drDef = cmdDB.ExecuteReader())
{
if (drDef.Read())
{
try { blnCapsWebProcessing = Convert.ToBoolean(drDef["blnCapsWebProcessing"]); }
catch { blnCapsWebProcessing = false; }
try { lngDefCustRegFlagTransType = Convert.ToInt32(drDef["lngDefCustRegFlagTransType"]); }
catch { lngDefCustRegFlagTransType = 0; }
}
drDef.Close();
}
for (int intI = 0; intI < cboTransTypeForCustomRegFlagCharge.Items.Count; intI++)
{
if (lngDefCustRegFlagTransType == ((clsCboItem)cboTransTypeForCustomRegFlagCharge.Items[intI]).ID)
cboTransTypeForCustomRegFlagCharge.SelectedIndex = intI;
}
}
catch { }
}
conDB.Close();
subLiveChargeVisibility();
}
}
catch { }
}
