private void Education_FormationRecord_SelectCompetence(Education_Formation currentEducation_Formation) { if (currentEducation_Formation.Education_Competence != null) { comboBoxProvider.SelectedIndex = comboBoxProvider.FindStringExact(currentEducation_Formation.Education_Competence.Competence_Name); } }
public Education_FormationDossier SaveTestDoc(Education_Formation formation, string filePath) { Education_FormationDossier newRecord; var recordFound = db.Education_FormationDossier.Where(x => x.FormationDossier_Formation == formation.Formation_Id).FirstOrDefault(); if (recordFound == null) { newRecord = new Education_FormationDossier() { FormationDossier_Formation = formation.Formation_Id, FormationDossier_DateUpdate = DateTime.Now, FormationDossier_TestHyperLink = filePath, }; db.Education_FormationDossier.Add(newRecord); db.SaveChanges(); return(newRecord); } else { recordFound.FormationDossier_DateUpdate = DateTime.Now; recordFound.FormationDossier_TestHyperLink = filePath; //db.Education_FormationDossier.Add(recordFound); db.SaveChanges(); return(recordFound); } }
private void LoadFicheEducation_Formation(string Education_FormationSAPSelected) { //DeleteButtonSavingAgent(); TabPage page = (TabPage)this.tabControl_Education_Formations.Controls[1]; this.EnableTab(page, true); CurrentFormation = db.LoadSingleEducation_Formation(Education_FormationIDSelected); if (CurrentFormation != null) { Education_FormationRecord_FillLabels(CurrentFormation); Education_FormationRecord_FillLabelsActif(CurrentFormation); Education_FormationRecord_FillSAP(CurrentFormation); //Education_FormationRecord_FillAdmin(CurrentEducation_Formation); Education_FormationRecord_SelectCompetence(CurrentFormation); Education_FormationRecord_PickDateOfCreation(CurrentFormation); //Education_FormationRecord_PickDateOfEntry(CurrentEducation_Formation); //Education_FormationRecord_PickUser_DateSeniority(CurrentEducation_Formation); //Education_FormationRecord_PickDateFunction(CurrentEducation_Formation); Education_FormationRecord_FillRemarks(CurrentFormation); Education_FormationRecord_SelectDurationInDays(CurrentFormation); Education_FormationRecord_SelectMinCapacity(CurrentFormation); Education_FormationRecord_SelectMaxCapacity(CurrentFormation); //Education_FormationRecord_SelectRoleEPI(CurrentEducation_Formation); //Education_FormationRecord_SelectRoleAstreinte(userReCurrentEducation_Formationcord); //Education_FormationRecord_SelectEducation_Habilitation(CurrentEducation_Formation); //UserRecord_LoadEducation_FormationsOfUser(userRecord); CreateButtonSavingAgent(); } }
private void Education_FormationRecord_FillSAP(Education_Formation currentEducation_Formation) { if (CurrentFormation.Formation_SAP != null) { labelSAPEducation_Formation.Text = CurrentFormation.Formation_SAP; } }
private void Education_FormationRecord_PickDateOfCreation(Education_Formation currentEducation_Formation) { if (currentEducation_Formation.Formation_YearOfCreation != null) { txtYearOfCreation.Text = currentEducation_Formation.Formation_YearOfCreation.ToString(); } }
private void Education_FormationRecord_SelectMaxCapacity(Education_Formation currentEducation_Formation) { if (currentEducation_Formation.Formation_MinCapacity != null) { comboBoxMaxCapacity.SelectedIndex = comboBoxMaxCapacity .FindStringExact(currentEducation_Formation.Formation_MinCapacity.ToString()); } }
public void Education_FormationRecord_FillRemarks(Education_Formation currentEducation_Formation) { if (currentEducation_Formation.Formation_Remarks != null) { richTextBoxRemarks.Text = currentEducation_Formation.Formation_Remarks; } else { richTextBoxRemarks.Text = ""; } }
/// <summary> /// Adding new Education_Formation /// </summary> /// <param name="newEducation_Formation"></param> /// <returns> Newly added Education_Formation </returns> public Education_Formation AddEducation_Formation(Education_Formation newEducation_Formation) { var Education_FormationFromDB = db.Education_Formation.Where(x => x.Formation_SAP == newEducation_Formation.Formation_SAP).FirstOrDefault(); if (Education_FormationFromDB == null) { db.Education_Formation.Add(newEducation_Formation); db.SaveChangesAsync(); } return(newEducation_Formation); }
public async void SaveEducation_Formation(Education_Formation currentEducation_Formation) { if (currentEducation_Formation != null) { var Education_Formation = db.Education_Formation.Where(x => x.Formation_SAP == currentEducation_Formation.Formation_SAP).FirstOrDefault(); Education_Formation = currentEducation_Formation; await db.SaveChangesAsync(); } else { db.Education_Formation.Add(currentEducation_Formation); await db.SaveChangesAsync(); } }
public List <Education_Agent> LoadAllAgentsFiltered(Education_Formation Education_Formation) { List <Education_Agent> UserListFiltered = new List <Education_Agent>(); var userEducation_FormationList = db.Education_Agent_Formation.Where(x => x.AgentFormation_Formation == Education_Formation.Formation_Id).ToList(); if (userEducation_FormationList != null) { foreach (var userEducation_Formation in userEducation_FormationList) { var userTemp = db.Education_Agent.Where(y => y.Agent_Id == userEducation_Formation.AgentFormation_Agent).FirstOrDefault(); UserListFiltered.Add(userTemp); } } return(UserListFiltered); }
private void Education_FormationRecord_SelectDurationInDays(Education_Formation currentEducation_Formation) { if (currentEducation_Formation.Formation_DurationInDays != null) { var float_number = (decimal)currentEducation_Formation.Formation_DurationInDays; var result = float_number - Math.Truncate(float_number); int hours = (int)Math.Ceiling(8 * result); comboBoxDurationhours.SelectedIndex = comboBoxDurationhours .FindStringExact(hours.ToString()); int days = (int)Math.Truncate(float_number); comboBoxDurationInDays.SelectedIndex = comboBoxDurationInDays .FindStringExact(days.ToString()); } }
private void Education_FormationRecord_FillLabels(Education_Formation Education_FormationRecord) { if (Education_FormationRecord.Formation_ShortTitle != null) { tbShortTitleEducation_Formation.Text = Education_FormationRecord.Formation_ShortTitle; } if (Education_FormationRecord.Formation_LongTitle != null) { tbLongTitle.Text = Education_FormationRecord.Formation_LongTitle; } SizeF stringSize = ResizeTextBox(tbShortTitleEducation_Formation); this.tbShortTitleEducation_Formation.Width = (int)Math.Round(stringSize.Width, 0); stringSize = ResizeTextBox(tbLongTitle); this.tbLongTitle.Width = (int)Math.Round(stringSize.Width, 0); }
public async void SaveEducation_FormationAsync(Education_Formation currentEducation_Formation) { using (CFNEducation_FormationEntities dbSaveSet = new CFNEducation_FormationEntities()) { if (currentEducation_Formation != null) { var Education_Formation = dbSaveSet.Education_Formation.Where(x => x.Formation_SAP == currentEducation_Formation.Formation_SAP).FirstOrDefault(); Education_Formation = currentEducation_Formation; await dbSaveSet.SaveChangesAsync(); } else { dbSaveSet.Education_Formation.Add(currentEducation_Formation); await dbSaveSet.SaveChangesAsync(); } } }
private void SelectFormationEquiv(Education_Matrice_Agent currentMatriceAgent) { int rowIndex = -1; if (currentMatriceAgent.Education_Matrice_AgentEquivalence != null) { Education_Formation formation = dbFormation.LoadSingleEducation_Formation(currentMatriceAgent.Education_Matrice_AgentEquivalence.MatriceAgentEquivalence_Formation); DataGridViewRow row = l_PopUp.Rows .Cast <DataGridViewRow>() .Where(r => r.Cells["Formation_SAP"].Value.ToString().Equals(formation.Formation_SAP)) .First(); rowIndex = row.Index; this.l_PopUp.Rows[rowIndex].Selected = true; this.l_PopUp.CurrentCell = this.l_PopUp.Rows[rowIndex].Cells[0]; } }
/// <summary> /// Update an existing Education_Formation /// </summary> /// <param name="updatedEducation_Formation"></param> /// <returns> updated Education_Formation Education_Formation </returns> public Education_Formation UpdateEducation_Formation(Education_Formation updatedEducation_Formation) { var Education_FormationFromDB = db.Education_Formation.Where(x => x.Formation_SAP == updatedEducation_Formation.Formation_SAP).FirstOrDefault(); if (Education_FormationFromDB == null) { Education_FormationFromDB.Formation_IsInterne = updatedEducation_Formation.Formation_IsInterne; Education_FormationFromDB.Formation_AnnualOrders = updatedEducation_Formation.Formation_AnnualOrders; Education_FormationFromDB.Formation_DemandeDeDates = updatedEducation_Formation.Formation_DemandeDeDates; Education_FormationFromDB.Formation_DurationInDays = updatedEducation_Formation.Formation_DurationInDays; Education_FormationFromDB.Formation_LongTitle = updatedEducation_Formation.Formation_LongTitle; Education_FormationFromDB.Formation_MaxCapacity = updatedEducation_Formation.Formation_MaxCapacity; Education_FormationFromDB.Formation_MinCapacity = updatedEducation_Formation.Formation_MinCapacity; Education_FormationFromDB.Formation_OptimalCapacity = updatedEducation_Formation.Formation_OptimalCapacity; Education_FormationFromDB.Formation_Price = updatedEducation_Formation.Formation_Price; Education_FormationFromDB.Formation_ShortTitle = updatedEducation_Formation.Formation_ShortTitle; Education_FormationFromDB.Formation_YearOfCreation = updatedEducation_Formation.Formation_YearOfCreation; db.SaveChangesAsync(); } return(Education_FormationFromDB); }
public Education_FormationDossier LoadInfoFiche(Education_Formation formation) { return(db.Education_FormationDossier .Where(x => x.FormationDossier_Formation == formation.Formation_Id) .FirstOrDefault()); }
public MyColumnCollectionFrmFormation(Education_Formation obj) { _obj = obj; }
public List<Education_FormationResultat> LoadAllResultatByFormation(Education_Formation formation) { return db.Education_FormationResultat .Where(x => x.FormationResultat_Formation == formation.Formation_Id) .ToList(); }
private void Education_FormationRecord_FillLabelsActif(Education_Formation currentEducation_Formation) { }
public Education_FormationSession LoadAllSessionUniteOfFormationByYear(Education_Formation formation, int year) { return(db.Education_FormationSession .Where(x => x.FormationSession_Formation == formation.Formation_Id && x.FormationSession_Year == year).FirstOrDefault()); }
public List <Education_FormationProvider> LoadFormationProviderByFormation(Education_Formation formation) { return(db.Education_FormationProvider .Where(x => x.FormationProvider_Formation == formation.Formation_Id) .ToList()); }