private bool SpellCheck()
{
HideErrorMark();
if (comboBox1.Text.Length < 3)
{
label11.Visible = true;
return(false);
}
if (textBox1.Text.Length < 3)
{
label8.Visible = true;
return(false);
}
if (CalcDate.DaysDiff(dateTimePicker1.Value, DateTime.Now) < (-31) || CalcDate.DaysDiff(dateTimePicker1.Value, DateTime.Now) > 365)
{
label9.Visible = true;
return(false);
}
if (CalcDate.DaysDiff(dateTimePicker2.Value, DateTime.Now) < (-365) || CalcDate.DaysDiff(dateTimePicker2.Value, DateTime.Now) > 1)
{
label10.Visible = true;
return(false);
}
HideErrorMark();
return(true);
}
private void ShowTasks()
{
UnregisterEventDGV1();
dataGridView1.Visible = false;
dataGridView1.Rows.Clear();
int index = 0;
List <int> numSlaves = new List <int>();
foreach (Employees currExecutor in allExecutors)
{
numSlaves.Add(currExecutor.ID);
}
if (numSlaves.Count > 0)
{
string strInSlaves = string.Join(",", numSlaves.Select(x => x.ToString()).ToArray());
DataRowCollection drcTasks = db2.GetTasksForSlave(strInSlaves, currentShowMadeTask, glb.employeeID);
if (drcTasks.Count > 0)
{
foreach (DataRow dr in drcTasks)
{
//if (dr["ISDELETE"].ToString().Equals("0"))
{
string dtDateInit = GetShortDateOnly(dr["DATEINIT"].ToString());
string dtDeadLine = GetShortDateOnly(dr["DEADLINE"].ToString());
string dtMakeDate = GetShortDateOnly(dr["MAKEDATE"].ToString());
string dtCommitDate = GetShortDateOnly(dr["COMMITDATE"].ToString());
string dtDateDoc = GetShortDateOnly(dr["DATEDOC"].ToString());
string priority = "нормальний";
if (dr["PRIORITY"].ToString().Equals("1"))
{
priority = "високий";
}
if (dr["PRIORITY"].ToString().Equals("2"))
{
priority = "терміново";
}
index = dataGridView1.Rows.Add(dr["ID"].ToString(),
dr["SUBJECT"].ToString(),
dr["SHORTDESCRIPTION"].ToString(),
dr["SLAVEFIO"].ToString(),
dtDateInit,
dtDeadLine,
dtMakeDate,
dr["MAKETASK"],
dr["MASTERFIO"].ToString(),
dtCommitDate,
dr["COMMITMAKE"],
priority,
dtDateDoc,
dr["NUMBERDOC"].ToString(),
dr["EXECUTORID"].ToString(),
dr["MANAGERID"].ToString());
if (dr["COMMITMAKE"].ToString().Equals("0")) //завдання не виконано
{
int daysDiff = CalcDate.DaysDiffNow(dtDeadLine);
if (daysDiff < 0)
{
dataGridView1.Rows[index].DefaultCellStyle.ForeColor = Color.Red;
}
else if (daysDiff < 7)
{
dataGridView1.Rows[index].DefaultCellStyle.ForeColor = Color.Green;
}
else
{
dataGridView1.Rows[index].DefaultCellStyle.ForeColor = Color.Blue;
}
}
else
{
dataGridView1.Rows[index].DefaultCellStyle.ForeColor = Color.Black;
}
}
}
}
}
dataGridView1.Visible = true;
RegisterEventsDGV1();
}
