/// <summary>
/// Loads the projets.
/// </summary>
private void LoadProjets()
{
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
// Query for all blogs with names starting with B
var projet = (from b in context.Projets
orderby b.DateDuMariage
select b).ToList();
ObservableCollection<ProjetAmelio> projs2 = new ObservableCollection<ProjetAmelio>();
projet.ForEach(x => projs2.Add(new ProjetAmelio(x)));
this.SetValue(ProjetsPage.DataListProperty, projs2);
}
}
public NewComposant(int idComposant)
{
InitializeComponent();
if (idComposant > -1)
{
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
// Query for all blogs with names starting with B
var composant = (from b in context.Composants
where b.IdComposant == idComposant
select b).FirstOrDefault();
LayoutRoot.DataContext = composant;
}
}
}
public NewProject(int idProjet)
{
this.InitializeComponent();
expand.Visibility = System.Windows.Visibility.Visible;
if (idProjet > -1)
{
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
// Query for all blogs with names starting with B
var projet = (from b in context.Projets
where b.IdProjet == idProjet
select b).FirstOrDefault();
LayoutRoot.DataContext = new ProjetAmelio(projet);
}
}
else
{
expand.IsExpanded = true;
LayoutRoot.DataContext = new ProjetAmelio();
}
}
private void Button_save_Click(object sender, RoutedEventArgs e)
{
//string saveFolderpath = @".\ContactImages\";
string filepath = tbPathImage.Text;
//FileInfo fi = new FileInfo(filepath);
//string finename = Guid.NewGuid().ToString() + fi.Extension;
//if (!Directory.Exists(saveFolderpath))
//{
// Directory.CreateDirectory(saveFolderpath);
//}
//System.IO.File.Copy(filepath, saveFolderpath + finename, true);
imgSrc.Source = null;
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
Composant compo = new Composant();
//if (idProjet.Text != string.Empty)
//{
// long idProj = long.Parse(idProjet.Text);
// projet = (from b in context.Projets
// where b.IdProjet == idProj
// select b).FirstOrDefault();
//}
//else
//{
context.Composants.Add(compo);
//}
compo.Nom = tbName.Text;
compo.Note = tbNote.Text;
compo.UrlPhoto = "urlPicture";
compo.Image = ConvertImage(filepath);
context.SaveChanges();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Projet projet = new Projet();
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
if (idProjet.Text != string.Empty)
{
long idProj = long.Parse(idProjet.Text);
projet = (from b in context.Projets
where b.IdProjet == idProj
select b).FirstOrDefault();
}
else
{
context.Projets.Add(projet);
}
projet.Civilite1 = long.Parse(CbCivi1.SelectedValue.ToString());
projet.Nom1 = nom1.Text;
projet.Prenom1 = prenom1.Text;
projet.Civilite2 = long.Parse(CbCivi2.SelectedValue.ToString());
projet.Nom2 = nom2.Text;
projet.Prenom2 = prenom2.Text;
projet.Telephone = telephone.Text;
projet.Ville = ville.Text;
projet.Email = email.Text;
projet.Adresse = adresse.Text;
projet.CodePostal = codepostal.Text;
projet.Budget = long.Parse(budget.Text);
projet.DateDuMariage = DateTime.Parse(dateDuMarriage.Text);
context.SaveChanges();
}
expand.IsExpanded = false;
}
/// <summary>
/// Loads the composants.
/// </summary>
private void LoadComposants()
{
using (var context = new AVosSouhaits.AVSouhaitsDBEntities())
{
DateTime now = DateTime.Now;
ObservableCollection<LineOfComponent> linesOfComponent = new ObservableCollection<LineOfComponent>();
// Query for all blogs with names starting with B
var compos = (from b in context.Composants
orderby b.Nom
select b).ToList();
Parallel.For(0, compos.Count / 4, i =>
{
int value = i * 4;
LineOfComponent line = new LineOfComponent();
line.compo1 = compos[value];
if (value + 1 < compos.Count)
{
line.compo2 = compos[value + 1];
}
if (value + 2 < compos.Count)
{
line.compo3 = compos[value + 2];
}
if (value + 3 < compos.Count)
{
line.compo4 = compos[value + 3];
}
linesOfComponent.Add(line);
});
TimeSpan ts = DateTime.Now - now;
this.SetValue(Administration.DataListProperty, linesOfComponent);
}
}
