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>
/// Takes the specified bank.
/// </summary>
/// <param name="bank">The bank.</param>
/// <returns></returns>
private static object[] Take(DBOptionEntity bank)
{
return(new object[]
{
"@OptionID", bank.OptionId,
"@OptionValue", bank.OptionValue,
"@ValueType", bank.ValueType,
"@Description", bank.Description,
"@IsSystem", bank.IsSystem
});
}
/// <summary>
/// Updates the database option.
/// </summary>
/// <param name="dBOption">The d b option.</param>
/// <returns></returns>
public string UpdateDBOption(DBOptionEntity dBOption)
{
const string sql = @"uspUpdate_DBOption";
return(Db.Update(sql, true, Take(dBOption)));
}
