private bool InsertAnte()
{
try
{
using (var model = new ExpFinanceEntities())
{
var detail = new DetailsDossier();
var tempdata = (from temp in model.AF_TEMP_DATA_ANT
where temp.entite == _entite
select temp);
foreach (var temp in tempdata)
{
//EXERCICE ANTERIEUR
ErrorLog.LogMessage($"treating avoir{temp.numAvoir}");
var year = temp.Exercice;
var factures = temp.factures.Split('-').ToList();
//Get the liste of facture
var liste = detail.GetListeFacturesClientAllYears(factures, year.Value.Year);
if (liste.Count == 0 || liste.All(f => f == null))
{
ErrorLog.LogMessage($"No factures in avoir{temp.numAvoir}");
}
//Creating Groupe Details
//var entite = liste.Where(f=>f!=null).Select(f => f.entite).First();
//var codeClient = liste.Where(f => f != null).Select(f => f.code_clien).First();
decimal?mntHt = 0, mntRz = 0, mntTtc = 0, mntTva = 0, marge = 0;
if (liste.Count != 0 || liste.All(f => f != null))
{
//calculating totales in factures
liste.ForEach(f =>
{
mntHt += f?.total_HT; //this is HTR !!
mntRz += f?.T_remise;
mntTtc += f?.total_TTC;
mntTva += f?.total_TVA;
marge += f?.Marge;
});
}
var newGroupeCvn = new AF_TEMP_GROUPE_FACTURE
{
ID_GROUPE_FACT = temp.idgroupe ?? 0,
DATE_CADEAU = year,
DATE_DOSSIER = DateTime.Today,
ENTITE = _entite,
CODE_CLIENT = temp.codeClient,
//MNT_HT = temp.CA, //this info is given by entite (we switch to avoid to insert les avoirs clients)
MNT_HT = mntHt,
MNT_RZ = mntRz,
MNT_TVA = mntTva,
MNT_TTC = mntTtc,
MONTANT_CHEQUE = mntHt,//this by the db
MARGE = marge,
ETAT = 20,
};
model.AF_TEMP_GROUPE_FACTURE.Add(newGroupeCvn);
if (liste.Count != 0 || liste.All(f => f != null))
{
liste.ForEach(facture =>
{
if (facture != null)
{
var newFacture = new AF_TEMP_FACTURE
{
NUM_FACT = facture.num_trans,
CODE_CLIENT = facture.code_clien,
DATE_FACT = facture.date_trans ?? default(DateTime),
ENTITE = facture.entite,
MARGE = facture.Marge,
MNT_HT_RZ = facture.total_HT - facture.T_remise,
MNT_TTC = facture.total_TTC,
MNT_RZ = facture.T_remise,
MNT_TVA = facture.total_TVA,
ID_GROUPE_FACT = temp.idgroupe ?? 0,
};
model.AF_TEMP_FACTURE.Add(newFacture);
}
});
}
//model.SaveChanges();
//_numGroupe = newGroupeCvn.ID_GROUPE_FACT;
//Insert AVOIR
_numAvoir = temp.numAvoir;
var avoir = new AF_TEMP_AVOIR_FINANCIER
{
numAvoir = _numAvoir,
montant = temp.Montant ?? 0,
dateAvoir = temp.dateAvoir ?? DateTime.Now,
designation = "REMISE FINANCIERE",
montantCheque = temp.cheque ?? 0,
montantCreance = temp.creance ?? 0,
Observation = "",
typeAvoir = byte.Parse(temp.typeAvoir),
numAvoirComptable = 20,
};
var libre = (byte)2;
//insert the related group
var avoirGroupe = new AF_TEMP_AVOIR_GROUPE
{
numAvoir = avoir.numAvoir,
IDG = temp.idgroupe ?? 0,
Libre = libre
};
model.AF_TEMP_AVOIR_GROUPE.Add(avoirGroupe);
//Insert in the etat table
var etat = new AF_TEMP_ETAT_AVOIR
{
numDossier = temp.refAvoir,
numAvoir = avoir.numAvoir,
IDG = temp.idgroupe ?? 0,
Etat = 3,
dateHeure = DateTime.Today
};
model.AF_TEMP_ETAT_AVOIR.Add(etat);
model.AF_TEMP_AVOIR_FINANCIER.Add(avoir);
//model.SaveChanges();
}
model.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Messages.Error(@"Erreur insertion factures: " + e.Message);
ErrorLog.LogError(@"Erreur insertion factures: ", e);
return(false);
}
}
private bool InsertAvoir2016()
{
try
{
using (var model = new ExpFinanceEntities())
{
var detail = new DetailsDossier();
var tempdata = (from temp in model.AF_TEMP_DATA
where temp.entite == _entite
select temp);
foreach (var temp in tempdata)
{
//EXERCICE 2016
var factures = temp.factures.Split('-').ToList();
ErrorLog.LogMessage($"treating avoir{temp.numAvoir}");
//Get the liste of facture
var liste = detail.GetListeFacturesClientAll(factures);
if (liste.Count == 0 || liste.All(f => f == null))
{
ErrorLog.LogMessage($"No factures in avoir{temp.numAvoir}");
}
//Creating Groupe Details
//var entite = liste.Where(f => f != null).Select(f => f.entite).First();
//var codeClient = liste.Where(f => f != null).Select(f => f.code_clien).First();
decimal?mntHt = 0, mntRz = 0, mntTtc = 0, mntTva = 0, marge = 0;
//calculating totales in factures
if (liste.Count != 0 || liste.All(f => f != null))
{
//calculating totales in factures
liste.ForEach(f =>
{
mntHt += f?.total_HT; //this is HTR !!
mntRz += f?.T_remise;
mntTtc += f?.total_TTC;
mntTva += f?.total_TVA;
marge += f?.Marge;
});
}
var newGroupeCvn = new AF_TEMP_GROUPE_FACTURE
{
ID_GROUPE_FACT = temp.idgroupe ?? 0,
DATE_DOSSIER = DateTime.Today,
ENTITE = _entite,
CODE_CLIENT = temp.codeClient,
MNT_HT = mntHt,
MNT_RZ = mntRz,
MNT_TVA = mntTva,
MNT_TTC = mntTtc,
MARGE = marge,
ETAT = 10,
};
model.AF_TEMP_GROUPE_FACTURE.Add(newGroupeCvn);
if (liste.Count != 0 || liste.All(f => f != null))
{
liste.ForEach(facture =>
{
if (facture != null)
{
var newFacture = new AF_TEMP_FACTURE
{
NUM_FACT = facture.num_trans,
CODE_CLIENT = facture.code_clien,
DATE_FACT = facture.date_trans ?? default(DateTime),
ENTITE = facture.entite,
MARGE = facture.Marge,
MNT_HT_RZ = facture.total_HT - facture.T_remise,
MNT_TTC = facture.total_TTC,
MNT_RZ = facture.T_remise,
MNT_TVA = facture.total_TVA,
ID_GROUPE_FACT = temp.idgroupe ?? 0,
};
model.AF_TEMP_FACTURE.Add(newFacture);
}
});
}
//Insert AVOIR
_numAvoir = temp.numAvoir;
var avoir = new AF_TEMP_AVOIR_FINANCIER
{
numAvoir = _numAvoir,
montant = temp.Montant ?? 0,
dateAvoir = temp.dateAvoir,
designation = "REMISE FINANCIERE",
montantCheque = temp.cheque ?? 0,
montantCreance = temp.creance ?? 0,
Observation = "",
typeAvoir = byte.Parse(temp.typeAvoir),
numAvoirComptable = 10,
};
var libre = (byte)1;
//insert the related group
var avoirGroupe = new AF_TEMP_AVOIR_GROUPE
{
numAvoir = avoir.numAvoir,
IDG = temp.idgroupe ?? 0,
Libre = libre
};
model.AF_TEMP_AVOIR_GROUPE.Add(avoirGroupe);
//Insert in the etat table
var etat = new AF_TEMP_ETAT_AVOIR
{
numDossier = temp.refAvoir,
numAvoir = avoir.numAvoir,
IDG = temp.idgroupe ?? 0,
Etat = 3,
dateHeure = DateTime.Today
};
model.AF_TEMP_ETAT_AVOIR.Add(etat);
model.AF_TEMP_AVOIR_FINANCIER.Add(avoir);
}
model.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Messages.Error(@"Erreur insertion factures: " + e.Message);
ErrorLog.LogError(@"Erreur insertion factures: ", e);
return(false);
}
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// ErrorLog.LogError($"Entity of type \"{ eve.Entry.Entity.GetType().Name}\" in state \"{eve.Entry.State}\" has the following validation errors:");
// foreach (var ve in eve.ValidationErrors)
// {
// ErrorLog.LogError($"- Property: \"{ ve.PropertyName}\", Error: \"{ve.ErrorMessage}\"");
// }
// }
// throw;
//}
}