public static List <ATTOrganizationUnit> GetOrganizationUnits(int?orgID, int?unitID)
        {
            List <ATTOrganizationUnit> lstOrgUnits = new List <ATTOrganizationUnit>();

            try
            {
                foreach (DataRow row in DLLOrganizationUnit.GetOrganizationUnits(orgID, unitID).Rows)
                {
                    ATTOrganizationUnit objOrgUnits = new ATTOrganizationUnit(
                        int.Parse(row["ORG_ID"].ToString()),
                        int.Parse(row["UNIT_ID"].ToString()),
                        (string)row["UNIT_NAME"]);
                    if (row["PARENT_ORG_ID"] != System.DBNull.Value)
                    {
                        objOrgUnits.ParentOrgID = int.Parse(row["PARENT_ORG_ID"].ToString());
                    }
                    if (row["PARENT_UNIT_ID"] != System.DBNull.Value)
                    {
                        objOrgUnits.ParentUnitID = int.Parse(row["PARENT_UNIT_ID"].ToString());
                    }
                    objOrgUnits.UnitType = (row["UNIT_TYPE"] == System.DBNull.Value) ? "" : (string)row["UNIT_TYPE"];
                    lstOrgUnits.Add(objOrgUnits);
                }
                return(lstOrgUnits);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static List <ATTOrganizationUnit> GetOrganizationUnits(string unitType, int orgID)
        {
            List <ATTOrganizationUnit> lstOrgUnits = new List <ATTOrganizationUnit>();

            try
            {
                DataTable tbl = new DataTable();
                tbl = DLLOrganizationUnit.GetOrganizationUnits(unitType, orgID);


                foreach (DataRow row in tbl.Rows)
                {
                    ATTOrganizationUnit objOrgUnits = new ATTOrganizationUnit(
                        int.Parse(row["ORG_ID"].ToString()),
                        int.Parse(row["UNIT_ID"].ToString()),
                        (string)row["UNIT_NAME"]
                        );

                    //ORG_ID,UNIT_ID,UNIT_NAME,PARENT_ORG_ID,PARENT_UNIT_ID,UNIT_TYPE

                    if (row["PARENT_ORG_ID"] != System.DBNull.Value)
                    {
                        objOrgUnits.ParentOrgID = int.Parse(row["PARENT_ORG_ID"].ToString());
                    }
                    if (row["PARENT_UNIT_ID"] != System.DBNull.Value)
                    {
                        objOrgUnits.ParentUnitID = int.Parse(row["PARENT_UNIT_ID"].ToString());
                    }

                    objOrgUnits.UnitType = row["UNIT_TYPE"].ToString();

                    lstOrgUnits.Add(objOrgUnits);
                }

                return(lstOrgUnits);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }