/// <summary> /// For HolidayList Bind /// </summary> /// <returns></returns> public List <tblHoliday> GetHolidayList(string Empid) { try { DALBase obj = new DALBase(_config); List <tblHoliday> listObj = new List <tblHoliday>(); DataSet ds = obj.GetHolidaylist(ConstantStoredProcedure.SP_BCL_HOLIDAYLIST, Empid); if (ds != null && ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables.Count; i++) { if (ds.Tables[i] != null && ds.Tables[i].Rows.Count > 0) { foreach (DataRow dtRow in ds.Tables[i].Rows) { var date = dtRow["FROMDATE"].ToString(); var Descr = dtRow["TODATE"].ToString(); var Descr1 = dtRow["DESCRIPTION"].ToString(); var Descr2 = dtRow["Status"].ToString(); var objLeave = new tblHoliday(); objLeave.HolidayDate = Convert.ToDateTime(date).ToString("yyyy/MM/dd").Replace('-', '/'); objLeave.HolidayName = Convert.ToDateTime(Descr).ToString("yyyy/MM/dd").Replace('-', '/'); objLeave.Text = Descr1; objLeave.Text1 = Descr2; listObj.Add(objLeave); } } } } return(listObj); } catch (Exception ex) { throw ex; } }