Esempio n. 1
0
        public static List <MicroCalendar> SetHolidays(DataTable HolidayTable)
        {
            try
            {
                List <MicroCalendar> HolidayList = new List <MicroCalendar>();

                foreach (DataRow dr in HolidayTable.Rows)
                {
                    MicroCalendar _Holiday = new MicroCalendar();

                    _Holiday.TheDateID        = int.Parse(dr["TheDateID"].ToString());
                    _Holiday.CalendarDate     = DateTime.Parse(dr["CalendarDate"].ToString());
                    _Holiday.CalendarDateDesc = dr["CalendarDateDesc"].ToString();
                    if (!string.IsNullOrEmpty(dr["IsGovtHoliday"].ToString()))
                    {
                        _Holiday.IsGovtHoliday = char.Parse(dr["IsGovtHoliday"].ToString());
                    }
                    if (!string.IsNullOrEmpty(dr["IsLocalHoliday"].ToString()))
                    {
                        _Holiday.IsLocalHoliday = char.Parse(dr["IsLocalHoliday"].ToString());
                    }
                    if (!string.IsNullOrEmpty(dr["IsMicroHoliday"].ToString()))
                    {
                        _Holiday.IsMicroHoliday = char.Parse(dr["IsMicroHoliday"].ToString());
                    }

                    HolidayList.Add(_Holiday);
                }
                return(HolidayList);
            }
            catch (Exception ex)
            {
                throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
            }
        }
Esempio n. 2
0
        public static MicroCalendar GetAllDateByID(int TheDateID)
        {
            try
            {
                DataRow HolidayRow = CalendarDataAccess.GetInstance.GetAllDateByID(TheDateID);

                MicroCalendar _Holiday = new MicroCalendar();

                _Holiday.TheDateID        = int.Parse(HolidayRow["TheDateID"].ToString());
                _Holiday.CalendarDate     = DateTime.Parse(HolidayRow["CalendarDate"].ToString());
                _Holiday.CalendarDateDesc = HolidayRow["DateOfOccasion"].ToString();
                _Holiday.IsLocalHoliday   = char.Parse(HolidayRow["IsLocalHoliday"].ToString());
                _Holiday.IsGovtHoliday    = char.Parse(HolidayRow["IsGovtHoliday"].ToString());
                _Holiday.IsMicroHoliday   = char.Parse(HolidayRow["IsMicroHoliday"].ToString());

                return(_Holiday);
            }
            catch (Exception ex)
            {
                throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
            }
        }