protected int nextId(statdataEntities ctx, String name) { int nRet = 0; string sname = name.Trim().ToLower(); var q = from x in ctx.DbKeys where x.Nom.Trim().ToLower() == sname select x; if (q.Count() > 0) { DbKey p = q.First(); nRet = p.Valeur; p.Valeur = nRet + 1; } else { DbKey p = new DbKey(); p.Nom = sname; p.Valeur = 2; ctx.DbKeys.Add(p); ctx.SaveChanges(); nRet = 1; } return nRet; }
protected int[] nextIds(statdataEntities ctx, String name, int count) { int nRet = 0; string sname = name.Trim().ToLower(); var q = from x in ctx.DbKeys where x.Nom.Trim().ToLower() == sname select x; if (q.Count() > 0) { DbKey p = q.First(); nRet = p.Valeur; p.Valeur = nRet + count; } else { DbKey p = new DbKey(); p.Nom = sname; p.Valeur = count + 1; ctx.DbKeys.Add(p); ctx.SaveChanges(); nRet = 1; } int[] pRet = new int[count]; for (int i = 0; i < count; ++i) { pRet[i] = nRet + i; } return pRet; }
protected DbDataSet maintainsDataSet(statdataEntities ctx, StatDataSet oSet) { if (oSet == null) { return null; } String sname = oSet.Name.Trim(); if (String.IsNullOrEmpty(sname)) { return null; } DbDataSet pRet = findDataSet(ctx, oSet); if (pRet != null) { pRet.Name = oSet.Name; pRet.Description = oSet.Description; } else { pRet = new DbDataSet(); pRet.Id = nextId(ctx, TAB_DATASET); pRet.LastIndex = 0; pRet.Name = sname; pRet.Description = oSet.Description; ctx.DbDataSets.Add(pRet); ctx.SaveChanges(); } return pRet; }