private static List <SickDays> RetrieveSickDaysByIDRepackage(DataTable myTable)
{
List <SickDays> sickDayList = new List <SickDays>();
foreach (DataRow tempRow in myTable.Rows)
{
SickDays tmpSickDays = new SickDays();
tmpSickDays.SickDayID = Convert.ToInt32(tempRow["sickDayId"]);
tmpSickDays.SickDayDate = Convert.ToDateTime(tempRow["sickDayDate"]);
tmpSickDays.SickDayLength = Convert.ToDouble(tempRow["sickDayLength"]);
tmpSickDays.SickDayDescription = Convert.ToString(tempRow["sickDayDescription"]);
tmpSickDays.empId = Convert.ToInt32(tempRow["empId"]);
sickDayList.Add(tmpSickDays);
}
return(sickDayList);
}
public string MarkDays(DateTime dt1, DateTime dt2)
{
ClearDays();
if (HireFire == null)
{
return("Darbieneiks nav pieņemts darbā.");
}
foreach (var pv in Positions)
{
var dids = new EPeriodId[31];
var didsa = new EEventId[31];
ClearA(dids);
ClearB(didsa);
PositionDayIds[pv.Key] = dids;
PositionDayIdsA[pv.Key] = didsa;
}
foreach (var pv in Positions)
{
pv.Value.MarkDates(DayIds, dt1, dt2, EPeriodId.Ir_pieņemts);
var posdayids = PositionDayIds[pv.Key];
pv.Value.MarkDates(posdayids, dt1, dt2, EPeriodId.Ir_pieņemts);
}
Vacations.MarkDates(DayIds, dt1, dt2, EPeriodId.Atvaļinājums);
SickDays.MarkDates(DayIds, dt1, dt2, EPeriodId.Slimo);
foreach (var pv in Positions)
{
var posdayids = PositionDayIds[pv.Key];
Vacations.MarkDates(posdayids, dt1, dt2, EPeriodId.Atvaļinājums);
SickDays.MarkDates(posdayids, dt1, dt2, EPeriodId.Slimo);
}
foreach (var pi in Vacations.LinkedPeriods)
{
pi.EEventId = (pi.Item1 as KlonsADataSet.EVENTSRow).EventCode;
}
foreach (var pi in SickDays.LinkedPeriods)
{
pi.EEventId = (pi.Item1 as KlonsADataSet.EVENTSRow).EventCode;
}
foreach (var pv in Positions)
{
pv.Value.MarkDates(DayIdsA, dt1, dt2, EEventId.Pieņemts);
var posdayidsa = PositionDayIdsA[pv.Key];
pv.Value.MarkDates(posdayidsa, dt1, dt2, EEventId.Pieņemts);
}
Vacations.MarkDatesA(DayIdsA, dt1, dt2, d => d.EEventId);
SickDays.MarkDatesA(DayIdsA, dt1, dt2, d => d.EEventId);
foreach (var pv in Positions)
{
var posdayidsa = PositionDayIdsA[pv.Key];
Vacations.MarkDatesA(posdayidsa, dt1, dt2, d => d.EEventId);
SickDays.MarkDatesA(posdayidsa, dt1, dt2, d => d.EEventId);
}
return("OK");
}
public static Boolean CreateNewSickDay(SickDays sickDays)
{
return(HRSQL.CreateNewSickDay(sickDays));
}
private void btnAddSickDay_Click(object sender, EventArgs e)
{
try
{
if (txtSickDayDescription.Text == "")
{
MessageBox.Show("Error Missing Sick Day Description.");
}
else if (dtpSickDayDate.Value.Date > DateTime.Now.Date || dtpSickDayEndDate.Value.Date > DateTime.Now.Date)
{
MessageBox.Show("Error sick date cannot be in the future.");
}
else if (dtpSickDayDate.Value.Date > dtpSickDayEndDate.Value.Date)
{
MessageBox.Show("Error sick start date must be before sick end date.");
}
else
{
List <SickDays> sickDays = new List <SickDays>();
if (chkRangeOfSickDates.Checked)
{
//TimeSpan difference = (dtpSickDayEndDate.Value.Date - dtpSickDayDate.Value.Date);
DateTime tmpDate = dtpSickDayDate.Value.Date;
while (tmpDate.Date <= dtpSickDayEndDate.Value.Date)
{
SickDays tmpSickDay = SickDaysFactory.SickDaysCreate();
tmpSickDay.empId = emp[listBoxResults.SelectedIndex].EmpID;
tmpSickDay.SickDayDate = tmpDate;
tmpSickDay.SickDayDescription = txtSickDayDescription.Text;
if (cmbLenthOfDay.SelectedValue.ToString() == "Full")
{
tmpSickDay.SickDayLength = 1;
}
else
{
tmpSickDay.SickDayLength = 0.5;
}
sickDays.Add(tmpSickDay);
tmpDate = tmpDate.AddDays(1);
}
}
else
{
SickDays tmpSickDaySingular = SickDaysFactory.SickDaysCreate();
tmpSickDaySingular.empId = emp[listBoxResults.SelectedIndex].EmpID;
tmpSickDaySingular.SickDayDate = dtpSickDayDate.Value;
tmpSickDaySingular.SickDayDescription = txtSickDayDescription.Text;
if (cmbLenthOfDay.SelectedValue.ToString() == "Full")
{
tmpSickDaySingular.SickDayLength = 1;
}
else
{
tmpSickDaySingular.SickDayLength = 0.5;
}
sickDays.Add(tmpSickDaySingular);
}
foreach (SickDays tmpAddSickDay in sickDays)
{
CUDMethods.CreateNewSickDay(tmpAddSickDay);
}
MessageBox.Show("Sick Day Added.");
RetrieveSickDays(emp[listBoxResults.SelectedIndex].EmpID);
clearSickDayInfo();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
