//==========================================================================================================================================================CREATE==================================================================
/// <summary>
/// Creates new records in db for avilable values in selection.
/// </summary>
/// <param name="availableValues">Enumeration of available values.</param>
/// <param name="property">Entity of selectable property.</param>
internal static bool AddAvailableValues(IEnumerable<string> availableValues, Property property)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
foreach (String availableValue in availableValues)
{
db.AddToAvailableValues(new AvailableValue { Value = availableValue, Property = property.SystemName });
}
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
finally
{
}
}
internal static void AddProperties(string[] properties, Project project, bool visible, bool important, String author)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
foreach (String property in properties)
{
Value toAdd = Value.CreateValue(property, project.Id, visible, important, author);
if (toAdd == null)
{
throw new IllegalDBOperationException(project);
}
else
{
db.AddToValues(toAdd);
}
}
db.SaveChanges();
}
catch(IllegalDBOperationException e)
{
throw e;
}
catch (Exception e)
{
throw new ConnectionException(e);
}
finally
{
}
}
/// <summary>
/// Creates project with specified owner, time of creation and properties that predefined in Validation settings
/// </summary>
/// <param name="owner"></param>
/// <param name="dateTime"></param>
internal static int CreateProject(string owner)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
Project project = Project.CreateProject(DateTime.Now, null);
DbTransaction transaction = db.Connection.BeginTransaction();
try
{
db.AddToProjects(project);
db.SaveChanges();
IEnumerable<String> defaultPropertiesNames = DBDefinitionsHelper.GetDefaultProperties();
foreach (String name in defaultPropertiesNames)
{
Value defaultProperty = Value.CreateValue(name, project.Id, true, true, owner);
if (name == "project_url")
{
defaultProperty.Value1 = DBDefinitionsHelper.GetProjectUrl(project.Id);
defaultProperty.Visible = false;
}
else if (name == "name")
{
defaultProperty.Value1 = DBDefinitionsHelper.GetDefaultProjectName();
}
else if (name == "owner")
{
defaultProperty.Value1 = owner;
}
db.AddToValues(defaultProperty);
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
throw e;
}
return project.Id;
}
catch(InvalidOperationException e)
{
throw new IllegalDBOperationException(e);
}
catch (Exception e)
{
throw new ConnectionException(e);
}
finally
{
db.Connection.Close();
}
}
/// <summary>
///
/// </summary>
/// <param name="external"></param>
/// <param name="visible"></param>
/// <exception cref="ConnectionException" />
internal static void SetVisability(Value external, bool visible)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
Value original = db.Values.FirstOrDefault(x => x.Id == external.Id);
original.Visible = visible;
db.Refresh(System.Data.Objects.RefreshMode.ClientWins, original);
db.SaveChanges();
}
catch (Exception e)
{
throw new ConnectionException(e);
}
finally
{
}
}
/// <summary>
/// Sets available values for specified property instead of existing.
/// </summary>
/// <param name="availablevalues"></param>
/// <param name="property"></param>
/// <exception cref="ConnectionException" />
internal static void SetAvailableValues(IEnumerable<String> availablevalues, Property property)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
foreach (AvailableValue value in property.AvailableValues)
{
DeleteWithoutSubmitting(value, db);
}
foreach (String value in availablevalues)
{
AvailableValue availableValue = AvailableValue.CreateAvailableValue(property.SystemName);
db.AddToAvailableValues(availableValue);
}
db.SaveChanges();
}
catch (Exception e)
{
throw new ConnectionException(e);
}
finally
{
}
}
/// <summary>
/// Saves old version into History table and modifies existing value.
/// </summary>
/// <param name="entity">New values of existing project properties.</param>
/// <param name="author">Author of modification.</param>
/// <returns>If operation was done.</returns>
internal static bool ModifyWithHistory(Value entity)
{
bool operationSuccess = false;
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
DbTransaction transaction = db.Connection.BeginTransaction();
try
{
Value oldVersion = db.Values.FirstOrDefault(x => x.Id == entity.Id);
if (oldVersion == null)
{
throw new IllegalDBOperationException(entity);
}
if (oldVersion.Value1.Equals(entity.Value1))
{
return true;
}
History forOldVersion = new History(oldVersion);
db.AddToHistories(forOldVersion);
if (entity.Important)
{
Project currentProject = db.Projects.FirstOrDefault(x => x.Id == entity.ProjectId);
if (currentProject == null)
{
throw new IllegalDBOperationException(entity);
}
db.SaveChanges();
currentProject.LastChanged = forOldVersion.Id;
db.Refresh(RefreshMode.ClientWins, currentProject);
}
oldVersion.ModifyItself(entity);
db.Refresh(RefreshMode.ClientWins, oldVersion);
db.SaveChanges();
transaction.Commit();
operationSuccess = true;
}
catch(IllegalDBOperationException e)
{
transaction.Rollback();
}
catch (Exception e)
{
transaction.Rollback();
}
finally
{
db.Connection.Close();
}
return operationSuccess;
}
//==================================================================================DELETE===========================================================================================//
/// <summary>
/// Deletes record from db.
/// </summary>
/// <param name="toDelete"></param>
/// <exception cref="ConnectionException" />
internal static void Delete(EntityObject toDelete)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
db.DeleteObject(toDelete);
db.SaveChanges();
}
catch (Exception e)
{
throw new ConnectionException(e);
}
finally
{
}
}
/// <summary>
/// Tryes to create specified property.
/// </summary>
/// <param name="creating">Property to write to db.</param>
/// <returns>If saving was successful.</returns>
internal static bool CreateProperty(Property creating)
{
ProjectPropertiesEntities db = new ProjectPropertiesEntities();
if (db.Connection.State != System.Data.ConnectionState.Open)
{
db.Connection.Open();
}
try
{
db.AddToProperties(creating);
db.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
finally
{
}
}
