public override global::System.Data.DataTable Clone()
{
ResultDataTable cln = ((ResultDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private DataRow AddResultTableRow(WorkItem workItem, Revision workItemRevisions, string changedBy, Field remainingWorkField, Field completedWorkField, double?completedDelta, double?remainingDelta, double?rqEffort, string error, bool isOpenIssue)
{
DataRow dr = ResultDataTable.NewRow();
dr.ItemArray = new object[] {
workItemRevisions == null ? workItem.RevisedDate : workItemRevisions.Fields["Changed Date"].Value,
string.IsNullOrEmpty(changedBy) ? workItem.Fields["System.AssignedTo"].Value : changedBy,
workItemRevisions == null ? workItem.Id : workItemRevisions.Fields["ID"].Value,
workItemRevisions == null ? workItem.Title : workItemRevisions.Fields["Title"].Value,
workItem.Type.Name,
workItemRevisions == null ? workItem.IterationPath : workItemRevisions.Fields["Iteration Path"].Value,
workItemRevisions == null ? string.Empty : workItemRevisions.Fields["Stack Rank"].Value ?? string.Empty,
completedWorkField == null ? 0d : completedWorkField.OriginalValue ?? 0d,
completedWorkField == null ? 0d : completedWorkField.Value,
remainingWorkField == null ? 0d : remainingWorkField.OriginalValue ?? 0d,
remainingWorkField == null ? 0d : remainingWorkField.Value ?? 0d,
rqEffort == null || isOpenIssue ? 0d : rqEffort.Value,
!isOpenIssue || rqEffort == null ? 0d : rqEffort.Value,
completedDelta == null ? 0d : completedDelta.Value,
remainingDelta == null ? 0d : remainingDelta.Value,
(remainingDelta == null || completedDelta == null) ? 0d : (completedDelta.Value + remainingDelta.Value)
};
dr.RowError = error;
AddRowToTable(dr);
return(dr);
}
private void updateTable(ProblemResult result)
{
ResultTabs.Clear();
for (int i = 0; i < result.TableResult.Values.Count; ++i)
{
ResultDataTable resultDataTable = new ResultDataTable(result.TableResult.Values[i]);
DataGrid dataGrid = new DataGrid();
dataGrid.IsReadOnly = true;
dataGrid.CanUserSortColumns = false;
dataGrid.CanUserAddRows = false;
dataGrid.CanUserDeleteRows = false;
dataGrid.CanUserResizeRows = false;
dataGrid.CanUserResizeColumns = false;
dataGrid.SelectionUnit = DataGridSelectionUnit.Cell;
dataGrid.ItemsSource = resultDataTable.AsDataView;
TabItem tabItem = new TabItem();
tabItem.Header =
string.IsNullOrEmpty(result.TableResult.Values[i].Title)
? (i + 1).ToString() : result.TableResult.Values[i].Title;
tabItem.Content = dataGrid;
ResultTabs.Add(tabItem);
}
if (ResultTabs.Count > 0)
{
tcResultsTabs.SelectedIndex = 0;
tcResultsTabs.SelectedItem = ResultTabs.First();
ResultTabs.First().IsSelected = true;
}
}
private void InitClass()
{
this.DataSetName = "ResultDataSet1";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ResultDataSet1.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableResult = new ResultDataTable();
base.Tables.Add(this.tableResult);
}
internal void InitVars(bool initTable)
{
this.tableResult = ((ResultDataTable)(base.Tables["Result"]));
if ((initTable == true))
{
if ((this.tableResult != null))
{
this.tableResult.InitVars();
}
}
}
private void LoadRows([NotNull] ResultDataTable dataTable, [NotNull] XElement element)
{
Debug.ArgumentNotNull(dataTable, nameof(dataTable));
Debug.ArgumentNotNull(element, nameof(element));
var itemsElement = element.Element(@"rows");
if (itemsElement == null)
{
return;
}
if (!itemsElement.Elements().Any())
{
var dataRow = (ResultDataRow)dataTable.NewRow();
dataTable.Rows.Add(dataRow);
return;
}
foreach (var item in itemsElement.Elements())
{
var fieldArray = new List <FieldUri>();
var columnArray = new List <string>();
var languageName = item.GetAttributeValue("language", LanguageManager.CurrentLanguage.Name) ?? "en";
var itemUri = new ItemUri(DatabaseUri, new ItemId(new Guid(item.GetAttributeValue("id"))));
var itemVersionUri = new ItemVersionUri(itemUri, new Language(languageName), Data.Version.Latest);
foreach (var field in item.Elements())
{
FieldUri fieldUri = null;
var id = field.GetAttributeValue("id");
if (!string.IsNullOrEmpty(id))
{
fieldUri = new FieldUri(itemVersionUri, new FieldId(new Guid(id)));
}
fieldArray.Add(fieldUri);
columnArray.Add(field.Value);
}
var dataRow = (ResultDataRow)dataTable.NewRow();
dataRow.Name = item.GetAttributeValue("name");
dataRow.Icon = new Icon(DatabaseUri.Site, item.GetAttributeValue("icon"));
dataRow.ItemUri = itemUri;
dataRow.FieldArray = fieldArray.ToArray();
dataRow.ItemArray = columnArray.ToArray();
dataTable.Rows.Add(dataRow);
}
}
private FrameworkElement LoadTable([NotNull] XElement element)
{
// data table
Debug.ArgumentNotNull(element, nameof(element));
var dataTable = new ResultDataTable
{
TableName = @"Table"
};
dataTable.RowChanged += DataTableOnRowChanged;
LoadColumns(dataTable, element);
LoadRows(dataTable, element);
dataTable.AcceptChanges();
DataTables.Add(dataTable);
// datagrid
var dataGrid = new DataGrid
{
VerticalAlignment = VerticalAlignment.Stretch,
RowHeaderWidth = 0,
CanUserReorderColumns = false,
CanUserSortColumns = false,
CanUserAddRows = false,
CanUserDeleteRows = false,
Tag = dataTable
};
dataGrid.BeginningEdit += OnBeginningEdit;
dataGrid.PreviewMouseRightButtonDown += HandleRightMouseDown;
DataGrids.Add(dataGrid);
dataGrid.ItemsSource = dataTable.DefaultView;
return(dataGrid);
}
private void LoadColumns([NotNull] ResultDataTable dataTable, [NotNull] XElement element)
{
Debug.ArgumentNotNull(dataTable, nameof(dataTable));
Debug.ArgumentNotNull(element, nameof(element));
var columnsElement = element.Element(@"columns");
if (columnsElement == null)
{
return;
}
foreach (var e in columnsElement.Elements())
{
var dataColumn = new DataColumn(e.GetAttributeValue("name"), typeof(string))
{
ReadOnly = e.GetAttributeValue("isreadonly") == @"true"
};
dataTable.Columns.Add(dataColumn);
}
}
internal ResultRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableResult = ((ResultDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "DataSet";
this.Prefix = "";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableResult = new ResultDataTable();
base.Tables.Add(this.tableResult);
}
public async Task <ResultDataTable> Obtener(PedidoDetalleObtenerFiltroDto prm)
{
ResultDataTable resultado = new ResultDataTable();
long totalRegistros = 0;
List <PedidoDetalleObtenerPorIdPedidoDtoApi> lista = new List <PedidoDetalleObtenerPorIdPedidoDtoApi>();
int statusCode = 0;
try
{
try
{
prm.Length = 100;
}
catch
{
}
var response = string.Empty;
string url = string.Format("{0}{1}/ObtenerPorIdPedido/{2}", ConstanteVo.UrlBaseApi, _nombreControlador, prm.IdPedido);
using (var client = new HttpClient())
{
if (ConstanteVo.ActivarLLamadasConToken && !string.IsNullOrEmpty(ConfiguracionToken.ConfigToken))
{
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ConfiguracionToken.ConfigToken.Trim());
}
HttpResponseMessage result = await client.GetAsync(new Uri(url));
if (result != null)
{
response = await result.Content.ReadAsStringAsync();
statusCode = (int)result.StatusCode;
}
}
ResponsePedidoDetalleObtenerPorIdPedidoDtoApi root = JsonConvert.DeserializeObject <ResponsePedidoDetalleObtenerPorIdPedidoDtoApi>(response);
if (root != null && root.Cuerpo != null)
{
lista = root.Cuerpo;
totalRegistros = root.CantidadTotalRegistros;
if (lista.Any())
{
int indice = Convert.ToInt32(prm.Start) + 1;
foreach (var item in lista)
{
item.Item = indice;
indice++;
}
}
}
}
catch (Exception ex)
{
string exMessage = (ex.InnerException == null ? ex.Message : ex.InnerException.Message).Replace(Environment.NewLine, " ");
Log(Level.Error, exMessage);
resultado.error = exMessage;
}
finally
{
resultado.data = lista;
resultado.draw = prm.Draw;
resultado.recordsTotal = (int)totalRegistros;
resultado.recordsFiltered = (int)totalRegistros;
if (resultado != null)
{
resultado.StatusCode = statusCode;
}
}
return(resultado);
}
private void InitClass() {
this.DataSetName = "DataSet1";
this.Prefix = "";
this.Namespace = "http://tempuri.org/DataSet1.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableStation_Table = new Station_TableDataTable();
base.Tables.Add(this.tableStation_Table);
this.tableGoods_Table = new Goods_TableDataTable();
base.Tables.Add(this.tableGoods_Table);
this.tableResult = new ResultDataTable();
base.Tables.Add(this.tableResult);
this.tableMyDate = new MyDateDataTable();
base.Tables.Add(this.tableMyDate);
this.tableResult_t1 = new Result_t1DataTable();
base.Tables.Add(this.tableResult_t1);
this.tableResult_t2 = new Result_t2DataTable();
base.Tables.Add(this.tableResult_t2);
this.tableResult_t3 = new Result_t3DataTable();
base.Tables.Add(this.tableResult_t3);
this.tableTemp_Result = new Temp_ResultDataTable();
base.Tables.Add(this.tableTemp_Result);
this.tableResult_t0 = new Result_t0DataTable();
base.Tables.Add(this.tableResult_t0);
this.relationStation_Table_Goods_Table = new global::System.Data.DataRelation("Station_Table_Goods_Table", new global::System.Data.DataColumn[] {
this.tableStation_Table.IDColumn}, new global::System.Data.DataColumn[] {
this.tableGoods_Table.IDColumn}, false);
this.Relations.Add(this.relationStation_Table_Goods_Table);
this.relationMyDate_Result = new global::System.Data.DataRelation("MyDate_Result", new global::System.Data.DataColumn[] {
this.tableMyDate.DateIDColumn}, new global::System.Data.DataColumn[] {
this.tableResult.DateIDColumn}, false);
this.Relations.Add(this.relationMyDate_Result);
}
internal ResultRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableResult = ((ResultDataTable)(this.Table));
}
internal void InitVars(bool initTable) {
this.tableStation_Table = ((Station_TableDataTable)(base.Tables["Station_Table"]));
if ((initTable == true)) {
if ((this.tableStation_Table != null)) {
this.tableStation_Table.InitVars();
}
}
this.tableGoods_Table = ((Goods_TableDataTable)(base.Tables["Goods_Table"]));
if ((initTable == true)) {
if ((this.tableGoods_Table != null)) {
this.tableGoods_Table.InitVars();
}
}
this.tableResult = ((ResultDataTable)(base.Tables["Result"]));
if ((initTable == true)) {
if ((this.tableResult != null)) {
this.tableResult.InitVars();
}
}
this.tableMyDate = ((MyDateDataTable)(base.Tables["MyDate"]));
if ((initTable == true)) {
if ((this.tableMyDate != null)) {
this.tableMyDate.InitVars();
}
}
this.tableResult_t1 = ((Result_t1DataTable)(base.Tables["Result_t1"]));
if ((initTable == true)) {
if ((this.tableResult_t1 != null)) {
this.tableResult_t1.InitVars();
}
}
this.tableResult_t2 = ((Result_t2DataTable)(base.Tables["Result_t2"]));
if ((initTable == true)) {
if ((this.tableResult_t2 != null)) {
this.tableResult_t2.InitVars();
}
}
this.tableResult_t3 = ((Result_t3DataTable)(base.Tables["Result_t3"]));
if ((initTable == true)) {
if ((this.tableResult_t3 != null)) {
this.tableResult_t3.InitVars();
}
}
this.tableTemp_Result = ((Temp_ResultDataTable)(base.Tables["Temp_Result"]));
if ((initTable == true)) {
if ((this.tableTemp_Result != null)) {
this.tableTemp_Result.InitVars();
}
}
this.tableResult_t0 = ((Result_t0DataTable)(base.Tables["Result_t0"]));
if ((initTable == true)) {
if ((this.tableResult_t0 != null)) {
this.tableResult_t0.InitVars();
}
}
this.relationStation_Table_Goods_Table = this.Relations["Station_Table_Goods_Table"];
this.relationMyDate_Result = this.Relations["MyDate_Result"];
}
// TODO: ?
public ResultDataTable QueryNew(String search)
{
// TODO: Umschreiben von ServerPathen auf lokale Pfade
List<String> qryResult = QueryRaw(search);
ResultDataTable result = new ResultDataTable();
foreach (String srvPath in qryResult)
{
}
return result;
}
public async Task <ResultDataTable> Obtener(TipoEstadoObtenerFiltroDto prm)
{
ResultDataTable resultado = new ResultDataTable();
long totalRegistros = 0;
List <TipoEstadoObtenerDtoApi> lista = new List <TipoEstadoObtenerDtoApi>();
int statusCode = 0;
try
{
//Dentro de AJAX => datatype: 'json', headers: {'Authorization': 'Basic ' + valor token }, ....
RequestTipoEstadoObtenerDtoApi filtroApi = new RequestTipoEstadoObtenerDtoApi
{
Buscar = string.IsNullOrEmpty(prm.Buscar) ? string.Empty : prm.Buscar,
};
if (prm.Start == null)
{
prm.Start = 0;
}
filtroApi.CantidadRegistros = prm.Length == null ? 10 : Convert.ToInt32(prm.Length);
filtroApi.NumeroPagina = (Convert.ToInt32(prm.Start) / filtroApi.CantidadRegistros) + 1;
if (prm.Order != null && prm.Order.Count > 0)
{
filtroApi.ColumnaOrden = prm.Columns[prm.Order[0].Column].Name;
filtroApi.DireccionOrden = prm.Order[0].Dir;
}
var response = string.Empty;
string url = string.Format("{0}{1}/Obtener", ConstanteVo.UrlBaseApi, _nombreControlador);
using (var client = new HttpClient())
{
if (ConstanteVo.ActivarLLamadasConToken && !string.IsNullOrEmpty(ConfiguracionToken.ConfigToken))
{
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ConfiguracionToken.ConfigToken.Trim());
}
var content = new StringContent(JsonConvert.SerializeObject(filtroApi), Encoding.UTF8, "application/json");
HttpResponseMessage result = await client.PostAsync(new Uri(url), content);
if (result != null)
{
response = await result.Content.ReadAsStringAsync();
statusCode = (int)result.StatusCode;
}
}
ResponseTipoEstadoObtenerDtoApi root = JsonConvert.DeserializeObject <ResponseTipoEstadoObtenerDtoApi>(response);
if (root != null && root.Cuerpo != null)
{
lista = root.Cuerpo;
totalRegistros = root.CantidadTotalRegistros;
if (lista.Any())
{
int indice = Convert.ToInt32(prm.Start) + 1;
foreach (var item in lista)
{
item.Item = indice;
indice++;
}
}
}
}
catch (Exception ex)
{
string exMessage = (ex.InnerException == null ? ex.Message : ex.InnerException.Message).Replace(Environment.NewLine, " ");
Log(Level.Error, exMessage);
resultado.error = exMessage;
}
finally
{
resultado.data = lista;
resultado.draw = prm.Draw;
resultado.recordsTotal = (int)totalRegistros;
resultado.recordsFiltered = (int)totalRegistros;
if (resultado != null)
{
resultado.StatusCode = statusCode;
}
}
return(resultado);
}
internal void InitVars(bool initTable) {
this.tableResult = ((ResultDataTable)(base.Tables["Result"]));
if ((initTable == true)) {
if ((this.tableResult != null)) {
this.tableResult.InitVars();
}
}
}
