public DevisElements(string _nomFichier, decimal _totalTable)
{
this.dateCreation = DateTime.Now.ToShortDateString();
this.dateVersion = DateTime.Now.ToShortDateString();
this.numVersion = 1.0m;
this.numEdition = 1;
this.nomFichier = _nomFichier;
this.totalTable = _totalTable;
DateTime firstOfTheMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
this.dateDebut = firstOfTheMonth.ToLongDateString();
this.livraisonFinal = firstOfTheMonth.AddMonths(1).AddDays(-1).ToLongDateString();
//Calculs des factu CDP et DT
using (DevisEntities cont = new DevisEntities())
{
//Atttention ta base est pourrie pense a changer les labels pour les finaux
decimal cdp = cont.Tarification.Where(s => s.Type == "CDP").Select(s => s.Tar5).First();
decimal dt = cont.Tarification.Where(s => s.Type == "Directeur").Select(s => s.Tar5).First();
this.facturationCDP = 20 * cdp;
this.facturationDT = 7 * dt;
this.estimationDTCDP = this.facturationDT + this.facturationCDP;
}
this.totalCumule = this.estimationDTCDP + this.totalTable;
}
public void updateValue(bool isAmo)
{
using (DevisEntities cont = new DevisEntities())
{
Ressource res = cont.Ressource.Where(x => x.Initial == initials).Include(x => x.Tarification_Ressource).FirstOrDefault();
if (res != null)
{
List <long> typeId = res.Tarification_Ressource.Select(x => x.FK_Tarification).ToList();
Tarification tar = cont.Tarification.Where(x => typeId.Contains(x.ID) && x.IsAmo == isAmo).FirstOrDefault();
decimal dailyValue = this.value != null?Math.Round(Convert.ToDecimal(this.value / 7), 2) : 0;
dailyValue = getDecimalPart(dailyValue);
this.value = Math.Round(dailyValue * (res.Niveau == 3 ? (decimal)tar.Tar3 : (decimal)tar.Tar5), 2);
}
}
}
public Facturation(string initials, bool isAmo, long type)
{
using (DevisEntities cont = new DevisEntities())
{
Ressource res = cont.Ressource.Where(x => x.Initial == initials).FirstOrDefault();
if (res != null)
{
List <long> typeId = res.Tarification_Ressource.Select(x => x.FK_Tarification).ToList();
Tarification tar = cont.Tarification.Where(x => typeId.Contains(x.ID) && x.IsAmo == isAmo).FirstOrDefault();
if (tar != null)
{
this.initials = res.Initial;
decimal dailyValue = this.value != null?Math.Round(Convert.ToDecimal(this.value / 7), 2) : 0;
this.value = Math.Round(dailyValue * (res.Niveau == 3 ? (decimal)tar.Tar3 : (decimal)tar.Tar5), 2);
}
}
}
}
