/// <summary>
/// Metoda pobiera z bazy dni w których jakikolwiek pracownik był na urlopie
/// w danym niesiącu i w danym roku.
/// Wynik zapisuje do listy.
/// </summary>
/// <param name="date">Data do sprawdzenia (miesiąc, rok)</param>
/// <param name="disconnect">True - odłącza od bazy danych</param>
public static void GetDayOffToList(DateTime date, ConnectionToDB disconnect)//misiąc+rok
{
string select = "select * from urlop_rodzaj_new where datepart(year,data)=" + date.Year + " AND datepart(month,data)=" + date.Month;
arrayListWorkTime.Clear();
SqlDataReader dataReader = Database.GetData(select);
while (dataReader.Read())
{
DayOff d = new DayOff();
//id potrzebne do grida
d.IdEmployee = dataReader.GetInt32(0);
d.Date = dataReader.GetDateTime(1);
d.IdTypeDayOff = dataReader.GetInt32(2);
d.PercentTypeDayOff = dataReader.GetInt32(3);
arrayListWorkTime.Add(d);
}
dataReader.Close();
if (disconnect == ConnectionToDB.disconnect)
{
Polaczenia.OdlaczenieOdBazy();
}
}
public static void AddWorkTime(IWorkTime workTime, ConnectionToDB disconnect = ConnectionToDB.disconnect)
{
string select = String.Empty;
if (workTime is Work)
// if (typeof(Work).IsInstanceOfType(workTime))
{
Work work = (Work)workTime;
select = "insert into praca values('" + work.Date.ToString("d", DateFormat.TakeDateFormat()) + "'" +
",'" + work.IdEmployee + "','" + work.StartTime.ToString("d", DateFormat.TakeDateFormat()) + " " + work.StartTime.ToString("T", DateFormat.TakeDateFormat()) +
"','" + work.StopTime.ToString("d", DateFormat.TakeDateFormat()) + " " + work.StopTime.ToString("T", DateFormat.TakeDateFormat()) + "')";
}
if (workTime is Illness)
{
Illness illness = (Illness)workTime;
select = "insert into choroba values('" + illness.IdEmployee + "'" +
",'" + illness.Date.ToString("d", DateFormat.TakeDateFormat()) + "','" + illness.IdIllnessType + "')";
}
if (workTime is DayOff)
{
DayOff dayOff = (DayOff)workTime;
select = "insert into urlop values('" + dayOff.IdEmployee + "'" +
",'" + dayOff.Date.ToString("d", DateFormat.TakeDateFormat()) + "','" + dayOff.IdTypeDayOff + "')";
}
Database.Save(select, disconnect);
//log
LogSys.DodanieLoguSystemu(new LogSys(Polaczenia.idUser, RodzajZdarzenia.dodawanie, DateTime.Now, Polaczenia.ip, NazwaTabeli.praca, select), disconnect == ConnectionToDB.disconnect ? true : false);
}
public static DayOff GetDayOff(int idEmployee, DateTime date, ConnectionToDB disconnect)//misiąc+rok
{
string select = "select * from urlop where id_pracownika=" + idEmployee +
" AND datepart(year,data)=" + date.Year + " AND datepart(month,data)=" + date.Month + " AND datepart(day,data)=" + date.Day;
SqlDataReader dataReader = Database.GetData(select);
DayOff d = new DayOff();
while (dataReader.Read())
{
//id potrzebne do grida
d.IdEmployee = idEmployee;
d.Date = dataReader.GetDateTime(1);
d.IdTypeDayOff = dataReader.GetInt32(2);
}
dataReader.Close();
if (disconnect == ConnectionToDB.disconnect)
{
Polaczenia.OdlaczenieOdBazy();
}
return(d);
}