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