public ubergabe() { InitializeComponent(); if (isAdmin()) { ubergabeBox.ResetText(); ubergabeBox.Enabled = true; } else { ubergabeBox.Text = Person.getInfo()[0]; ubergabeBox.Enabled = false; } var list = new List <string>(); var query = "SELECT sachbearbeiter FROM pendenz"; var dataTable = db.Select(query); foreach (DataRow row in dataTable.Rows) { if (!ubergabeBox.Items.Contains(row[0])) { ubergabeBox.Items.Add(row[0]); } } }
private void submitButton_Click(object sender, EventArgs e) { string detailsText = $"{DateTime.Now} {Person.getInfo()[1]} {Person.getInfo()[2]}\n{detailsTextBox.Text}"; var lieferant = companyBox.Text; var referenz = referenceTextBox.Text; var document = documentTextBox.Text; var erfasstAm = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string erfasstVon = Person.getInfo()[0]; var sachbearbeiter = responsibleTextBox.Text.ToUpper(); var due = duePicker.Value.ToString("yyyy-MM-dd HH:mm:ss"); var details = detailsText; string department = ""; if (Person.isAdmin() && departmentBox.Text != "") { department = departmentBox.Text; } else { department = Person.getInfo()[4]; } checkEntries(); if (_error == false) { string query = $"INSERT INTO pendenz (lieferant, referenz, document, erfasst_am, erfasst_von, sachbearbeiter, due, detail, department) VALUES" + $"('{lieferant}', '{referenz.Replace("'", "''")}', '{document.Replace("'", "''")}', '{erfasstAm}', '{erfasstVon}', '{sachbearbeiter}', '{due}', '{details.Replace("'", "''")}', '{department}')"; db.Insert(query); Close(); } }
public static string admin() { if (!Person.isAdmin()) { return($"AND department = '{Person.getInfo()[4]}'"); } return(""); }
public static string admin(String modifier) { if (!Person.isAdmin()) { return($"{modifier} department = '{Person.getInfo()[4]}'"); } return(""); }
private string admin() { if (!isAdmin) { return($"AND department = '{Person.getInfo()[4]}'"); } return(""); }
private string dept() { if (isAdmin) { return("aller Abteilungen"); } return($"{Person.getInfo()[4]}"); }
private bool isAdmin() { if (Person.getInfo()[4] == "Informatik" || Person.getInfo()[4] == "GL") { return(true); } else { return(false); } }
private void submitButton_Click(object sender, EventArgs e) { if (companyIDTextBox.TextLength > 0) { string newDetails = $"Firma {companyIDTextBox.Text} erstellt\n{companyTextBox.Text}, {streetTextBox.Text}, {plzTextBox.Text}, {cityTextBox.Text}"; string history = $"{DateTime.Now.ToString("dd. MMM. yy HH:mm")} {Person.getInfo()}[1] {Person.getInfo()}[2]\n{newDetails}"; var verkaufKontakt = "Nein"; var einkaufKontakt = "Nein"; var verkaufBuspro = "Nein"; var einkaufBuspro = "Nein"; if (verkaufKontaktCheck.Checked) { verkaufKontakt = "Ja"; } if (einkaufKontaktCheck.Checked) { einkaufKontakt = "Ja"; } if (verkaufBusproCheck.Checked) { verkaufBuspro = "Ja"; } if (einkaufBusproCheck.Checked) { einkaufBuspro = "Ja"; } string query = $"INSERT INTO company VALUES ('{companyIDTextBox.Text}', '{companyTextBox.Text.Replace("'", "''")}', '{streetTextBox.Text.Replace("'", "''")}', '{poBoxTextBox.Text}', '{plzTextBox.Text}', '{cityTextBox.Text.Replace("'", "''")}', '{countryTextBox.Text}', '{phoneTextBox.Text}', '{urlTextBox.Text}', '{emailVerkaufTextBox.Text}', '{emailEinkaufTextBox.Text}', '{verkaufKontakt}', '{einkaufKontakt}', '{verkaufBuspro}', '{einkaufBuspro}', {neukundeVerkauf}, {neukundeEinkauf}, '{history.Replace("'", "''")}')"; Console.WriteLine(query); db.Insert(query); Close(); } else { var result = MessageBox.Show(Resources.idRequired, "Fehlende Eingabe", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); } }
private void submitButton_Click(object sender, EventArgs e) { var verkaufKontakt = "Nein"; var einkaufKontakt = "Nein"; var verkaufBuspro = "Nein"; var einkaufBuspro = "Nein"; var neukundeVerkauf = "null"; var neukundeEinkauf = "null"; if (verkaufKontaktCheck.Checked) { verkaufKontakt = "Ja"; } if (einkaufKontaktCheck.Checked) { einkaufKontakt = "Ja"; } if (verkaufBusproCheck.Checked) { verkaufBuspro = "Ja"; } if (einkaufBusproCheck.Checked) { einkaufBuspro = "Ja"; } if (neukundeVerkaufCheck.Checked) { neukundeVerkauf = DateTime.Now.ToString("yyyy-MM-dd"); neukundeVerkauf = $"'{neukundeVerkauf}'"; } if (neukundeEinkaufCheck.Checked) { neukundeEinkauf = DateTime.Now.ToString("yyyy-MM-dd"); neukundeEinkauf = $"'{neukundeEinkauf}'"; } var history = $"{DateTime.Now.ToString("dd. MMM. yy HH:mm")} {Person.getInfo()}[1] {Person.getInfo()}[2]\n" + newHistory(); string query = $"UPDATE company SET company_name='{companyTextBox.Text.Replace("'", "''")}', company_street='{streetTextBox.Text}', company_pobox='{poBoxTextBox.Text}', company_plz='{plzTextBox.Text}', company_city='{cityTextBox.Text.Replace("'", "''")}', company_country='{countryTextBox.Text}', company_phone='{phoneTextBox.Text}', company_website='{urlTextBox.Text}', company_verkaufmail='{emailVerkaufTextBox.Text}', company_einkaufmail='{emailEinkaufTextBox.Text}', company_verkaufkontakt='{verkaufKontakt}', company_einkaufkontakt='{einkaufKontakt}', company_verkaufBuspro='{verkaufBuspro}', company_einkaufBuspro='{einkaufBuspro}', company_sellersince = {neukundeVerkauf}, company_clientsince = {neukundeEinkauf}, company_history = '{history.Replace("'", "''")}' WHERE company_id = '{_id}'"; db.Update(query); Close(); }
private void submitStorno(object sender, EventArgs e) { if (!stornoFieldsComplete()) { MessageBox.Show("Bitte sämtliche Felder ausfüllen.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string department = Person.getInfo()[4]; if (Person.isAdmin() && departmentBox.Text != "") { department = departmentBox.Text; } var amountDouble = Double.Parse(amount.Text); var date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); var query = $"INSERT INTO stats (invoice, credit, company, amount, user, date, reason, department) Values " + $"('{invoice.Text}', '{credit.Text}', '{companyBox.Text}', {amountDouble}, '{Person.getID()}', '{date}', '{reasonBox.Text}', '{department}')"; db.Insert(query); } }
public AddIssue() { InitializeComponent(); if (Person.isAdmin()) { departmentLabel.Visible = true; departmentBox.Visible = true; foreach (String d in Departments.getList()) { departmentBox.Items.Add(d); } } setCompanyBox(); creatorLabel.Text = $"Erfasser: {Person.getInfo()[1]} {Person.getInfo()[2]}"; abteilungLabel.Text = $"Abteilung: {Person.getInfo()[4]}"; dateLabel.Text = $"Datum: {DateTime.Today.ToShortDateString()}"; duePicker.Value = DateTime.Now.AddDays(7); }
public mainForm() { InitializeComponent(); sendStats(); if (Person.isAdmin()) { departmentLabel.Visible = true; departmentBox.Visible = true; foreach (String d in Departments.getList()) { departmentBox.Items.Add(d); } } query = baseQuery + "FROM pendenz WHERE state = 'open'" + Query.admin() + Query.department(departmentBox.Text) + Query.ending("desc"); nameLabel.Text = $"Name: {Person.getInfo()[1]} {Person.getInfo()[2]} / {Person.getInfo()[0]}\nAbteilung: {Person.getInfo()[4]}\nDatum: {DateTime.Today.ToShortDateString()}"; string[] status = { "open", "done", "cancelled" }; foreach (var s in status) { searchStatusBox.Items.Add(s); } oldTable = db.Select(query); issueDataView.DataSource = oldTable; tabControl_Selected(null, null); isOn = true; setCompany(); setReason(); if (updateAvailable()) { updateButton.Text = "Updates verfügbar!"; updateButton.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); } threadStarter(); }
private void okButton_Click(object sender, EventArgs e) { var newState = ""; var finalizedDate = ""; var changes = new List <string>(); if (companyBox.Text != _company) { changes.Add("Firma: " + companyBox.Text); } if (referenceTextBox.Text != _reference) { changes.Add("Referenz: " + referenceTextBox.Text); } if (documentLabel.Text != _document) { changes.Add("Beleg: " + documentTextBox.Text); } if (responsibleTextBox.Text != _responsible) { changes.Add("SB: " + responsibleTextBox.Text); } if (duePicker.Value != _due) { changes.Add("Fällig: " + duePicker.Value.ToShortDateString()); } if (changes.Count != 0) { changesText = string.Join(", ", changes.ToArray()); changesText = "Änderungen: " + changesText + "\n"; } var newDetails = ""; if (detailsTextBox.Text != "") { newDetails = detailsTextBox.Text + "\n"; } var detailsText = $"{DateTime.Now.ToString("dd. MMM. yy HH:mm")} {Person.getInfo()[1]} {Person.getInfo()[2]}\n{newDetails}{changesText}" + historyTextBox.Text; if (finalizedButton.Checked) { newState = "done"; finalizedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else if (cancelButton.Checked) { newState = "cancelled"; finalizedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else if (openButton.Checked) { newState = "open"; finalizedDate = ""; } string lieferant = $"lieferant = '{companyBox.Text}'"; string referenz = $"referenz = '{referenceTextBox.Text}'"; string document = $"document = '{documentTextBox.Text}'"; string sachbearbeiter = $"sachbearbeiter = '{responsibleTextBox.Text}'"; string due = $"due = '{duePicker.Value.ToString("yyyy-MM-dd HH:mm:ss")}'"; string detail = $"detail = '{detailsText}'"; string finalized; if (finalizedDate == "") { finalized = "finalized = null"; } else { finalized = $"finalized = '{finalizedDate}'"; } string state = $"state = '{newState}'"; string query = $"UPDATE pendenz SET {lieferant}, {referenz}, {document}, {sachbearbeiter}, {due}, {detail}, {finalized}, {state} WHERE idpendenz={_id}"; db.Update(query); Close(); }