public MemeCreation GetRandomMeme(out MemeImage memeImage) { DataTable memeCreationTable = ExecuteQuery($"SELECT TOP 1 MemeCreations.Id, Url, MemeText, Position, Color, Size FROM MemeCreations JOIN MemeImages ON MemeImages.Id = MemeCreations.MemeImg ORDER BY NEWID()"); if (memeCreationTable.Rows.Count > 0) { DataRow row = memeCreationTable.Rows[0]; int id = (int)row["Id"]; string url = (string)row["Url"]; string memeText = (string)row["MemeText"]; string position = (string)row["Position"]; string color = (string)row["Color"]; string size = (string)row["Size"]; memeImage = new MemeImage() { Url = url }; MemeCreation memeCreation = new MemeCreation() { Id = id, MemeText = memeText, Position = position, Color = color, Size = size }; return(memeCreation); } else { throw new ArgumentException($"No memes were found"); } }
public List <MemeCreation> SearchForMeme(string searchString) { string sql = $"SELECT MemeCreations.*, Url, AltText FROM MemeCreations JOIN MemeImages ON MemeCreations.MemeImg = MemeImages.Id WHERE MemeText LIKE '%{searchString}%'"; DataTable MemeTable = ExecuteQuery(sql); List <MemeCreation> memeList = new List <MemeCreation>(); foreach (DataRow row in MemeTable.Rows) { int memeImg = (int)row["MemeImg"]; DateTime timeStamp = (DateTime)row["TimeStamp"]; string memeText = (string)row["MemeText"]; string position = (string)row["Position"]; string color = (string)row["Color"]; string size = (string)row["Size"]; string url = (string)row["Url"]; string altText = (string)row["AltText"]; MemeImage memeImage = new MemeImage(memeImg, url, altText); MemeCreation meme = new MemeCreation(memeImage, memeImg, timeStamp, memeText, position, color, size); memeList.Add(meme); } return(memeList); }
private MemeCreation ExtractMemeCreation(DataRow row) { int memeCreationId = (int)row["Id"]; string url = (string)row["Url"]; string altText = (string)row["AltText"]; int memeImageId = (int)row["MemeImg"]; string memeText = (string)row["MemeText"]; string position = (string)row["Position"]; string size = (string)row["Size"]; string color = (string)row["Color"]; DateTime creationTime = (DateTime)row["TimeStamp"]; MemeImage memeImage = new MemeImage(memeImageId, url, altText); MemeCreation memeCreation = new MemeCreation() { Id = memeCreationId, Color = color, CreationTime = creationTime, MemeImage = memeImage, Position = position, MemeImageId = memeImageId, Size = size, Text = memeText }; return(memeCreation); }
public MemeCreation GetMostRecentMeme() { string sql = $"SELECT TOP(1) MemeCreations.*, MemeImages.Url, MemeImages.AltText FROM MemeCreations JOIN MemeImages ON MemeCreations.MemeImg = MemeImages.Id ORDER BY TimeStamp DESC"; DataTable memeCreationsTable = ExecuteQuery(sql); if (memeCreationsTable.Rows.Count == 1) { int memeCreationsId = (int)memeCreationsTable.Rows[0]["Id"]; string url = (string)memeCreationsTable.Rows[0]["Url"]; string altText = (string)memeCreationsTable.Rows[0]["AltText"]; int memeImageId = (int)memeCreationsTable.Rows[0]["MemeImg"]; DateTime creationTime = (DateTime)memeCreationsTable.Rows[0]["TimeStamp"]; string memeText = (string)memeCreationsTable.Rows[0]["MemeText"]; string position = (string)memeCreationsTable.Rows[0]["Position"]; string color = (string)memeCreationsTable.Rows[0]["Color"]; string size = (string)memeCreationsTable.Rows[0]["Size"]; MemeImage memeImage = new MemeImage(memeImageId, url, altText); MemeCreation memeCreation = new MemeCreation(memeCreationsId, memeImage, creationTime, memeText, position, color, size); return(memeCreation); } else { throw new ArgumentException($"GetMostRecentMeme was not found"); } }
public void OnGet() { MemeCreationRepository memeCreationRepo = new MemeCreationRepository(@"Data Source=(localdb)\mssqllocaldb;Initial Catalog=MemeGenerator;Integrated Security=True;"); MemeImage memeImage; MemeCreation = memeCreationRepo.GetRandomMeme(out memeImage); MemeImage = memeImage; }
public void OnGet() { memeImage = memeImageRepository.GetMemeImage(ImageSelected); memeCreation.MemeImg = memeImage; memeCreation.TimeStamp = DateTime.Now; memeCreation.MemeText = MemeText; memeCreation.Position = TextPosition; memeCreation.Color = TextColor; memeCreation.Size = TextSize; memeCreationRepository.Insert(memeCreation); }
private List <MemeImage> HandleData(DataTable dataTable) { List <MemeImage> memeImages = new List <MemeImage>(); foreach (DataRow row in dataTable.Rows) { MemeImage memeImage = new MemeImage((int)row["Id"], (string)row["Url"], (string)row["AltText"]); memeImages.Add(memeImage); } return(memeImages); }
public MemeImage GetMostUsed() { string sql = "SELECT TOP(1) MemeImg, url, alttext, COUNT(*) FROM MemeCreations JOIN MemeImages on MemeCreations.MemeImg = MemeImages.Id GROUP BY MemeImg, url, alttext ORDER BY COUNT(*) DESC"; DataTable data = ExecuteQuery(sql); List <MemeImage> memeImages = new List <MemeImage>(); foreach (DataRow row in data.Rows) { MemeImage memeImage = new MemeImage((int)row["MemeImg"], (string)row["Url"], (string)row["AltText"]); memeImages.Add(memeImage); } return(memeImages.FirstOrDefault()); }
public MemeImage GetMostUsedImage() { string sql = "SELECT TOP(1) COUNT(MemeImg) as Images, Url, AltText " + "FROM MemeCreations " + "JOIN MemeImages ON MemeCreations.MemeImg = MemeImages.Id " + "GROUP BY MemeImages.Url, AltText " + "ORDER BY Images DESC"; DataTable memeImageTable = ExecuteQuery(sql); MemeImage memeImage = new MemeImage(); memeImage.Url = (string)memeImageTable.Rows[0]["Url"]; memeImage.AltText = (string)memeImageTable.Rows[0]["AltText"]; return(memeImage); }
public List <MemeImage> GetAllMemeImages() { List <MemeImage> memeImages = new List <MemeImage>(); string sql = "SELECT * FROM MemeImages"; DataTable memeImagesTable = ExecuteQuery(sql); foreach (DataRow row in memeImagesTable.Rows) { int id = (int)row["Id"]; string url = (string)row["Url"]; string altText = (string)row["AltText"]; MemeImage memeImage = new MemeImage(id, url, altText); memeImages.Add(memeImage); } return(memeImages); }
public MemeImage GetMostUsedImg() { string sql = $"SELECT TOP(1) COUNT(MemeImages.Id) as Occurences, Url, AltText FROM MemeImages JOIN MemeCreations ON MemeCreations.MemeImg = MemeImages.Id GROUP BY Url, AltText ORDER BY Occurences DESC"; DataTable memeImagesTable = ExecuteQuery(sql); if (memeImagesTable.Rows.Count == 1) { int id = (int)memeImagesTable.Rows[0]["Occurences"]; string url = (string)memeImagesTable.Rows[0]["Url"]; string altText = (string)memeImagesTable.Rows[0]["AltText"]; MemeImage memeImage = new MemeImage(id, url, altText); return(memeImage); } else { throw new ArgumentException($"MemeImage was not found"); } }
public MemeImage GetMemeImage(int imageSelected) { string sql = $"SELECT * FROM MemeImages WHERE Id={imageSelected}"; DataTable memeImagesTable = ExecuteQuery(sql); if (memeImagesTable.Rows.Count == 1) { int id = (int)memeImagesTable.Rows[0]["Id"]; string url = (string)memeImagesTable.Rows[0]["Url"]; string altText = (string)memeImagesTable.Rows[0]["AltText"]; MemeImage memeImage = new MemeImage(id, url, altText); return(memeImage); } else { throw new ArgumentException($"MemeImage with id={imageSelected} was not found"); } }
public MemeCreation GetLatestMeme() { string sql = "SELECT TOP(1) MemeCreations.*, MemeImages.Url, MemeImages.AltText " + "FROM MemeCreations " + "JOIN MemeImages ON MemeCreations.MemeImg = MemeImages.Id " + "ORDER BY TimeStamp DESC; "; DataTable MemeImagesTable = ExecuteQuery(sql); DataRow row = MemeImagesTable.Rows[0]; int memeImg = (int)row["MemeImg"]; DateTime timeStamp = (DateTime)row["TimeStamp"]; string memeText = (string)row["MemeText"]; string position = (string)row["Position"]; string color = (string)row["Color"]; string size = (string)row["Size"]; string url = (string)row["Url"]; string altText = (string)row["AltText"]; MemeImage memeImage = new MemeImage(memeImg, url, altText); MemeCreation meme = new MemeCreation(memeImage, memeImg, timeStamp, memeText, position, color, size); return(meme); }
public void OnGet() { MemeImageRepository memeImageRepo = new MemeImageRepository(@"Data Source=(localdb)\mssqllocaldb;Initial Catalog=MemeGenerator;Integrated Security=True;"); mostUsedImg = memeImageRepo.GetMostUsedImage(); }
public MemePreview(MemeImage meme) { Id = meme.Id; Image = meme.Data; Name = meme.Name; }
public int InsertMemeImage(MemeImage memeImage) { string sql = $"INSERT INTO MemeImages VALUES('{memeImage.Url}', '{memeImage.AltText}')"; return(ExecuteNonQuery(sql)); }
public void Insert(MemeImage imageTemplate) { _context.MemeImages.Add(imageTemplate); }
public void GetLatestMeme() { MemeCreation = memeCreations.GetLatestMeme(); MemeImg = MemeCreation.MemeImg; }
public void MostUsedImage() { MemeImg = memeImages.GetMostUsed(); }