private void btnRemove_Click(object sender, System.EventArgs e) { if (HasHistory) { if (MessageBox.Show("رکورد جاری پاک شود؟", "پاک کردن رکورد", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.deleteChange(change.getId()); this.DialogResult = DialogResult.OK; this.Close(); } } }
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(); }
void AddPerson(int id, List <String> rest) { String dayStatus = "W"; Color color = Color.LightGreen; int from, to, WORK, REST; from = to = WORK = REST = 0; string changeStatus = dayStatus; for (int i = 1; i <= MaxDay; i++) { Changes change = database.getChange(id, (Year + "-" + Month + "-" + i)); if (change.getId() != 0) { HasChange = true; string[] date = calendar.SplitDate(change.getFromDate()); from = int.Parse(date[2]); date = calendar.SplitDate(change.getToDate()); to = int.Parse(date[2]); dayStatus = changeStatus = change.getStatus(); color = Color.MediumPurple; } else if (HasChange && (i >= from && i <= to)) { dayStatus = changeStatus; color = Color.MediumPurple; } else { if (rest.Contains(i.ToString())) { dayStatus = "R"; } else { dayStatus = "W"; } if (dayStatus == "W") { color = Color.LightGreen; } else if (dayStatus == "R") { color = Color.LightPink; } } if (Year == calendar.Year() && Month == calendar.Month() && i == calendar.Day()) { color = Color.LightBlue; } else if (dayStatus == "A") { color = Color.Khaki; } if (dayStatus == "W") { Available[i - 1]++; Total[i - 1]++; WORK++; } else if (dayStatus == "R") { REST++; } this.Controls[PERSON + id + "-" + i].Text = dayStatus; this.Controls[PERSON + id + "-" + i].Tag = dayStatus + "~" + id + "~" + Year + "~" + Month + "~" + i; this.Controls[PERSON + id].Tag = id; this.Controls[PERSON + id + "-" + i].BackColor = color; } if (MaxDay < 31) { for (int i = MaxDay + 1; i <= 31; i++) { this.Controls[PERSON + id + "-" + i].Text = ""; this.Controls[PERSON + id + "-" + i].Tag = null; this.Controls[PERSON + id + "-" + i].BackColor = Color.White; } } this.Controls[PERSON_WORK + id].Text = (WORK).ToString(); this.Controls[PERSON_REST + id].Text = (REST).ToString(); Work += WORK; Rest += REST; }