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;
}
