public void DeleteEvent(int idEvent)
{
Models.DataContext context = new Models.DataContext();
Event tmp = new Event {
Id = idEvent
};
context.Event.Remove(tmp);
context.SaveChanges();
Event currentEvent = null;
foreach (var destination in _destinations)
{
foreach (var evt in destination.Event)
{
if (evt.Id == idEvent)
{
currentEvent = evt;
break;
}
}
}
if (currentEvent != null)
{
_destinations.Where(d => d.Id == currentEvent.DestinationId).First().Event.Remove(currentEvent);
}
}
protected override void Seed(Models.DataContext context)
{
// This method will be called after migrating to the latest version.
if (!context.Cafes.Any())
{
context.Cafes.AddOrUpdate(
c => c.Id,
new CafeData
{
Id = "1",
Name = "Tina, we salute you",
CoffeeRating = 4,
AtmosphereRating = 5,
NumberOfVotes = 250,
Address = "47 King Henry's Walk",
PostCode = "N1 4NH",
Latitude = 51.549112,
Longitude = -0.07934,
},
new CafeData
{
Id = "2",
Name = "Shoreditch Grind",
CoffeeRating = 4.75,
AtmosphereRating = 3.5,
NumberOfVotes = 320,
Address = "213 Old Street",
PostCode = "EC1V 9NR",
Latitude = 51.526,
Longitude = -0.088196,
});
}
}
private async void GetData()
{
Models.DataContext context = new Models.DataContext();
var user = await context.User.Where(x => x.TravelId == TravelHelper.Instance.Travel.Id).ToListAsync();
Users = new ObservableCollection <User>(user);
}
protected override void Seed(Models.DataContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
}
/// <summary>
/// Get all the transactions
/// </summary>
/// <returns>
/// Return the transactions in ObservableCollection
/// </returns>
private ObservableCollection <Transaction> getTransaction()
{
Models.DataContext context = new Models.DataContext();
var transactions = context.Transaction.Where(x => x.User.TravelId == TravelHelper.Instance.Travel.Id).Include(x => x.User).Include(x => x.Event).ToList();
return(new ObservableCollection <Transaction>(transactions));
}
private ObservableCollection <Event> getEvents()
{
Models.DataContext context = new Models.DataContext();
var events = context.Event.Where(x => x.Destination.TravelId == TravelHelper.Instance.Travel.Id).ToList();
return(new ObservableCollection <Event>(events));
}
/// <summary>
/// Get alll Users
/// </summary>
/// <returns>
/// Return the users in ObservableCollection
/// </returns>
private ObservableCollection <User> getUsers()
{
Models.DataContext context = new Models.DataContext();
var user = context.User.Where(x => x.TravelId == TravelHelper.Instance.Travel.Id).ToList();
return(new ObservableCollection <User>(user));
}
private async void GetTypes()
{
Models.DataContext context = new Models.DataContext();
var tmp = await context.DocumentType.ToListAsync();
Types = new ObservableCollection <DocumentType>(tmp);
}
public void AddDestination(Destination destination)
{
destination.TravelId = TravelHelper.Instance.Travel.Id;
Models.DataContext context = new Models.DataContext();
var newDestination = context.Destination.Add(destination);
context.SaveChanges();
_destinations.Add(newDestination.Entity);
}
public async void CreateUser()
{
Models.DataContext context = new Models.DataContext();
await context.User.AddAsync(new User { FamilyName = FamilyName, Name = Name, TravelId = TravelHelper.Instance.Travel.Id });
await context.SaveChangesAsync();
GetData();
OnPropertyChanged("Users");
}
public async void CreateDocument()
{
Models.DataContext context = new Models.DataContext();
await context.Document.AddAsync(new Document { UserId = User.Id, TypeId = Type.Id, TravelId = TravelHelper.Instance.Travel.Id, Path = Path, EventId = EventId });
await context.SaveChangesAsync();
GetData();
OnPropertyChanged("Documents");
}
private async void GetData()
{
Models.DataContext context = new Models.DataContext();
var docs = await context.Document.Where(x => x.TravelId == TravelHelper.Instance.Travel.Id)
.Include(x => x.User)
.Include(x => x.Type)
.ToListAsync();
Documents = new ObservableCollection <Document>(docs);
}
private DestinationHelper()
{
Models.DataContext context = new Models.DataContext();
var destinations = context.Destination.Where(x => x.TravelId == TravelHelper.Instance.Travel.Id).Include(x => x.Event).ToList();
_destinations = new ObservableCollection <Destination>(destinations);
var eventTypes = context.EventType.ToList();
_eventTypes = new ObservableCollection <EventType>(eventTypes);
}
public void AddEvent(Event newEvent, EventType type)
{
Models.DataContext context = new Models.DataContext();
var eventInDb = context.Event.Add(newEvent);
context.SaveChanges();
newEvent.Id = eventInDb.Entity.Id;
newEvent.Type = type;
_destinations.Where(d => d.Id == newEvent.DestinationId).First().Event.Add(newEvent);
}
/// <summary>
/// Create a transaction
/// </summary>
public async void createTransaction()
{
Models.DataContext context = new Models.DataContext();
context.Transaction.Add(new Transaction {
EventId = TransactionEvent.Id, UserId = TransactionUser.Id, Cost = TransactionCost, CreatedAt = System.DateTime.Now
});
await context.SaveChangesAsync();
Transactions = getTransaction();
OnPropertyChanged("Transactions");
}
public void DeleteDestination(int id)
{
Models.DataContext context = new Models.DataContext();
Destination tmp = new Destination {
Id = id
};
context.Destination.Remove(tmp);
context.SaveChanges();
_destinations.Remove(_destinations.Where(d => d.Id == id).Single());
}
public async void CreateTravel(string name)
{
var createdAt = DateTime.Now;
var sharingCode = GetHashString(createdAt.ToString());
Models.DataContext context = new Models.DataContext();
var tmp = await context.Travel.AddAsync(new Travel { SharingCode = sharingCode, CreatedAt = createdAt, Name = name });
_travel = tmp.Entity;
await context.SaveChangesAsync();
}
public async void DeleteDocument(int id)
{
Models.DataContext context = new Models.DataContext();
Document tmp = new Document {
Id = id
};
context.Document.Remove(tmp);
await context.SaveChangesAsync();
GetData();
OnPropertyChanged("Documents");
}
public async void DeleteTransaction(int id)
{
Models.DataContext context = new Models.DataContext();
Transaction tmp = new Transaction {
Id = id
};
context.Transaction.Remove(tmp);
await context.SaveChangesAsync();
Transactions = getTransaction();
OnPropertyChanged("Transactions");
}
public async void DeleteUser(int id)
{
Models.DataContext context = new Models.DataContext();
User tmp = new User {
Id = id
};
context.User.Remove(tmp);
await context.SaveChangesAsync();
GetData();
OnPropertyChanged("Users");
}
public async Task <bool> JoinTravel(string sharingCode)
{
Models.DataContext context = new Models.DataContext();
try
{
var travel = await context.Travel.SingleAsync(t => t.SharingCode == sharingCode);
_travel = travel;
return(true);
}
catch
{
return(false);
}
}
///<summary>
///Controla el flujo de la aplicacion segun el estado del usuario
///</summary>
///<param name="user">Obtener los datos del usuario de la base de datos.</param>
///<param name="actionName">Nombre de la accion que dispara el evento.</param>
private string AppFacebookControl(ref User user, string actionName)
{
string response = null; //Mostrar la vista del controlador actual por defecto
string accessToken = (string)Session["AccessToken"];
if (!string.IsNullOrWhiteSpace(accessToken))
{
try
{
dynamic me = FBClient(accessToken).Get("me"); //Obtener datos de un Usuario desde Facebook.
string id = me != null ? me.id : null; //Obtener Id de Facebook, de lo contrario retorna null.
if (!string.IsNullOrWhiteSpace(id)) //Comprobar el id del usuario.
{
using (var context = new Models.DataContext())
{
user = context.Users.SingleOrDefault(x => x.IdUser == id); //Obtener al Usuario de la Base de Datos.
}
if (user != null)
{
if (actionName != "Ok")
{
response = "Index"; //El usuario instalo la aplicacion y realizo el registro exitosamente.
}
}
else
{
if (actionName != "Register")
{
response = "Register"; //El usuario instalo la aplicacion pero no ha registrado sus datos.
}
}
return(response);
}
}
catch
{
Session.Remove("AccessToken"); //El token ha expirado
}
}
if (actionName != "Install")
{
response = "Install"; //El usuario no ha instalado la aplicacion o el token ha expirado.
}
return(response);
}
///<summary>
///Controla el flujo de la aplicacion segun el estado del usuario
///</summary>
///<param name="user">Obtener los datos del usuario de la base de datos.</param>
///<param name="actionName">Nombre de la accion que dispara el evento.</param>
private string AppFacebookControl(ref User user, string actionName)
{
string response = null; //Mostrar la vista del controlador actual por defecto
string accessToken = (string)Session["AccessToken"];
if (!string.IsNullOrWhiteSpace(accessToken))
{
try
{
dynamic me = FBClient(accessToken).Get("me"); //Obtener datos de un Usuario desde Facebook.
string id = me != null ? me.id : null;//Obtener Id de Facebook, de lo contrario retorna null.
if (!string.IsNullOrWhiteSpace(id)) //Comprobar el id del usuario.
{
using (var context = new Models.DataContext())
{
user = context.Users.SingleOrDefault(x => x.IdUser == id); //Obtener al Usuario de la Base de Datos.
}
if (user != null)
{
if (actionName != "Ok")
{
response = "Index"; //El usuario instalo la aplicacion y realizo el registro exitosamente.
}
}
else
{
if (actionName != "Register")
{
response = "Register"; //El usuario instalo la aplicacion pero no ha registrado sus datos.
}
}
return response;
}
}
catch
{
Session.Remove("AccessToken"); //El token ha expirado
}
}
if (actionName != "Install")
{
response = "Install"; //El usuario no ha instalado la aplicacion o el token ha expirado.
}
return response;
}
public ActionResult NewUser(User user)
{
if (!ModelState.IsValid)
{
return(View("Register", user));
}
else
{
//Registrar el Usuario en la Base de Datos si previamente no existe
using (var context = new Models.DataContext())
{
if (!context.Users.Any(x => x.IdUser == user.IdUser))
{
context.Users.Add(user);
context.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
}
public ProductsController(Models.DataContext context, IMapper mapper)
{
DbContext = context;
Mapper = mapper;
}
public AccountController(Models.DataContext context)
{
contextDb = context;
}
public CreateUpdateWineRepository(Models.DataContext dataContext)
{
_dataContext = dataContext;
}
public ActionResult NewUser(User user)
{
if (!ModelState.IsValid)
{
return View("Register", user);
}
else
{
//Registrar el Usuario en la Base de Datos si previamente no existe
using (var context = new Models.DataContext())
{
if (!context.Users.Any(x => x.IdUser == user.IdUser))
{
context.Users.Add(user);
context.SaveChanges();
}
}
return RedirectToAction("Index");
}
}
public CriteriasController(Models.DataContext context, IMapper mapper)
{
DbContext = context;
Mapper = mapper;
}
public ReportsController(Models.DataContext context)
{
DbContext = context;
}
public static void Initialize(Models.DataContext webContext)
{
Webcontext = webContext;
}
public AuthController(Models.DataContext context, IOptions <AppSettings> settings)
{
DbContext = context;
AppSettings = settings.Value;
}
