/// <summary>
/// Creates a new Version Info entity.
/// </summary>
/// <param name="component">The name of the component.</param>
/// <param name="version">The version of the component.</param>
/// <returns>A <see cref="ManagerResponse"/> object.</returns>
public ManagerResponse Add(string component, string version)
{
// Validate parameters
if (String.IsNullOrWhiteSpace(component))
{
return ManagerResponse.InvalidData;
}
if (String.IsNullOrWhiteSpace(version))
{
return ManagerResponse.InvalidData;
}
var sqlScriptVersionInfo = new SqlScriptVersionInfo()
{
Component = component,
Version = version,
};
ManagerResponse response;
using (var context = new Entities(_connectionString))
{
context.SqlScriptVersionInfos.AddObject(sqlScriptVersionInfo as SqlScriptVersionInfo);
response = context.SaveChanges() == 1 ? ManagerResponse.Success : ManagerResponse.UnknownFailure;
}
return response;
}
/// <summary>
/// Updates the specified <see cref="IVersionInfo"/> entity.
/// </summary>
/// <param name="versionInfo">The <see cref="IVersionInfo"/> entity to update.</param>
/// <returns>A <see cref="ManagerResponse"/> object.</returns>
public ManagerResponse Update(IVersionInfo versionInfo)
{
// Validate parameters
if (versionInfo == null)
{
return ManagerResponse.MissingData;
}
if (String.IsNullOrWhiteSpace(versionInfo.Component))
{
return ManagerResponse.InvalidData;
}
if (String.IsNullOrWhiteSpace(versionInfo.Version))
{
return ManagerResponse.InvalidData;
}
ManagerResponse response;
using (var context = new Entities(_connectionString))
{
context.SqlScriptVersionInfos.Attach(versionInfo as SqlScriptVersionInfo);
context.ObjectStateManager.ChangeObjectState(versionInfo, EntityState.Modified);
response = context.SaveChanges() == 1 ? ManagerResponse.Success : ManagerResponse.UnknownFailure;
}
return response;
}