public static List<Users> getListUsers(String query) { NpgsqlConnection con = Connexion.Connection(); try { List<Users> l = new List<Users>(); NpgsqlCommand Lcmd = new NpgsqlCommand(query, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); if (lect.HasRows) { while (lect.Read()) { Users a = new Users(); a.Admin = false; l.Add(a); } lect.Close(); } return l; } catch (NpgsqlException e) { Messages.Exception(e); return null; } finally { Connexion.Deconnection(con); } }
public static Personnel One(Users users) { try { return PersonnelDao.getOnePersonnel(users); } catch (Exception ex) { throw new Exception("Impossible d'atteindre l'enregistrement", ex); } }
public static Users getAjoutUsers(Users 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); } }
public bool correct(Users users) { if (users.codeUsers == null || users.codeUsers.Trim().Equals("")) { Messages.ShowErreur("Le code ne peut pas être null!"); return false; } if (users.password == null || users.password.Trim().Equals("")) { Messages.ShowErreur("Le mot de passe ne peut pas être null!"); return false; } return true; }
private Users RecopiewView() { Users u = new Users(); u.CodeUsers = txt_email.Text.Trim(); u.Password = txt_pwd.Text.Trim(); return u; }
public static Users getOneUsers(long id) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from yvs_users where id = " + id + ""; NpgsqlCommand Lcmd = new NpgsqlCommand(search, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); Users a = new Users(); if (lect.HasRows) { while (lect.Read()) { a.Id = Convert.ToInt64(lect["id"].ToString()); a.Civilite = lect["civilite"].ToString().Trim(); a.NomUser = lect["nom_users"].ToString().Trim(); a.CodeUsers = lect["code_users"].ToString().Trim(); a.Password = lect["password_user"].ToString().Trim(); a.Photo = lect["photo"].ToString().Trim(); a.Actif = Convert.ToBoolean((lect["actif"].ToString() != null) ? (!lect["actif"].ToString().Trim().Equals("") ? lect["actif"].ToString().Trim() : "false") : "false"); a.Connected = Convert.ToBoolean((lect["connecte"].ToString() != null) ? (!lect["connecte"].ToString().Trim().Equals("") ? lect["connecte"].ToString().Trim() : "false") : "false"); a.Agence = (lect["agence"] != null ? (!lect["agence"].ToString().Trim().Equals("") ? BLL.AgenceBll.One(Convert.ToInt32(lect["agence"].ToString())) : new Agence()) : new Agence()); a.Admin = false; } lect.Close(); } return a; } catch (NpgsqlException e) { Messages.Exception(e); return null; } finally { Connexion.Deconnection(con); } }
public static bool getUpdateUsers(Users 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); } }
public UsersBll(Users unUsers) { users = unUsers; }
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); } }