public static bool updatePhotoUsers(Users f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string path = "";
if (!(f.Photo == null || f.Photo.Trim().Equals("")))
{
path = f.Photo;
f.Photo = Utils.milliseconds() + Path.GetExtension(path);
}
string delete = "update users set photo = '" + f.Photo + "' where id = " + f.Id;
NpgsqlCommand cmd = new NpgsqlCommand(delete, con);
cmd.ExecuteNonQuery();
if (!(path == null || path.Trim().Equals("")))
{
string chemin = Chemins.getCheminUsers(f.Id.ToString()) + f.Photo;
System.IO.File.Copy(path, chemin, true);
}
return(true);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
private void btn_connecter_Click(object sender, EventArgs e)
{
try
{
if (ConnectLog())
{
timer1.Stop();
timer2.Stop();
this.Close();
Form_Parent f_parent = new Form_Parent();
if (Constantes.f_parent == null)
{
f_parent.Show();
Constantes.f_parent = f_parent;
}
else
{
Constantes.f_parent.InitializeComponent();
Constantes.f_parent.Show();
}
if (Constantes.users != null)
{
Acces.LoadAcces(Constantes.users.Niveau);
Constantes.f_parent.txt_users.Text = Constantes.users.Prenom + " " + Constantes.users.Nom;
if (!(Constantes.users.Photo == null || Constantes.users.Photo.Trim().Equals("")))
{
string chemin = Chemins.getCheminUsers(Constantes.users.Id.ToString());
if (System.IO.File.Exists(chemin + Constantes.users.Photo))
{
Constantes.f_parent.box_users.Image = Image.FromFile(chemin + Constantes.users.Photo);
return;
}
}
}
Constantes.f_parent.box_users.Image.Dispose();
Constantes.f_parent.box_users.Image = global::CATALOGUE_ARTICLE.Properties.Resources.contact;
}
}
catch (Exception ex)
{
Messages.Exception(ex);
}
}
private void box_photo_DoubleClick(object sender, EventArgs e)
{
bool add = (bool)(((PictureBox)sender).Tag);
if (!add)
{
OpenFileDialog file = new OpenFileDialog();
file.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
file.Filter = "Fichiers jpg (*.jpg)|*.jpg|Fichiers png (*.png)|*.png|Fichiers bmp (*.bmp)|*.bmp|Tous les images (*.*)|*.jpg;*.png;*.bmp";
if (file.ShowDialog(this) == DialogResult.OK)
{
string path = file.FileName;
if (path != null ? !path.Trim().Equals("") : false)
{
current.Photo = path;
if (current != null ? current.Id > 0 : false)
{
if (DialogResult.Yes == Messages.Confirmation(Mots.Enregistrer))
{
if (UsersBLL.UpdatePhoto(current))
{
var t = current.Photo;
box_photo.Image = Image.FromFile(Chemins.getCheminUsers(current.Id.ToString()) + current.Photo);
box_photo.Tag = true;
lk_box_photo.Visible = true;
Messages.Succes();
}
}
}
else
{
box_photo.Image = Image.FromFile(current.Photo);
}
}
}
}
else
{
Messages.Information(Mots.Msg_Photo_exist);
}
}
private void LoadPhoto(Users u)
{
if (u != null ? u.Id > 0 : false)
{
if (!(u.Photo == null || u.Photo.Trim().Equals("")))
{
string chemin = Chemins.getCheminUsers(u.Id.ToString());
if (System.IO.File.Exists(chemin + u.Photo))
{
box_photo.Image = Image.FromFile(chemin + u.Photo);
box_photo.Tag = true;
lk_box_photo.Visible = true;
return;
}
}
}
box_photo.Image.Dispose();
box_photo.Image = global::CATALOGUE_ARTICLE.Properties.Resources.ajouter;
box_photo.Tag = false;
lk_box_photo.Visible = false;
}
public static Users saveUsers(Users f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string path = "";
if (!(f.Photo == null || f.Photo.Trim().Equals("")))
{
path = f.Photo;
f.Photo = Utils.milliseconds() + Path.GetExtension(path);
}
string insert = "insert into users (nom, prenom, identifiant, mot_passe, photo, actif, niveau) values " +
"('" + f.Nom + "','" + f.Prenom + "','" + f.Identifiant + "','" + f.Password + "','" + f.Photo + "','" + f.Actif + "'," + f.Niveau.Id + ")";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
f.Id = currentUsers(f);
if (!(path == null || path.Trim().Equals("")))
{
string chemin = Chemins.getCheminUsers(f.Id.ToString()) + f.Photo;
System.IO.File.Copy(path, chemin, true);
}
return(f);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}