protected void btnApprove_Click(object sender, EventArgs e) { Guid suggestionId = GetSuggestionIdFromRequest(); if (suggestionId != Guid.Empty) { using (var ctx = new EF.RepositoryContext("LogoDB")) { var suggestion = ctx.Suggestions .Include("Channels") .Include("Messages") .Include("Aliases") .Include("Logos").Include("Logos.Channels").Include("Logos.Channels.Logos") .FirstOrDefault(s => s.Id == suggestionId); if (suggestion != null) { foreach (var channel in suggestion.Channels) { channel.Suggestion = null; } if (suggestion.Logos.Any()) { // delete the old logo (DB object and files) on the channel when suggestion was new logo foreach (var logo in suggestion.Logos.First().Channels.First().Logos.Where(l => l.Suggestion == null).ToList()) { logo.Repository = null; logo.Creator = null; ctx.Logos.Remove(logo); File.Delete(Thumbnailer.GetThumbFilePath(logo.Id)); File.Delete(Path.Combine(Server.MapPath("~/Logos"), logo.Id + ".png")); } } foreach (var logo in suggestion.Logos) { logo.Suggestion = null; } foreach (var alias in suggestion.Aliases) { alias.Suggestion = null; } ctx.Messages.RemoveRange(suggestion.Messages); ctx.Suggestions.Remove(suggestion); ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); Response.Redirect("/ListSuggestions.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); this.Visible = false; } } } }
protected void btnDecline_Click(object sender, EventArgs e) { Guid suggestionId = GetSuggestionIdFromRequest(); if (suggestionId != Guid.Empty) { using (var ctx = new EF.RepositoryContext("LogoDB")) { var suggestion = ctx.Suggestions .Include("Channels") .Include("Messages") .Include("Aliases") .Include("Logos") .FirstOrDefault(s => s.Id == suggestionId); if (suggestion != null) { var logoFilesToDelete = suggestion.Logos.Select(l => l.Id).ToList(); ctx.Channels.RemoveRange(suggestion.Channels); ctx.Logos.RemoveRange(suggestion.Logos); ctx.Aliases.RemoveRange(suggestion.Aliases); ctx.Messages.RemoveRange(suggestion.Messages); ctx.Suggestions.Remove(suggestion); ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); logoFilesToDelete.ForEach(l => { var logoFilePath = Path.Combine(Server.MapPath("~/Logos"), l + ".png"); if (File.Exists(logoFilePath)) { File.Delete(logoFilePath); } var logoThumbPath = Thumbnailer.GetThumbFilePath(l); if (File.Exists(logoThumbPath)) { File.Delete(logoThumbPath); } }); Response.Redirect("/ListSuggestions.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); this.Visible = false; } } } }
protected void gvChannels_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteChannel") { var channelId = new Guid((string)e.CommandArgument); using (var ctx = new EF.RepositoryContext("LogoDB")) { var channel = ctx.Channels .Include("Aliases").Include("Aliases.Suggestion") .Include("Logos").Include("Logos.Suggestion") .FirstOrDefault(c => c.Id == channelId); if (channel != null) { foreach (var alias in channel.Aliases.ToList()) { if (alias.Suggestion != null) { ctx.Suggestions.Remove(alias.Suggestion); } ctx.Aliases.Remove(alias); } foreach (var logo in channel.Logos.ToList()) { if (logo.Suggestion != null) { ctx.Suggestions.Remove(logo.Suggestion); } ctx.Logos.Remove(logo); File.Delete(Thumbnailer.GetThumbFilePath(logo.Id)); File.Delete(Path.Combine(Server.MapPath("~/Logos"), logo.Id + ".png")); } ctx.Channels.Remove(channel); ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); } } BindChannelsGrid(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { using (var ctx = new EF.RepositoryContext("LogoDB")) { var channel = GetChannel(ctx); if (channel != null) { channel.Website = tbxChannelWebsite.Text.Trim(); channel.Description = tbxChannelDescription.Text.Trim(); if (listNewAliases.Items.Count == 0) { throw new Exception("A Channel must have at least one Alias!"); } // delete aliases that are no longer there if (channel.Aliases != null) { foreach (var alias in channel.Aliases.ToList()) { if (listNewAliases.Items.FindByText(alias.Name) == null) { ctx.Aliases.Remove(alias); } } } // add new aliases foreach (ListItem item in listNewAliases.Items) { string newAliasTrimmed = item.Text.Trim(); if (!string.IsNullOrEmpty(newAliasTrimmed)) { if (!channel.Aliases.Any(a => a.Name == newAliasTrimmed)) { var alias = ctx.Aliases.Create(); alias.Id = Guid.NewGuid(); alias.Name = newAliasTrimmed; alias.Created = DateTime.Now; alias.Channel = channel; channel.Aliases.Add(alias); } } } // new logo if (uploadLogoFile.HasFile) { var repo = ctx.Repositorys.FirstOrDefault(); var membership = System.Web.Security.Membership.GetUser(); var user = membership != null?ctx.Users.FirstOrDefault(u => u.Id == (Guid)membership.ProviderUserKey) : null; // check that file is PNG byte[] logoData = uploadLogoFile.FileBytes; using (MemoryStream ms = new MemoryStream(logoData)) { using (System.Drawing.Image image = System.Drawing.Image.FromStream(ms, true, true)) { if (image.RawFormat.Guid != System.Drawing.Imaging.ImageFormat.Png.Guid) { throw new Exception("The supplied Logo file is not a valid PNG image!"); } if (string.IsNullOrEmpty(tbxLogoName.Text.Trim())) { throw new Exception("Please give the new Logo an unique name!"); } // delete old logo var oldLogo = channel.Logos.First(l => l.Suggestion == null); ctx.Logos.Remove(oldLogo); File.Delete(Thumbnailer.GetThumbFilePath(oldLogo.Id)); File.Delete(Path.Combine(Server.MapPath("~/Logos"), oldLogo.Id + ".png")); // create new logo var logo = ctx.Logos.Create(); logo.Id = Guid.NewGuid(); logo.Name = tbxLogoName.Text.Trim(); logo.Origin = tbxLogoOrigin.Text.Trim(); logo.LastModified = DateTime.Now; logo.Width = image.Width; logo.Height = image.Height; logo.SizeInBytes = logoData.Length; repo.Logos.Add(logo); logo.Creator = user; logo.Channels.Add(channel); File.WriteAllBytes(Path.Combine(Server.MapPath("~/Logos"), logo.Id + ".png"), logoData); Thumbnailer.CreateLogoThumb(image, logo.Id); imgChannelLogo.ImageUrl = Thumbnailer.GetThumbFileUrl(logo.Id); imgChannelLogo.NavigateUrl = "/Logos/" + logo.Id + ".png"; } } } ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); } } lblReturnMessage.Visible = true; lblReturnMessage.ForeColor = System.Drawing.Color.Green; lblReturnMessage.Text = "Channel successfully saved!"; } catch (Exception ex) { lblReturnMessage.Visible = true; lblReturnMessage.ForeColor = System.Drawing.Color.Red; lblReturnMessage.Text = ex.Message; } }