Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement