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