private void button1_ausAlterBestellung_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; bool isAdresseSelected = this.adressenDataGridView.SelectedRows.Count == 1; bool isBestellungSelected = this.bestellungenDataGridView.SelectedRows.Count == 1; if (isAdresseSelected && isBestellungSelected) { var datarow = this.adressenDataGridView.CurrentRow; DAL.DataSet1.AdressenRow row = (DAL.DataSet1.AdressenRow)((DataRowView)datarow.DataBoundItem).Row; var adressRow = this.adressenDataGridView.CurrentRow; neueBestellung.Adresse = Helper.Jsons.datagridrowToJson(adressRow); neueBestellung.ErstelltVon = Environment.UserName; neueBestellung.Datum = DateTime.Now; neueBestellung.Firmenname = row.Firmenname; neueBestellung.Email1Adresse = row.Email1Adresse == null ? "" : row.Email1Adresse; neueBestellung.AdressID = row.ID; // neueBestellung.Email2Adresse = row.Email2Adresse == null ? "" : row.Email2Adresse; //adressRow.Cells[0].Value.ToString(); string dieVorlage = this.bestellungenDataGridView.CurrentRow.Cells["speicherortDataGridViewTextBoxColumn"].Value.ToString(); if (File.Exists(dieVorlage)) { // hier wird die Bestellung auch gespeichert Helper.ExcelHelper.createNewExcelFromOldone(neueBestellung, dieVorlage); try { System.Diagnostics.Process.Start(neueBestellung.Speicherort); } catch (Exception ex) { if (ex.Message.Contains("Netzwerk")) { System.Diagnostics.Process.Start(neueBestellung.Speicherort.Replace("PRINTUMSERVER", "192.168.26.250")); } } } else { MessageBox.Show("Die Vorlage existiert nicht (mehr)."); } this.Close(); } else { MessageBox.Show("Bitte eine Adresse UND eine alte Bestellung auswählen"); } this.Cursor = Cursors.Default; }
private void NeueBestellung(object sender, EventArgs e, bool IsEnglich) { this.Cursor = Cursors.WaitCursor; bool isAdresseSelected = this.adressenDataGridView.SelectedRows.Count == 1; if (isAdresseSelected) { var adressRow = this.adressenDataGridView.CurrentRow; DAL.DataSet1.AdressenRow row = (DAL.DataSet1.AdressenRow)((DataRowView)adressRow.DataBoundItem).Row; neueBestellung.Adresse = Helper.Jsons.datagridrowToJson(adressRow); neueBestellung.ErstelltVon = Environment.UserName; neueBestellung.Datum = DateTime.Now; neueBestellung.Firmenname = row.Firmenname; neueBestellung.Email1Adresse = row.Email1Adresse == null ? "" : row.Email1Adresse; // neueBestellung.Email2Adresse = row.Email2Adresse == null ? "" : row.Email2Adresse; neueBestellung.AdressID = row.ID; Helper.ExcelHelper.createNewExcel(neueBestellung, IsEnglich); // Excel öffnen try { System.Diagnostics.Process.Start(neueBestellung.Speicherort); } catch (Exception ex) { if (ex.Message.Contains("Netzwerk")) { System.Diagnostics.Process.Start(neueBestellung.Speicherort.Replace("PRINTUMSERVER", "192.168.26.250")); } else { Helper.LogHelper.WriteDebugLog(ex.ToString()); } } this.Close(); } else { MessageBox.Show("Bitte eine Adresse auswählen"); } this.Cursor = Cursors.Default; }
private void AdresseWaehlenUndSchliessen() { var rows = this.adressenDataGridView.SelectedRows; if (rows.Count > 0) { try { var bounditem = rows[0].DataBoundItem; var rowview = ((DataRowView)bounditem).Row; this.rrrow = (DAL.DataSet1.AdressenRow)rowview; this.DialogResult = DialogResult.OK; this.Close(); //var L05 = Application.OpenForms["Lieferschein05_neuerLS"] as Lieferschein05_neuerLS; //if (L05 != null) //{ // // var rrrow = (DAL.DataSet1.AdressenRow)rowview; // L05.Adressenrow = this.rrrow; //} //var R05 = Application.OpenForms["Rechnung05_neueRE"] as Rechnung05_neueRE; //if (R05 != null) //{ // // var rrrow = (DAL.DataSet1.AdressenRow)rowview; // R05.Adressenrow = this.rrrow; //} } catch (Exception ex) { var name = "bla"; } finally { this.Close(); } } }
private void adressenDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { var datarow = this.adressenDataGridView.CurrentRow; DAL.DataSet1.AdressenRow row = (DAL.DataSet1.AdressenRow)((DataRowView)datarow.DataBoundItem).Row; string txt = "AdressID: " + row.AdressID + Environment.NewLine; txt += " Firmenname: " + row.Firmenname + Environment.NewLine; // txt += "ID: " + row.ID + Environment.NewLine; txt += "Name: " + row.Name + Environment.NewLine; txt += "JobTitle: " + row.JobTitle + Environment.NewLine; // txt += "Ort: " + row.Ort + Environment.NewLine; txt += "Strasse: " + row.Strasse + Environment.NewLine; // txt += "PLZ: " + row.PLZ + Environment.NewLine; txt += "PLZundORT: " + row.PLZundORT + Environment.NewLine; txt += "Land: " + row.Land + Environment.NewLine; txt += "Email1Adresse: " + row.Email1Adresse + Environment.NewLine; txt += "ZuHaendenVon: " + row.ZuHaendenVon + Environment.NewLine; txt += "Telefon1: " + row.Telefon1 + Environment.NewLine; txt += "Matchcode: " + row.Matchcode + Environment.NewLine; MessageBox.Show(txt); }
private void dieInfoAdressenAuslesen() { this.dataSet1.Adressen.Clear(); foreach (var adr in this.alleAdressen) { DAL.DataSet1.AdressenRow row = this.dataSet1.Adressen.NewAdressenRow(); try { string nachname = (adr.Surname == null) ? "" : adr.Surname; string vorname = (adr.GivenName == null) ? "" : adr.GivenName; row.Name = (vorname.Count() > 0) ? vorname + " " + nachname : nachname; row.Firmenname = (adr.CompanyName == null) ? "" : adr.CompanyName; row.businessHomePage = (adr.BusinessHomePage == null) ? "" : adr.BusinessHomePage; row.FileAs = (adr.FileAs == null) ? "" : adr.FileAs; row.ID = adr.Id.UniqueId; row.JobTitle = (adr.JobTitle == null) ? "" : adr.JobTitle; if (adr.DisplayName != null) { adr.DisplayName = (adr.GivenName == null) ? "" : adr.GivenName + " "; adr.DisplayName += (adr.Surname == null) ? "" : adr.Surname; } row.Matchcode = row.Firmenname + ", " + "(" + row.Name + "), "; PhysicalAddressEntry entry; PhysicalAddressKey key = PhysicalAddressKey.Business; if (adr.PhysicalAddresses.TryGetValue(key, out entry)) { row.Strasse = (entry.Street == null) ? "" : entry.Street; row.Ort = (entry.City == null) ? "" : entry.City; row.PLZ = (entry.PostalCode == null) ? "" : entry.PostalCode; row.Land = (entry.CountryOrRegion == null) ? "" : entry.CountryOrRegion; row.PLZundORT = row.PLZ + " " + row.Ort; row.Matchcode += row.PLZundORT; } EmailAddress eAdress1; EmailAddressKey eKey1 = EmailAddressKey.EmailAddress1; if (adr.EmailAddresses.TryGetValue(eKey1, out eAdress1)) { row.Email1Adresse = eAdress1.Address; } else { row.Email1Adresse = ""; } EmailAddress eAdress2; EmailAddressKey eKey2 = EmailAddressKey.EmailAddress2; if (adr.EmailAddresses.TryGetValue(eKey2, out eAdress2)) { row.Email2Adresse = eAdress2.Address; } else { row.Email2Adresse = ""; } StringList _categories = (adr.Categories == null) ? new StringList() : adr.Categories; } catch (Exception ex) { Helper.LogHelper.WriteDebugLog(ex.ToString()); } this.dataSet1.Adressen.AddAdressenRow(row); } }
private void dieInfoAdressenAuslesen() { this.dataSet1.Adressen.Clear(); foreach (var adr in this.alleAdressen) { DAL.DataSet1.AdressenRow row = this.dataSet1.Adressen.NewAdressenRow(); try { string nachname = (adr.Surname == null) ? "" : adr.Surname; row.Nachname = nachname; string vorname = (adr.GivenName == null) ? "" : adr.GivenName; row.Vorname = vorname; if (adr.Categories.Count > 0) { string categories = ""; foreach (var item in adr.Categories) { categories += item + " "; } row.Categories = categories; } row.Name = (vorname.Count() > 0) ? vorname + " " + nachname : nachname; row.Firmenname = (adr.CompanyName == null) ? "" : adr.CompanyName; row.businessHomePage = (adr.BusinessHomePage == null) ? "" : adr.BusinessHomePage; row.FileAs = (adr.FileAs == null) ? "" : adr.FileAs; row.ID = adr.Id.UniqueId; row.JobTitle = (adr.JobTitle == null) ? "" : adr.JobTitle; if (adr.DisplayName != null) { adr.DisplayName = (adr.GivenName == null) ? "" : adr.GivenName + " "; adr.DisplayName += (adr.Surname == null) ? "" : adr.Surname; } row.Matchcode = row.Firmenname + ", " + "(" + row.Name + "), "; PhysicalAddressEntry entry; PhysicalAddressKey key = PhysicalAddressKey.Business; if (adr.PhysicalAddresses.TryGetValue(key, out entry)) { row.Strasse = (entry.Street == null) ? "" : entry.Street; row.Ort = (entry.City == null) ? "" : entry.City; row.PLZ = (entry.PostalCode == null) ? "" : entry.PostalCode; row.Land = (entry.CountryOrRegion == null) ? "" : entry.CountryOrRegion; row.PLZundORT = row.PLZ + " " + row.Ort; row.Matchcode += row.PLZundORT; } //PhysicalAddressEntry pEntry; //PhysicalAddressKey pKey = PhysicalAddressKey.Business; //if (adr.PostalAddressIndex.HasValue) //{ // row.Strasse = (entry.Street == null) ? "" : entry.Street; // row.Ort = (entry.City == null) ? "" : entry.City; // row.PLZ = (entry.PostalCode == null) ? "" : entry.PostalCode; // row.Land = (entry.CountryOrRegion == null) ? "" : entry.CountryOrRegion; // row.PLZundORT = row.PLZ + " " + row.Ort; // row.Matchcode += row.PLZundORT; //} EmailAddress eAdress1; EmailAddressKey eKey1 = EmailAddressKey.EmailAddress1; if (adr.EmailAddresses.TryGetValue(eKey1, out eAdress1)) { row.Email1Adresse = eAdress1.Address; } else { row.Email1Adresse = ""; } EmailAddress eAdress2; EmailAddressKey eKey2 = EmailAddressKey.EmailAddress2; if (adr.EmailAddresses.TryGetValue(eKey2, out eAdress2)) { row.Email2Adresse = eAdress2.Address; } else { row.Email2Adresse = ""; } string buissnessNr = ""; PhoneNumberKey pKey = PhoneNumberKey.BusinessPhone; if (adr.PhoneNumbers.TryGetValue(pKey, out buissnessNr)) { row.Telefon1 = buissnessNr; } else { row.Telefon1 = ""; } string mobileNR = ""; PhoneNumberKey mKey = PhoneNumberKey.MobilePhone; if (adr.PhoneNumbers.TryGetValue(mKey, out mobileNR)) { row.TelefonMobile = mobileNR; } else { row.Telefon1 = ""; } } catch (Exception ex) { Helper.LogHelper.WriteDebugLog(ex.ToString()); } this.dataSet1.Adressen.AddAdressenRow(row); } }