public override bool DeleteContract(ICoreContract contract)
{
try
{
foreach (var contractArticleGroup in contract.ArticleGroups)
{
var deleteArticleGroup = DeleteArticleGroup(contractArticleGroup);
if (!deleteArticleGroup)
{
return(false);
}
}
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\Contract", "DeleteContract");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", contract.Id));
command.ExecuteNonQuery();
var result = command.ExecuteNonQuery();
return(result == 0);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public override ICoreArticleGroup CreateArticleGroup(ICoreContract contract, string name)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ArticleGroup", "CreateArticleGroup");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@name", name));
command.Parameters.Add(CreateParameter("@ownerId", contract.Id));
var id = (int)command.ExecuteScalar();
return(new CoreArticleGroupImpl()
{
Id = id,
Name = name,
OwnerId = contract.Id
});
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public override ICoreContract UpdateContract(ICoreContract contract)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\Contract", "UpdateContract");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", contract.Id));
command.Parameters.Add(CreateParameter("@name", contract.Name));
command.Parameters.Add(CreateParameter("@startDate", contract.StartDate));
command.Parameters.Add(CreateParameter("@endDate", contract.EndDate));
command.ExecuteScalar();
return(contract);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public ContractVm(ICoreContract coreContract)
{
Name = coreContract.Name;
StartDate = coreContract.StartDate;
EndDate = coreContract.EndDate;
Id = coreContract.Id;
ArticleGroups = new ObservableCollection <ArticleGroupVm>();
foreach (var coreArticleGroup in coreContract.ArticleGroups)
{
var articleGroup = new ArticleGroupVm(coreArticleGroup, Id)
{
Name = coreArticleGroup.Name
};
ArticleGroups.Add(articleGroup);
}
}
public override IEnumerable <ICoreArticleGroup> GetArticleGroups(ICoreContract contract)
{
try
{
var articleGroups = new List <ICoreArticleGroup>();
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ArticleGroup", "GetArticleGroups");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@ownerId", contract.Id));
var reader = command.ExecuteReader();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
var articleGroup = GetCoreArticleGroup(reader);
articleGroups.Add(articleGroup);
}
}
}
finally
{
reader?.Close();
}
}
}
return(articleGroups);
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public ICoreArticleGroup CreateArticleGroup(ICoreContract contract, string name)
{
throw new NotImplementedException();
}
public IEnumerable <ICoreArticleGroup> GetArticleGroups(ICoreContract contract)
{
throw new NotImplementedException();
}
public bool DeleteContract(ICoreContract contract)
{
throw new System.NotImplementedException();
}
public ICoreContract UpdateContract(ICoreContract contract)
{
throw new System.NotImplementedException();
}
public abstract ICoreContract UpdateContract(ICoreContract contract);
public static bool DeleteContract(IEhrmannCore ehrmannCore, ICoreContract coreContract)
{
return(ehrmannCore.DeleteContract(coreContract));
}
public abstract bool DeleteContract(ICoreContract contract);
public static ICoreContract UpdateContract(IEhrmannCore ehrmannCore, ICoreContract coreContract)
{
return(ehrmannCore.UpdateContract(coreContract));
}
public ICoreArticleGroup CreateArticleGroup(ICoreContract contract, string name)
{
return(_mapper.CreateArticleGroup(contract, name));
}
public ContractVm(ICoreContract coreContract, MainViewModel owner) : this(coreContract)
{
_owner = owner;
}
public IEnumerable <ICoreArticleGroup> GetArticleGroups(ICoreContract contract)
{
return(_mapper.GetArticleGroups(contract));
}
public bool DeleteContract(ICoreContract contract)
{
return(_mapper.DeleteContract(contract));
}
public ICoreContract UpdateContract(ICoreContract contract)
{
return(_mapper.UpdateContract(contract));
}
public abstract ICoreArticleGroup CreateArticleGroup(ICoreContract contract, string name);
public abstract IEnumerable <ICoreArticleGroup> GetArticleGroups(ICoreContract contract);
