public static void DeleteReleve(BusinessReleve businessReleve)
{
dataReportEntities ctx = new dataReportEntities();
var LigneReleveRecupere = ctx.ligneReleve.Include("releve").Where(l => l.releveID == businessReleve.IdReleve).ToList();
ctx.ligneReleve.RemoveRange(LigneReleveRecupere);
ctx.releve.Remove(ctx.releve.Where(r => r.idReleve == businessReleve.IdReleve).FirstOrDefault());
ctx.SaveChanges();
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSupprimerReleve(object sender, RoutedEventArgs e)
{
BusinessReleve releveARetirer = gridReleve.SelectedItem as BusinessReleve;
MessageBoxResult messageBoxResult = MessageBox.Show("Voulez-vous supprimer le revelé selectionné?", "Supprimer ?", MessageBoxButton.YesNoCancel, MessageBoxImage.Question);
if (releveARetirer != null)
{
if (messageBoxResult == MessageBoxResult.Yes)
{
ServiceReleve.DeleteReleve(releveARetirer);
}
gridLigneReleve.ItemsSource = null;
gridReleve.ItemsSource = ServiceReleve.GetReleveByCapteurId(releveARetirer.CapteurID);
}
}
public static BusinessReleve AddReleve(BusinessReleve businessReleve)
{
dataReportEntities ctx = new dataReportEntities();
var releve = new releve
{
capteurID = businessReleve.CapteurID,
dateReleve = DateTime.Now
};
ctx.releve.Add(releve);
ctx.SaveChanges();
businessReleve.IdReleve = releve.idReleve;
return(businessReleve);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveReleveToBDD(object sender, RoutedEventArgs e)
{
if (gridCapteur.SelectedItem == null)
{
MessageBox.Show("Veuillez choisir un capteur");
return;
}
BusinessReleve businessReleve = new BusinessReleve
{
CapteurID = ((BusinessCapteur)gridCapteur.SelectedItem).IdCapteur,
};
ServiceReleve.AddReleve(businessReleve);
List <BusinessLigneReleve> lignesReleve = new List <BusinessLigneReleve>();
foreach (var item in listBoxReleve.Items)
{
string[] list = Regex.Split(item.ToString(), @"\s+");
BusinessLigneReleve businessLigneReleve = new BusinessLigneReleve
{
DateLigneReleve = DateTime.Parse(list[1]),
HeureLigneReleve = TimeSpan.Parse(list[2]),
Temperature = double.Parse(list[3].Replace(".", ",")),
Hygrometrie = double.Parse(list[4].Remove(list[4].Length - 1).Replace(".", ",")),
ReleveID = businessReleve.IdReleve
};
lignesReleve.Add(businessLigneReleve);
}
ServiceLigneReleve.AddLignesReleve(lignesReleve);
MessageBox.Show("Fichier TXT associé au capteur");
listBoxReleve.Items.Clear();
gridReleve.ItemsSource = ServiceReleve.GetReleveByCapteurId(businessReleve.IdReleve);
}
