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());
}
