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 department(String department, String modifier) { if (Person.isAdmin() && department != "") { return($" {modifier} department = '{department}'"); } return(""); }
public static string department(string department) { if (Person.isAdmin() && department != "") { return($" AND department = '{department}'"); } return(""); }
public static string admin(String modifier) { if (!Person.isAdmin()) { return($"{modifier} department = '{Person.getInfo()[4]}'"); } return(""); }
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(); }