public int CreateInteraction(Interaction shared) { DALayer.Entities.Interaction data = InteractionHandler.SharedToData(shared); ctx.Interaction.Add(data); ctx.SaveChanges(); return(data.Id); }
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,UnitNumber,AptName,Reason,PhonNum,Permission,DateReq")] Tenant tenant) { if (ModelState.IsValid) { db.Tenants.Add(tenant); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tenant)); }
public ActionResult RequestForm([Bind(Include = "ID, FirstName, LastName, PhoneNumber, ApartmentName, UnitNumber, Description, Checkbox, Received")] Tenant tenant) { if (ModelState.IsValid) //Are required fields filled out? { //adds form infomation to database db.Tenants.Add(tenant); db.SaveChanges(); return(RedirectToAction("ViewForms")); } return(View(tenant)); }
public ViewResult TenantView([Bind(Include = "ID,FirstName,LastName,PhoneNumber,ApartmentName,ApartmentNumber,FixDescription")] Tenant tenant) { if (ModelState.IsValid) // Check to see if the model is valid { tc.Tenants.Add(tenant); // If model is valid, add the tenant form information into the database tc.SaveChanges(); // Save the changes to the database return(View("Thanks", tenant)); // Return the tenant's name on a "thank you" page } else { return(View(tenant)); // If model is invalid, validation issue and just return tenant information } }
public void createRelJugadorInvestigacion(RelJugadorInvestigacion r) { var col = ctx.RelJugadorMapa.Where(w => w.id == r.colonia.id).SingleOrDefault(); var inv = ctx.Investigacion.Where(w => w.id == r.investigacion.id).SingleOrDefault(); List <Entities.Costo> cos = new List <Entities.Costo>(); foreach (var item in r.investigacion.costos) { var rec = ctx.Recurso.Where(w => w.id == item.recurso.id).SingleOrDefault(); var prod = ctx.Producto.Where(w => w.id == item.idProducto).SingleOrDefault(); var c = new Entities.Costo(rec, prod, item.valor, item.incrementoNivel); cos.Add(c); } Entities.RelJugadorInvestigacion rji = new Entities.RelJugadorInvestigacion(col, inv, r.nivel, r.finalizaConstruccion); try { ctx.RelJugadorInvestigacion.Add(rji); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public int createDestacamento(Destacamento d) { Entities.Destacamento desE = new Entities.Destacamento(d.nombre, d.descripcion, d.foto, d.ataque, d.escudo, d.efectividadAtaque, d.vida, d.velocidad, d.enMision, d.tiempoInicial, d.incrementoTiempo); try { ctx.Database.Connection.Open(); ctx.Destacamento.Add(desE); ctx.SaveChanges(); Entities.Destacamento des = ctx.Destacamento.ToList().LastOrDefault(); ctx.Database.Connection.Close(); return(des.id); } catch (Exception e) { throw e; } }
public void registerLogin(string id) { Entities.ActividadJugador j = ctx.ActividadJugador.Where(c => c.UserId.Equals(id)).OrderByDescending(c => c.CreatedDate).FirstOrDefault(); if (j == null || j.CreatedDate.Date.CompareTo(DateTime.Now.Date) != 0) { ctx.ActividadJugador.Add(new Entities.ActividadJugador { UserId = id, CreatedDate = DateTime.Now, tipo = "login" }); ctx.SaveChanges(); } }
public void createConf(Configuracion conf) { Entities.Configuracion u = new Entities.Configuracion(conf.css, conf.nombre, conf.titulo, conf.idAppFace, conf.claveAppFace); try { ctx.Configuracion.Add(u); ctx.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void createRecurso(Recurso r) { Entities.Recurso rec = new Entities.Recurso(r.nombre, r.descripcion, r.cantInicial, r.capacidadInicial, r.produccionXTiempo, r.foto); try { ctx.Recurso.Add(rec); ctx.SaveChanges(); } catch (Exception ex) { throw ex; } }
//public IActionResult ProcessCode(string code, string error, string error_description, string resource, string state) public async Task <IActionResult> ProcessCode(OnboardingModel model) { //Find Tenant based on tenant guid var t = m_db.Tenants.FirstOrDefault(p => p.Secret == model.state); if (t != null) { var authContext = new AuthenticationContext($"{m_aadOptions.AzureAdInstance}"); //MT var creds = new ClientCredential(m_aadOptions.ClientId, m_aadOptions.ClientSecret); var redirectUri = new Uri($"{m_aadOptions.Domain}/MT/ProcessCode"); var authResult = await authContext.AcquireTokenByAuthorizationCodeAsync( model.code, redirectUri, creds, "https://graph.microsoft.com/"); //Do we already registered that tenant? if (m_db.Tenants.FirstOrDefault(p => p.TenantGuid == authResult.TenantId.ToLower()) == null) { t.TenantGuid = authResult.TenantId.ToLower(); } else { m_db.Tenants.Remove(t); } m_db.SaveChanges(); } //Else - wrong secret //Clean old var old = m_db.Tenants.Where(p => p.TenantGuid == "" && p.DtCreated < DateTime.UtcNow.AddMinutes(-5)); if (old.Count() > 0) { foreach (var item in old) { m_db.Tenants.Remove(item); } m_db.SaveChanges(); } return(View(model)); }
public TenantController(TenantContext context) { _context = context; if (_context.Tenants.Count() == 0) { // Create a new Tenant if collection is empty, // which means you can't delete all Tenants. _context.Tenants.Add(new Tenant { Name = "Tenant1" }); _context.SaveChanges(); } }
public void CreateMapa(MapaNode m) { var mapaE = new Entities.MapaNode(m.nombre, m.nivel, m.cantidad, m.distance); try { ctx.MapaNode.Add(mapaE); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createRelJugadorMapa(RelJugadorMapa r) { var j = ctx.Jugador.Where(w => w.Id == r.jugador.id).SingleOrDefault(); var rel = new Entities.RelJugadorMapa(r.nivel1, r.nivel2, r.nivel3, r.nivel4, r.nivel5, r.coord, j); try { ctx.RelJugadorMapa.Add(rel); ctx.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void createCosto(Costo c) { try { Entities.Recurso rec = ctx.Recurso.Where(w => w.id == c.recurso.id).SingleOrDefault(); var prod = ctx.Producto.Where(w => w.id == c.idProducto).SingleOrDefault(); var cost = new Entities.Costo(rec, prod, c.valor, c.incrementoNivel); ctx.Costo.Add(cost); ctx.SaveChanges(); ctx.Database.Connection.Close(); } catch (Exception e) { throw e; } }
public void createAlianza(Alianza a) { var admin = ctx.Jugador.Where(w => w.Id == a.administrador.id).SingleOrDefault(); Entities.Alianza alli = new Entities.Alianza(a.nombre, a.descripcion, a.foto, admin); try { ctx.Alianza.Add(alli); ctx.SaveChanges(); } catch (Exception ex) { throw ex; } }
public void createProduce(Produce p) { try { ctx.Database.Connection.Open(); Entities.Recurso rec = ctx.Recurso.Where(w => w.id == p.recurso.id).SingleOrDefault(); var prod = ctx.Producto.Where(w => w.id == p.idProducto).SingleOrDefault(); var produce = new Entities.Produce(rec, prod, p.valor, p.incrementoNivel); ctx.Produce.Add(produce); ctx.SaveChanges(); ctx.Database.Connection.Close(); } catch (Exception e) { throw e; } }
public void createRelJugadorRecurso(RelJugadorRecurso r) { var rec = ctx.Recurso.Where(w => w.id == r.recurso.id).SingleOrDefault(); var col = ctx.RelJugadorMapa.Where(w => w.id == r.colonia.id).SingleOrDefault(); var rjr = new Entities.RelJugadorRecurso(rec, col, r.capacidad, r.cantidadR, r.produccionXTiempo, r.ultimaConsulta); try { ctx.RelJugadorRecurso.Add(rjr); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createRelJugadorAlianza(RelJugadorAlianza r) { var ali = ctx.Alianza.Where(w => w.id == r.alianza.id).SingleOrDefault(); var mie = ctx.Jugador.Where(w => w.Id == r.miembro.id).SingleOrDefault(); Entities.RelJugadorAlianza rja = new Entities.RelJugadorAlianza(ali, mie, r.activo); try { ctx.RelJugadorAlianza.Add(rja); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createCapacidad(Capacidad c) { try { ctx.Database.Connection.Open(); Entities.Recurso recurso = ctx.Recurso.Where(w => w.id == c.recurso.id).SingleOrDefault(); var producto = ctx.Producto.Where(w => w.id == c.idProducto).SingleOrDefault(); var capacity = new Entities.Capacidad(recurso, producto, c.valor, c.incrementoNivel); ctx.Capacidad.Add(capacity); ctx.SaveChanges(); ctx.Database.Connection.Close(); } catch (Exception e) { throw e; } }
public void createRelJugadorEdificio(RelJugadorEdificio r) { var col = ctx.RelJugadorMapa.Where(w => w.id == r.colonia.id).SingleOrDefault(); var ed = ctx.Edificio.Where(w => w.id == r.edificio.id).SingleOrDefault(); var rje = new Entities.RelJugadorEdificio(col, ed, r.nivelE, r.finalizaConstruccion); try { ctx.RelJugadorEdificio.Add(rje); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createHistorialVentas(HistorialVentas hvTmp) { Entities.HistorialVentas hv = new Entities.HistorialVentas(); hv.idusuario = hvTmp.idusuario; hv.nombreOferta = hvTmp.nombreOferta; hv.fechaCompra = hvTmp.fechaCompra; try { ctx.HistorialVentas.Add(hv); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public int createInvestigacion(Investigacion i) { var inv = new Entities.Investigacion(i.nombre, i.descripcion, i.foto, i.tiempoInicial, i.incrementoTiempo); try { ctx.Investigacion.Add(inv); ctx.SaveChanges(); Entities.Investigacion invs = ctx.Investigacion.ToList().LastOrDefault(); return(invs.id); } catch (Exception e) { throw e; } }
public void createPaquetePaypal(PaquetePaypal ppTmp) { Entities.PaquetePaypal pp = new Entities.PaquetePaypal(); pp.nombreOferta = ppTmp.nombreOferta; pp.producto = ppTmp.producto; pp.cantidad = ppTmp.cantidad; pp.precio = ppTmp.precio; pp.ofertaActiva = ppTmp.ofertaActiva; try { ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createDependencia(Dependencia d) { var padre = (from c in ctx.Producto where c.id == d.padreId select c).SingleOrDefault(); var hijo = (from c in ctx.Producto where c.id == d.hijoId select c).SingleOrDefault(); Entities.Dependencia dep = new Entities.Dependencia(padre, hijo, d.nivel); try { ctx.Dependencia.Add(dep); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public void createRelJugadorDestacamento(RelJugadorDestacamento r) { CostoHandlerEF cosoH = new CostoHandlerEF(ctx); var col = ctx.RelJugadorMapa.Where(w => w.id == r.colonia.id).SingleOrDefault(); var des = ctx.Destacamento.Where(w => w.id == r.destacamento.id).SingleOrDefault(); List <Entities.Costo> cos = new List <Entities.Costo>(); foreach (var item in r.destacamento.costos) { var rec = ctx.Recurso.Where(w => w.id == item.recurso.id).SingleOrDefault(); var prod = ctx.Producto.Where(w => w.id == item.idProducto).SingleOrDefault(); var c = new Entities.Costo(rec, prod, item.valor, item.incrementoNivel); cos.Add(c); } List <Entities.Capacidad> cap = new List <Entities.Capacidad>(); foreach (var item in r.destacamento.capacidad) { var rec = ctx.Recurso.Where(w => w.id == item.recurso.id).SingleOrDefault(); var prod = ctx.Producto.Where(w => w.id == item.idProducto).SingleOrDefault(); var c = new Entities.Capacidad(rec, prod, item.valor, item.incrementoNivel); cap.Add(c); } var rje = new Entities.RelJugadorDestacamento(col, des, r.cantidad, r.finalizaConstruccion); try { ctx.RelJugadorDestacamento.Add(rje); ctx.SaveChanges(); } catch (Exception e) { throw e; } }
public bool addEntity(Tenant newTenant) { if (_context.Tenants.Where(c => c.SubDomainName == newTenant.SubDomainName).Count() == 0) { _context.Add(newTenant); saveAll(); string connectionString = null; try { connectionString = onTenantEntry(newTenant); } catch (Exception ex) { connectionString = null; } try { if (connectionString != null) { var dbContextOptionsBuilder = new DbContextOptionsBuilder <TenantContext>(); dbContextOptionsBuilder.UseNpgsql(_configuration.GetConnectionString("DefaultConnectionString")); TenantContext tenantContext_temp = new TenantContext(dbContextOptionsBuilder.Options); Tenant recent_tenant = tenantContext_temp.Tenants.Last(); recent_tenant.ConnectionStringName = connectionString; tenantContext_temp.SaveChanges(); } } catch (Exception ex) { return(false); } return(true); } else { return(false); } }
public static void Initialize(TenantContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Tenants.Any()) { return; // DB has been seeded } var tenants = new Tenant[] { new Tenant { FullName = "Doctor Aged Care", CustomerCode = "DAC", DnsName = "dac.helix.medicaldirector.com", SubscriptionCode = "MD" }, }; foreach (Tenant s in tenants) { context.Tenants.Add(s); } context.SaveChanges(); }
internal void SeedDeaultTenant(long tenantId, TenantContext context) { var tenant = new Tenant() { Id = tenantId, Name="ApexVox" }; if(!context.Tenants.Any(x=>x.Id == tenantId)) { context.Database.OpenConnection(); try { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Tenants ON"); context.Tenants.Add(tenant); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Tenants OFF"); } finally { context.Database.CloseConnection(); } } }
public async Task <TwiMLResult> SmsWebhook(SmsRequest request, int numMedia) { // Is this number in our database? var accountsRef = _db.Collection("accounts"); var query = accountsRef.WhereEqualTo("PhoneNumber", request.From); var querySnapshot = await query.GetSnapshotAsync(); DocumentSnapshot?document; if (querySnapshot.Count == 0) { await accountsRef.Document(Guid.NewGuid().ToString()) .SetAsync(new Dictionary <string, object>() { { "PhoneNumber", request.From } }); var snapshot = await query.GetSnapshotAsync(); document = snapshot.Documents[0]; } else { document = querySnapshot.Documents[0]; } // Save the message body if there is one if (request.Body != null) { await document.Reference.UpdateAsync("Messages", FieldValue.ArrayUnion(new Dictionary <string, object>() { { "Text", request.Body }, { "Timestamp", Timestamp.GetCurrentTimestamp() } })); } var filenames = await SaveMedia(numMedia); var phone = _context.Phones.FirstOrDefault(x => x.PhoneNumber == request.From); if (phone == null) { phone = new Phone { PhoneNumber = request.From, Images = new List <Models.Image>() }; _context.Phones.Add(phone); } foreach (var(image, thumbnail) in filenames) { if (phone.Images == null) { phone.Images = new List <Models.Image>(); } phone.Images.Add(new Models.Image { Name = image, ThumbnailName = thumbnail }); } _context.SaveChanges(); var response = new MessagingResponse(); var messageBody = numMedia == 0 ? "Send us an image!" : $"Thanks for sending us {numMedia} file(s)!"; response.Message(messageBody); return(TwiML(response)); }
public void Add(Portfolio portfolio) { _context.Add(portfolio); _context.SaveChanges(); }