public async Task <List <GroupPeriod> > GetAllGroupTemplate(int idZone) { var sqlDataBase = _stObjMap.StObjs.Obtain <SqlDefaultDatabase>(); using (var ctx = new SqlStandardCallContext()) { GroupQueries groupQueries = new GroupQueries(ctx, sqlDataBase); List <string> listGroups = await groupQueries.GetAllGroupByZoneId(idZone); List <GroupPeriod> list = new List <GroupPeriod>(); for (int i = 0; i < listGroups.Count; i++) { GroupPeriod gp = new GroupPeriod(); gp.Name = listGroups[i]; gp.State = true; gp.IsAlreadyPermanent = true; list.Add(gp); } return(list); } }