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