/// <summary> /// Va chercher les users et leurs workcenter en db /// </summary> private void GetUser() { List <UserWorkCenter> UserWorkCenters = new List <UserWorkCenter>(); List <ADR_WorkCenterUser> WorkCenterUsers; using (WorkCenterUserRepository WorkCenterUserRepository = new WorkCenterUserRepository()) { WorkCenterUsers = WorkCenterUserRepository.Get().Where((u) => !u.IsDisabled).OrderBy((u) => u.UserId).ToList(); } foreach (ADR_WorkCenterUser item in WorkCenterUsers) { ADR_WorkCenter WorkCenter; using (WorkCenterRepository WorkCenterRepository = new WorkCenterRepository()) { WorkCenter = WorkCenterRepository.Get(item.WorkCenterId); } UserWorkCenters.Add(new UserWorkCenter() { UserId = item.Id, WorkCenterId = item.WorkCenterId, User = item.UserId, WorkCenter = WorkCenter.WorkCenter }); } olvUser.SetObjects(UserWorkCenters); }
/// <summary> /// Attribue les noms aux controlleurs depuis les fichiers ressources. /// </summary> private bool LoadControllerName() { using (WorkCenterUserRepository WorkCenterUserRepository = new WorkCenterUserRepository()) { ADRWorkCenterUser = WorkCenterUserRepository.GetByUserId(FormUser.UserID); } if (ADRWorkCenterUser != null) { if (!ADRWorkCenterUser.IsDisabled) { using (WorkCenterRepository WorkCenterRepository = new WorkCenterRepository()) { ADRWorkCenter = WorkCenterRepository.Get(ADRWorkCenterUser.WorkCenterId); } } else { return(false); } } string WorkCenter = ADRWorkCenter != null ? ADRWorkCenter.WorkCenter : "Pas de section"; tssUser.Text = $"{SynapseForm.FormUser.ToString()} / {WorkCenter}"; tssRole.Text = string.Empty; tssBlank.Text = " "; return(true); }
/// <summary> /// Sauvegarde le choix de la section /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, System.EventArgs e) { ADR_WorkCenter WorkCenter = (ADR_WorkCenter)cbWorkCenter.SelectedItem; bool IsInserted = false; bool IsUpdated = false; if (WorkCenterUser == null) { WorkCenterUser = new ADR_WorkCenterUser() { UserId = FormUser.UserID.ToUpper(), WorkCenterId = WorkCenter.Id }; using (WorkCenterUserRepository WorkCenterUserRepository = new WorkCenterUserRepository()) { IsInserted = WorkCenterUserRepository.Insert(WorkCenterUser); } GenerateHistorique.CreateHistorique(FormUser.UserID, "Choix du WorkCenter (Création de l'utilisateur)", WorkCenter.WorkCenter); } else { string Origine; using (WorkCenterRepository WorkCenterRepository = new WorkCenterRepository()) { Origine = WorkCenterRepository.Get(WorkCenter.Id).WorkCenter; } WorkCenterUser.WorkCenterId = WorkCenter.Id; using (WorkCenterUserRepository WorkCenterUserRepository = new WorkCenterUserRepository()) { IsUpdated = WorkCenterUserRepository.Update(WorkCenterUser); } if (IsUpdated) { GenerateHistorique.CreateHistorique(FormUser.UserID, "Choix du WorkCenter", Origine, WorkCenter.WorkCenter); } } ADR.tssUser.Text = $"{SynapseForm.FormUser.ToString()} / {WorkCenter.WorkCenter}"; ADR.ADRWorkCenter = WorkCenter; ADR.ADRWorkCenterUser = WorkCenterUser; if (IsInserted || IsUpdated) { this.Dispose(); } }
/// <summary> /// Va chercher les workcenters en db /// </summary> private void GetWorkCenter() { List <ADR_WorkCenter> WorkCenters = new List <ADR_WorkCenter>(); WorkCenters.Add(new ADR_WorkCenter() { Id = 0, WorkCenter = "" }); using (WorkCenterRepository WorkCenterRepository = new WorkCenterRepository()) { WorkCenters.AddRange(WorkCenterRepository.Get().Where((wk) => !wk.IsDisabled).OrderBy((wk) => wk.WorkCenter)); } cbWorkCenter.DataSource = WorkCenters; cbWorkCenter.DisplayMember = "WorkCenter"; cbWorkCenter.ValueMember = "Id"; }
/// <summary> /// Va chercher tout les workcenter présent en db et les ajoutes à la combobox /// </summary> private void GetWorkCenter() { lblName.Text = $"Bonjour {FormUser.ToString()}"; lblMessage.Text = "Merci de sélectionner une section."; List <ADR_WorkCenter> WorkCenters; using (WorkCenterRepository WorkCenterRepository = new WorkCenterRepository()) { WorkCenters = WorkCenterRepository.Get().ToList(); } cbWorkCenter.DataSource = WorkCenters; cbWorkCenter.DisplayMember = "WorkCenter"; cbWorkCenter.ValueMember = "Id"; if (WorkCenterUser != null) { cbWorkCenter.Text = WorkCenters.Where((wk) => wk.Id == WorkCenterUser.WorkCenterId).Select((wk) => wk.WorkCenter).FirstOrDefault(); } }