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; }