private void cmdAcceptChanges_Click(object sender, EventArgs e)
{
FillTextBox();
dgvSugarActive.DataSource = null;
dgvSugarActive.DataSource = m_DS.Tables[m_const_strSugarTableSearchAllPrivate].DefaultView;
cSugar m_objSugar = new cSugar(m_DS, m_BS);
m_objSugar.SaveChanges();
}
/// <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();
}
/// <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 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;
}
}
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 Sugarcrm Contacts Table.
/// </summary>
private void UpdateContactSugar()
{
cSugar m_objUpdateSugar = new cSugar(m_DS, m_BS_SugarSearchContacts);
MySqlConnection m_cnSugar = new MySqlConnection();
m_cnSugar = m_objUpdateSugar.SugarConnection;
StringBuilder sb_UpdateCommand = new StringBuilder();
sb_UpdateCommand.Append("UPDATE contacts SET ");
sb_UpdateCommand.Append(@"first_name='");
sb_UpdateCommand.Append(txtVorname.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"last_name='");
sb_UpdateCommand.Append(txtName.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"salutation='");
sb_UpdateCommand.Append(cboAnrede.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"primary_address_street='");
sb_UpdateCommand.Append(txtStrasse1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"primary_address_postalcode='");
sb_UpdateCommand.Append(txtPLZ.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"primary_address_city='");
sb_UpdateCommand.Append(txtOrt.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_fax='");
sb_UpdateCommand.Append(txtFax.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_mobile='");
sb_UpdateCommand.Append(txtMobile.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_work='");
sb_UpdateCommand.Append(txtPhon2.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_home='");
sb_UpdateCommand.Append(txtPhone1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"description='");
sb_UpdateCommand.Append(txtBemerkung.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"primary_address_country='");
sb_UpdateCommand.Append(txtSugarLand.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"lead_source='");
sb_UpdateCommand.Append(txtSugarLeadSource.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"department='");
sb_UpdateCommand.Append(txtSugarAbteilung.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"title='");
sb_UpdateCommand.Append(txtSugarTitle.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"birthdate='");
sb_UpdateCommand.Append(dtpGebDatum.Value.Year.ToString() + "-" + dtpGebDatum.Value.Month.ToString() + "-" + dtpGebDatum.Value.Day.ToString());
sb_UpdateCommand.Append(@"', ");
DateTime today = DateTime.Now;
sb_UpdateCommand.Append(@"date_modified='");
sb_UpdateCommand.Append(today.ToString("yyyy-MM-dd"));
sb_UpdateCommand.Append(@"'");
sb_UpdateCommand.Append(@" where id = '");
sb_UpdateCommand.Append(((DataRowView)m_BS_SugarSearchContacts.Current)["id"].ToString());
sb_UpdateCommand.Append(@"';");
MySqlCommand myUpdateCommand = new MySqlCommand(sb_UpdateCommand.ToString(), m_objSugar.SugarConnection);
if (myUpdateCommand.Connection.State == ConnectionState.Closed)
{
myUpdateCommand.Connection.Open();
}
try
{
myUpdateCommand.ExecuteNonQuery();
myUpdateCommand.Connection.Clone();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
/// <summary>
/// Updates the Current Company in the Sugar accounts table.
/// </summary>
private void UpdateCompanySugar()
{
cSugar m_objUpdateSugar = new cSugar(m_DS, m_BS_SugarSearchFirma);
MySqlConnection m_cnSugar = new MySqlConnection();
m_cnSugar = m_objUpdateSugar.SugarConnection;
StringBuilder sb_UpdateCommand = new StringBuilder();
sb_UpdateCommand.Append("UPDATE accounts SET ");
sb_UpdateCommand.Append(@"name='");
sb_UpdateCommand.Append(txtFName1.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"billing_address_street='");
sb_UpdateCommand.Append(txtFStrasse.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"billing_address_postalcode='");
sb_UpdateCommand.Append(txtFPLZ.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"billing_address_city='");
sb_UpdateCommand.Append(txtFOrt.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"billing_address_country='");
sb_UpdateCommand.Append(txtFSugarLand.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_office='");
sb_UpdateCommand.Append(txtFPhone.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"phone_fax='");
sb_UpdateCommand.Append(txtFFax.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"description='");
sb_UpdateCommand.Append(txtFBemerkung.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"website='");
sb_UpdateCommand.Append(txtFWeb.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"account_type='");
sb_UpdateCommand.Append(cboFSugarType.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"industry='");
sb_UpdateCommand.Append(cboFSugarIndustry.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"annual_revenue='");
sb_UpdateCommand.Append(txtFSugarUmsatz.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"employees='");
sb_UpdateCommand.Append(txtFSugarMitarbeiter.Text);
sb_UpdateCommand.Append(@"', ");
sb_UpdateCommand.Append(@"modified_user_id='");
sb_UpdateCommand.Append("ed2d04a5-8264-45e7-fbdb-4ebebdf8375a");
sb_UpdateCommand.Append(@"', ");
DateTime today = DateTime.Now;
sb_UpdateCommand.Append(@"date_modified='");
sb_UpdateCommand.Append(today.ToString("yyyy-MM-dd_HH:mm:ss"));
sb_UpdateCommand.Append(@"'");
sb_UpdateCommand.Append(@" where id = '");
sb_UpdateCommand.Append(((DataRowView)m_BS_SugarSearchFirma.Current)["id"].ToString());
sb_UpdateCommand.Append(@"';");
MySqlCommand myUpdateCommand = new MySqlCommand(sb_UpdateCommand.ToString(), m_objSugar.SugarConnection);
if (myUpdateCommand.Connection.State == ConnectionState.Closed)
{
myUpdateCommand.Connection.Open();
}
try
{
myUpdateCommand.ExecuteNonQuery();
myUpdateCommand.Connection.Clone();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}