public ParserExample()
{
MethodToExecute = Example;
OnExecuteCompleted += OnEndPars;
dynamic parameter = new List <string>();
Parametres.Push(parameter);
Execute(100);
}
public CardInfo(Parametres parameters, Card card)
{
reversed = parameters.isReverse;
pos = parameters.lastPosition;
childOrder = parameters.lastChildOrder;
parentTransform = parameters.lastParent;
this.card = card;
cardAbove = parameters.lastCardAbove;
}
public Parametres GetAll()
{
var res = new Parametres();
try
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = @"select
PA_No as No,PA_CodeTaxeTimbre as CodeTaxeTimbre,PA_ArticleTimbre as ArticleTimbre,
PA_CodeTaxeTimbreAchat as CodeTaxeTimbreAchat,PA_NumRegCourant as NumRegCourant,PA_NumRegCourantF as NumRegCourantF,
PA_CouleurR as CouleurR,PA_CouleurB as CouleurB,PA_CouleurV as CouleurV,PA_ArticleFraisD as ArticleFraisD,
PA_StockNegatif as StockNegatif,PA_Precision as Precisions,PA_Limit as Limit,PA_TxVente1 as TxVente1,
PA_TxVente2 as TxVente2,PA_TxVente3 as TxVente3,PA_TxAchat1 as TxAchat1,
PA_TxAchat2 as TxAchat2,PA_TxAchat3 as TxAchat3,PA_RegBL as RegBL,
PA_CollabClient as CollabClient,PA_DEVISE as DEVISE,PA_INCFRS as INCFRS,PA_INCCLI as INCCLI,PA_NUMFRS as NUMFRS,
PA_NUMCLI as NUMCLI,PA_REPFAC as REPFAC,PA_REPLIV as REPLIV,PA_REPACHAT as REPACHAT,PA_LOGO as LOGO,
PA_PIED1 as PIED1,PA_PIED2 as PIED2,PA_PIED3 as PIED3,PA_REPCMD as REPCMD,PA_REPDEVIS as REPDEVIS,
PA_LIBLIGTXT1 as LIBLIGTXT1,PA_LIBLIGTXT2 as LIBLIGTXT2,PA_LIBLIGTXT3 as LIBLIGTXT3,PA_LIBLIGVAL1 as LIBLIGVAL1,
PA_LIBLIGVAL2 as LIBLIGVAL2,PA_LIBLIGVAL3 as LIBLIGVAL3,PA_LIBLIGDAT1 as LIBLIGDAT1,PA_LIBLIGDAT2 as LIBLIGDAT2,
PA_LIBLIGDAT3 as LIBLIGDAT3,PA_LIBLIGBOO1 as LIBLIGBOO1,PA_LIBLIGBOO2 as LIBLIGBOO2,PA_LIBLIGBOO3 as LIBLIGBOO3,
PA_LIBDOCTXT1 as LIBDOCTXT1,PA_LIBDOCTXT2 as LIBDOCTXT2,PA_LIBDOCTXT3 as LIBDOCTXT3,PA_LIBDOCVAL1 as LIBDOCVAL1,
PA_LIBDOCVAL2 as LIBDOCVAL2,PA_LIBDOCVAL3 as LIBDOCVAL3,PA_LIBDOCDAT1 as LIBDOCDAT1,PA_LIBDOCDAT2 as LIBDOCDAT2,
PA_LIBDOCDAT3 as LIBDOCDAT3,PA_LIBDOCBOO1 as LIBDOCBOO1,PA_LIBDOCBOO2 as LIBDOCBOO2,PA_LIBDOCBOO3 as LIBDOCBOO3,
PA_LIBCTETXT1 as LIBCTETXT1,PA_LIBCTETXT2 as LIBCTETXT2,PA_LIBCTETXT3 as LIBCTETXT3,PA_LIBCTEVAL1 as LIBCTEVAL1,
PA_LIBCTEVAL2 as LIBCTEVAL2,PA_LIBCTEVAL3 as LIBCTEVAL3,PA_LIBCTEDAT1 as LIBCTEDAT1,PA_LIBCTEDAT2 as LIBCTEDAT2,
PA_LIBCTEDAT3 as LIBCTEDAT3,PA_LIBCTEBOO1 as LIBCTEBOO1,PA_LIBCTEBOO2 as LIBCTEBOO2,PA_LIBCTEBOO3 as LIBCTEBOO3,
PA_REPCMDACH as REPCMDACH,PA_REPLIVACH as REPLIVACH,PA_UNITE as UNITE,PA_LIBARTTXT1 as LIBARTTXT1,
PA_LIBARTTXT2 as LIBARTTXT2,PA_LIBARTTXT3 as LIBARTTXT3,PA_LIBARTVAL1 as LIBARTVAL1,PA_LIBARTVAL2 as LIBARTVAL2,
PA_LIBARTVAL3 as LIBARTVAL3,PA_LIBARTDAT1 as LIBARTDAT1,PA_LIBARTDAT2 as LIBARTDAT2,PA_LIBARTDAT3 as LIBARTDAT3,
PA_LIBARTBOO1 as LIBARTBOO1,PA_LIBARTBOO2 as LIBARTBOO2,PA_LIBARTBOO3 as LIBARTBOO3,PA_PARTAGEPATH as PARTAGEPATH,
PA_FRAISPRI1 as FRAISPRI1,PA_FRAISPRI2 as FRAISPRI2,PA_TYPEFRAISPRI1 as TYPEFRAISPRI1,PA_TYPEFRAISPRI2 as TYPEFRAISPRI2,
PA_TYPEVALPRI as TYPEVALPRI,PA_FAMILLEOT as FAMILLEOT,PA_OTLANCEAUTO as OTLANCEAUTO,PA_PHASELANCEAUTO as PHASELANCEAUTO,
PA_OTSOLDEAUTO as OTSOLDEAUTO,PA_PHASELANCETOUT as PHASELANCETOUT,PA_LIBOTTXT1 as LIBOTTXT1,
PA_LIBOTTXT2 as LIBOTTXT2,PA_LIBOTTXT3 as LIBOTTXT3,PA_LIBOTVAL1 as LIBOTVAL1,PA_LIBOTVAL2 as LIBOTVAL2,PA_LIBOTVAL3 as LIBOTVAL3,
PA_LIBOTDAT1 as LIBOTDAT1,PA_LIBOTDAT2 as LIBOTDAT2,PA_LIBOTDAT3 as LIBOTDAT3,PA_LIBOTBOO1 as LIBOTBOO1,
PA_LIBOTBOO2 as LIBOTBOO2,PA_LIBOTBOO3 as LIBOTBOO3,PA_REPSTOCK as REPSTOCK,PA_FIFO as FIFO,PA_INCART as INCART,
PA_INCARTFAM as INCARTFAM,PA_NUMART as NUMART,PA_MULTISUPPART as MULTISUPPART,PA_MULTISUPPCLT as MULTISUPPCLT,
PA_MULTISUPPFRS as MULTISUPPFRS,PA_LIBARTTAB1 as LIBARTTAB1,PA_LIBARTTAB2 as LIBARTTAB2,PA_LIBARTTAB3 as LIBARTTAB3,
PA_LIBCLTTAB1 as LIBCLTTAB1,PA_LIBCLTTAB2 as LIBCLTTAB2,PA_LIBCLTTAB3 as LIBCLTTAB3,PA_TARIFARTGEN as TARIFARTGEN,
PA_MAILHOST as MAILHOST,PA_MAILPORT as MAILPORT,PA_MAILUSER as MAILUSER,PA_MAILPASS as MAILPASS,
PA_TxVente4 as TxVente4,PA_TxAchat4 as TxAchat4,PA_RemisePied as RemisePied,PA_MES as MES
from P_PARAMETRE ";
dbConnection.Open();
res = dbConnection.Query <Parametres>(sQuery).FirstOrDefault();
}
}
catch (Exception)
{
return(null);
}
return(res);
}
public ArticleGenerique Add(ArticleGenerique articleGenerique)
{
ArticleGenerique result = new ArticleGenerique();
Parametres parametres = new Parametres();
parametres = _parametresRepository.GetAll();
if (parametres.INCART == false)
{
var res = CheckUnicReference(articleGenerique.Reference);
if (res == false)
{
result = _ArticleGeneriqueRepository.Add(articleGenerique);
}
else
{
result = null;
}
}
else
{
if (parametres.INCARTFAM == false)
{
articleGenerique.Reference = parametres.NUMART;
while (CheckUnicReference(articleGenerique.Reference))
{
articleGenerique.Reference.IncrementCode();
}
_ArticleGeneriqueRepository.Add(articleGenerique);
parametres.NUMART = articleGenerique.Reference;
_parametresRepository.Update(parametres);
}
else
{
Famille res = new Famille();
res = _familleRepository.GetById(articleGenerique.Familles.ID);
string s = articleGenerique.Familles.CodeFamille.Substring(0, 3);
articleGenerique.Reference = articleGenerique.Familles.CodeFamille.Substring(0, 3) + parametres.NUMART;
while (CheckUnicReference(articleGenerique.Reference))
{
articleGenerique.Reference.IncrementCode();
}
result = _ArticleGeneriqueRepository.Add(articleGenerique);
parametres.NUMART = articleGenerique.Reference;
_parametresRepository.Update(parametres);
}
}
return(result);
}
public Parametres Update(Parametres parametres)
{
try
{
_ParametresRepository.Update(parametres);
return(parametres);
}
catch (Exception)
{
throw;
}
}
public Parametres Update(Parametres parametres)
{
try
{
_context.Update(parametres);
_context.SaveChanges();
return(parametres);
}
catch (Exception ex)
{
throw ex;
}
}
public virtual void Awake()
{
children = new List <Transform>();
draggableParent = GameObject.FindGameObjectWithTag("UndoHolder").transform;
canvasGroup = GetComponent <CanvasGroup>();
LayoutElement layoutElement = GetComponent <LayoutElement>();
size = new Vector2(layoutElement.minWidth, layoutElement.minHeight);
stock = FindObjectOfType <Stock>();
animationQueueController = FindObjectOfType <AnimationQueueController>();
lastGoodParametres = new Parametres();
ApplicationPauseWatcher.RegisterOnAppPauseCB(ForceStopDrag);
}
public Parametres GetAll()
{
var res = new Parametres();
try
{
res = _context.Parametres.FirstOrDefault();
return(res);
}
catch (Exception ex)
{
throw ex;
}
}
public Parametres Update(Parametres parametres)
{
try
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = @"update P_PARAMETRE set
PA_No=@No,PA_CodeTaxeTimbre=@CodeTaxeTimbre,PA_ArticleTimbre=@ArticleTimbre,PA_CodeTaxeTimbreAchat=@CodeTaxeTimbreAchat,
PA_NumRegCourant=@NumRegCourant,PA_NumRegCourantF=@NumRegCourantF,PA_CouleurR=@CouleurR,PA_CouleurB=@CouleurB,PA_CouleurV=@CouleurV,
PA_ArticleFraisD=@ArticleFraisD,PA_StockNegatif=@StockNegatif,PA_Precision=@Precisions,PA_Limit=@Limit,PA_TxVente1=@ TxVente1,
PA_TxVente2=@TxVente2,PA_TxVente3=@TxVente3,PA_TxAchat1=@TxAchat1,PA_TxAchat2=@TxAchat2,
PA_TxAchat3=@TxAchat3,PA_RegBL=@RegBL,PA_CollabClient=@CollabClient,PA_DEVISE=@DEVISE,PA_INCFRS=@INCFRS,
PA_INCCLI=@INCCLI,PA_NUMFRS=@NUMFRS,PA_NUMCLI=@NUMCLI,PA_REPFAC=@REPFAC,PA_REPLIV=@REPLIV,PA_REPACHAT=@REPACHAT,
PA_LOGO=@LOGO,PA_PIED1=@PIED1,PA_PIED2=@PIED2,PA_PIED3=@PIED3,PA_REPCMD=@REPCMD,PA_REPDEVIS=@REPDEVIS,
PA_LIBLIGTXT1=@LIBLIGTXT1,PA_LIBLIGTXT2=@LIBLIGTXT2,PA_LIBLIGTXT3=@LIBLIGTXT3,PA_LIBLIGVAL1=@LIBLIGVAL1,
PA_LIBLIGVAL2=@LIBLIGVAL2,PA_LIBLIGVAL3=@LIBLIGVAL3,PA_LIBLIGDAT1=@LIBLIGDAT1,PA_LIBLIGDAT2=@LIBLIGDAT2,
PA_LIBLIGDAT3=@LIBLIGDAT3,PA_LIBLIGBOO1=@LIBLIGBOO1,PA_LIBLIGBOO2=@LIBLIGBOO2,PA_LIBLIGBOO3=@LIBLIGBOO3,
PA_LIBDOCTXT1=@LIBDOCTXT1,PA_LIBDOCTXT2=@LIBDOCTXT2,PA_LIBDOCTXT3=@LIBDOCTXT3,PA_LIBDOCVAL1=@LIBDOCVAL1,
PA_LIBDOCVAL2=@LIBDOCVAL2,PA_LIBDOCVAL3=@LIBDOCVAL3,PA_LIBDOCDAT1=@LIBDOCDAT1,PA_LIBDOCDAT2=@LIBDOCDAT2,
PA_LIBDOCDAT3=@LIBDOCDAT3,PA_LIBDOCBOO1=@LIBDOCBOO1,PA_LIBDOCBOO2=@LIBDOCBOO2,PA_LIBDOCBOO3=@LIBDOCBOO3,
PA_LIBCTETXT1=@LIBCTETXT1,PA_LIBCTETXT2=@LIBCTETXT2,PA_LIBCTETXT3=@LIBCTETXT3,PA_LIBCTEVAL1=@LIBCTEVAL1,
PA_LIBCTEVAL2=@LIBCTEVAL2,PA_LIBCTEVAL3=@LIBCTEVAL3,PA_LIBCTEDAT1=@LIBCTEDAT1,PA_LIBCTEDAT2=@LIBCTEDAT2,
PA_LIBCTEDAT3=@LIBCTEDAT3,PA_LIBCTEBOO1=@LIBCTEBOO1,PA_LIBCTEBOO2=@LIBCTEBOO2,PA_LIBCTEBOO3=@LIBCTEBOO3,
PA_REPCMDACH=@REPCMDACH,PA_REPLIVACH=@REPLIVACH,PA_UNITE=@UNITE,PA_LIBARTTXT1=@LIBARTTXT1,PA_LIBARTTXT2=@LIBARTTXT2,
PA_LIBARTTXT3=@LIBARTTXT3,PA_LIBARTVAL1=@LIBARTVAL1,PA_LIBARTVAL2=@LIBARTVAL2,PA_LIBARTVAL3=@LIBARTVAL3,
PA_LIBARTDAT1=@LIBARTDAT1,PA_LIBARTDAT2=@LIBARTDAT2,PA_LIBARTDAT3=@LIBARTDAT3,PA_LIBARTBOO1=@LIBARTBOO1,
PA_LIBARTBOO2=@LIBARTBOO2,PA_LIBARTBOO3=@LIBARTBOO3,PA_PARTAGEPATH=@PARTAGEPATH,PA_FRAISPRI1=@FRAISPRI1,
PA_FRAISPRI2=@FRAISPRI2,PA_TYPEFRAISPRI1=@TYPEFRAISPRI1,PA_TYPEFRAISPRI2=@TYPEFRAISPRI2,
PA_TYPEVALPRI=@TYPEVALPRI,PA_FAMILLEOT=@FAMILLEOT,PA_OTLANCEAUTO=@OTLANCEAUTO,PA_PHASELANCEAUTO=@PHASELANCEAUTO,
PA_OTSOLDEAUTO=@OTSOLDEAUTO,PA_PHASELANCETOUT=@PHASELANCETOUT,PA_LIBOTTXT1=@LIBOTTXT1,
PA_LIBOTTXT2=@LIBOTTXT2,PA_LIBOTTXT3=@LIBOTTXT3,PA_LIBOTVAL1=@LIBOTVAL1,PA_LIBOTVAL2=@LIBOTVAL2,
PA_LIBOTVAL3=@LIBOTVAL3,PA_LIBOTDAT1=@LIBOTDAT1,PA_LIBOTDAT2=@LIBOTDAT2,PA_LIBOTDAT3=@LIBOTDAT3,
PA_LIBOTBOO1=@LIBOTBOO1,PA_LIBOTBOO2=@LIBOTBOO2,PA_LIBOTBOO3=@LIBOTBOO3,PA_REPSTOCK=@REPSTOCK,PA_FIFO=@FIFO,
PA_INCART=@INCART,PA_INCARTFAM=@INCARTFAM,PA_NUMART=@NUMART,PA_MULTISUPPART=@MULTISUPPART,PA_MULTISUPPCLT=@MULTISUPPCLT,
PA_MULTISUPPFRS=@MULTISUPPFRS,PA_LIBARTTAB1=@LIBARTTAB1,PA_LIBARTTAB2=@LIBARTTAB2,PA_LIBARTTAB3=@LIBARTTAB3,
PA_LIBCLTTAB1=@LIBCLTTAB1,PA_LIBCLTTAB2=@LIBCLTTAB2,PA_LIBCLTTAB3=@LIBCLTTAB3,PA_TARIFARTGEN=@TARIFARTGEN,
PA_MAILHOST=@MAILHOST,PA_MAILPORT=@MAILPORT,PA_MAILUSER=@MAILUSER,PA_MAILPASS=@MAILPASS,PA_TxVente4=@ TxVente4,
PA_TxAchat4=@ TxAchat4,PA_RemisePied=@RemisePied,PA_MES=@MES
";
dbConnection.Open();
dbConnection.Execute(sQuery, parametres);
}
}
catch (Exception)
{
return(null);
}
return(parametres);
}
/// <summary>
/// Méthode permettant d'ajouter un utilisateur à la liste des utilisateurs de l'application (lors de l'inscription d'un utilisateur).
/// </summary>
/// <param name="mail">Mail de l'utilisateur</param>
/// <param name="motDePasse">Mot de passe de l'utilisateur</param>
/// <param name="nom">Nom de l'utilisateur</param>
/// <param name="prenom">Prénom de l'utilisateur</param>
/// <param name="type">Type de l'utilisateur</param>
/// <returns>string: Identifiant de l'utilisateur créé</returns>
public string AjouterUtilisateur(string mail, string motDePasse, string nom, string prenom, TypeUtilisateur type, ICollection <Telephone> telephones, Lieu lieu, Civilite civilite, string otherInfo)
{
var param = new Parametre();
Parametres.Add(param);
Lieux.Add(lieu);
SaveChanges();
var user = new Utilisateur(mail, motDePasse, nom, prenom, telephones, type, lieu, civilite, param, otherInfo);
Utilisateurs.Add(user);
SaveChanges();
Telephones.AddRange(telephones);
SaveChanges();
return(user.ID);
}
public async void Initialize()
{
ParamGlobaux = _dataService.ParamGlobaux;
EnableImprimer = false;
oConnection = ClassLibraryProget.DataBase.OpenSqlServer(_dataService.ParamGlobaux.ConnectionString);
DureeMaxCDDCourt = Convert.ToInt32(Parametres.RechercherParametres(oConnection, ParamGlobaux.IDEtablissement, "", "Durée maxi CDD court"));
oConnection.Close();
IsEnable = true;
//Initialisation des listes///////////
SelectedAgent = new AgentModel();
PeriodeCommun = new ObservableCollection <PeriodeModulation>();
var taskAgents = _dataService.GetAgentsContratsAsync();
var taskStatuts = _dataService.GetStatutsAsync(true);
var taskServices = _dataService.GetServicesAsync(true);
var taskEmplois = _dataService.GetEmploisAsync(true);
await Task.WhenAll(taskAgents, taskStatuts, taskServices, taskEmplois);
_TousAgents = taskAgents.Result.ToList();
Agents = new ObservableCollection <AgentModel>(_TousAgents.Distinct().OrderBy(a => a.Prenom).OrderBy(a => a.Nom));
Statuts = taskStatuts.Result;
Services = taskServices.Result;
Emplois = taskEmplois.Result;
//On initialise les selections sur la ligne vide
_SelectedStatut = Statuts[0];
_SelectedService = Services[0];
_SelectedEmploi = Emplois[0];
SelectAllAgents = false;
UpdateListePeriodes();
}
public Parametres Update(Parametres parametres)
{
_ParametresRepository.Update(parametres);
return(parametres);
}
private async Task CreationApercu(IProgress <ProgressMessage> progress)
{
_ReportSource = new CRRecapReposConges();
DataSet DsTemp = new DataSet();
oConnection = ClassLibraryProget.DataBase.OpenSqlServer(_dataService.ParamGlobaux.ConnectionString);
DsRecapReposConges DsRecapReposConges = new DsRecapReposConges();
////////////////////////Initialisation barre de progression//////////////////////////
_progressMax = (ListAgents.Count() * 5);
int _progressValue = 0;
#region Remplissage du DataSet Agents
//Remplissage du DataSet Agents
foreach (AgentModel ag in ListAgents)
{
if (ag.Typecontrat != null)
{
DsRecapReposConges.Tables["Agents"].Rows.Add(ag.Matricule, ag.Mail, ag.Nom, ag.Prenom, ag.IDService, ag.IDSection, ag.IDEmploi,
ag.IDFiliere, ag.Typecontrat, ag.DebutContrat, ag.FinContrat);
}
else
{
DsRecapReposConges.Tables["Agents"].Rows.Add(ag.Matricule, ag.Mail, ag.Nom, ag.Prenom, ag.IDService, ag.IDSection, ag.IDEmploi,
ag.IDFiliere, "", ag.DebutContrat, ag.FinContrat);
}
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
#endregion
#region Remplissage du DataSet PeriodeModulation
//remplissage du DataSet PeriodeModulation
PeriodeModulation pTemp = new PeriodeModulation();
DureeMaxCDDCourt = Convert.ToInt32(Parametres.RechercherParametres(oConnection, ParamGlobaux.IDEtablissement, "", "Durée maxi CDD court"));
foreach (AgentModel ag in ListAgents)
{
listPeriodseModulation = await gestion.PeriodesModulation(ParamGlobaux.ConnectionString, ag.Matricule, PeriodeModulation.Debut, DureeMaxCDDCourt);
pTemp = listPeriodseModulation.Where(pm => pm.EnCours == true).SingleOrDefault();
DsRecapReposConges.Tables["PeriodeModulation"].Rows.Add(ag.Matricule, pTemp.Debut, pTemp.Fin, pTemp.TypeContrat, pTemp.IdContrat,
pTemp.TempsBase, pTemp.Regime, pTemp.IDEtablissement, pTemp.EnCours);
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
#endregion
#region Remplissage DataSet CongesDroits
List <Parametre> Params = new List <Parametre>();
List <TypesJours> typesJours = new List <TypesJours>();
var taskTypeJour = _dataService.GetTypesJoursAsync();
await taskTypeJour;
typesJours = taskTypeJour.Result.ToList();
int DroitCPA;
double DroitRCNuit;
double DroitRCC;
int DroitCESS;
StrucRTT DroitRTT = new StrucRTT();
foreach (AgentModel ag in ListAgents)
{
ParamGlobaux.StMatricule = ag.Matricule;
Params = await Parametres.GetParametresAsync(_dataService.ParamGlobaux.ConnectionString, _dataService.ParamGlobaux.IDEtablissement, ag.Matricule,
new List <string> {
"Congés en jours ouvrés",
"Début periode de prise congés",
"Durée maxi Contrat court CPA",
"Durée carence CPA",
"Jours Congés Ouvrables",
"Jours Congés Ouvrés",
"Durée pause avec Repas",
"Durée pause sans Repas",
"Valorisation CPA",
"Valorisation CA",
"Base hebdomadaire",
"Durée maxi CDD court",
"Année Calcul N-1 RCN",
"Convention collective",
"Forfait RC Nuit",
"Taux RC Nuit",
"Heure début nuit",
"Heure fin nuit",
"Heure début nuit AT",
"Heure fin nuit AT",
"Forfait RCC",
"Durée Repos Quotidien",
"Ouverture droit coupure",
"Année Calcul N-1 RCC"
});
DroitCPA = await TempsTravail.CalculDroitCPA(ParamGlobaux, PeriodeModulation.Debut, Params, true);
DroitRCNuit = (await TempsTravail.CalculDroitRCNuitH(ParamGlobaux, Params, typesJours, PeriodeModulation.Debut, PeriodeModulation.Fin)) / 60;
DroitRCC = await TempsTravail.CalculDroitRCC(ParamGlobaux, typesJours, PeriodeModulation.Debut, PeriodeModulation.Fin);
DroitCESS = await TempsTravail.CalculDroitCESS(ParamGlobaux, typesJours, PeriodeModulation.Debut);
DroitRTT = await TempsTravail.CalculDroitRTT(ParamGlobaux, PeriodeModulation.Debut, PeriodeModulation.Fin);
DsRecapReposConges.Tables["CongesDroits"].Rows.Add(ag.Matricule, DroitCPA, DroitRCNuit, DroitRCC, DroitCESS, DroitRTT.DbDroitRTT);
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
#endregion
#region Remplissage DataSet CongesPris
await taskTypeJour;
typesJours = taskTypeJour.Result.ToList();
int PrisCPA;
int PrisCA;
int TotalCPACA;
double PrisRCNuit;
double PrisRCC;
int PrisCESS;
double PrisRTT;
foreach (AgentModel ag in ListAgents)
{
ParamGlobaux.StMatricule = ag.Matricule;
Params = await Parametres.GetParametresAsync(_dataService.ParamGlobaux.ConnectionString, _dataService.ParamGlobaux.IDEtablissement, ag.Matricule,
new List <string> {
"Congés en jours ouvrés",
"Début periode de prise congés",
"Durée maxi Contrat court CPA",
"Durée carence CPA",
"Jours Congés Ouvrables",
"Jours Congés Ouvrés",
"Durée pause avec Repas",
"Durée pause sans Repas",
"Valorisation CPA",
"Valorisation CA",
"Base hebdomadaire",
"Durée maxi CDD court",
"Année Calcul N-1 RCN",
"Convention collective",
"Forfait RC Nuit",
"Taux RC Nuit",
"Heure début nuit",
"Heure fin nuit",
"Heure début nuit AT",
"Heure fin nuit AT",
"Forfait RCC",
"Durée Repos Quotidien",
"Ouverture droit coupure",
"Année Calcul N-1 RCC"
});
(PrisCPA, PrisCA) = await TempsTravail.CalculPrisCPA(_dataService.ParamGlobaux.ConnectionString, _dataService.ParamGlobaux.IDEtablissement, ag.Matricule, PeriodeModulation.Debut);
TotalCPACA = PrisCPA + PrisCA;
PrisRCNuit = await TempsTravail.CalculPrisRCNuit(ParamGlobaux, typesJours, Params, PeriodeModulation.Debut, PeriodeModulation.Fin);
PrisRCC = await TempsTravail.CalculGenreH(ParamGlobaux, typesJours, Params, "13", PeriodeModulation.Debut, PeriodeModulation.Fin);
PrisCESS = TempsTravail.CalculPrisCESS(ParamGlobaux, PeriodeModulation.Debut, PeriodeModulation.Fin);
PrisRTT = TempsTravail.CalculGenreJ(_dataService.ParamGlobaux.ConnectionString, ag.Matricule, "30", PeriodeModulation.Debut, PeriodeModulation.Fin);
DsRecapReposConges.Tables["CongesPris"].Rows.Add(ag.Matricule, TotalCPACA, PrisRCNuit, PrisRCC, PrisCESS, PrisRTT);
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
#endregion
#region Remplissage DataSet RcFeries
ObservableCollection <RCFerie> RCFeries;
IEnumerable <JourFerieW> ListRCFerie;
DataSet DsRCFeriePris;
DateTime d = new DateTime(1900, 01, 01);
foreach (AgentModel ag in ListAgents)
{
ParamGlobaux.StMatricule = ag.Matricule;
Params = await Parametres.GetParametresAsync(_dataService.ParamGlobaux.ConnectionString, _dataService.ParamGlobaux.IDEtablissement, ag.Matricule,
new List <string> {
"Congés en jours ouvrés",
"Début periode de prise congés",
"Durée maxi Contrat court CPA",
"Durée carence CPA",
"Jours Congés Ouvrables",
"Jours Congés Ouvrés",
"Durée pause avec Repas",
"Durée pause sans Repas",
"Valorisation CPA",
"Valorisation CA",
"Base hebdomadaire",
"Durée maxi CDD court",
"Année Calcul N-1 RCN",
"Convention collective",
"Forfait RC Nuit",
"Taux RC Nuit",
"Heure début nuit",
"Heure fin nuit",
"Heure début nuit AT",
"Heure fin nuit AT",
"Forfait RCC",
"Durée Repos Quotidien",
"Ouverture droit coupure",
"Année Calcul N-1 RCC"
});
ListRCFerie = await TempsTravail.CalculFeriesAgent(ParamGlobaux, typesJours, PeriodeModulation.Debut, PeriodeModulation.Fin);
RCFeries = await _dataService.GetHistoriqueRCFAsync(PeriodeModulation.Debut, PeriodeModulation.Fin);
foreach (RCFerie rc in RCFeries)
{
ListRCFerie = ListRCFerie.Where(a => a.Date != rc.JourFerie);
}
if (ListRCFerie != null)
{
foreach (var item in ListRCFerie)
{
RCFerie temp = new RCFerie(d, item.Date, item.NbHeuresW);
RCFeries.Add(temp);
}
}
ObservableCollection <RCFerie> RCFeries2 = new ObservableCollection <RCFerie> (RCFeries.OrderBy(a => a.JourFerie));
if (RCFeries2.Count() > 0)
{
foreach (RCFerie RCF in RCFeries2)
{
if (RCF.JourFerie != null && RCF.RCF != d)
{
DsRecapReposConges.Tables["RcFeries"].Rows.Add(ag.Matricule, Convert.ToDateTime(RCF.JourFerie).ToShortDateString(), RCF.NbHeures.ToString(@"hh\:mm"), RCF.RCF.ToShortDateString(), RCF.NbHeuresRCF.ToString(@"hh\:mm"));
}
else if (RCF.JourFerie == null && RCF.JourFerie != d)
{
DsRecapReposConges.Tables["RcFeries"].Rows.Add(ag.Matricule, "", RCF.NbHeures.ToString(@"hh\:mm"), RCF.RCF.ToShortDateString(), RCF.NbHeuresRCF.ToString(@"hh\:mm"));
}
else
{
DsRecapReposConges.Tables["RcFeries"].Rows.Add(ag.Matricule, Convert.ToDateTime(RCF.JourFerie).ToShortDateString(), RCF.NbHeures.ToString(@"hh\:mm"), "", "");
}
}
}
else
{
DsRecapReposConges.Tables["RcFeries"].Rows.Add(ag.Matricule, "", "", "", "");
}
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
#endregion
_ReportSource.SetDataSource(DsRecapReposConges);
RaisePropertyChanged("ReportSource");
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
Parametres.Init(configuration);
}
public UserService(IOptions <Parametres> appSettings)
{
this.Parametres = appSettings.Value;
}
/// //////////////////////////////////// /////////////////////////////////
public C2iExpressionIndexeur(IExpression expressionChamp, IExpression expressionIndexeur)
{
Parametres.Add(expressionChamp);
Parametres.Add(expressionIndexeur);
}
private async Task CreationApercu(IProgress <ProgressMessage> progress)
{
dateSemaine = (DateTime)_dataService.Jour;
DataRow DtRow;
string StSQL;
StSQL = "";
DataSet DsTemp = new DataSet();
bool ajoutVirgule = false;
_ReportSource = new CRBordereauDeclaratif();
DsBordereauDeclaratif DsBordereauDeclaratif = new DsBordereauDeclaratif();
///////////////////////////////////////////////////////////////////////////////////
/////////////Table Agents///////////////////////////////////////////
//////Création de la requete/////////////////
StSQL = "SELECT * FROM Agents WHERE Agents.Matricule IN (";
ajoutVirgule = false;
foreach (string s in Agents)
{
if (ajoutVirgule == true)
{
StSQL += ",";
}
StSQL += "'" + s + "'";
ajoutVirgule = true;
}
StSQL += ")";
oConnection = ClassLibraryProget.DataBase.OpenSqlServer(ParamGlobaux.ConnectionString);
////////remplissage du DsTemp///////////////
try
{
DsTemp = ClassLibraryProget.DataBase.SELECTSqlServer(oConnection, "Agents", StSQL);
}
catch (SqlException exc)
{
System.Windows.MessageBox.Show("Lecture impossible des données de la table " + "Agents" + " " + exc.Message, "Erreur");
}
////////remplissage du DsBordereauDeclaratif///////////////
for (int i = 0; i < DsTemp.Tables[0].Rows.Count; i++)
{
DtRow = DsBordereauDeclaratif.Tables["Agents"].NewRow();
for (int j = 0; j < DsTemp.Tables[0].Columns.Count; j++)
{
DtRow[j] = DsTemp.Tables[0].Rows[i][j];
}
DsBordereauDeclaratif.Tables["Agents"].Rows.Add(DtRow);
}
///////////////////////////////////////////////////////////////////////////////////
/////////////Table Planning///////////////////////////////////////////
/////Calcul du numéro de la semaine///////////
CultureInfo ci = CultureInfo.CurrentCulture;
weekOfYear = ci.Calendar.GetWeekOfYear(dateSemaine, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
//////Création de la requete/////////////////
StSQL = "SELECT * FROM Planning WHERE Planning.Matricule IN (";
ajoutVirgule = false;
foreach (string s in Agents)
{
if (ajoutVirgule == true)
{
StSQL += ",";
}
StSQL += "'" + s + "'";
ajoutVirgule = true;
}
StSQL += ") AND Planning.[Num semaine] = " + weekOfYear + " AND YEAR(Jour) = " + dateSemaine.Year;
////////remplissage du DsTemp///////////////
try
{
DsTemp = ClassLibraryProget.DataBase.SELECTSqlServer(oConnection, "Planning", StSQL);
}
catch (SqlException exc)
{
MessageBoxResult _dialogResult = _dialogService.ShowMessageBox(this,
"Lecture impossible des données de la table " + "Planning" + " " + exc.Message,
"Erreur",
MessageBoxButton.OK,
MessageBoxImage.Error);
}
///////////////////////si pas resultat///////////////////////////////////////////
if (DsTemp.Tables[0].Rows.Count == 0)
{
MessageBoxResult _dialogResult = _dialogService.ShowMessageBox(this,
"Aucun planning correspondant n'a été trouvé",
"Erreur",
MessageBoxButton.OK,
MessageBoxImage.Error);
_progress.Report(new ProgressMessage(100, "Finished", true));
Reset();
await Task.Delay(500);
Close = true;
return;
}
////////////////////////Initialisation barre de progression//////////////////////////
_progressMax = (Agents.Count * 1);
int _progressValue = 0;
////////remplissage du DsBordereauDeclaratif///////////////
for (int i = 0; i < DsTemp.Tables[0].Rows.Count; i++)
{
DtRow = DsBordereauDeclaratif.Tables["Planning"].NewRow();
for (int j = 0; j < DsTemp.Tables[0].Columns.Count; j++)
{
DtRow[j] = DsTemp.Tables[0].Rows[i][j];
}
DsBordereauDeclaratif.Tables["Planning"].Rows.Add(DtRow);
}
//////////////////Remplissage Annualisation/////////////////////////////////
//////////////////////////////////////////////////////////////////////////
List <Parametre> Params = new List <Parametre>();
List <PeriodeModulation> Periodes = new List <PeriodeModulation>();
List <Data> ListeData = new List <Data>();
///compteur de tour de boucle//
int k = 0;
foreach (var item in Agents)
{
//////recherche parametre pour la methode PeriodesModulation//////////////////////////////////
Params = await Parametres.GetParametresAsync(ParamGlobaux.ConnectionString, ParamGlobaux.IDEtablissement, item,
new List <string> {
"Durée maxi CDD court"
});
int DureeMaxCDDCourt = Convert.ToInt32(Params.Single(p => p.Name == "Durée maxi CDD court").Value);
/////////////////////////////recherche des périodes de modulation/////////////////////////////////////////////
Periodes = await gestion.PeriodesModulation(ParamGlobaux.ConnectionString, item, dateSemaine, DureeMaxCDDCourt);
////////////////////////////Création liste Data Matricule + tempbase///////////////////////////////////////////////////
foreach (var z in Periodes)
{
if (z.EnCours == true)
{
ListeData.Add(new Data(item, z.TempsBase, z.Regime));
}
}
_progressValue++;
_progress.Report(new ProgressMessage((_progressValue * 100) / _progressMax, "Création de l'aperçu...", false));
}
////////////////////////////////////Remplissage DsBordereauDeclaratif//////////////////////////////////////////////
foreach (var x in ListeData)
{
k = 0;
foreach (DataRow DtRowBD in DsBordereauDeclaratif.Tables["Planning"].Rows)
{
if (DsBordereauDeclaratif.Tables["Planning"].Rows[k]["Matricule"].ToString() == x.Matricule)
{
DsBordereauDeclaratif.Tables["Planning"].Rows[k]["Annualisation"] = x.TempBase;
DsBordereauDeclaratif.Tables["Planning"].Rows[k]["Regime"] = x.Regime;
}
k++;
}
}
// =======================================================================================================================================
// Définir une structure de données temps de travail pour les calculs
// =======================================================================================================================================
ClassGetMS.TpsDeTravail TempsTravail;
List <Data> listeCalcul = new List <Data>();
List <DateTime> Jours = new List <DateTime>();
for (int i = 0; i < 7; i++)
{
Jours.Add(dateSemaine);
dateSemaine = dateSemaine.AddDays(1);
}
DateTime dateValue = new DateTime(1900, 1, 1, 0, 0, 0);
DateTime dateValue1 = new DateTime(1900, 1, 1, 0, 0, 0);
foreach (var item in Agents)
{
foreach (var d in Jours)
{
TempsTravail = await ClassGetMS.TempsTravail.CalculTpsTravail(ParamGlobaux, item, d, d, ParamGlobaux.IDEtablissement, "", "");
listeCalcul.Add(new Data(item, ((TempsTravail.TpsTravailEffectif + TempsTravail.TpsTravailAssimilé + TempsTravail.TpsRéparti) / (double)60.00m), TempsTravail.HeuresAbsencesRémunérées, d));
}
}
foreach (DataRow DtRowBD in DsBordereauDeclaratif.Tables["Planning"].Rows)
{
Data jour = listeCalcul.SingleOrDefault(l => l.Matricule == DtRowBD["Matricule"].ToString() && l.Jour == Convert.ToDateTime(DtRowBD["Jour"]));
if (jour != null)
{
DtRowBD["Temp de travail"] = jour.TempTravail;
DtRowBD["Abs"] = jour.Abs;
}
}
//////////Prévisionnel en string////////////
if (previsionnel.ToString() == "Oui")
{
stringPrevisionnel = "Prévisionnel";
}
else
{
stringPrevisionnel = "";
}
if (entete == null)
{
entete = "";
}
_ReportSource.SetDataSource(DsBordereauDeclaratif);
///////////Nom Etablissement/////////////////////////////
string NomEtablissement;
NomEtablissement = ParamGlobaux.Etablissement.ToString();
TextObject Commentaire;
TextObject Previsionnel;
TextObject Etablissement;
if ((_ReportSource.ReportDefinition.ReportObjects["Text3"] != null) &&
(_ReportSource.ReportDefinition.ReportObjects["Text4"] != null) &&
(_ReportSource.ReportDefinition.ReportObjects["Text6"] != null))
{
Commentaire = (TextObject)_ReportSource.ReportDefinition.ReportObjects["Text3"];
Commentaire.Text = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(entete.ToString());
Previsionnel = (TextObject)_ReportSource.ReportDefinition.ReportObjects["Text4"];
Previsionnel.Text = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(stringPrevisionnel.ToString());
Etablissement = (TextObject)_ReportSource.ReportDefinition.ReportObjects["Text6"];
Etablissement.Text = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(NomEtablissement.ToString());
}
RaisePropertyChanged("ReportSource");
}
public string GetIncrement()
{
Parametres parametres = _parametresService.GetAll();
return(parametres.NUMCLI.IncrementCode());
}
private void btnEnregistrer_Click(object sender, RoutedEventArgs e)
{
try
{
//if (!GlobalData.VerifyClotureSession())
//{
// var result = MessageBox.Show("Voulez-vous fermer la session précédente ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Warning);
// if (result == MessageBoxResult.Yes)
// {
// RadDocumentPane radMenu = new RadDocumentPane();
// radMenu.Content = new GESHOTEL.ReservationsModules.Views.Win.ClotureJourneeFrm("Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString());
// radMenu.Header = "Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString();
// GlobalData.rrvMain.Title = "Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString();
// radMenu.FontFamily = new FontFamily("Perpetua Titling MT");
// radMenu.HorizontalAlignment = System.Windows.HorizontalAlignment.Stretch;
// radMenu.VerticalAlignment = System.Windows.VerticalAlignment.Stretch;
// if (!GlobalData.VerifyDock("Cloture de la session du " + GlobalData.CurrentRegistres.DateDebut.Value.ToShortDateString()))
// {
// GlobalData.PaneGroup.AddItem(radMenu, Telerik.Windows.Controls.Docking.DockPosition.Center);
// }
// else
// {
// }
// }
// return;
//}
Chambres Cham = chambreAutoCompleteBox.SelectedItem as Chambres;
if (Cham.EtatOperation == "SALLE")
{
MessageBox.Show("La chambre est salle veuillez la nettoyée", "Message", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
var results = MessageBox.Show("Voulez-vous enregistrer ?", "Message", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (results == MessageBoxResult.Yes)
{
int NbreHr = -rtHD.SelectedTime.Value.Subtract(rtHF.SelectedTime.Value).Hours;
if (rnHeure.Value <= 0)
{
MessageBox.Show("Le nombre d'heure ne peut pa etre egale a 0", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
if (chambreAutoCompleteBox.SelectedItem == null)
{
MessageBox.Show("Choisissez une chambre svp", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
if (NbreHr <= 0)
{
MessageBox.Show("Le nombre d'heure ne peut pa etre egale a 0", "Message", MessageBoxButton.OKCancel, MessageBoxImage.Warning); return;
}
Transactions Trans = new Transactions();
Trans.DateTransaction = DateTime.Now;
Trans.TotalPaye = Convert.ToDecimal(rntarif.Value);
Trans.TotalTTC = Convert.ToDecimal(rntarif.Value);
Trans.TotalHT = Convert.ToDecimal(rntarif.Value);
Trans.TVA = 0;
Trans.TotalReste = 0;
Trans.Etat = "PAYE";
DetailPaiements dtPaie = new DetailPaiements();
dtPaie.Montant = rntarif.Value;
dtPaie.DatePaiement = DateTime.Now;
dtPaie.MethodePaiements = GlobalData.model.MethodePaiements.Where(c => c.Libelle == "ESPECE").First();
dtPaie.Transactions = Trans;
dtPaie.Etat = "ACTIF";
//dtPaie.idHotel = GlobalData.HotId;
Trans.DetailPaiements.Add(dtPaie);
if (Cham.EtatOperation == "LIBRE" || Cham.EtatOperation == "RESERVER")
{
Cham.EtatOperation = "OCCUPER";
}
DetailTransactions dtTrans = new DetailTransactions();
dtTrans.Date = DateTime.Now;
dtTrans.Descriptions = "CHAMBRE " + Cham.TypeChambres.Libelle + " " + Cham.Numero;
dtTrans.prix = Convert.ToDecimal(rntarif.Value);
dtTrans.Quantite = 1;
dtTrans.Montant = Convert.ToDecimal(rntarif.Value);
dtTrans.Transactions = Trans;
dtTrans.Etat = "ACTIF";
//dtTrans.idHotel = GlobalData.HotId;
dtTrans.Produits = GlobalData.model.Produits.Where(c => c.Libelle == "CHAMBRE").First();
Trans.DetailTransactions.Add(dtTrans);
ReservationTypes resType = GlobalData.model.ReservationTypes.Where(c => c.ReservationType == "PASSAGE").First();
Reservations Reservations = new Reservations();
Reservations.ReservationDate = DateTime.Now;
Reservations.Chambres = Cham;
Reservations.Transactions.Add(Trans);
Reservations.ReservationTypes = resType;
Reservations.NbreNuit = NbreHr;
Reservations.Etat = "ACTIF";
Reservations.EtatOperation = "ARRIVEE";
Reservations.TotalPaye = Trans.TotalPaye;
Reservations.TotalReste = Trans.TotalReste;
Reservations.TotalTTC = Trans.TotalTTC;
Reservations.DateDepart = new DateTime(rtHF.SelectedDate.Value.Year, rtHF.SelectedDate.Value.Month, rtHF.SelectedDate.Value.Day, rtHF.SelectedTime.Value.Hours, rtHF.SelectedTime.Value.Minutes, rtHF.SelectedTime.Value.Seconds);
Reservations.DateArrive = new DateTime(rtHD.SelectedDate.Value.Year, rtHD.SelectedDate.Value.Month, rtHD.SelectedDate.Value.Day, rtHD.SelectedTime.Value.Hours, rtHD.SelectedTime.Value.Minutes, rtHD.SelectedTime.Value.Seconds);
Reservations.TypeOperation = "LOCATION CHAMBRE";
Reservations.DateCheckIn = DateTime.Now;
Reservations.isCheckIn = true;
//Reservations.idHotel = GlobalData.HotId;
Reservations.idRegistre = GlobalData.RegId;
//Trans.idHotel = GlobalData.HotId;
Trans.idRegistre = GlobalData.RegId;
Trans.TypeTransaction = resType.ReservationType;
Parametres param = GlobalData.model.Parametres.Where(c => c.IdParametre == 1).First();
Trans.TransactionNumero = GlobalData.GenerateFacture(param.TransNum.ToString(), 6);
param.TransNum++;
GlobalData.model.Transactions.Add(Trans);
GlobalData.model.Reservations.Add(Reservations);
GlobalData.model.SaveChanges();
var result = MessageBox.Show("Voulez vous imprimer le recu?", "Vente", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
try
{
//RapportWindows frm = new RapportWindows(Reservations.ID, "", "ALL");
//frm.ShowDialog();
//frm.Print();
}
catch (Exception ex)
{
}
}
//MessageBox.Show("Operation terminée", "Message", MessageBoxButton.OK, MessageBoxImage.None);
Clear();
GlobalFO.rpVM.Load();
chambreAutoCompleteBox.Focus();
}
}
catch (Exception ex)
{
if (ex.Message == "Échec du fournisseur sous-jacent sur Commit.")
{
}
else
{
}
}
}
/// //////////////////////////////////// /////////////////////////////////
public C2iExpressionObjet(IExpression expressionSource, IExpression methodeOuPropriete)
: base()
{
Parametres.Add(expressionSource);
Parametres.Add(methodeOuPropriete);
}
