public bool SaveInstrument(IInstrument inst, int id) { var dc = new Dal.StageplanEntities(); var stagePlan = dc.Stageplans.Single(a => a.Id == id); var instrument = new Dal.StageplanInstrument() { DataText = inst.Text, DataDetail = inst.Detail, X = inst.Left, Y = inst.Top, Src = inst.Src, Stageplan = stagePlan, BandMember = inst.BandMemberName, IsFixedPosition = inst.IsFixedPosition, SelectedInstrument = inst.SelectedInstrument, Width = inst.Width, Height = inst.Height, Zindex = inst.Zindex, RotateAngle = inst.RotateAngle }; dc.StageplanInstruments.Add(instrument); return(base.SaveToDatabase(dc)); }
public int SaveBand(string name, decimal width, decimal height, int userAccountId, string bandWebUrl, string socialMediaUrl, string genre, string country, bool willSaveForRecent) { var dc = new Dal.StageplanEntities(); var guid = GetUniqueGuid(); var stagePlan = new Dal.Stageplan() { BandName = name, Token = guid, Height = height, Width = width, SavedByAccountId = userAccountId, CreationDate = DateTime.Now, Genre = genre, SocialMedia = WebPaths.AddMissingHttp(socialMediaUrl), Website = WebPaths.AddMissingHttp(bandWebUrl), Country = country, WillShowInRecentBands = willSaveForRecent }; dc.Stageplans.Add(stagePlan); if (base.SaveToDatabase(dc)) { return(stagePlan.Id); } return(-99); }
/// <summary> /// Gets the average score /// </summary> /// <returns></returns> public decimal GetScore() { var dc = new Dal.StageplanEntities(); var generic = dc.Generics.SingleOrDefault(); var newScore = GetScore(generic.NumberOfVoters, generic.TotalScore); return(Math.Round(newScore, 2)); }
/// <summary> /// DO NOT USE ANY MORE /// </summary> /// <param name="dc"></param> /// <returns></returns> protected bool SaveToDatabase(Dal.StageplanEntities dc) { try { dc.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public void SetLatestResults() { var dc = new Dal.StageplanEntities(); var result = (from d in dc.Generics select new { Score = d.TotalScore, Votes = d.NumberOfVoters, TotalPlans = d.TotalStagePlans }).SingleOrDefault(); this.TotalScore = result.Score; this.TotalVotes = result.Votes; this.StagePlansCreated = result.TotalPlans; }
///// <summary> ///// Returns the current score ///// </summary> ///// <returns></returns> //public decimal GetScore() //{ // var dc = new Dal.StageplanEntities(); // decimal dbScore = dc.Generics.Select(a => a.TotalScore).SingleOrDefault(); // return dbScore; //} public bool SaveRating(int newScore) { var dc = new Dal.StageplanEntities(); var rating = dc.Generics.SingleOrDefault(); if (rating == null) { rating = new Dal.Generic(); dc.Generics.Add(rating); } rating.TotalScore += newScore; rating.NumberOfVoters++; return(base.SaveToDatabase(dc)); }
//[TestMethod] //public void SaveBandByName() //{ // Bll.Save save = new Bll.Save(); // var id = save.SaveBand(this._bandName); // Assert.IsTrue(id > 0); // var dc = new Dal.StageplanEntities(); // var b = (from d in dc.Stageplans // where d.Id == id // select d).SingleOrDefault(); // Assert.IsTrue(b != null); // DeleteBandById(id); //} private void DeleteBandById(int id) { var dc = new Dal.StageplanEntities(); var r = (from d in dc.Stageplans where d.Id == id select d).SingleOrDefault(); if (r == null) { return; } dc.Stageplans.Remove(r); dc.SaveChanges(); }
private string GetUniqueGuid() { var dc = new Dal.StageplanEntities(); string guid = String.Empty; int i = 0; while (i < 100) { guid = Guid.NewGuid().ToString(); if (!dc.Stageplans.Any(a => a.Token == guid)) { return(guid); } } return(guid); }
private bool Delete(Bll.SubscriptionPreferences email) { Dal.StageplanEntities dc = new Dal.StageplanEntities(); var ml = dc.MailingLists.Where(a => a.EmailAddress == email.EmailAddress).SingleOrDefault(); if (ml != null) { try { dc.MailingLists.Remove(ml); dc.SaveChanges(); return(true); } catch (Exception) { throw new Exception(); } } return(false); }
/// <summary> /// Gets the instruments based upon the token /// </summary> /// <param name="token"></param> /// <returns></returns> public Instruments GetInstruments(string token) { var dc = new Dal.StageplanEntities(); var plan = dc.Stageplans.Where(a => a.Token == token).SingleOrDefault(); if (plan == null) { return(null); } var result = new Instruments(); result.BandName = plan.BandName; result.Height = plan.Height; result.Width = plan.Width; result.AllInstruments = new List <Instrument>(); foreach (var item in plan.StageplanInstruments) { var detail = String.IsNullOrEmpty(item.DataDetail) ? " " : HttpContext.Current.Server.UrlDecode(item.DataDetail); result.AllInstruments.Add(new Instrument() { Detail = detail, Left = item.X, Src = item.Src, Text = String.IsNullOrEmpty(item.DataText) ? " " : item.DataText, Top = item.Y, BandMemberName = item.BandMember, IsFixedPosition = item.IsFixedPosition, Width = item.Width.HasValue ? (int)item.Width : 75, Height = item.Height.HasValue ? (int)item.Height : 75, Zindex = item.Zindex, SelectedInstrument = item.SelectedInstrument, RotateAngle = item.RotateAngle }); } return(result); }
public DataAccess() { this.DataContext = new Dal.StageplanEntities(); }
public SubscriptionPreferences() { this._dc = new Dal.StageplanEntities(); this.IsOptIn = true; }
public RecentBands() { this._dc = new Dal.StageplanEntities(); }