private void fusionnerToolStripMenuItem_Click(object sender, EventArgs e)
{
if (position > -1)
{
Presence presence = presences[position];
presence.Pointages = pointages;
if (presence != null ? presence.Id > 0 : false)
{
string adresse = Constantes.SOCIETE.AdresseIp;
List <Presence> list = PresenceBLL.List("select p.* from yvs_grh_presence p where p.employe = " + presence.Employe.Id + " and p.date_debut = '" + dtp_date.Value + "' order by heure_debut", true, adresse);
if (list != null ? list.Count > 1 : false)
{
foreach (Presence p in list)
{
if (p.Id != presence.Id)
{
presence.Pointages.AddRange(PointageBLL.List("select * from yvs_grh_pointage where presence = " + p.Id, true, adresse));
Bll.RequeteLibre("delete from yvs_grh_presence where id = " + p.Id, adresse);
presences.Remove(p);
lb_pagination.Text = (position + 1) + "/" + presences.Count;
txt_index_of.Text = (position + 1).ToString();
}
}
}
ReorganiserFiche(presence);
}
}
}
private void loadPointage(Presence y, string adresse)
{
object_pointage.ClearDataGridView(true);
if (y != null ? y.Id > 0 : false)
{
presence = y;
string query = "select * from yvs_grh_pointage where presence = " + y.Id;
List <Pointage> lp = PointageBLL.List(query, true, adresse);
if (lp != null ? lp.Count > 0 : false)
{
foreach (Pointage p in lp)
{
object[] value = new object[] { p.Id, p.HeureEntree.ToShortTimeString(), p.HeureSortie.ToShortTimeString(), p.Duree, p.Valider, p.Supplementaire, false, true };
object_pointage.WriteDataGridView(value);
}
}
}
}
private void LoadPointage(Presence p)
{
try
{
string adresse = Constantes.SOCIETE.AdresseIp;
object_statut.SetValueBar(0);
Constantes.PBAR_WAIT = pbar_statut;
ObjectThread o = new ObjectThread(dgv_pointage);
o.ClearDataGridView(true);
string query = "select * from yvs_grh_pointage where presence = " + p.Id + " order by heure_entree, heure_sortie";
string queryCount = "select count(id) from yvs_grh_pointage where presence = " + p.Id + "";
pointages = PointageBLL.List(query, true, queryCount, adresse);
for (int i = 0; i < pointages.Count; i++)
{
o.WriteDataGridView(new object[] { pointages[i].Id, i + 1, pointages[i].HeureEntree.ToShortTimeString(), pointages[i].HeureSortie.ToShortTimeString(), Utils.GetTime(pointages[i].Duree), pointages[i].Valider, pointages[i].Supplementaire });
}
}
catch (Exception ex)
{
Messages.Exception("Form_Presence (LoadPointage)", ex);
}
}