Пример #1
0
        public List <MVCModels.HiDoctor_Master.WeekendGroup> GetMappingGroupHeader(string RegionCodes)
        {
            string companyCode = _objCurInfo.GetCompanyCode();
            List <MVCModels.HiDoctor_Master.WeekendGroup> lstWeekendGroup = new List <MVCModels.HiDoctor_Master.WeekendGroup>();

            if (RegionCodes != "")
            {
                try
                {
                    _objData.OpenConnection(companyCode);
                    {
                        using (sqldataReader = _objData.ExecuteReader("" + EXEC + " " + SP_HDGETMAPPINGREGION + " '" + companyCode + "'" + "," + "'" + RegionCodes + "'"))
                        {
                            while (sqldataReader.Read())
                            {
                                MVCModels.HiDoctor_Master.WeekendGroup objWeekendGroup = new MVCModels.HiDoctor_Master.WeekendGroup();
                                objWeekendGroup.Region_Code = sqldataReader["Region_Code"].ToString();
                                lstWeekendGroup.Add(objWeekendGroup);
                            }
                        }
                    }
                }
                catch
                {
                    throw;
                }
                finally
                {
                    _objData.CloseConnection();
                }
            }
            return(lstWeekendGroup);
        }
Пример #2
0
        public List <MVCModels.HiDoctor_Master.WeekendGroup> GetWeekendGroupHeader()
        {
            string companyCode = _objCurInfo.GetCompanyCode();
            List <MVCModels.HiDoctor_Master.WeekendGroup> lstWeekendGroup = new List <MVCModels.HiDoctor_Master.WeekendGroup>();

            try
            {
                _objData.OpenConnection(companyCode);
                {
                    using (sqldataReader = _objData.ExecuteReader("" + EXEC + " " + SP_HDGETWEEKENDGROUPNAME + " '" + companyCode + "'"))
                    {
                        while (sqldataReader.Read())
                        {
                            MVCModels.HiDoctor_Master.WeekendGroup objWeekendGroup = new MVCModels.HiDoctor_Master.WeekendGroup();
                            objWeekendGroup.Weekend_Off_Code = sqldataReader["Weekend_Off_Code"].ToString();
                            objWeekendGroup.Weekend_Off_Name = sqldataReader["Weekend_Off_Name"].ToString();
                            lstWeekendGroup.Add(objWeekendGroup);
                        }
                    }
                }
            }
            catch
            {
                throw;
            }
            finally
            {
                _objData.CloseConnection();
            }
            return(lstWeekendGroup);
        }