// Maps the dynamic result
private static MspWorklogType MapWorklogType(dynamic res)
{
var type = new MspWorklogType {
Id = res.picklistid, Description = res.value, IsRemoved = false
};
if (type.Description.Contains("Removed"))
{
type.IsRemoved = true;
}
return(type);
}
/// <inheritdoc />
public void Add(MspWorklogType worklogType)
{
const string query = "INSERT INTO udf_picklistvalues(picklistid, tablename, columname, value) " +
"VALUES (nextval('picklist_id_seq'), 'WorkLog_Fields', 'UDF_CHAR1', @Desc) RETURNING picklistid";
var param = new
{
Desc = worklogType.Description
};
worklogType.Id = Connection.ExecuteScalar <long>(query, param, Transaction);
}
/// <inheritdoc />
public void Remove(MspWorklogType worklogType)
{
const string query = "UPDATE udf_picklistvalues" +
"SET value = @Desc " +
"WHERE picklistid = @Id";
var param = new
{
Desc = $"Removed - {worklogType.Description}",
Id = worklogType.Id,
};
worklogType.Id = Connection.ExecuteScalar <long>(query, param, Transaction);
}
