Untitled

altervisi0n

Jun 25th, 2025

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

text 1.33 KB | None | 0 0

raw download clone embed print report

private async Task LoadParameters()
{
try
{
string sql = "SELECT * FROM process_activity_param_view1($1, $2)";
var parameters = new List<object> { DbConnect.CodeUser, Id };
using (DataTable dataTable = await DbConnect.GetDataTableParamAsync(sql, parameters))
{
if (dataTable == null) return;
ObservableCollection<ParameterItem> temp = new ObservableCollection<ParameterItem>(
dataTable.AsEnumerable().Select(r => new ParameterItem()
{
Code = r["code"] as int?,
Name = r["name"].ToString(),
Value = r["value"].ToString(),
Date = r["date"] as DateTime?,
User = r["user"].ToString()
}));
foreach (ParameterItem i in temp)
{
if (!string.IsNullOrEmpty(i.User) && i.Date != null)
{
i.UserDateHint = i.User + " " + ((DateTime)i.Date).ToString("dd.MM.yyyy HH:mm");
}
if (string.IsNullOrEmpty(i.Hint))
{
i.Hint = null;
}
}
ItemsCombobox = temp;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

Add Comment

Please, Sign In to add comment