Exemplo n.º 1
0
        //Populate HR Names
        public static string GET_HR_NAMES()
        {
            string HRIDs = ConvertStringArrayToString.ConvertArraytoString(ConfigurationManager.AppSettings["HRDepartmentID"].ToString().Split(','));

            return("Select SWG,Name from Emp where DeptId in (" + HRIDs + ")");
        }
Exemplo n.º 2
0
        //done
        public static string GET_ROLE_HR(string swg)
        {
            string HRIDs = ConvertStringArrayToString.ConvertArraytoString(ConfigurationManager.AppSettings["HRDepartmentID"].ToString().Split(','));

            return("select 'HR' from emp where DeptId in (" + HRIDs + ") and SWG='" + swg + "'");
        }