void init() { HasHistory = HistoryCheck(change); string[] date = calendar.SplitDate(change.getFromDate()); lblFrom.Text = date[0] + "-" + date[1] + "-"; txtFrom.Text = date[2]; if (change.getToDate() != null) { date = calendar.SplitDate(change.getToDate()); lblTo.Text = date[0] + "-" + date[1] + "-"; txtTo.Text = date[2]; } else { lblTo.Text = lblFrom.Text; txtTo.Text = txtFrom.Text; } Option3.Text = change.getStatus(); if (Option3.Text == "R") { Option3.BackColor = Color.LightPink; Option1.BackColor = Color.LightGreen; Option2.BackColor = Color.Khaki; Option1.Text = "W"; Option2.Text = "A"; } else if (Option3.Text == "W") { Option3.BackColor = Color.LightGreen; Option1.BackColor = Color.LightPink; Option2.BackColor = Color.Khaki; Option1.Text = "R"; Option2.Text = "A"; } else if (Option3.Text == "A") { Option3.BackColor = Color.Khaki; Option1.BackColor = Color.LightGreen; Option2.BackColor = Color.LightPink; Option1.Text = "W"; Option2.Text = "R"; } txtReason.Text = change.getReason(); Personnel person = db.getPerson(change.getPersonId()); lblName.Text = person.getName(); HasChangeToSave = !HasHistory; btnRemove.Visible = HasHistory; HasChangeToSave = false; }
public void updatePerson(Personnel person) { string sql = "UPDATE personnel SET name = '" + person.getName() + "', start = '" + person.getStart() + "', work = " + person.getWork() + ", rest = " + person.getRest() + ", xp_id = " + person.getXpId() + " WHERE id = " + person.getId() + ";"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }
public void addPerson(Personnel person) { string sql = "INSERT INTO personnel (name, start, work, rest, xp_id) VALUES " + "('" + person.getName() + "', '" + person.getStart() + "', " + person.getWork() + ", " + person.getRest() + ", " + person.getXpId() + ");"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }
private void init() { txtName.Text = person.getName(); txtRest.Text = person.getRest().ToString(); txtWork.Text = person.getWork().ToString(); String[] date = calendar.SplitDate(person.getStart()); txtRDay.Text = date[2]; txtRYear.Text = date[0]; cbRMonth.SelectedIndex = int.Parse(date[1]) - 1; xps = db.getExpertise(); foreach (Expertise xp in xps) { cbXP.Items.Add(xp.getXp()); } cbXP.SelectedIndex = cbXP.Items.IndexOf(person.getXp()); HasChangeToSave = false; }