private void LoadSociete(string groupe) { string query = "select y.id, y.name, y.adresse_ip, COALESCE(i.port, 0) AS port, i.users, i.password, i.domain, i.type_connexion, y.groupe, g.libelle " + "from yvs_societes y left join yvs_base_groupe_societe g on y.groupe = g.id left join yvs_societes_connexion i on i.societe = y.id "; if (groupe != null ? groupe.Trim().Length > 0 : false) { query += " where g.libelle = '" + groupe + "'"; } societes = SocieteBLL.List(query); try { cbox_societe.Items.Clear(); for (int i = 0; i < societes.Count; i++) { cbox_societe.Items.Add(societes[i].Name); cbox_societe.AutoCompleteCustomSource.Add(societes[i].Name); } cbox_societe.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbox_societe.AutoCompleteSource = AutoCompleteSource.CustomSource; } catch (Exception ex) { Messages.Exception("Form_Societe (LoadSociete)", ex); cbox_societe.Items.Clear(); } }
private void btn_save_Click(object sender, EventArgs e) { if (societe != null ? societe.Id > 0 : false) { string adresse = txt_adresse.Text; societe.AdresseIp = adresse; societe.TypeConnexion = cbox_type_connexion.SelectedItem.ToString(); societe.Users = txt_users.Text; societe.Domain = txt_domain.Text; societe.Password = txt_password.Text; societe.Port = Convert.ToInt32(txt_port.Value); if (SocieteBLL.Update(societe)) { if (start) { ask_ = true; Application.Restart(); return; } else { if (Constantes.SOCIETE.Id.Equals(societe.Id) ? SocieteBLL.CreateSociete(societe) : false) { Constantes.SOCIETE = societe; if (Constantes.FORM_PARENT != null) { Constantes.FORM_PARENT.LoadInfosSociete(); } } } } Messages.Succes(); } }
private void LoadCurrentSociete() { Societe s = SocieteBLL.ReturnSociete(); if (s != null ? s.Id > 0 : false) { cbox_societe.SelectedText = s.Name; societe = s; txt_name.Text = s.Name; txt_group.Text = s.Groupe != null ? s.Groupe.Libelle : ""; LoadAgence(s); } }
public void LoadPointeuse() { if (Constantes.POINTEUSES.Count < 1) { Societe s = SocieteBLL.ReturnSociete(); Constantes.POINTEUSES = PointeuseBLL.List("select * from yvs_pointeuse where societe = " + s.Id + " order by adresse_ip"); } dgv_pointeuse.Rows.Clear(); ObjectThread o = new ObjectThread(dgv_pointeuse); foreach (Pointeuse p in Constantes.POINTEUSES) { o.WriteDataGridView(new object[] { p.Id, p.Ip, p.Emplacement, p.Type }); } }
private void LoadCurrentSociete() { Societe s = SocieteBLL.ReturnSociete(); if (s != null ? s.Id > 0 : false) { cbox_societe.SelectedText = s.Name; societe = s; txt_name.Text = s.Name; txt_adresse.Text = s.AdresseIp; cbox_type_connexion.Text = s.TypeConnexion; txt_users.Text = s.Users; txt_domain.Text = s.Domain; txt_password.Text = s.Password; txt_port.Value = s.Port; } }
private void Loggin() { try { string query = "select id from yvs_users_agence where users = " + users.Id + " and agence = " + agence.Id; object author = Bll.LoadOneObject(query, null); users.Author = author != null?Convert.ToInt32(author.ToString()) : 0; if (UsersBLL.CreateUsers(users)) { societe = SocieteBLL.OneById(societe.Id); SocieteBLL.CreateSociete(societe); AgenceBLL.CreateAgence(agence); ask_ = true; Application.Restart(); } } catch (Exception ex) { Messages.Exception(ex); } }
private void btn_save_Click(object sender, EventArgs e) { if (societe != null ? societe.Id > 0 : false) { if (SocieteBLL.CreateSociete(societe)) { if (agence != null ? agence.Id > 0 : false) { AgenceBLL.CreateAgence(agence); } else { AgenceBLL.RemoveAgence(); } Constantes.SOCIETE = societe; Constantes.AGENCE = agence; if (DialogResult.Yes == Messages.Confirmation(Mots.Restart_Now.ToLower())) { Application.ExitThread(); Application.Restart(); } } } }
private void txt_login_Leave(object sender, EventArgs e) { try { ResetFiche(); Users u = Recopiew(); if (Utils.asString(u.Code)) { users = UsersBLL.OneByName(u.Code); if (users != null ? users.Id > 0 : false) { if (!users.Actif) { if (Messages.Erreur_Retry("Utilisateur Inactif") == System.Windows.Forms.DialogResult.Retry) { txt_login_Leave(sender, e); } return; } com_societe.Enabled = users.AccesMultiSociete; com_agence.Enabled = users.AccesMultiSociete; if (users.AccesMultiSociete) { if (users.SuperAdmin) { societes = SocieteBLL.List("select y.id, y.name, y.adresse_ip, COALESCE(i.port, 0) AS port, i.users, i.password, i.domain, i.type_connexion, y.groupe, g.libelle " + "from yvs_societes y left join yvs_societes_connexion i on i.societe = y.id left join yvs_base_groupe_societe g on y.groupe = g.id "); } else if (users.Agence.Societe.Groupe != null? users.Agence.Societe.Groupe.Id > 0:false) { societes = SocieteBLL.List("select y.id, y.name, y.adresse_ip, COALESCE(i.port, 0) AS port, i.users, i.password, i.domain, i.type_connexion, y.groupe, g.libelle " + "from yvs_societes y left join yvs_societes_connexion i on i.societe = y.id left join yvs_base_groupe_societe g on y.groupe = g.id where y.groupe = " + users.Agence.Societe.Groupe.Id); } else { societes.Add(users.Agence.Societe); } } else if (users.AccesMultiAgence) { societes.Add(users.Agence.Societe); } else { agence = users.Agence; societe = agence.Societe; societes.Add(societe); } if (societes.Count > 0) { LoadSociete(societes); } } else { if (Messages.Erreur_Retry("Utilisateur Incorrect") == System.Windows.Forms.DialogResult.Retry) { txt_login_Leave(sender, e); } } } else { Messages.ShowErreur("L'identifiant de l'utilisateur ne peut pas être null!"); } } catch (Exception ex) { Messages.Exception(ex); } }