// Check if series in database
public static void CreateSeries(bool DeleteOldSeries = true)
{
if (DeleteOldSeries)
{
var oldseries = DS.db.GetAll <SeriesName>(a => true) as IEnumerable <SeriesName>;
DS.db.DeleteMany(oldseries);
}
var modulesWithSeries = DS.db.GetAll <ModuleErp>(a => true) as IEnumerable <ModuleErp>;
if (modulesWithSeries != null)
{
foreach (var module in modulesWithSeries)
{
try
{
var serie = new SeriesName();
serie.Libelle = module.Name;
serie.Sufix = new string(module.Libelle.Take(2).ToArray()).ToUpper() + "-########";
serie.Indexe = 1;
serie.ForceIgniorValidatUnique = true;
serie.Save();
module.SeriesNames = new List <SeriesName>();
module.SeriesNames.Add(serie);
module.SeriesDefault = serie.Id;
module.Save();
}
catch (Exception s)
{
DataHelpers.Logger.LogError(s);
throw s;
}
}
}
}
public static void CreateSeries(ModuleErp module, long currentIndex, bool createAnyway = false)
{
if (!module.HasSeries && createAnyway == false)
{
return;
}
var serie = new SeriesName();
serie.Libelle = _(module.Name);
string suffix = "";
string libelle = module.Libelle;
var trim = libelle.Split(' ');
if (trim.Length == 1)
{
var word = trim.FirstOrDefault();
suffix += word.Substring(0, 2).ToUpper();
}
else
{
foreach (var item in trim)
{
if (item.Length > 2)
{
var firstCharcter = new string(item.Take(1).ToArray());
suffix += firstCharcter.ToUpper();
}
}
}
serie.Sufix = suffix + "-########";
serie.Indexe = currentIndex++;
serie.ForceIgniorValidatUnique = true;
serie.Save();
// module.SeriesNames = new List<SeriesName>();
module.SeriesNames.Add(serie);
if (module.SeriesDefault.IsValide() == false)
{
module.SeriesDefault = serie.Id;
}
module.ForceIgniorValidatUnique = true;
module.Save();
}