static void Main(string[] args) { var connectionString = ConfigurationManager.AppSettings["defaultConnection"]; using (var context = new HeroDbContext(connectionString)) { if (context.Database.Exists()) context.Database.Delete(); context.Database.Create(); } var contexts = new DbContext[] { }; foreach (var context in contexts) { var adapter = (IObjectContextAdapter)context; var script = adapter.ObjectContext.CreateDatabaseScript(); context.Database.ExecuteSqlCommand(script); context.Dispose(); } //Seed Databases using (var context = new HeroDbContext(connectionString)) { HeroDbContextInitializer.Seed(context); } }
public async Task <ActionResult> InsertVote([FromBody] string heroid) { string IPAddress = Request.HttpContext.Connection.RemoteIpAddress.ToString(); string heroDetail = ""; try { using (HeroDbContext db = new HeroDbContext()) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@HeroID", SqlDbType.VarChar, 5) { Value = heroid }, new SqlParameter("@IPAddress", SqlDbType.VarChar, 30) { Value = IPAddress } }; var hero = await db.Votes.FromSql("EXEC InsertVote @HeroID, @IPAddress", parameters) .Select(h => h.HeroID).AsNoTracking().FirstOrDefaultAsync(); heroDetail = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(heroDetail)); }
//Check Username Password for Login private async Task <bool> GetUserIdFromCredentials(Account loginViewModel) { bool userId = false; try { using (HeroDbContext db = new HeroDbContext()) { DateTime date = DateTime.Now; var userdb = await(from u in db.Admins where u.Username == loginViewModel.Username select u).FirstOrDefaultAsync(); if (userdb != null) { if ((loginViewModel.Username == userdb.Username) && (loginViewModel.Password == userdb.Password)) { userId = true; } } } } catch (Exception) { } return(userId); }
public async Task <ActionResult> getTopHeroes() { string heroList = ""; try { using (HeroDbContext db = new HeroDbContext()) { /*var hero = await (from h in db.Heroes * join v in db.Votes on h.HeroID equals v.HeroID into result1 * from r1 in result1.DefaultIfEmpty() group r1 by new {h.HeroID,h.HeroName,h.HeroIMG} into result2 * select new { result2.Key.HeroID, result2.Key.HeroName, result2.Key.HeroIMG, * HeroVoted = result2.Count(c => c != null) })*/ var hero = await(from h in db.Heroes let vCount = (from v in db.Votes where h.HeroID == v.HeroID select v).Count() let cCount = (from c in db.Comments where h.HeroID == c.HeroID select c).Count() select new { h.HeroID, h.HeroName, HeroIMG = imgStorage + (h.HeroIMG != null && h.HeroIMG != "" ? h.HeroIMG : "noimages.jpg;"), HeroVoted = vCount, HeroCommented = cCount }) .OrderByDescending(h => h.HeroVoted).AsNoTracking().Take(5).ToListAsync(); heroList = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(heroList)); }
public PlayerHand Get(HeroDbContext dbContext) { return(new PlayerHand { Cards = dbContext.HeroCards.ToList() }); }
protected override void Seed(HeroDbContext 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. //SeedDataPowers(context); //SeedDataHeroes(context); //SeedDataPowerDetails(context); }
public void CreateHero(HeroInfo heroInfo) { using (var context = new HeroDbContext(_nameOrConnectionString)) { var hero = new Hero(heroInfo.Id, heroInfo.SerialNumber, heroInfo.Name, heroInfo.Power, heroInfo.AlterEgo); context.Set<Hero>().Add(hero); context.SaveChanges(); } }
private void SeedDataPowers(HeroDbContext context) { string[] powerNames = Enum.GetNames(typeof(EPower)); if (powerNames != null && powerNames.Length > 0) { Power[] powers = new Power[powerNames.Length]; for (int i = 0; i < powers.Length; i++) { powers[i] = new Power(powerNames[i]); } context.Powers.AddOrUpdate(powers); } }
private void SeedDataHeroes(HeroDbContext context) { string[] heroNames = { "Thor", "Batman", "Hulk", "Doctor Strange", "Superman", "Venom", "Flash", "Spiderman", "Supergirl", "Deadpool" }; if (heroNames != null && heroNames.Length > 0) { Hero[] heroes = new Hero[heroNames.Length]; for (int i = 0; i < heroes.Length; i++) { heroes[i] = new Hero(heroNames[i]); } context.Heroes.AddOrUpdate(heroes); } }
// POST: api/Heroes public async Task <IHttpActionResult> Post([FromBody] HeroCreate hero) { if (hero == null || string.IsNullOrEmpty(hero.HeroName) || string.IsNullOrWhiteSpace(hero.HeroName)) { return(BadRequest(string.Format(GeneralMessages.InvalidData, ModelNames.Hero))); } using (HeroDbContext context = new HeroDbContext()) { context.Heroes.Add(new Hero(hero)); await context.SaveChangesAsync(); return(Ok(new CMessage(string.Format(GeneralMessages.CreateSuccess, ModelNames.Hero)))); } }
// GET: api/Heroes/5 public async Task <IHttpActionResult> Get(int id) { using (HeroDbContext context = new HeroDbContext()) { Hero hero = await context.Heroes.FirstOrDefaultAsync(h => h.HeroId == id); if (hero != null) { HeroInfo heroInfo = new HeroInfo(hero); return(Json(heroInfo)); } } return(BadRequest(string.Format(GeneralMessages.NotFound, ModelNames.Hero, _heroMessages.GetString("HeroId"), id))); }
// DELETE: api/Heroes/5 public async Task <IHttpActionResult> Delete(int id) { using (HeroDbContext context = new HeroDbContext()) { Hero findHero = await context.Heroes.FirstOrDefaultAsync(h => h.HeroId == id); if (findHero == null) { return(BadRequest(string.Format(GeneralMessages.NotFound, ModelNames.Hero, _heroMessages.GetString("HeroId"), id))); } context.Heroes.Remove(findHero); await context.SaveChangesAsync(); return(Ok(new CMessage(string.Format(GeneralMessages.DeleteSuccess, ModelNames.Hero, _heroMessages.GetString("HeroId"), id)))); } }
// GET: api/Heroes public async Task <IHttpActionResult> Get() { List <HeroInfo> result = new List <HeroInfo>(); using (HeroDbContext context = new HeroDbContext()) { var heroes = await context.Heroes.Where(h => true).ToListAsync(); foreach (Hero hero in heroes) { await context.Entry(hero).Collection(h => h.PowerDetails).LoadAsync(); result.Add(new HeroInfo(hero)); } } return(Json(result)); }
public async Task <ActionResult> InsertComment([FromBody] PostComment comment) { bool status = false; if (ModelState.IsValid) { try { using (HeroDbContext db = new HeroDbContext()) { string IP = Request.HttpContext.Connection.RemoteIpAddress.ToString(); DateTime date = DateTime.Now; int heroCount = await db.Heroes.Where(h => h.HeroID == comment.HeroID).CountAsync(); if (heroCount > 0) { Comments cm = new Comments() { HeroID = comment.HeroID, Name = comment.Name.Trim(), Email = comment.Email.Trim(), Message = comment.Message.Trim(), IPAddress = IP, CommentDate = date }; db.Comments.Add(cm); int row = await db.SaveChangesAsync(); if (row > 0) { status = true; } } } } catch (Exception) { return(BadRequest()); } } return(Ok(status)); }
public async Task <ActionResult> GetSearchHero(string heroid) { string heroDetail = ""; try { using (HeroDbContext db = new HeroDbContext()) { var hero = await(from h in db.Heroes where h.HeroName.Contains(heroid) select new { h.HeroID, h.HeroName }).AsNoTracking().ToListAsync(); heroDetail = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(heroDetail)); }
public ActionResult DeleteComment([FromBody] Account commentid) { bool status = false; try { using (HeroDbContext db = new HeroDbContext()) { /*var comments = await (from c in db.Comments where c.CommentID == commentid select c).FirstOrDefaultAsync(); * db.Comments.Remove(comments); * var row = await db.SaveChangesAsync(); * if(row > 0) status = true;*/ } } catch (Exception) { return(BadRequest()); } return(Ok(status)); }
public async Task <ActionResult> getHeroDetail(string heroid) { string heroDetail = ""; try { using (HeroDbContext db = new HeroDbContext()) { var hero = await(from h in db.Heroes where h.HeroID == heroid join v in db.Votes on h.HeroID equals v.HeroID into result1 from r1 in result1.DefaultIfEmpty() group r1 by new { h.HeroID, h.HeroName, h.HeroDesc, h.HeroIMG } into result2 select new HeroDetail { HeroID = result2.Key.HeroID, HeroName = result2.Key.HeroName, HeroDesc = result2.Key.HeroDesc, HeroIMG = (result2.Key.HeroIMG != null && result2.Key.HeroIMG != "" ? result2.Key.HeroIMG : "noimages.jpg;"), HeroVoted = result2.Count(c => c != null) }).AsNoTracking().FirstOrDefaultAsync(); if (hero != null) { string[] HeroIMG = hero.HeroIMG.Split(";"); HeroIMG = HeroIMG.Take(HeroIMG.Count() - 1).ToArray(); //ไม่เอา array element ช่องสุดท้าย hero.HeroIMG = ""; foreach (var h in HeroIMG) { hero.HeroIMG += imgStorage + h + ";"; } } heroDetail = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(heroDetail)); }
private void SeedDataPowerDetails(HeroDbContext context) { PowerDetail[] powerDetails = new PowerDetail[16]; powerDetails[0] = new PowerDetail(1, (int)EPower.Thunder); powerDetails[1] = new PowerDetail(1, (int)EPower.Strength); powerDetails[2] = new PowerDetail(2, (int)EPower.Rich); powerDetails[3] = new PowerDetail(2, (int)EPower.Strength); powerDetails[4] = new PowerDetail(3, (int)EPower.Strength); powerDetails[5] = new PowerDetail(4, (int)EPower.Magic); powerDetails[6] = new PowerDetail(5, (int)EPower.Strength); powerDetails[7] = new PowerDetail(5, (int)EPower.Speed); powerDetails[8] = new PowerDetail(5, (int)EPower.LaserEyes); powerDetails[9] = new PowerDetail(6, (int)EPower.Strength); powerDetails[10] = new PowerDetail(6, (int)EPower.Speed); powerDetails[11] = new PowerDetail(7, (int)EPower.Speed); powerDetails[12] = new PowerDetail(8, (int)EPower.Strength); powerDetails[13] = new PowerDetail(9, (int)EPower.Strength); powerDetails[14] = new PowerDetail(9, (int)EPower.LaserEyes); powerDetails[15] = new PowerDetail(10, (int)EPower.Strength); context.PowerDetails.AddOrUpdate(powerDetails); }
// PUT: api/Heroes/5 public async Task <IHttpActionResult> Put(int id, [FromBody] HeroCreate hero) { if (hero == null || string.IsNullOrEmpty(hero.HeroName) || string.IsNullOrWhiteSpace(hero.HeroName)) { return(BadRequest(string.Format(GeneralMessages.InvalidData, ModelNames.Hero))); } using (HeroDbContext context = new HeroDbContext()) { Hero findHero = await context.Heroes.FirstOrDefaultAsync(h => h.HeroId == id); if (findHero == null) { return(BadRequest(string.Format(GeneralMessages.NotFound, ModelNames.Hero, _heroMessages.GetString("HeroId"), id))); } findHero.HeroName = hero.HeroName; await context.SaveChangesAsync(); return(Ok(new CMessage(string.Format(GeneralMessages.UpdateSuccess, ModelNames.Hero, _heroMessages.GetString("HeroId"), id)))); } }
public async Task <ActionResult> GetHeroComment(string heroid) { string Comments = ""; try { using (HeroDbContext db = new HeroDbContext()) { var hero = await(from c in db.Comments where c.HeroID == heroid select new { c.CommentID, CommentGroup = (c.ParentID != 0 ? c.ParentID : c.CommentID), //c.Name, c.Email, c.Message, CommentDate = c.CommentDate.ToString("d MMMM yyyy เวลา HH.mm น.")}) c.Name, c.Email, c.Message, CommentDate = c.CommentDate }) .OrderBy(c => c.CommentGroup).ThenBy(c => c.CommentID).AsNoTracking().ToListAsync(); Comments = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(Comments)); }
public async Task <ActionResult> getMoreHero(int skipNum) { string heroList = ""; try { using (HeroDbContext db = new HeroDbContext()) { var hero = await(from h in db.Heroes let vCount = (from v in db.Votes where h.HeroID == v.HeroID select v).Count() let cCount = (from c in db.Comments where h.HeroID == c.HeroID select c).Count() select new { h.HeroID, h.HeroName, HeroIMG = imgStorage + (h.HeroIMG != null && h.HeroIMG != "" ? h.HeroIMG : "noimages.jpg;"), HeroVoted = vCount, HeroCommented = cCount }) .OrderByDescending(h => h.HeroVoted).AsNoTracking().Skip(skipNum).Take(4).ToListAsync(); heroList = JsonConvert.SerializeObject(hero); } } catch (Exception) { return(BadRequest()); } return(Ok(heroList)); }
public PostRepository(HeroDbContext dbContext, IMapper mapper) { this.dbContext = dbContext; this.mapper = mapper; }
public HeroRepository(HeroDbContext context) : base(context) { }
public MetaHumansTeamsRepository(HeroDbContext context) : base(context) { }
public ProfileController(HeroDbContext context, IHelpers helper) { _context = context; _helper = helper; }
public HeroController(HeroDbContext dbContext, IHeroApplicationService heroService) { this._dbContext = dbContext; this._heroService = heroService; }
public TeamsController(HeroDbContext context, IMapper mapper) : base(mapper) { teamsRepository = new TeamsRepository(context); }
public AbilitiesRepository(HeroDbContext context) : base(context) { }
public HeroController(HeroDbContext context) { _context = context; }
public Repository(HeroDbContext dbContext) { Db = dbContext ?? throw new ArgumentNullException(nameof(dbContext)); DbSet = Db.Set <TEntity>(); }
public VillainsController(HeroDbContext context) { _context = context; }
/// <summary> /// Initializes a new instance of the <see cref="MetaHumansAbilitiesController"/> class. /// </summary> /// <param name="context">The database context</param> public MetaHumansAbilitiesController(HeroDbContext context) { this.metahumanAbilitiesRepository = new MetaHumansAbilitiesRepository(context); }