internal List <PickListValueFavourite> GetPicklistValueFavourites(string tenantCode, short picklistId, Guid userId)
{
var lstPicklistFavourites = new List <PickListValueFavourite>();
try
{
var cmd = CreateProcedureCommand("dbo.PicklistValue_GetFavourite");
cmd.AppendXSmallText("@strTenantCode", tenantCode);
cmd.AppendSmallInt("@intPicklistId", picklistId);
cmd.AppendGuid("@guidUserId", userId);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
var info = new PickListValueFavourite
{
PicklistId = (short)(reader.IsDBNull(0) ? 0 : reader.GetInt16(0)),
PicklistValueId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1),
UserId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2),
};
lstPicklistFavourites.Add(info);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "PickListValueFavourite::GetPicklistValueFavourites");
}
return(lstPicklistFavourites);
}
internal void CreatePicklistValueFavourite(string tenantCode, PickListValueFavourite pickListValueFavourite)
{
try
{
var cmd = CreateProcedureCommand("dbo.PicklistValue_Create_Favourite");
cmd.AppendXSmallText("@strTenantCode", tenantCode);
cmd.AppendSmallInt("@intPicklistId", pickListValueFavourite.PicklistId);
cmd.AppendGuid("@guidPicklistValueId", pickListValueFavourite.PicklistValueId);
cmd.AppendGuid("@guidUserId", pickListValueFavourite.UserId);
ExecuteCommand(cmd);
}
catch (SqlException e)
{
_log.Error(e);
throw ReportAndTranslateException(e, "PickListValueFavourite::CreatePicklistValueFavourite");
}
}
