/// <summary>
/// Please make sure to set the property Privat to true or false
/// before calling any functions!
/// </summary>
/// <param name="ds">a DataSet</param>
/// <param name="searchstring">the searchstring</param>
/// <param name="obj_cao">the cCao Object from frmMain</param>
/// <param name="obj_sugar">the cSugar Object from frmMain</param>
/// <param name="mainform">reference to the frmMain</param>
/// <param name="bsCao">The Databinding for Cao</param>
/// <param name="bsSugar">The Databinding for Sugar</param>
public frmSuche(DataSet ds, string searchstring, cCao obj_cao, cSugar obj_sugar, frmMain mainform, BindingSource bsCao, BindingSource bsSugar)
{
m_strSuchstring = searchstring;
m_DS = ds;
m_objCao = obj_cao;
m_objSugar = obj_sugar;
this.frmMain = mainform;
m_BS_Cao = bsCao;
m_BS_Sugar = bsSugar;
InitializeComponent();
}
private void cmdTest_Click(object sender, EventArgs e)
{
Cugar.Properties.Settings.Default.caohost = txtCaoHost.Text;
Cugar.Properties.Settings.Default.caouser = txtCaoUser.Text;
Cugar.Properties.Settings.Default.caopw = txtCaoPW.Text;
Cugar.Properties.Settings.Default.sugarhost = txtSugarHost.Text;
Cugar.Properties.Settings.Default.sugaruser = txtSugarUser.Text;
Cugar.Properties.Settings.Default.sugarpw = txtSugarPW.Text;
Cugar.Properties.Settings.Default.Save();
Cugar.Properties.Settings.Default.Upgrade();
DataSet m_ds = new DataSet();
cCao m_objCao = new cCao(m_ds);
/* Test Cao connection */
if (m_objCao.testConnection == true)
{
/* on Success show a Message and save the success into caook */
MessageBox.Show("Cao Verbindung erfolgreich getestet.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
caook = true;
}
else
{
MessageBox.Show("Fehler in Cao Verbindung. \n Bitte überprüfen Sie die Einstellungen!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
/* Test Sugar Connection */
cSugar m_objSugar = new cSugar(m_ds);
if (m_objSugar.testConnection == true)
{
/* on success display a message and save the success into sugarok */
MessageBox.Show("Sugar Verbindung erfolgreich getestet.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
sugarok = true;
}
else
{
MessageBox.Show("Fehler in Sugar Verbindung. \n Bitte überprüfen Sie die Einstellungen!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (caook == true && sugarok == true)
{
/* the user may only save hes settings if both settings are correct */
MessageBox.Show("Beide Verbindungen erfolgreich getestet. Klicken Sie auf Speichern um fortzufahren...", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdSave.Enabled = true;
}
}
/// <summary>
/// Searches Cao and Sugar for contacts
/// according to the checked search criterion.
/// </summary>
/// <param name="searchstring">the stirng to search for</param>
public void StartSearchPrivat(string searchstring)
{
/* Create new Object cCao.
* Use the Search Contacts Method.
* Bind the DataSource from the Binding Source
* Set the DataSource for the dgv */
m_objCao = new cCao(m_DS, m_BS_Cao);
if (rbName.Checked == true)
{
m_objCao.SearchContactsByName(searchstring);
}
if (rbStrasse.Checked == true)
{
m_objCao.SearchContactsBySteet(searchstring);
}
if (rbTelefon.Checked == true)
{
m_objCao.SearchContactsByPhone(searchstring);
}
m_BS_Cao.DataSource = m_DS.Tables[m_const_strCaoTableSearchAllPrivate];
dgvCaoSuche.DataSource = m_BS_Cao;
HideRowsCao();
m_objSugar = new cSugar(m_DS, m_BS_Sugar);
if (rbName.Checked == true)
{
m_objSugar.SearchContactsByName(searchstring);
}
if (rbStrasse.Checked == true)
{
m_objSugar.SearchContactsByStreet(searchstring);
}
if (rbTelefon.Checked == true)
{
m_objSugar.SearchContactsByPhone(searchstring);
}
m_BS_Sugar.DataSource = m_DS.Tables[m_const_strSugarTableSearchAllPrivate];
dgvSugarSuche.DataSource = m_BS_Sugar;
HideRowsSugarContacts();
}
/// <summary>
/// Searches Cao and Sugar for companies
/// according to the checked search criterion.
/// </summary>
/// <param name="searchstring">the stirng to search for</param>
public void StartSearchFirma(string searchstring)
{
m_objCao = new cCao(m_DS, m_BS_Cao);
if (rbName.Checked == true)
{
m_objCao.SearchCompanyByName(searchstring);
}
if (rbStrasse.Checked == true)
{
m_objCao.SearchCompanyByStreet(searchstring);
}
if (rbTelefon.Checked == true)
{
m_objCao.SearchCompanyByPhone(searchstring);
}
m_BS_Cao.DataSource = m_DS.Tables[m_const_strCaoTableSearchAllCompanies];
dgvCaoSuche.DataSource = m_BS_Cao;
HideRowsCao();
m_objSugar = new cSugar(m_DS, m_BS_Sugar);
if (rbName.Checked == true)
{
m_objSugar.SearchCompanyByName(searchstring);
}
if (rbStrasse.Checked == true)
{
m_objSugar.SearchCompanyByStreet(searchstring);
}
if (rbTelefon.Checked == true)
{
m_objSugar.SearchCompanyByPhone(searchstring);
}
m_BS_Sugar.DataSource = m_DS.Tables[m_const_strSugarTableSearchAllCompanies];
dgvSugarSuche.DataSource = m_BS_Sugar;
HideRowsSugarCompanies();
}
private void Form1_Load(object sender, EventArgs e)
{
/* If its the first start show frmSettings */
if (Cugar.Properties.Settings.Default.first_start == true)
{
frmSettings m_SubForm_Settings = new frmSettings();
m_SubForm_Settings.ShowDialog();
}
if (m_DS.Tables.Count == 0)
{
#region prepare cCao Object and cSugar Object
try
{
m_objCao = new cCao(m_DS);
}
catch (Exception asdf)
{
MessageBox.Show(asdf.ToString());
Application.Exit();
}
try
{
m_objSugar = new cSugar(m_DS);
#region obsolete
//searchme
//m_objSugar = new cSugar(m_DS, m_BS_SugarSearchContacts);
//m_objSugar = new cSugar(m_DS);
//m_objSugar.LoadPrivateCustomers();
//m_dvSugar = m_DS.Tables[m_const_strSugarTablePrivate].DefaultView;
//dgvSugar.DataSource = m_dvSugar;
#endregion
}
catch (Exception asdf)
{
MessageBox.Show("Ein Fehler ist aufgetreten!\n Bitte überprüfen Sie die Einstellungen!");
MessageBox.Show(asdf.ToString());
Application.Exit();
}
#endregion
/* Versandarten ausfüllen */
if (m_objCao.testConnection == true)
{
LoadCaoVersandArten();
cboCaoVersand.SelectedIndex = 0;
}
/* zahlunggsarten ausfüllen */
if (m_objCao.testConnection == true)
{
LoadCaoZahlungsarten();
cboCaoZahlart.SelectedIndex = 0;
}
}
// Prepare cbos
cboAnrede.SelectedIndex = 0;
cboFAnrede.SelectedIndex = 0;
cboFSugarType.SelectedIndex = 0;
cboFCaoBriefanrede.SelectedIndex = 0;
cboFSugarType.SelectedIndex = 0;
cboCaoBriefanrede.SelectedIndex = 0;
cboFSugarIndustry.SelectedIndex = 0;
}
/// <summary>
/// Updates the Current Contact in the Cao adressen Table.
/// </summary>
private void UpdateContactCao()
{
cCao m_objUpdateSugar = new cCao(m_DS, m_BS_CaoSearchContacts);
OdbcConnection m_cnCao = new OdbcConnection();
m_cnCao = m_objCao.CaoConnection;
StringBuilder sb_UpdateCommand = new StringBuilder();
sb_UpdateCommand.Append("UPDATE adressen SET ");
sb_UpdateCommand.Append(@"KUNDENGRUPPE=1");
sb_UpdateCommand.Append(@", ");
sb_UpdateCommand.Append(@"NAME1='");
sb_UpdateCommand.Append(txtVorname.Text + " " + txtName.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"NAME2='");
sb_UpdateCommand.Append(txtName2.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"NAME3='");
sb_UpdateCommand.Append(txtName3.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"EMAIL='");
sb_UpdateCommand.Append(txtEmail.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"INTERNET='");
sb_UpdateCommand.Append(txtWebpage.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_ZAHLART='");
sb_UpdateCommand.Append(cboCaoZahlart.SelectedIndex + 1);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_LIEFART='");
sb_UpdateCommand.Append(cboCaoVersand.SelectedIndex + 1);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"ANREDE='");
sb_UpdateCommand.Append(cboAnrede.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"STRASSE='");
sb_UpdateCommand.Append(txtStrasse1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"PLZ='");
sb_UpdateCommand.Append(txtPLZ.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"ORT='");
sb_UpdateCommand.Append(txtOrt.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"FAX='");
sb_UpdateCommand.Append(txtFax.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"FUNK='");
sb_UpdateCommand.Append(txtMobile.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"TELE2='");
sb_UpdateCommand.Append(txtPhon2.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"TELE1='");
sb_UpdateCommand.Append(txtPhone1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"INFO='");
sb_UpdateCommand.Append(txtBemerkung.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_GEBDATUM='");
sb_UpdateCommand.Append(dtpGebDatum.Value.Year.ToString() + "-" + dtpGebDatum.Value.Month.ToString() + "-" + dtpGebDatum.Value.Day.ToString());
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"GEAEND_NAME='Cugar'");
sb_UpdateCommand.Append(@" where REC_ID = '");
sb_UpdateCommand.Append(((DataRowView)m_BS_CaoSearchContacts.Current)["REC_ID"].ToString());
sb_UpdateCommand.Append(@"';");
OdbcCommand myUpdateCommand = new OdbcCommand(sb_UpdateCommand.ToString(), m_objCao.CaoConnection);
if (myUpdateCommand.Connection.State == ConnectionState.Closed)
{
myUpdateCommand.Connection.Open();
}
try
{
myUpdateCommand.ExecuteNonQuery();
myUpdateCommand.Connection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
/// <summary>
/// Updates the Current Company in the Cao Contacts Table.
/// Using KUNDENGRUPPE=2
/// </summary>
private void UpdateCompanyCao()
{
cCao m_objUpdateSugar = new cCao(m_DS, m_BS_CaoSearchFirma);
OdbcConnection m_cnCao = new OdbcConnection();
m_cnCao = m_objCao.CaoConnection;
StringBuilder sb_UpdateCommand = new StringBuilder();
sb_UpdateCommand.Append("UPDATE adressen SET ");
sb_UpdateCommand.Append(@"KUNDENGRUPPE=2");
sb_UpdateCommand.Append(@", ");
sb_UpdateCommand.Append(@"NAME1='");
sb_UpdateCommand.Append(txtFName1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"NAME2='");
sb_UpdateCommand.Append(txtFName2.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"PLZ='");
sb_UpdateCommand.Append(txtFPLZ.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"ORT='");
sb_UpdateCommand.Append(txtFOrt.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"ANREDE='");
sb_UpdateCommand.Append(cboFAnrede.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"STRASSE='");
sb_UpdateCommand.Append(txtFStrasse.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"TELE1='");
sb_UpdateCommand.Append(txtFPhone.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"FAX='");
sb_UpdateCommand.Append(txtFFax.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"EMAIL='");
sb_UpdateCommand.Append(txtFMail.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"INTERNET='");
sb_UpdateCommand.Append(txtFWeb.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"BRT_TAGE='");
sb_UpdateCommand.Append(txtFZahlungsziel.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"INFO='");
sb_UpdateCommand.Append(txtFBemerkung.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_LIEFART='");
sb_UpdateCommand.Append(cboFVersand.SelectedIndex + 1);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_SEIT='");
sb_UpdateCommand.Append(dtpFKunSeit.Value.Year.ToString() + "-" + dtpFKunSeit.Value.Month.ToString() + "-" + dtpFKunSeit.Value.Day.ToString());
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"GEAEND_NAME='");
sb_UpdateCommand.Append("Cugar");
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"KUN_ZAHLART='");
sb_UpdateCommand.Append(cboFZahlart.SelectedIndex + 1);
sb_UpdateCommand.Append(@"'");
sb_UpdateCommand.Append(@" where REC_ID =");
sb_UpdateCommand.Append(((DataRowView)m_BS_CaoSearchFirma.Current)["REC_ID"].ToString());
sb_UpdateCommand.Append(@";");
OdbcCommand myUpdateCommand = new OdbcCommand(sb_UpdateCommand.ToString(), m_objCao.CaoConnection);
if (myUpdateCommand.Connection.State == ConnectionState.Closed)
{
myUpdateCommand.Connection.Open();
}
try
{
myUpdateCommand.ExecuteNonQuery();
myUpdateCommand.Connection.Close();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
