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