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