private void writeDataInList()
{
using (var db = new PSDBContext())
{
AddressesCollection.Clear();
db.Addresses.Where(login => login.User.Login == userViewModel.UserLogin).ToList().ForEach(a =>
{
AddressesCollection.Add(new Address {
Title = a.Title
});
});
}
}
/// <summary>
/// Crea una lista de direcciones
/// </summary>
private static string CreateAddressList(AddressesCollection objColAddress)
{
StringBuilder sb = new StringBuilder();
// Añade las direcciones
foreach (Address objAddress in objColAddress)
if (!string.IsNullOrEmpty(objAddress.EMail))
{// Añade una coma si es necesario
if (sb.Length > 0)
sb.Append(",");
// Añade la dirección de correo
sb.Append(GetEMail(objAddress));
}
// Devuelve la lista de direcciones
return sb.ToString().Trim();
}
public void writeDataWithDateTimeInTable()
{
using (var db = new PSDBContext())
{
AddressesCollection.Clear();
db.Addresses.Where(login => login.User.Login == userViewModel.UserLogin).ToList().ForEach(ad =>
AddressesCollection.Add(new Address
{
Title = ad.Title
})
);
ServicesCollection.Clear();
db.Services.Where(login => login.User.Login == userViewModel.UserLogin).ToList().ForEach(ad =>
ServicesCollection.Add(new Service
{
Title = ad.Title
})
);
RatesCollection.Clear();
db.Rates.Where(login => login.User.Login == userViewModel.UserLogin).ToList().ForEach(ad =>
RatesCollection.Add(new Rate
{
Title = ad.Title,
MeasureTitle = ad.MeasureTitle,
Price = ad.Price.ToString()
})
);
VICollection.Clear();
db.VolumeIndications.Where(login => login.User.Login == userViewModel.UserLogin && login.DatePaid == SelectedDate).ToList().ForEach(vi =>
VICollection.Add(new VolumeIndication
{
SelectedAddress = AddressesCollection.FirstOrDefault(adcol => adcol.Title == vi.Address.Title),
SelectedService = ServicesCollection.FirstOrDefault(adcol => adcol.Title == vi.Service.Title),
SelectedRate = RatesCollection.FirstOrDefault(adcol => adcol.Title == vi.Rate.Title),
PrevIndication = vi.PrevIndication.ToString(),
CurIndication = vi.CurIndication.ToString(),
Total = vi.Total.ToString(),
SelectedDate = vi.DatePaid,
Id = vi.Id
}
));
}
}
