public void DeleteEnterprise(EnterpriseModel enterprise)
{
if (enterprise == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
ENTERPRISE current = data.ENTERPRISE.Where(p => p.ID == enterprise.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (UpdateException ex)
{
if (ex.InnerException != null)
{
throw new UpdateException(ex.InnerException.Message);
}
throw;
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateEnterprise(EnterpriseModel enterprise)
{
using (AppTourEntities data = new AppTourEntities())
{
ENTERPRISE current = data.ENTERPRISE.Where(x => enterprise.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.NAME = enterprise.Name;
current.DESCRIPTION = enterprise.Description;
current.CREATION_DATE = enterprise.CreationDate;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteCountry(CountryModel Country)
{
if (Country == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
COUNTRY current = data.COUNTRY.Where(x => x.ID == Country.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateCountry(CountryModel Country)
{
using (AppTourEntities data = new AppTourEntities())
{
COUNTRY current = data.COUNTRY.Where(x => Country.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.COUNTRY_CODE = Country.CountryCode;
current.NAME = Country.Name;
current.ISO = Country.ISO;
current.ISO3 = Country.ISO3;
current.COUNTRY_NAME = Country.CountryName;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public Guid InsertAuthor(AuthorModel Author)
{
Guid id = Guid.NewGuid();
if (Author == null)
{
throw new NullReferenceException();
}
using (AppTourEntities data = new AppTourEntities())
{
AUTHOR _new = new AUTHOR
{
ID = id,
ENTERPRISE = data.ENTERPRISE.Where(f => f.ID == Author.Enterprise.Id).FirstOrDefault(),
NAME = Author.Name,
REALNAME = Author.RealName,
EMAIL = Author.Email,
CREATION_DATE = DateTime.Now,
UPDATE_DATE = DateTime.Now
};
data.AUTHOR.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public Guid InsertCountry(CountryModel Country)
{
Guid id = Guid.NewGuid();
if (Country == null)
{
throw new NullReferenceException();
}
using (AppTourEntities data = new AppTourEntities())
{
COUNTRY _new = new COUNTRY
{
ID = id,
NAME = Country.Name,
COUNTRY_CODE = Country.CountryCode,
COUNTRY_NAME = Country.CountryName,
ISO = Country.ISO,
ISO3 = Country.ISO3
};
data.COUNTRY.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public bool Deactivate(UserModel user)
{
if (user == null)
{
throw new ArgumentNullException("user");
}
using (AppTourEntities data = new AppTourEntities())
{
USER current = data.USER.Where(p => p.ID == user.Id).SingleOrDefault();
if (current != null)
{
try
{
current.IS_ACTIVE = false;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
return(true);
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
return(false);
}
}
public void UpdateAuthor(AuthorModel Author)
{
using (AppTourEntities data = new AppTourEntities())
{
AUTHOR current = data.AUTHOR.Where(x => Author.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.ENTERPRISE = data.ENTERPRISE.Where(f => f.ID == Author.Id).FirstOrDefault();
current.NAME = Author.Name;
current.REALNAME = Author.RealName;
current.EMAIL = Author.Email;
current.CREATION_DATE = Author.CreationDate;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteUser(UserModel user)
{
if (user == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
USER current = data.USER.Where(p => p.ID == user.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateUser(UserModel user)
{
using (AppTourEntities data = new AppTourEntities())
{
USER current = data.USER.Where(x => user.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.REALNAME = user.RealName;
current.IS_ACTIVE = user.IsActive;
current.CREATION_DATE = user.CreationDate;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateAgent(AgentModel agentModel)
{
using (AppTourEntities data = new AppTourEntities())
{
AGENTS current = data.AGENTS.SingleOrDefault(x => x.ID == agentModel.Id);
if (current != null)
{
try
{
current.NAME = agentModel.Name;
current.IS_ACTIVE = agentModel.IsActive;
current.LAST_EXECUTION_DATE = agentModel.LastExecutionDate;
current.MAX_REQUEST_PER_DAY = agentModel.MaxRequestPerDay;
current.PERIODICITY = agentModel.Periodicity;
current.RATING = agentModel.Rating;
current.LAST_REFERENCE = agentModel.LastReference;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public Guid InsertEnterprise(EnterpriseModel enterprise)
{
Guid id = Guid.NewGuid();
if (enterprise == null)
{
throw new NullReferenceException();
}
using (AppTourEntities data = new AppTourEntities())
{
ENTERPRISE _new = new ENTERPRISE
{
ID = id,
NAME = enterprise.Name,
DESCRIPTION = enterprise.Description,
CREATION_DATE = DateTime.Now,
UPDATE_DATE = DateTime.Now
};
data.ENTERPRISE.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public Guid InsertApp(AppModel App)
{
Guid id = Guid.NewGuid();
if (App == null)
{
throw new NullReferenceException();
}
using (AppTourEntities data = new AppTourEntities())
{
APP _new = new APP
{
ID = id,
ENTERPRISE = data.ENTERPRISE.Where(f => f.ID == App.Enterprise.Id).FirstOrDefault(),
NAME = App.Name,
DESCRIPTION = App.Description,
VERSION = App.Version,
URL = App.URL,
CREATION_DATE = DateTime.Now,
UPDATE_DATE = DateTime.Now
};
data.APP.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public Guid InsertLanguage(LanguageModel language)
{
if (language == null)
{
throw new NullReferenceException("language");
}
Guid id = (language.Id == null || language.Id == Guid.Empty ? Guid.NewGuid() : language.Id);
using (AppTourEntities data = new AppTourEntities())
{
LANGUAGE _new = new LANGUAGE
{
ID = id,
NAME = language.Name,
ISO2 = language.ISO2,
IS_ACTIVE = language.IsActive
};
data.LANGUAGE.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public Guid InsertComment(CommentModel Comment)
{
if (Comment == null)
{
throw new NullReferenceException();
}
using (AppTourEntities data = new AppTourEntities())
{
COMMENT _new = new COMMENT
{
ID = (Comment.Id == null || Comment.Id == Guid.Empty ? Guid.NewGuid() : Comment.Id),
EVENT = (Comment.Event != null ? data.EVENT.SingleOrDefault(x => x.ID.Equals(Comment.Event.Id)) : null),
POINT = (Comment.Point != null ? data.POINT.SingleOrDefault(x => x.ID.Equals(Comment.Point.Id)) : null),
IS_REPORTED = Comment.IsReported,
IS_ACTIVE = Comment.IsActive,
USER = data.USER.SingleOrDefault(x => x.ID.Equals(Comment.User.Id)),
COMMENT1 = Comment.Comment,
CREATION_DATE = DateTime.Now
};
data.COMMENT.AddObject(_new);
data.SaveChanges();
return(_new.ID);
}
}
public void DeleteEnterprise(LanguageModel language)
{
if (language == null)
{
throw new ArgumentNullException("language");
}
using (AppTourEntities data = new AppTourEntities())
{
LANGUAGE current = data.LANGUAGE.Where(p => p.ID == language.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (UpdateException ex)
{
if (ex.InnerException != null)
{
throw new UpdateException(ex.InnerException.Message);
}
throw;
}
catch (Exception)
{
throw;
}
}
}
}
public void UpdateLanguage(LanguageModel language)
{
using (AppTourEntities data = new AppTourEntities())
{
LANGUAGE current = data.LANGUAGE.Where(x => language.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.NAME = language.Name;
current.ISO2 = language.ISO2;
current.IS_ACTIVE = language.IsActive;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateCity(CityModel City)
{
using (AppTourEntities data = new AppTourEntities())
{
CITY current = data.CITY.Where(x => City.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.COUNTRY = data.COUNTRY.Where(x => x.ID == City.Country.Id).SingleOrDefault();
current.NAME = City.Name;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteCity(CityModel City)
{
if (City == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
CITY current = data.CITY.Where(x => x.ID == City.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (UpdateException upx)
{
throw new UpdateException(upx.InnerException.Message);
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteTheme(ThemeModel theme)
{
if (theme == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
THEME current = data.THEME.Where(p => p.ID == theme.Id).SingleOrDefault();
if (current != null)
{
try
{
current.IS_ACTIVE = false;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void UpdateTheme(ThemeModel theme)
{
using (AppTourEntities data = new AppTourEntities())
{
THEME current = data.THEME.Where(x => theme.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.NAME = theme.Name;
current.DESCRIPTION = theme.Description;
current.IMAGE = theme.Image;
current.IS_ACTIVE = theme.IsActive;
current.CREATION_DATE = theme.CreationDate;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void AddNewVote(ClassificationModel Classification)
{
if (Classification == null)
{
throw new NullReferenceException();
}
if (Classification.Point != null)
{
int value = GetClassificationForPoint(Classification.Point).Where(x => x.User.Id == Classification.User.Id).Count();
if (value > 0)
{
return;
}
}
using (AppTourEntities data = new AppTourEntities())
{
CLASSIFICATION _new = new CLASSIFICATION
{
ID = (Classification.Id == null || Classification.Id == Guid.Empty ? Guid.NewGuid() : Classification.Id),
EVENT = (Classification.Event != null ? data.EVENT.SingleOrDefault(x => x.ID.Equals(Classification.Event.Id)) : null),
POINT = (Classification.Point != null ? data.POINT.SingleOrDefault(x => x.ID.Equals(Classification.Point.Id)) : null),
CLASSIFICATION1 = Classification.Classification,
USER = data.USER.SingleOrDefault(x => x.ID.Equals(Classification.User.Id)),
CREATION_DATE = DateTime.Now
};
data.CLASSIFICATION.AddObject(_new);
data.SaveChanges();
}
}
public Guid InsertTheme(ThemeModel theme)
{
Guid id = Guid.NewGuid();
if (theme == null)
{
throw new NullReferenceException("theme");
}
using (AppTourEntities data = new AppTourEntities())
{
THEME _new = new THEME
{
ID = id,
NAME = theme.Name,
DESCRIPTION = theme.Description,
IMAGE = theme.Image,
IS_ACTIVE = theme.IsActive,
CREATION_DATE = DateTime.Now,
UPDATE_DATE = DateTime.Now
};
data.THEME.AddObject(_new);
data.SaveChanges();
}
return(id);
}
public Guid InsertPointAttribute(PointAttributeModel pointAttribute)
{
if (pointAttribute == null)
{
throw new NullReferenceException("pointAttribute");
}
using (AppTourEntities data = new AppTourEntities())
{
POINTS_ATTRIBUTES novo = new POINTS_ATTRIBUTES
{
ID = (pointAttribute.Id == null || pointAttribute.Id == Guid.Empty ? Guid.NewGuid() : pointAttribute.Id),
POINT = data.POINT.Single(x => x.ID.Equals(pointAttribute.Point.Id)),
KEYPAIR = pointAttribute.KeyPair,
VALUE_BOOL = pointAttribute.Value_bool,
VALUE_STRING = pointAttribute.Value_string,
VALUE_DATE = pointAttribute.Value_Date,
VALUE_NUMBER = pointAttribute.Value_number,
VALUE_TYPE = pointAttribute.Value_Type,
IS_ACTIVE = pointAttribute.IsActive
};
data.POINTS_ATTRIBUTES.AddObject(novo);
data.SaveChanges();
return(novo.ID);
}
}
public void UpdateTranslation(TranslationModel translation)
{
using (AppTourEntities data = new AppTourEntities())
{
try
{
TRANSLATIONS edited = data.TRANSLATIONS.Single(x => translation.Id == x.ID);
if (edited != null)
{
edited.TABLE_NAME = translation.TableName;
edited.FIELD_NAME = translation.FieldName;
edited.VALUE = translation.Value;
edited.LANGUAGE = data.LANGUAGE.Single(x => x.ID.Equals(translation.Language.Id));
edited.FOREIGN_ID = translation.ForeignId;
data.SaveChanges();
}
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
public void DeletePointAttribute(PointAttributeModel pointAttributeModel)
{
if (pointAttributeModel == null)
{
throw new ArgumentNullException("pointAttributeModel");
}
using (AppTourEntities data = new AppTourEntities())
{
try
{
POINTS_ATTRIBUTES current = data.POINTS_ATTRIBUTES.Single(p => p.ID == pointAttributeModel.Id);
if (current != null)
{
data.POINTS_ATTRIBUTES.DeleteObject(current);
data.SaveChanges();
}
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
public void UpdateApp(AppModel App)
{
using (AppTourEntities data = new AppTourEntities())
{
APP current = data.APP.Where(x => App.Id == x.ID).SingleOrDefault();
if (current != null)
{
try
{
current.NAME = App.Name;
current.ENTERPRISE = data.ENTERPRISE.Where(f => f.ID == App.Enterprise.Id).FirstOrDefault();
current.DESCRIPTION = App.Description;
current.VERSION = App.Version;
current.URL = App.URL;
current.CREATION_DATE = App.CreationDate;
current.UPDATE_DATE = DateTime.Now;
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteApp(AppModel App)
{
if (App == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
APP current = data.APP.Where(p => p.ID == App.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public void DeleteTopic(TopicModel topic)
{
if (topic == null)
{
throw new ArgumentNullException();
}
using (AppTourEntities data = new AppTourEntities())
{
TOPIC current = data.TOPIC.Where(p => p.ID == topic.Id).SingleOrDefault();
if (current != null)
{
try
{
data.DeleteObject(current);
data.SaveChanges();
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new Exception(e.InnerException.Message);
}
throw;
}
}
}
}
public Guid InsertSearchProfile(SearchProfileModel searchProfile)
{
using (AppTourEntities data = new AppTourEntities())
{
try
{
SEARCH_PROFILE novo = new SEARCH_PROFILE
{
ID = searchProfile.Id == null || searchProfile.Id == Guid.Empty ? Guid.NewGuid() : searchProfile.Id,
NAME = searchProfile.Name,
POINTS_RANGE_DISTANCE = searchProfile.PointsRangeDistance,
SEARCH_CRITERIA = searchProfile.SearchCriteria,
EVENTS_SEARCH_DAYS = searchProfile.EventsSearchDays,
CREATION_DATE = DateTime.Now,
UPDATE_DATE = DateTime.Now,
IS_ACTIVE = searchProfile.IsActive,
USER = data.USER.Single(x => x.ID == searchProfile.Utilizador.Id)
};
if (searchProfile.SearchProfileTopics != null && searchProfile.SearchProfileTopics.Count() > 0)
{
// Adicionar Atributos
searchProfile.SearchProfileTopics.ToList().ForEach(x => novo.SEARCH_PROFILE_TOPIC.Add(new SEARCH_PROFILE_TOPIC
{
ID = Guid.NewGuid(),
TOPIC = data.TOPIC.SingleOrDefault(y => y.ID == x.Id),
SEARCH_PROFILE = novo
}));
}
// Guardar tudo
data.SEARCH_PROFILE.AddObject(novo);
data.SaveChanges();
return(novo.ID);
}
catch (UpdateException upd)
{
throw new UpdateException(upd.InnerException.Message);
}
catch (Exception e)
{
if (e.InnerException != null)
{
throw new ApplicationException(e.InnerException.Message);
}
throw;
}
}
}
