protected bool crudUsersGeeltjes(Int32 geeltjeId, string noteRate, out bool isChange) { var validCount = false; isChange = false; using (var ctx = GeeltjesEntities.GetContext()) { try { Int32 thumbUp = 0; Int32 thumbDown = 0; if (noteRate == "thumbsup") { thumbUp = 1; } else { thumbDown = 1; } Icatt_Geeltjes_UserGeeltje userGeeltje = ctx.Icatt_Geeltjes_UserGeeltje.FirstOrDefault(ug => ug.GeeltjeId == geeltjeId && ug.UserId == _currentUser.UserID); if (userGeeltje == null) { //add validCount = true; userGeeltje = new Icatt_Geeltjes_UserGeeltje { GeeltjeId = geeltjeId, UserId = _userId, ThumbDown = thumbDown, ThumbUp = thumbUp }; // save UserGeeltje object ctx.Icatt_Geeltjes_UserGeeltje.AddObject(userGeeltje); } else { if ( ((!userGeeltje.ThumbDown.HasValue || userGeeltje.ThumbDown.Value == 0) && thumbDown == 1) || ((!userGeeltje.ThumbUp.HasValue || userGeeltje.ThumbUp.Value == 0) && thumbUp == 1) ) { //update if count is valid validCount = true; isChange = true; userGeeltje.ThumbDown = thumbDown; userGeeltje.ThumbUp = thumbUp; } } ctx.SaveChanges(); } catch (Exception ex) { throw ex.InnerException; } return(validCount); } }
protected void updatePosition(Int32 myId) { string myX = _context.Request.Params["x"]; string myY = _context.Request.Params["y"]; string myZ = _context.Request.Params["z"]; if (!string.IsNullOrEmpty(myX) && !string.IsNullOrEmpty(myY) && !string.IsNullOrEmpty(myZ)) { string[] myNewPos = { myX, myY, myZ }; String myStrNewPos = String.Join("x", myNewPos); using (var ctx = GeeltjesEntities.GetContext()) { try { var posToUpdate = ctx.Icatt_Geeltjes_Geeltje.FirstOrDefault(geel => geel.Id == myId); if (posToUpdate != null) { posToUpdate.Xyz = myStrNewPos; ctx.SaveChanges(); } } catch (Exception ex) { throw ex.InnerException; } } } }
protected void deleteNotes(Int32 geeltjeId, int moduleId) { using (var ctx = GeeltjesEntities.GetContext()) { try { Icatt_Geeltjes_Geeltje notesToDelete; notesToDelete = ctx.Icatt_Geeltjes_Geeltje.FirstOrDefault(geel => geel.Id == geeltjeId && geel.ModuleId == moduleId); if (notesToDelete != null && canEditNote(notesToDelete, moduleId)) { var userNotesToDelete = notesToDelete.Icatt_Geeltjes_UserGeeltje; //Delete votes foreach (var icattGeeltjesUserGeeltje in userNotesToDelete) { ctx.Icatt_Geeltjes_UserGeeltje.DeleteObject(icattGeeltjesUserGeeltje); } ctx.Icatt_Geeltjes_Geeltje.DeleteObject(notesToDelete); ctx.SaveChanges(); } } catch (Exception ex) { throw ex.InnerException; } } }
protected void rateNotes(Int32 geeltjeId, string noteRate) { using (var ctx = GeeltjesEntities.GetContext()) { try { bool isChange; if (crudUsersGeeltjes(geeltjeId, noteRate, out isChange)) { //only allow new rating or change of rating rateUpDownNotes(geeltjeId, noteRate, isChange); } } catch (Exception ex) { throw ex.InnerException; } } }
protected int addGeeltje() { using (var ctx = GeeltjesEntities.GetContext()) { try { string myUserName = _context.Request.Params["author"]; string myText = _context.Request.Params["body"]; string myColor = _context.Request.Params["color"]; string moduleIdValue = _context.Request.Params["moduleId"]; string myX = _context.Request.Params["x"]; string myY = _context.Request.Params["y"]; string myZ = _context.Request.Params["zIndex"]; string[] myNewPos = { myX, myY, myZ }; String myStrNewPos = String.Join("x", myNewPos); int moduleId = -1; if (!int.TryParse(moduleIdValue, out moduleId)) { throw new ArgumentException("Missing or invalid 'moduleId' parameter in request to add geeltje for AjaxHandler"); } var newNotes = new Icatt_Geeltjes_Geeltje { Color = myColor , Name = myUserName , Text = myText , Xyz = myStrNewPos , CreatedAt = DateTime.Now , CreatedByUserId = _userId , ModuleId = moduleId }; ctx.Icatt_Geeltjes_Geeltje.AddObject(newNotes); ctx.SaveChanges(); return(newNotes.Id); } catch (Exception ex) { throw ex.InnerException; } } }
protected void rateUpDownNotes(Int32 geeltjeId, string noteRate, bool isChange) { using (var ctx = GeeltjesEntities.GetContext()) { try { Icatt_Geeltjes_Geeltje notesToRate = ctx.Icatt_Geeltjes_Geeltje.FirstOrDefault(geel => geel.Id == geeltjeId); if (notesToRate != null) { Int32 noteThumbUpCount = notesToRate.ThumbUpCount.HasValue ? notesToRate.ThumbUpCount.Value : 0; Int32 noteThumbDownCount = notesToRate.ThumbDownCount.HasValue ? notesToRate.ThumbDownCount.Value : 0; if (noteRate == "thumbsup") { //increase 1 the ThumbUpCount of the notes noteThumbUpCount++; notesToRate.ThumbUpCount = noteThumbUpCount; if (isChange) { //change of thumbs down to thumbs up. decrease thumb down noteThumbDownCount--; notesToRate.ThumbDownCount = noteThumbDownCount; } } else { //increase 1 the ThumbDownCount of the notes noteThumbDownCount++; notesToRate.ThumbDownCount = noteThumbDownCount; if (isChange) { //change of thumbsup to thubsdown. decrease thumb up noteThumbUpCount--; notesToRate.ThumbUpCount = noteThumbUpCount; } } // save Geeltje object ctx.SaveChanges(); } } catch (Exception ex) { throw new InvalidOperationException(string.Format("There was an error rating this notes : {0}", ex.Message), ex); } } }
// Override the OnLoad method to set _text to // a default value if it is null. protected override void OnLoad(EventArgs e) { base.OnLoad(e); _settingAdapter = getModuleSettingsAdapter <Display_SettingAdapter>(); using (var entities = GeeltjesEntities.GetContext()){ _dataSource = entities.Icatt_Geeltjes_Geeltje .Include("Icatt_Geeltjes_UserGeeltje") .Where(g => g.ModuleId == this.ModuleId) .ToList() .Select(g => new Tuple <Icatt_Geeltjes_Geeltje, Icatt_Geeltjes_UserGeeltje>( g, g.Icatt_Geeltjes_UserGeeltje.SingleOrDefault(ug => ug.UserId == currentUser.UserID) )) .ToList(); } DataBind(); }
protected void updateGeeltje(Int32 myId, int moduleId) { string text = _context.Request.Params["body"]; string name = _context.Request.Params["author"]; string color = _context.Request.Params["color"]; using (var ctx = GeeltjesEntities.GetContext()) { try { var posToUpdate = ctx.Icatt_Geeltjes_Geeltje.FirstOrDefault(geel => geel.Id == myId && geel.ModuleId == moduleId); if (posToUpdate != null && canEditNote(posToUpdate, moduleId)) { posToUpdate.Name = name; posToUpdate.Text = text; posToUpdate.Color = color; ctx.SaveChanges(); } } catch (Exception ex) { throw ex.InnerException; } } }