private void insertHolyday(DateTime d , string holidayName) { clsHITM_CALENDAR_TB clstb = new clsHITM_CALENDAR_TB(); clstb.HOLIDAY_DT = d.ToString("yyyyMMdd"); clstb.HOLIDAY_NM = holidayName; clstb.COUNTRY = "SOUTH_KOREA"; clstb.START_DT = "20000101"; clstb.END_DT = "20400101"; clstb.Insert(); }
// static method public static bool isHoliday(string country, string dateStr) { System.Globalization.CultureInfo us = new System.Globalization.CultureInfo("en-US"); DateTime date = DateTime.ParseExact(dateStr, "yyyyMMdd", us); if (date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday) { return true; } clsHITM_CALENDAR_TB clstb = new clsHITM_CALENDAR_TB(); clstb.COUNTRY = country; clstb.HOLIDAY_DT = dateStr; int count = clstb.Select().Rows.Count; return (count > 0) ? true : false; }
public clsHITM_CALENDAR_TB Clone() { try { clsHITM_CALENDAR_TB cloneTB = new clsHITM_CALENDAR_TB(); cloneTB._COUNTRY = this._COUNTRY; cloneTB._HOLIDAY_DT = this._HOLIDAY_DT; cloneTB._HOLIDAY_NM = this._HOLIDAY_NM; cloneTB._START_DT = this._START_DT; cloneTB._END_DT = this._END_DT; return cloneTB; } catch(Exception ex) { throw new Exception(ex.Message); } }
public static clsHITM_CALENDAR_TB Create(DataRow dr) { try { clsHITM_CALENDAR_TB tb = new clsHITM_CALENDAR_TB(); tb._COUNTRY = Convert.ToString(dr[0]); tb._HOLIDAY_DT = Convert.ToString(dr[1]); tb._HOLIDAY_NM = Convert.ToString(dr[2]); tb._START_DT = Convert.ToString(dr[3]); tb._END_DT = Convert.ToString(dr[4]); return tb; } catch(Exception ex) { throw new Exception(ex.Message); } }