private bool InsertInEventFieldTable(EventFieldSet eventField) { return(CheckBeforeInsert( EVENTFIELD, ef => ef.EventSet.Name.ToLower().Equals(eventField.EventSet.Name.ToLower()) && ef.FieldSet.Name.ToLower().Equals(eventField.FieldSet.Name.ToLower()), ef => ef.EventSet.Name.ToLower().Equals(eventField.EventSet.Name.ToLower()) && ef.FieldSet.Name.ToLower().Equals(eventField.FieldSet.Name.ToLower()), eventField, this._repostitoryFactory.GetEventFieldRepository(this._dbContext))); }
public void UpdateEventField(string field, bool visibility) { EventFieldSet evf = this._repostitoryFactory .GetEventFieldRepository(this._dbContext) .SearchFor(e => e.EventID_Event == this._idEvent && e.FieldSet.Name.Equals(field)) .FirstOrDefault(); if (evf == null) { return; } evf.Visibility = visibility; this._repostitoryFactory.GetEventFieldRepository(this._dbContext).Update(evf); }
public void InsertNewUser(int index, string field, string data, bool visibility, bool onsite = false) { //INSERT IN USER TABLE UserSet user = new UserSet(); if (index == 0) { user.Active = true; user.CreationDate = DateTime.Now; user.Onsite = onsite; if (field.ToLower().Equals("barcode")) { user.Barcode = data; } else { //CHECK IN THE DB THE LASTBARCODE UserSet userDb = this._repostitoryFactory.GetUserRepository(this._dbContext).GetLastUser(); if (userDb == null) { //IF THE DB IS EMPTY AND THE MAP DOESN'T CONTAINS SOMEONE, START WITH 100000 user.Barcode = !this._myUsers.ContainsKey(USER) ? "100000" : (Int32.Parse(this._myUsers[USER].Cast <UserSet>().OrderByDescending(u => u.Barcode).FirstOrDefault().Barcode) + 1).ToString(); } else { user.Barcode = this._myUsers.ContainsKey(USER) ? (Int32.Parse(this._myUsers[USER].Cast <UserSet>().OrderByDescending(u => u.Barcode).FirstOrDefault().Barcode) + 1).ToString() : (Int32.Parse(userDb.Barcode) + 1).ToString(); } } InsertInUserTable(user); } else { user = this._myUsers[USER].Cast <UserSet>().OrderByDescending(u => u.Barcode).FirstOrDefault(); } //INSERT IN EVENTFIELD EventSet ev = this._repostitoryFactory.GetEventRepository(this._dbContext).GetById(this._idEvent); bool inDico = this._myUsers.ContainsKey(FIELD); FieldSet fieldDb = inDico ? this._myUsers[FIELD].Cast <FieldSet>().Where(f2 => f2.Name.ToLower().Equals(field.ToLower())).FirstOrDefault() ?? this._repostitoryFactory.GetFieldRepository(this._dbContext).SearchFor(f => f.Name.ToLower().Equals(field.ToLower())).FirstOrDefault() : this._repostitoryFactory.GetFieldRepository(this._dbContext).SearchFor(f => f.Name.ToLower().Equals(field.ToLower())).FirstOrDefault(); EventFieldSet evf = this._repostitoryFactory.GetEventFieldRepository(this._dbContext) .SearchFor(e => e.EventSet.Name.Equals(ev.Name) && e.FieldSet.Name.Equals(fieldDb.Name)).FirstOrDefault(); if (evf == null) { if (this._myUsers.ContainsKey(EVENTFIELD)) { evf = this._myUsers[EVENTFIELD].Cast <EventFieldSet>().Where(e => e.EventSet.Name.Equals(ev.Name) && e.FieldSet.Name.Equals(fieldDb.Name)).FirstOrDefault(); } } if (evf == null) { evf = new EventFieldSet(); evf.EventSet = ev; evf.FieldSet = fieldDb; evf.Visibility = visibility; evf.Unique = false; } bool isInserted = InsertInEventFieldTable(evf); if (!isInserted) { this._repostitoryFactory.GetEventFieldRepository(this._dbContext).Update(evf); } EventFieldUserSet evfu = new EventFieldUserSet(); evfu.UserSet = user; evfu.EventFieldSet = evf; evfu.Value = data; InsertInEventFieldUserTable(evfu); }