public static FieldForceRank GetFieldForceRankByID(int fieldForceRankID)
        {
            FieldForceRank TheFieldForceRank = new FieldForceRank();

            var FieldForceRankList = from FieldForceRankTable in GetFieldForceRanks()
                                     where FieldForceRankTable.FieldForceRankID == fieldForceRankID
                                     select FieldForceRankTable;

            foreach (FieldForceRank EachRank in FieldForceRankList)
            {
                TheFieldForceRank = EachRank;
            }

            return(TheFieldForceRank);
        }
        public static FieldForceRank DataRowToObject(DataRow dr)
        {
            FieldForceRank TheFieldForceRank = new FieldForceRank();

            TheFieldForceRank.FieldForceRankID          = int.Parse(dr["FieldForceRankID"].ToString());
            TheFieldForceRank.FieldForceRankName        = dr["FieldForceRankName"].ToString();
            TheFieldForceRank.FieldForceRankDescription = dr["FieldForceRankDescription"].ToString();
            TheFieldForceRank.HierarchyIndex            = int.Parse(dr["HierarchyIndex"].ToString());
            TheFieldForceRank.FieldForceAbbrText        = dr["FieldForceAbbrText"].ToString();
            TheFieldForceRank.NumberOfDigitsInCode      = int.Parse(dr["NumberOfDigitsInCode"].ToString());
            TheFieldForceRank.IsActive  = bool.Parse(dr["IsActive"].ToString());
            TheFieldForceRank.IsDeleted = bool.Parse(dr["IsDeleted"].ToString());

            return(TheFieldForceRank);
        }
        public static List <FieldForceRank> GetFieldForceRanks(int fieldForceRankID = 0)
        {
            List <FieldForceRank> FieldForceRankList = new List <FieldForceRank>();

            DataTable FieldForceTable = new DataTable();

            FieldForceTable = FieldForceRankDataAccess.GetInstance.GetFieldForceRanks(fieldForceRankID);

            foreach (DataRow dr in FieldForceTable.Rows)
            {
                FieldForceRank TheFieldForceRank = DataRowToObject(dr);

                FieldForceRankList.Add(TheFieldForceRank);
            }

            return(FieldForceRankList);
        }