//Commands public void addChange(Changes change = null) { string sql = "INSERT INTO changes (person, from_date, to_date, status, reason) VALUES " + "(" + change.getPersonId() + ", '" + change.getFromDate() + "', '" + change.getToDate() + "', '" + change.getStatus() + "', '" + change.getReason() + "');"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); }
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 updateChange(Changes change) { string sql = "UPDATE changes SET person = " + change.getPersonId() + ", from_date = '" + change.getFromDate() + "', to_date = '" + change.getToDate() + "', status = '" + change.getStatus() + "', reason = '" + change.getReason() + "' WHERE id = " + change.getId() + ";"; connection.Open(); SQLiteCommand command = new SQLiteCommand(sql, connection); command.ExecuteNonQuery(); connection.Close(); }