public static bool getUpdate(Pointage bean, long id, string adresse)
{
NpgsqlConnection connect = new Connexion().Connection(adresse);
try
{
string query = "update yvs_grh_pointage set ";
if (bean.PointeuseOut != null ? bean.PointeuseOut.Id > 0 : false)
{
if (bean._HeureSortie() != null)
{
query += "valider = " + bean.Valider + " , horaire_normale = " + bean.Valider + " , heure_sortie ='" + bean.HeureSortie + "', date_save_sortie ='" + bean.HeureSortie + "', pointeuse_out =" + bean.PointeuseOut.Id + ", system_out = '" + bean.SystemOut + "'";
}
else
{
query += "valider = " + bean.Valider + " , horaire_normale = " + bean.Valider + " , pointeuse_out =" + bean.PointeuseOut.Id + ", system_out = '" + bean.SystemOut + "'";
}
}
else
{
if (bean._HeureSortie() != null)
{
query += "valider = " + bean.Valider + " , horaire_normale = " + bean.Valider + " , heure_sortie ='" + bean.HeureSortie + "', date_save_sortie ='" + bean.HeureSortie + "', system_out = '" + bean.SystemOut + "'";
}
else
{
query += "valider = " + bean.Valider + " , horaire_normale = " + bean.Valider + " , system_out = '" + bean.SystemOut + "'";
}
}
query += " where id = " + id;
NpgsqlCommand cmd = new NpgsqlCommand(query, connect);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
Messages.Exception("PointageDao (getUpdate)", ex);
return(false);
}
finally
{
Connexion.Close(connect);
}
}
public static bool getInsert_U(Pointage bean, string adresse)
{
NpgsqlConnection connect = new Connexion().Connection(adresse);
try
{
if (bean.Presence != null ? bean.Presence.Id > 0 : false)
{
string query = "insert into yvs_grh_pointage(heure_entree, heure_sortie, valider, presence, date_save_entree, date_save_sortie, pointeuse_out, pointeuse_in, horaire_normale, system_in, system_out, heure_supplementaire, author) values ";
if ((bean.PointeuseIn != null ? bean.PointeuseIn.Id > 0 : false) && (bean.PointeuseOut != null ? bean.PointeuseOut.Id > 0 : false))
{
if (bean._HeureEntree() != null && bean._HeureSortie() != null)
{
query += "('" + bean.HeureEntree + "','" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "','" + bean.HeureSortie + "'," + bean.PointeuseOut.Id + "," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "', null, " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "',null," + bean.PointeuseOut.Id + "," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureSortie() != null)
{
query += "(null,'" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ", null,'" + bean.HeureSortie + "'," + bean.PointeuseOut.Id + "," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else
{
query += "(null, null, " + bean.Valider + "," + bean.Presence.Id + ", null, null," + bean.PointeuseOut.Id + "," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
}
else if (bean.PointeuseIn != null ? bean.PointeuseIn.Id > 0 : false)
{
if (bean._HeureEntree() != null && bean._HeureSortie() != null)
{
query += "('" + bean.HeureEntree + "','" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "','" + bean.HeureSortie + "', null," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "', null, " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "', null, null," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureSortie() != null)
{
query += "(null,'" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ", null,'" + bean.HeureSortie + "', null," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else
{
query += "(null, null, " + bean.Valider + "," + bean.Presence.Id + ", null, null, null," + bean.PointeuseIn.Id + ", " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "')";
}
}
else if (bean.PointeuseOut != null ? bean.PointeuseOut.Id > 0 : false)
{
if (bean._HeureEntree() != null && bean._HeureSortie() != null)
{
query += "('" + bean.HeureEntree + "','" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "','" + bean.HeureSortie + "'," + bean.PointeuseOut.Id + ", null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "', null, " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "', null," + bean.PointeuseOut.Id + ", null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureSortie() != null)
{
query += "(null,'" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ", null,'" + bean.HeureSortie + "'," + bean.PointeuseOut.Id + ", null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else
{
query += "(null, null, " + bean.Valider + "," + bean.Presence.Id + ", null, null," + bean.PointeuseOut.Id + ", null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
}
else
{
if (bean._HeureEntree() != null && bean._HeureSortie() != null)
{
query += "('" + bean.HeureEntree + "','" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "','" + bean.HeureSortie + "', null, null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "', null, " + bean.Valider + "," + bean.Presence.Id + ",'" + bean.HeureEntree + "', null, null, null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else if (bean._HeureSortie() != null)
{
query += "(null,'" + bean.HeureSortie + "', " + bean.Valider + "," + bean.Presence.Id + ", null,'" + bean.HeureSortie + "', null, null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
else
{
query += "(null, null, " + bean.Valider + "," + bean.Presence.Id + ", null, null, null, null, " + bean.Valider + ", '" + bean.SystemIn + "','" + bean.SystemOut + "','" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + " )";
}
}
NpgsqlCommand cmd = new NpgsqlCommand(query, connect);
cmd.ExecuteNonQuery();
return(true);
}
return(false);
}
catch (Exception ex)
{
Messages.Exception("PointageDao (getInsert)", ex);
return(false);
}
finally
{
Connexion.Close(connect);
}
}
