public QuotaController(GestecoContext context, ICommonService quota, IMapper mapper, ILogger <QuotaController> logger)
{
_context = context;
_quotaRepository = quota;
_mapper = mapper;
_logger = logger;
}
/// <summary>
/// Reinitialisation des quota
/// </summary>
/// <param name="dbcontext"></param>
/// <param name="currentDate"></param>
public void InitializeQuota(GestecoContext dbcontext, Historique_Initialisation_Quota currentDate)
{
using (var transaction = dbcontext.Database.BeginTransaction())
{
try
{
var listQuota = dbcontext.Quota.Where(p => p.IdQuota != -1);
var dtdebut = new DateTime(DateTime.Now.Year, 1, 1);
var dtdefin = new DateTime(DateTime.Now.Year, 12, 31);
var _quotaStandard = dbcontext.Quota_Standard.First();
foreach (var _quota in listQuota)
{
_quota.Quantite_Commerce = _quotaStandard.Quantite_Commerce;
_quota.Quantite_Disponible = _quotaStandard.Quantite;
_quota.DateDebut = dtdebut;
_quota.DateFin = dtdefin;
}
currentDate = dbcontext.Historique_Initialisation_Quota.FirstOrDefault(p => p.DateEncours);
currentDate.DateEncours = false;
var quotaInit = new Historique_Initialisation_Quota
{
DateEncours = true,
DateInit = DateTime.Now,
Description = string.Format("Quota initialization started on {0}", DateTime.Now)
};
dbcontext.Historique_Initialisation_Quota.Add(quotaInit);
dbcontext.SaveChanges();
transaction.CommitAsync();
}
catch (Exception ex)
{
transaction.RollbackAsync();
_logger.LogDebug("Quota initialization Fails {0}", ex.Message);
}
}
}
public MatiereRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public VisiteController(GestecoContext context, IMapper mapper, ICommonService visiteRepository)
{
_context = context;
_visiteRepository = visiteRepository;
_mapper = mapper;
}
public EcocentreRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public TarificationController(GestecoContext context, IMapper mapper, ICommonService tarificationRepository)
{
_context = context;
_mapper = mapper;
_icommonservice = tarificationRepository;
}
public VisiteRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public CommonService(GestecoContext context)
{
_context = context;
}
protected RepositoryBase(GestecoContext GestecoContext)
{
_GestecoContext = GestecoContext;
}
public TarificationRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public QuotaRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public ModePaiementRepository(GestecoContext context)
: base(context)
{
_context = context;
}
public MatiereController(GestecoContext context, IMapper mapper, ICommonService matiereRepository)
{
_context = context;
_mapper = mapper;
_matiereRepository = matiereRepository;
}
public ModePaiementController(GestecoContext context, IMapper mapper, ICommonService modePaiementRepository)
{
_context = context;
_mapper = mapper;
_modePaiementRepository = modePaiementRepository;
}
public EcocentreController(GestecoContext context, IMapper mapper, ICommonService commonService)
{
_context = context;
_mapper = mapper;
_icommonService = commonService;
}
public static void Seed(GestecoContext context)
{
/// verifit s"il deja des donnee dans la table quota standard
if (!context.Quota_Standard.Any())
{
var quota_Standard = new Quota_Standard
{
Quantite = 20,
Quantite_Commerce = 20
};
context.Quota_Standard.Add(quota_Standard);
context.SaveChanges();
}
/// verifit s"il deja des donnee dans la table tarification
if (!context.Tarification.Any())
{
var tarification = new Tarification
{
Prix = 11,
Prix_Commerce = 32
};
context.Tarification.Add(tarification);
context.SaveChanges();
}
/// verifit s"il deja des donnee dans la table ModePaiement
if (!context.ModePaiement.Any())
{
var modepaiement = new List <ModePaiement>
{
new ModePaiement {
Nom = "Comptant"
},
new ModePaiement {
Nom = "Debit"
},
new ModePaiement {
Nom = "Credit"
},
new ModePaiement {
Nom = "Autres"
},
};
context.ModePaiement.AddRange(modepaiement);
context.SaveChanges();
}
/// verifit s"il deja des donnee dans la table ModePaiement
if (!context.Historique_Initialisation_Quota.Any())
{
var quotaInit = new Historique_Initialisation_Quota
{
DateEncours = true,
DateInit = DateTime.Now,
Description = "Initialisation de depart"
};
context.Historique_Initialisation_Quota.Add(quotaInit);
context.SaveChanges();
}
}
