예제 #1
0
 public static Creneau One(Personnel pers)
 {
     try
     {
         return CreneauDao.getOneCreneau(pers);
     }
     catch (Exception ex)
     {
         throw new Exception("Impossible d'atteindre l'enregistrement", ex);
     }
 }
예제 #2
0
 public static Personnel getAjoutPersonnel(Personnel a)
 {
     NpgsqlConnection con = Connexion.Connection();
     try
     {
         string insert = "";
         NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
         cmd.ExecuteNonQuery();
         a.Id = getCurrent();
         return a;
     }
     catch
     {
         return null;
     }
     finally
     {
         Connexion.Deconnection(con);
     }
 }
예제 #3
0
 public static List<Personnel> getListPersonnel(String query)
 {
     NpgsqlConnection con = Connexion.Connection();
     try
     {
         List<Personnel> l = new List<Personnel>();
         NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
         NpgsqlDataReader lect = Lcmd.ExecuteReader();
         if (lect.HasRows)
         {
             while (lect.Read())
             {
                 Personnel a = new Personnel();
                 a.Id = Convert.ToInt64(lect["id"].ToString());
                 a.Users = (lect["users"] != null
                     ? (!lect["users"].ToString().Trim().Equals("")
                     ? BLL.UsersBll.One(Convert.ToInt64(lect["users"].ToString()))
                     : new Users())
                     : new Users());
                 a.Commission = (lect["plan_commission"] != null
                     ? (!lect["plan_commission"].ToString().Trim().Equals("")
                     ? BLL.PlanCommissionBll.One(Convert.ToInt64(lect["plan_commission"].ToString()))
                     : new PlanCommission())
                     : new PlanCommission());
                 a.Update = true;
                 l.Add(a);
             }
             lect.Close();
         }
         return l;
     }
     catch (NpgsqlException e)
     {
         Messages.Exception(e);
         return null;
     }
     finally
     {
         Connexion.Deconnection(con);
     }
 }
예제 #4
0
 public static Creneau getOneCreneau(Personnel pers, DateTime date, DateTime heureDebut, DateTime heureFin)
 {
     NpgsqlConnection con = Connexion.Connection();
     try
     {
         String search = "select c.id as id, c.date_travail as date_travail, c.users as users, c.actif actif, h.depot as depot, h.type as type"
             + " from yvs_com_creneau_horaire_users c "
             + " inner join yvs_com_creneau_horaire h on c.creneau = h.id"
             + " inner join yvs_com_type_creneau_horaire t on h.type = t.id"
             + " where c.users = " + pers.Id + " and c.date_travail ='" + date + "' and t.heure_debut = '" + heureDebut + "' and t.heure_fin = '" + heureFin + "'";
         NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
         NpgsqlDataReader lect = Lcmd.ExecuteReader();
         Creneau a = new Creneau();
         if (lect.HasRows)
         {
             while (lect.Read())
             {
                 a.Id = Convert.ToInt64(lect["id"].ToString());
                 a.Actif = Convert.ToBoolean((lect["actif"] != null) ? (!lect["actif"].ToString().Trim().Equals("") ? lect["actif"].ToString().Trim() : "false") : "false");
                 a.DateTravail = (DateTime)((lect["date_travail"] != null) ? (!lect["date_travail"].ToString().Trim().Equals("") ? lect["date_travail"] : DateTime.Now) : DateTime.Now);
                 a.Personnel = (lect["users"] != null
                     ? (!lect["users"].ToString().Trim().Equals("")
                     ? BLL.PersonnelBll.One(Convert.ToInt64(lect["users"].ToString()))
                     : new Personnel())
                     : new Personnel());
                 a.Depot = (lect["depot"] != null
                     ? (!lect["depot"].ToString().Trim().Equals("")
                     ? BLL.DepotBll.One(Convert.ToInt64(lect["depot"].ToString()))
                     : new Depot())
                     : new Depot());
                 a.Tranche = (lect["type"] != null
                     ? (!lect["type"].ToString().Trim().Equals("")
                     ? BLL.TrancheHoraireBll.One(Convert.ToInt64(lect["type"].ToString()))
                     : new TrancheHoraire())
                     : new TrancheHoraire());
                 a.Update = true;
             }
             lect.Close();
         }
         return a;
     }
     catch (NpgsqlException e)
     {
         Messages.Exception(e);
         return null;
     }
     finally
     {
         Connexion.Deconnection(con);
     }
 }
예제 #5
0
 public static Creneau getOneCreneau(Personnel pers)
 {
     return getOneCreneau(pers, DateTime.Now);
 }
예제 #6
0
 public static bool getUpdatePersonnel(Personnel a)
 {
     NpgsqlConnection con = Connexion.Connection();
     try
     {
         string update = "";
         NpgsqlCommand Ucmd = new NpgsqlCommand(update, con);
         Ucmd.ExecuteNonQuery();
         return true;
     }
     catch (Exception e)
     {
         Messages.Exception(e);
         return false;
     }
     finally
     {
         Connexion.Deconnection(con);
     }
 }
예제 #7
0
 public static Personnel getOnePersonnel(Users users)
 {
     NpgsqlConnection con = Connexion.Connection();
     try
     {
         String search = "select * from yvs_com_personnel where users = " + users.Id + " limit 1";
         NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
         NpgsqlDataReader lect = Lcmd.ExecuteReader();
         Personnel a = new Personnel();
         if (lect.HasRows)
         {
             while (lect.Read())
             {
                 a.Id = Convert.ToInt64(lect["id"].ToString());
                 a.Users = (lect["users"] != null
                     ? (!lect["users"].ToString().Trim().Equals("")
                     ? BLL.UsersBll.One(Convert.ToInt64(lect["users"].ToString()))
                     : new Users())
                     : new Users());
                 a.Commission = (lect["plan_commission"] != null
                     ? (!lect["plan_commission"].ToString().Trim().Equals("")
                     ? BLL.PlanCommissionBll.One(Convert.ToInt64(lect["plan_commission"].ToString()))
                     : new PlanCommission())
                     : new PlanCommission());
                 a.Update = true;
             }
             lect.Close();
         }
         return a;
     }
     catch (NpgsqlException e)
     {
         Messages.Exception(e);
         return null;
     }
     finally
     {
         Connexion.Deconnection(con);
     }
 }
예제 #8
0
 public static Creneau One(Personnel pers, DateTime date, DateTime heureDebut, DateTime heureFin)
 {
     try
     {
         return CreneauDao.getOneCreneau(pers, date, heureDebut, heureFin);
     }
     catch (Exception ex)
     {
         throw new Exception("Impossible d'atteindre l'enregistrement", ex);
     }
 }
예제 #9
0
 public PersonnelBll(Personnel unPersonnel)
 {
     personnel = unPersonnel;
 }