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);
}
