public DBOptionResponse UpdateDBOption(DBOptionEntity dbOptionEntity)
{
var response = new DBOptionResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!dbOptionEntity.Validate())
{
foreach (string error in dbOptionEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.Message = DBOptionDao.UpdateDBOption(dbOptionEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.OptionId = dbOptionEntity.OptionId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
/// <summary>
/// Gets the database options.
/// </summary>
/// <param name="request">The request.</param>
/// <returns></returns>
public DBOptionResponse GetDBOptions(DBOptionRequest request)
{
var response = new DBOptionResponse();
if (request.LoadOptions.Contains("DBOptions"))
{
if (request.LoadOptions.Contains("ValueType"))
{
response.DBOptions = DBOptionDao.GetDBOptionsByValueType(request.ValueType);
}
else if (request.LoadOptions.Contains("IsSystem"))
{
response.DBOptions = DBOptionDao.GetDBOptionsBySystem(true);
}
else
{
response.DBOptions = DBOptionDao.GetDBOptions();
}
}
if (request.LoadOptions.Contains("DBOption"))
{
response.DBOption = DBOptionDao.GetDBOption(request.DBOptionId);
}
return(response);
}
public DBOptionResponse SetDBOptions(DBOptionRequest request)
{
var response = new DBOptionResponse();
var dbOptionEntities = request.DBOptions;
try
{
if (request.Action == PersistType.Update)
{
if (request.DBOptions != null)
{
using (var scope = new TransactionScope())
{
foreach (var dbOption in dbOptionEntities)
{
if (!dbOption.Validate())
{
foreach (var error in dbOption.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.Message = DBOptionDao.UpdateDBOption(dbOption);
if (response.Message == null)
{
continue;
}
response.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(response);
}
scope.Complete();
}
}
else
{
var dbOptionEntity = request.DBOption;
if (!dbOptionEntity.Validate())
{
foreach (var error in dbOptionEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.Message = DBOptionDao.UpdateDBOption(dbOptionEntity);
}
}
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
response.Acknowledge = response.Message != null ? AcknowledgeType.Failure : AcknowledgeType.Success;
return(response);
}
