/// <summary>
/// Function for get ligne Hors Forfaits in fiche
/// <param name="ctx"> dbDataContext </param>
/// <param name="user"> visiteur </param>
/// <param name="date"> String </param>
/// </summary>
public static Object getLignesHorsForfaits(dbDataContext ctx, visiteur user, string date)
{
return from l in ctx.lignefraishorsforfait
where l.idVisiteur == user.id && l.mois == date
select new { Libelle = l.libelle, Date = l.date, Montant = l.montant };
}
/// <summary>
/// Function for get ligne Forfaits in fiche
/// <param name="ctx"> dbDataContext </param>
/// <param name="user"> visiteur </param>
/// <param name="date"> String </param>
/// </summary>
public static Object getLignesForfaits(dbDataContext ctx, visiteur user, string date)
{
return from l in ctx.lignefraisforfait
where l.idVisiteur == user.id && l.mois == date
select new { Frais = l.fraisforfait.libelle, Quantite = l.quantite };
}
/// <summary>
/// Function for get user
/// </summary>
/// <param name="login"> String </param>
/// <param name="password"> String </param>
/// <returns> if(user) return user; else return string error;</returns>
public static Object getUser(string login, string password)
{
var ctx = new dbDataContext();
try
{
var user = (from v in ctx.visiteur
where v.login == login && v.mdp == password
select v).First();
return user;
}
catch (Exception)
{
return "Login et/ou mot de passe incorrect";
}
}
/// <summary>
/// Function for add a new fiche in BDD
/// </summary>
/// <param name="ctx"> dbDataContext </param>
/// <param name="idUser"> String </param>
/// <param name="date"> String </param>
/// <param name="submit"> Boolean </param>
public static void insertNewFiche(dbDataContext ctx, string idUser, string date, bool submit)
{
var fiche = new fichefrais
{
idVisiteur = idUser,
mois = date,
nbJustificatifs = 0,
montantValide = 0,
dateModif = DateTime.Now,
idEtat = "CR"
};
ctx.fichefrais.InsertOnSubmit(fiche);
var req = from f in ctx.fraisforfait
select f;
foreach (var element in req)
{
var ligneFrais = new lignefraisforfait
{
idVisiteur = idUser,
mois = date,
idFraisForfait = element.id,
quantite = 0
};
ctx.lignefraisforfait.InsertOnSubmit(ligneFrais);
}
if (submit)
{
ctx.SubmitChanges();
}
}
/// <summary>
/// Function to start on click in buttonResetComptableView button
/// </summary>
/// <param name="sender"> Object </param>
/// <param name="e"> Events </param>
private void buttonResetComptableView_Click(object sender, EventArgs e)
{
this.ctx = new dbDataContext();
initDatas();
}