public static Pointage getOneById(int id, bool full)
{
Pointage bean = new Pointage();
NpgsqlConnection connect = new Connexion().Connection();
try
{
string query = "select * from yvs_grh_pointage where id =" + id + ";";
NpgsqlCommand Lcmd = new NpgsqlCommand(query, connect);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
bean = Return(lect, full);
}
}
return(bean);
}
catch (Exception ex)
{
Messages.Exception("PointageDao (getOneById)", ex);
return(bean);
}
finally
{
Connexion.Close(connect);
}
}
public bool getInsert_N(Pointage bean)
{
NpgsqlConnection connect = new Connexion().Connection();
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, author) values (null, null, false," + bean.Presence.Id + ",null,null," + (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);
}
}
private void dgv_pointage_MouseDown(object sender, MouseEventArgs e)
{
DataGridView.HitTestInfo info = dgv_pointage.HitTest(e.X, e.Y); //get info
int pos = dgv_pointage.HitTest(e.X, e.Y).RowIndex;
if (pos > -1)
{
if (dgv_pointage.Rows[pos].Cells[0].Value != null)
{
Int64 id = (Int64)dgv_pointage.Rows[pos].Cells[0].Value;
if (id > 0)
{
Pointage f = pointages.Find(x => x.Id == id);
switch (e.Button)
{
case MouseButtons.Right:
{
ResetPointage();
dgv_pointage.Rows[pos].Selected = true; //Select the row
}
break;
default:
break;
}
}
}
}
}
public static bool Update(Pointage bean, long id, string adresse)
{
try
{
return(PointageDAO.getUpdate(bean, id, adresse));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool InsertU(Pointage bean, string adresse)
{
try
{
return(PointageDAO.getInsert_U(bean, adresse));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool getInsert(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, valider, presence, date_save_entree, pointeuse_in, date_save_sortie, system_in, heure_supplementaire, author) values ";
if (bean.PointeuseIn != null ? bean.PointeuseIn.Id > 0 : false)
{
if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "',false ," + bean.Presence.Id + ",'" + bean.HeureEntree + "'," + bean.PointeuseIn.Id + ", null, '" + bean.SystemIn + "', '" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + ")";
}
else
{
query += "(null, false ," + bean.Presence.Id + ", null," + bean.PointeuseIn.Id + ", null, '" + bean.SystemIn + "', '" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + ")";
}
}
else
{
if (bean._HeureEntree() != null)
{
query += "('" + bean.HeureEntree + "', false," + bean.Presence.Id + ",'" + bean.HeureEntree + "', null, null, '" + bean.SystemIn + "', '" + bean.Supplementaire + "'," + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + ")";
}
else
{
query += "(null, false ," + bean.Presence.Id + ", null, null, null, '" + bean.SystemIn + "', '" + 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);
}
}
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);
}
}
private static Pointage Return(NpgsqlDataReader lect, bool full)
{
Pointage bean = new Pointage();
bean.Id = Convert.ToInt32(lect["id"].ToString());
if ((lect["heure_entree"] != null) ? lect["heure_entree"].ToString() != "" : false)
{
bean.HeureEntree = Convert.ToDateTime(lect["heure_entree"].ToString());
}
if ((lect["heure_sortie"] != null) ? lect["heure_sortie"].ToString() != "" : false)
{
bean.HeureSortie = Convert.ToDateTime(lect["heure_sortie"].ToString());
}
bean.Valider = Convert.ToBoolean((lect["valider"].ToString() != "") ? lect["valider"].ToString() : "false");
bean.Supplementaire = Convert.ToBoolean((lect["heure_supplementaire"].ToString() != "") ? lect["heure_supplementaire"].ToString() : "false");
bean.Presence = new Presence(Convert.ToInt32(lect["presence"].ToString()));
bean.SystemIn = (Boolean)((lect["system_in"] != null) ? (!lect["system_in"].ToString().Trim().Equals("") ? lect["system_in"] : false) : false);
bean.SystemOut = (Boolean)((lect["system_out"] != null) ? (!lect["system_out"].ToString().Trim().Equals("") ? lect["system_out"] : false) : false);
if (full)
{
bean.Presence = PresenceDAO.getOneById(Convert.ToInt32(lect["presence"].ToString()), false);
}
if ((lect["pointeuse_in"] != null) ? lect["pointeuse_in"].ToString() != "" : false)
{
bean.PointeuseIn = new Pointeuse(Convert.ToInt32(lect["pointeuse_in"].ToString()));
if (full)
{
bean.PointeuseIn = PointeuseDAO.getOneById(Convert.ToInt32(lect["pointeuse_in"].ToString()));
}
}
if ((lect["pointeuse_out"] != null) ? lect["pointeuse_out"].ToString() != "" : false)
{
bean.PointeuseOut = new Pointeuse(Convert.ToInt32(lect["pointeuse_out"].ToString()));
if (full)
{
bean.PointeuseOut = PointeuseDAO.getOneById(Convert.ToInt32(lect["pointeuse_out"].ToString()));
}
}
return(bean);
}
private void dgv_pointage_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewCell cell = this.dgv_pointage.Rows[e.RowIndex].Cells[0];
Pointage po = PointageBLL.OneById(Convert.ToInt32(cell.Value));
if ((e.ColumnIndex == this.dgv_pointage.Columns["heure_sortie"].Index) && e.Value != null)
{
cell = this.dgv_pointage.Rows[e.RowIndex].Cells[e.ColumnIndex];
if ((po.HeureSortie != null) ? po.HeureSortie.ToString() != "01/01/0001 00:00:00" : false)
{
cell.ToolTipText = po.HeureSortie.ToString();
}
}
else if ((e.ColumnIndex == this.dgv_pointage.Columns["heure_entree"].Index) && e.Value != null)
{
cell = this.dgv_pointage.Rows[e.RowIndex].Cells[e.ColumnIndex];
if ((po.HeureEntree != null) ? po.HeureEntree.ToString() != "01/01/0001 00:00:00" : false)
{
cell.ToolTipText = po.HeureEntree.ToString();
}
}
}
public async Task <IActionResult> BenevoleEditOrCreate(int id, [FromBody][Bind("BenevoleID,Date,NbDemiJournees")] Pointage pointage)
{
if (id != pointage.BenevoleID)
{
return(BadRequest("id does not match BenevoleId"));
}
var existing = _context.Pointages
.Where(p => p.BenevoleID == pointage.BenevoleID && p.Date == pointage.Date.Date)
.SingleOrDefault();
if (existing != null)
{
pointage.ID = existing.ID;
}
var benevole = _context.Benevoles.Include(b => b.Adresses).SingleOrDefault(b => b.ID == pointage.BenevoleID);
var adresse = benevole.GetAdresseFromDate(pointage.Date);
var centreId = adresse.CentreID;
pointage.AdresseID = adresse.ID;
if (existing != null && existing.AdresseID != pointage.AdresseID)
{
return(BadRequest("AdresseID does not match with existing pointage"));
}
var userCentreId = GetCurrentUser().CentreID;
if (userCentreId != null && centreId != userCentreId)
{
return(Forbid());
}
if (ModelState.IsValid)
{
try
{
bool created = false;
if (existing != null)
{
existing.NbDemiJournees = pointage.NbDemiJournees;
_context.Update(existing);
}
else
{
created = true;
_context.Pointages.Add(pointage);
}
await _context.SaveChangesAsync();
if (created)
{
LogInfo("Pointage créé au {DatePointage:dd/MM/yyyy} pour le benevole #{BenevoleID} sur l'adresse {AdresseID}", pointage.Date, pointage.BenevoleID, pointage.AdresseID);
}
else
{
LogInfo("Pointage modifié au {DatePointage:dd/MM/yyyy} pour le benevole #{BenevoleID} sur l'adresse {AdresseID}", pointage.Date, pointage.BenevoleID, pointage.AdresseID);
}
}
catch (DbUpdateConcurrencyException)
{
if (!PointageExists(pointage.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(Json(new { id = pointage.ID }));
}
return(View(pointage));
}
