public override ICoreArticleGroup UpdateArticleGroup(ICoreArticleGroup articleGroup)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ArticleGroup", "UpdateArticleGroup");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", articleGroup.Id));
command.Parameters.Add(CreateParameter("@name", articleGroup.Name));
command.ExecuteScalar();
return(articleGroup);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public override bool DeleteArticleGroup(ICoreArticleGroup articleGroup)
{
try
{
foreach (var conditionType in articleGroup.ConditionTypes)
{
var deleteConditionType = DeleteConditionType(conditionType);
if (!deleteConditionType)
{
return(false);
}
}
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ArticleGroup", "DeleteArticleGroup");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@id", articleGroup.Id));
command.ExecuteNonQuery();
var result = command.ExecuteNonQuery();
return(result == 0);
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public ArticleGroupVm(ICoreArticleGroup coreArticleGroup, int coreContractId)
{
OwnerId = coreContractId;
ConditionTypes = new ObservableCollection <ConditionTypeVm>();
foreach (var coreConditionType in coreArticleGroup.ConditionTypes)
{
var conditionType = new ConditionTypeVm(coreArticleGroup.Id)
{
Id = coreConditionType.Id,
Name = coreConditionType.Name,
Retro = coreConditionType.Retro,
RetroDistr = coreConditionType.RetroDistr,
Rku = coreConditionType.Rku,
RkuDistr = coreConditionType.RetroDistr
};
ConditionTypes.Add(conditionType);
}
}
public override IEnumerable <ICoreConditionType> GetConditionTypes(ICoreArticleGroup articleGroup)
{
try
{
var conditionTypes = new List <ICoreConditionType>();
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ConditionType", "GetConditionTypes");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@ownerId", articleGroup.Id));
var reader = command.ExecuteReader();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
var conditionType = GetCoreConditionType(reader);
conditionTypes.Add(conditionType);
}
}
}
finally
{
reader?.Close();
}
}
}
return(conditionTypes);
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public override ICoreConditionType CreateConditionType(ICoreArticleGroup articleGroup, string name, int retro, int retroDistr, int rku, int rkuDistr)
{
try
{
using (var connection = CreateConnection(_connection))
{
connection.Open();
var commandText = GetScript(ScriptsSection, ScriptsSqlPath + @"\ConditionType", "CreateConditionType");
using (var command = CreateCommang(commandText, connection))
{
command.CommandTimeout = GetCommandTimeout();
command.Parameters.Add(CreateParameter("@name", name));
command.Parameters.Add(CreateParameter("@retro", retro));
command.Parameters.Add(CreateParameter("@retroDistr", retroDistr));
command.Parameters.Add(CreateParameter("@rku", rku));
command.Parameters.Add(CreateParameter("@rkuDistr", rkuDistr));
command.Parameters.Add(CreateParameter("@ownerId", articleGroup.Id));
var id = (int)command.ExecuteScalar();
return(new CoreConditionTypeImpl()
{
Id = id,
Name = name,
Retro = retro,
RetroDistr = retroDistr,
Rku = rku,
RkuDistr = rkuDistr,
OwnerId = articleGroup.Id
});
}
}
}
catch (Exception ex)
{
// тут хорошо бы задействовать логгер, например, NLog
Trace.TraceError(ex.Message);
throw;
}
}
public bool DeleteArticleGroup(ICoreArticleGroup articleGroup)
{
throw new NotImplementedException();
}
public ICoreArticleGroup UpdateArticleGroup(ICoreArticleGroup articleGroup)
{
throw new NotImplementedException();
}
public abstract ICoreArticleGroup UpdateArticleGroup(ICoreArticleGroup articleGroup);
public IEnumerable <ICoreConditionType> GetConditionTypes(ICoreArticleGroup articleGroup)
{
return(_mapper.GetConditionTypes(articleGroup));
}
public bool DeleteArticleGroup(ICoreArticleGroup articleGroup)
{
return(_mapper.DeleteArticleGroup(articleGroup));
}
public ICoreArticleGroup UpdateArticleGroup(ICoreArticleGroup articleGroup)
{
return(_mapper.UpdateArticleGroup(articleGroup));
}
public abstract ICoreConditionType CreateConditionType(ICoreArticleGroup articleGroup, string name, int retro, int retroDistr, int rku, int rkuDistr);
public abstract IEnumerable <ICoreConditionType> GetConditionTypes(ICoreArticleGroup articleGroup);
public abstract bool DeleteArticleGroup(ICoreArticleGroup articleGroup);
public IEnumerable <ICoreConditionType> GetConditionTypes(ICoreArticleGroup articleGroup)
{
throw new NotImplementedException();
}
public ICoreConditionType CreateConditionType(ICoreArticleGroup articleGroup, string name, int retro, int retroDistr, int rku, int rkuDistr)
{
throw new NotImplementedException();
}
public ICoreConditionType CreateConditionType(ICoreArticleGroup articleGroup, string name, int retro, int retroDistr, int rku, int rkuDistr)
{
return(_mapper.CreateConditionType(articleGroup, name, retro, retroDistr, rku, rkuDistr));
}
