public object ExcluirRelatorioAcompanhamentoDiario([FromBody] JObject data)
{
Resposta resposta = new Resposta();
try
{
AFElement afElement = data.ToObject <AFElement>();
string path = @"\\" + PISystemName + @"\" + DatabaseName;
// Verify if Database exists
if (!PIWebAPIAccess.GetDatabase(BaseUrl, path))
{
throw new Exception(string.Format("Database {0} does not existis!", DatabaseName));
}
path = path + @"\" + MasterReportElementName;
// Verify if element "Reports" exists
if (!PIWebAPIAccess.GetElement(BaseUrl, path))
{
throw new Exception(string.Format("Element {0} does not existis!", MasterReportElementName));
}
path = path + @"\" + afElement.Name;
PIWebAPIAccess.DeleteElement(BaseUrl, path);
resposta.Status = true;
}
catch (Exception ex)
{
resposta.Status = false;
resposta.Mensagem = ex.Message;
}
return(resposta);
}
public object SalvarRelatorioAcompanhamentoDiario([FromBody] JObject data)
{
Resposta resposta = new Resposta();
try
{
AFElement afElement = data.ToObject <AFElement>();
string path = @"\\" + PISystemName + @"\" + DatabaseName;
// Verify if Database exists
if (!PIWebAPIAccess.GetDatabase(BaseUrl, path))
{
throw new Exception(string.Format("Database {0} does not existis!", DatabaseName));
}
path = path + @"\" + MasterReportElementName;
// Verify if element "Reports" exists
if (!PIWebAPIAccess.GetElement(BaseUrl, path))
{
throw new Exception(string.Format("Element {0} does not existis!", MasterReportElementName));
}
path = @"\\" + PISystemName + @"\" + DatabaseName + @"\" + MasterReportElementName + @"\" + afElement.Name;
// Verify if current "Relatorio de Acompanhameto Diario" exists
if (PIWebAPIAccess.GetElementByWebId(BaseUrl, afElement.WebId))
{
PIWebAPIAccess.DeleteElementByWebId(BaseUrl, afElement.WebId);
}
path = @"\\" + PISystemName + @"\" + DatabaseName + @"\" + MasterReportElementName;
// Create current "Relatorio de Acompanhameto Diario" element
PIWebAPIAccess.CreateElement(BaseUrl, path, ref afElement);
// Create each attribute for the "Relatorio de Acompanhameto Diario" element
foreach (var item in afElement.Attributes)
{
PIWebAPIAccess.CreateAttribute(BaseUrl, afElement.Path, item.Name, item.Value);
}
resposta.Dados = afElement;
resposta.Status = true;
}
catch (Exception ex)
{
resposta.Status = false;
resposta.Mensagem = ex.Message;
}
return(resposta);
}
public object RecuperarRelatorioAcompanhamentoDiario()
{
Resposta resposta = new Resposta();
try
{
string path = @"\\" + PISystemName + @"\" + DatabaseName;
// Verify if Database exists
if (!PIWebAPIAccess.GetDatabase(BaseUrl, path))
{
path = @"\\" + PISystemName;
PIWebAPIAccess.CreateDatabase(BaseUrl, path, DatabaseName);
path = @"\\" + PISystemName + @"\" + DatabaseName;
}
path = path + @"\" + MasterReportElementName;
// Verify if element "Reports" exists
if (!PIWebAPIAccess.GetElement(BaseUrl, path))
{
path = @"\\" + PISystemName + @"\" + DatabaseName;
PIWebAPIAccess.CreateMasterElement(BaseUrl, path, MasterReportElementName);
path = path + @"\" + MasterReportElementName;
}
List <AFElement> afElements = new List <AFElement>();
// Get all elements childs
afElements = PIWebAPIAccess.GetChildsElements(BaseUrl, path);
// Get all Attributes childs
foreach (var item in afElements)
{
item.Attributes = PIWebAPIAccess.GetAttributes(BaseUrl, item.Path);
}
resposta.Dados = afElements;
resposta.Status = true;
}
catch (Exception ex)
{
resposta.Status = false;
resposta.Mensagem = ex.Message;
}
return(resposta);
}
public object RecuperarDadosRelatorioAcompanhamentoDiario([FromBody] JObject data)
{
Resposta resposta = new Resposta();
try
{
AFElement afElement = JsonConvert.DeserializeObject <AFElement>(data.GetValue("RelatorioAcompanhamentoDiario").ToString(), dateTimeConverter);
DateTime dataInicial = DateTime.Parse(data.GetValue("Data").ToString()).Date;
DateTime dataFinal = dataInicial.AddDays(1);
string path = @"\\" + PISystemName + @"\" + DatabaseName;
RelatorioAcompanhamentoDiario relatorioAcompanhamentoDiario = new RelatorioAcompanhamentoDiario();
foreach (AFAttribute item in afElement.Attributes)
{
RelatorioAcompanhamentoDiario.InformacaoAttributo dados = new RelatorioAcompanhamentoDiario.InformacaoAttributo();
dados.AFAttribute = item;
dados.Summary.MediaDiaria = PIWebAPIAccess.GetSummaryData(BaseUrl, item.Path, dataInicial, dataFinal, "Average");
dados.Summary.DesvioPadrao = PIWebAPIAccess.GetSummaryData(BaseUrl, item.Path, dataInicial, dataFinal, "StdDev");
dados.Summary.MediaHoraria = PIWebAPIAccess.GetSummaryData(BaseUrl, item.Path, dataInicial, dataFinal, "Average", "1h");
//dados.Summary.MediaHoraria = new List<double>(new double[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 00});
relatorioAcompanhamentoDiario.Informacao.Add(dados);
}
resposta.Dados = relatorioAcompanhamentoDiario;
resposta.Status = true;
}
catch (Exception ex)
{
resposta.Status = false;
resposta.Mensagem = ex.Message;
}
return(resposta);
}