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