/// <summary> /// Check if the user has entered is working day /// </summary> /// <param name="pdtmDate"></param> /// <returns></returns> /// <author>Trada</author> /// <date>Thursday, Feb 16 2006</date> public bool CheckIfWorkingday(DateTime pdtmDate, int pintYear) { MST_WorkingDayMasterDS dsMST_WorkingDayMaster = new MST_WorkingDayMasterDS(); MST_WorkingDayMasterVO voWorkingDayMaster = (MST_WorkingDayMasterVO)dsMST_WorkingDayMaster.GetNoWorkingDay(pintYear); if (pdtmDate.DayOfWeek == DayOfWeek.Sunday) { return(voWorkingDayMaster.Sun); } if (pdtmDate.DayOfWeek == DayOfWeek.Monday) { return(voWorkingDayMaster.Mon); } if (pdtmDate.DayOfWeek == DayOfWeek.Tuesday) { return(voWorkingDayMaster.Tue); } if (pdtmDate.DayOfWeek == DayOfWeek.Wednesday) { return(voWorkingDayMaster.Wed); } if (pdtmDate.DayOfWeek == DayOfWeek.Thursday) { return(voWorkingDayMaster.Thu); } if (pdtmDate.DayOfWeek == DayOfWeek.Friday) { return(voWorkingDayMaster.Fri); } if (pdtmDate.DayOfWeek == DayOfWeek.Saturday) { return(voWorkingDayMaster.Sat); } return(false); }
/// <summary> /// Add Master & Detail /// </summary> /// <param name="pobjMaster"></param> /// <param name="pdstData"></param> public int AddWDCalendar(object pobjMaster, DataSet pdstData) { try { //add Master int intMasterID = new MST_WorkingDayMasterDS().AddAndReturnID(pobjMaster); //add Detail foreach (DataRow drow in pdstData.Tables[0].Rows) { if (drow.RowState == DataRowState.Added) { drow[MST_WorkingDayDetailTable.WORKINGDAYMASTERID_FLD] = intMasterID; } } new MST_WorkingDayDetailDS().UpdateDataSet(pdstData); return(intMasterID); } catch (PCSDBException ex) { throw ex; } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
/// <summary> /// CheckIfDateIsOutOfPeriod /// </summary> /// <param name="pintYear"></param> /// <param name="pdtmDateToCheck"></param> /// <returns></returns> /// <author>Trada</author> /// <date>Tuesday, Mar 7 2006</date> public bool CheckIfDateIsOutOfPeriod(DateTime pdtmDateToCheck, int pintYear) { DataSet dstWorkingDayMaster = new DataSet(); MST_WorkingDayMasterDS dsWorkingDayMaster = new MST_WorkingDayMasterDS(); dstWorkingDayMaster = dsWorkingDayMaster.GetCollectionOffDays(pintYear); if (dstWorkingDayMaster.Tables[0].Rows.Count == 0) { //Not config return(true); } // else // { // //Find the last off day // DateTime dtmTheLastOffDay = new DateTime(); // // if ((bool)dstWorkingDayMaster.Tables[0].Rows[0][MST_WorkingDayMasterTable.SUN_FLD] == false) // { // // } // } return(false); }