private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
var selectedItem = this.lvDataCollection.SelectedItem;
if (selectedItem != null)
{
DataCollectionEntity item = selectedItem as DataCollectionEntity;
DataCollectionService service = new DataCollectionService();
if (MessageBox.Show("Sei sicuro di voler eliminare l'elemento selezionato?", "Elimina riga", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (service.Delete(item) == 0)
{
MessageBox.Show("cancellato!");
this.RefreshData();
}
else
{
MessageBox.Show("NON cancellato!");
}
}
else
{
MessageBox.Show("NON cancellato!");
}
}
}
public int Add(DataCollectionEntity dataList)
{
try
{
using (var db = new CroceRossaEntities())
{
db.Ins.Add(dataList.ToIns());
db.SaveChanges();
return(0);
}
}
catch (Exception ex)
{
return(-1);
}
}
public int Delete(DataCollectionEntity dataList)
{
try
{
using (var db = new CroceRossaEntities())
{
Ins ins = db.Ins.First(x => x.InsOwnId == dataList.Id);
if (ins != null)
{
db.Ins.Remove(ins);
db.SaveChanges();
}
return(0);
}
}
catch (Exception)
{
return(-1);
}
}
public static Ins ToIns(this DataCollectionEntity dataList, Ins ins = null)
{
if (ins == null)
{
ins = new Ins();
}
ins.InsOwnId = dataList.Id;
ins.InsCarTarId = dataList.CarLicPlateAssociationId;
ins.InsChrTo = dataList.EntityId;
ins.InsIndFrom = dataList.AddressValueFrom;
ins.InsKmInt = dataList.ReturnKm;
ins.InsKmOut = dataList.ExitKm;
ins.InsPatId = dataList.PathologyId;
ins.InsPerId = dataList.PatientId;
ins.InsSvrDat = dataList.ServiceDate;
ins.InsTyp = dataList.ServiceType;
ins.InsSoc1Id = dataList.Rescuer1Id;
if (dataList.Rescuer2Id != -1)
{
ins.InsSoc2Id = dataList.Rescuer2Id;
}
else
{
ins.InsSoc2Id = null;
}
ins.InsAutId = dataList.DriverId;
ins.InsBilNum = dataList.BillNumber;
ins.InsTimIn = dataList.ReturnTime;
ins.InsTimOut = dataList.ExitTime;
ins.InsCrtNum = dataList.TagNumber;
ins.InsPlcFrom = dataList.PlaceValueFrom;
ins.InsPlcTo = dataList.PlaceValueTo;
ins.InsIndTo = dataList.AddressValueTo;
return(ins);
}
