public dynamic UpdateDtProcessamento(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " UPDATE [dbo].[LogProcessamento] ";
query += " SET [dtProcessamento] = @dtProcessamento, ";
query += " [flgErroProcessamento] = @flgErroProcessamento, ";
query += " [dscErroProcessamento] = @dscErroProcessamento ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
/*-----------*/
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
internal void DeleteWorkItem(List <int> idWIList, int ativo)
{
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.Ativo = ativo;
StringBuilder idsToDelete = new StringBuilder();
try
{
foreach (var item in idWIList)
{
idsToDelete.Append(item);
}
String query = "UPDATE [dbo].[TFS_WorkItem]";
query += "SET [Ativo] = @Ativo ";
query += "WHERE [Id_WorkItem] in (" + idsToDelete + ")";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
}
catch (Exception e)
{
throw e;
}
}
public dynamic UpdateDtRegistro(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " UPDATE [dbo].[" + tabelaLog + "] ";
query += " SET [Dt_Registro] = @Dt_Registro ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
/*-----------*/
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
public dynamic UpdateWorkItemRevision(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = "UPDATE [dbo].[TFS_Revisions]";
query += " SET [Json_Revisions] = @Json_Revisions , [Dt_Registro] = @Dt_Registro ";
query += " WHERE [Id_WorkItem] = @Id_WorkItem AND [Id_Revision] = @Id_Revision ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
public dynamic InsertDtRegistro(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " INSERT INTO [dbo].[" + tabelaLog + "] ";
query += " ([Dt_Registro]) VALUES";
query += " (@Dt_Registro) ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
/*-----------*/
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
//public String ConsultaDtLog()
//{
// string query = "Select dtProcessamento, dscErroProcessamento from [dbo].[LogProcessamento]";
// DateTime _retorno = conncetion._LogData(query);
// //return _retorno.ToString("yyyy/MM/dd HH:mm:ss");
// return _retorno.ToString("yyyy/MM/dd 00:00:00");
//}
public dynamic InsertLogProcessamento(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " INSERT INTO [dbo].[LogProcessamento] ";
query += " ([dtProcessamento], [flgErroProcessamento], [dscErroProcessamento], [etapaProcessamento]) VALUES";
query += " (@dtProcessamento, @flgErroProcessamento, @dscErroProcessamento, @etapaProcessamento ) ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
/*-----------*/
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
public dynamic UpdateWorkItemUpdate(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = "UPDATE [dbo].[TFS_Updates]";
query += " SET [Json_WorkItem] = @Json_WorkItem ";
query += " WHERE [Id_WorkItem] = @Id_WorkItem AND [Id_Update] = @Id_Update ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
_executado,
e.Message
});
}
}
public dynamic InsertWorkItem(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " INSERT INTO [dbo].[" + tabelaWorkItem + "] ";
query += " ([Id_WorkItem],[Json_WorkItem] ) VALUES";
query += " (@Id_WorkItem, @Json_WorkItem) ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
/*-----------*/
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
e
});
}
}
private void InsertRevisions(string idWI, string _dataWIR)
{
ids_WiR_LOCAL = _repRWI.ConsultaWorkItemRevisions(idWI);
JavaScriptSerializer jss = new JavaScriptSerializer();
Dictionary <string, object> _data = jss.DeserializeObject(_dataWIR) as Dictionary <string, object>;
ObjectToQuery _objectToQuery = new ObjectToQuery();
foreach (var item in _data)
{
if (item.Key.ToLower() != "count")
{
object[] _revisions = item.Value as object[];
foreach (Dictionary <string, object> revision in _revisions)
{
string _currentRevID = (revision["rev"]).ToString();
bool WIR_toINSERT = !(ids_WiR_LOCAL.Where(k => k.Key.Equals(Convert.ToInt32(_currentRevID))).Count() > 0);
if (WIR_toINSERT)
{
string _data_P_WIR = jss.Serialize(revision).ToString().Replace(_Maior, "<").Replace(_Menor, ">");
_objectToQuery.IdWorkItem = idWI;
_objectToQuery.IdAuxiliar = _currentRevID;
_objectToQuery.JsonWorkItem = _data_P_WIR;
_repRWI.InsertWorkItemRevision(_objectToQuery);
}
}
}
}
}
public dynamic InsertWorkItemUpdate(ObjectToQuery _objectToQuery)
{
bool _executado = false;
try
{
String query = " INSERT INTO [dbo].[TFS_Updates] ";
query += " ([Id_WorkItem],[Id_Update],[Json_Updates]) VALUES ";
query += " (@Id_WorkItem, @Id_Update, @Json_Updates) ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
return(new
{
_executado
});
}
catch (Exception e)
{
return(new
{
_executado,
e.Message
});
}
}
private void _parameters(ObjectToQuery _objectToQuery, string query)
{
cmd = new SqlCommand(query);
DateTime DtRegistro = Convert.ToDateTime(_objectToQuery.DtRegistro);
cmd.Parameters.Add("@Dt_Registro", SqlDbType.DateTime);
cmd.Parameters["@Dt_Registro"].Value = DtRegistro;
}
private void UpdateWorkItem(string idWI, string _dataWI)
{
string _dataRegistro = DateTime.Now.ToString();
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.IdWorkItem = idWI;
_objectToQuery.JsonWorkItem = _dataWI;
_repWI.UpdateWorkItem(_objectToQuery);
}
public void RegisterLog(string erro, string etapa)
{
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.DtRegistro = DateTime.Now;
_objectToQuery.FlagErroPrcessamento = (erro.Trim().Length > 0) ? true : false;
_objectToQuery.DscErroProcessamento = erro;
_objectToQuery.EtapaProcessamento = etapa;
_LogReg.InsertLogProcessamento(_objectToQuery);
}
private void _parameters(ObjectToQuery _objectToQuery, string query)
{
cmd = new SqlCommand(query);
int IdWorkItem = Convert.ToInt32(_objectToQuery.IdWorkItem);
string JsonWorkItem = _objectToQuery.JsonWorkItem;
DateTime DtRegistro = Convert.ToDateTime(_objectToQuery.DtRegistro);
cmd.Parameters.Add("@Id_WorkItem", SqlDbType.Int);
cmd.Parameters["@Id_WorkItem"].Value = IdWorkItem;
cmd.Parameters.Add("@Json_WorkItem", SqlDbType.NVarChar, -1);
cmd.Parameters["@Json_WorkItem"].Value = JsonWorkItem;
}
/*----------------------------------------------------------------------------------------------------------------------------------*/
public void RegistraProcesso(DateTime _dataRegistro)
{
DateTime dtRegistroLocal = Convert.ToDateTime(_LogReg.ConsultaDtRegistro());
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.DtRegistro = _dataRegistro;
if (String.IsNullOrEmpty(dtRegistroLocal.ToString()))
{
_LogReg.InsertDtRegistro(_objectToQuery);
}
else
{
_LogReg.UpdateDtRegistro(_objectToQuery);
}
}
public Dictionary <int, string> _dicionarioRevisionData(string query, int idWI)
{
Dictionary <int, string> _dados = new Dictionary <int, string>();
try
{
OpenConection();
List <ObjectToQuery> ResultSet = new List <ObjectToQuery>();
using (_connection)
{
SqlCommand command = new SqlCommand(query, _connection);
command.Parameters.Add("@Id_WorkItem", SqlDbType.Int);
command.Parameters["@Id_WorkItem"].Value = idWI;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var _Workitem = new ObjectToQuery();
_Workitem.IdAuxiliar = reader["ID_Revision"].ToString();
ResultSet.Add(_Workitem);
}
}
foreach (var item in ResultSet)
{
_dados.Add(Convert.ToInt32(item.IdAuxiliar), "");
}
}
catch (Exception e)
{
var error = e;
}
finally
{
CloseConnection();
}
return(_dados);
}
private void _parameters(ObjectToQuery _objectToQuery, string query)
{
cmd = new SqlCommand(query);
DateTime DtRegistro = Convert.ToDateTime(_objectToQuery.DtRegistro);
bool FlgErro = _objectToQuery.FlagErroPrcessamento;
string DscErro = (string.IsNullOrEmpty(_objectToQuery.DscErroProcessamento))?"": _objectToQuery.DscErroProcessamento;
string etapaProcessamento = (string.IsNullOrEmpty(_objectToQuery.EtapaProcessamento)) ? "" : _objectToQuery.EtapaProcessamento;
cmd.Parameters.Add("@dtProcessamento", SqlDbType.DateTime);
cmd.Parameters["@dtProcessamento"].Value = DtRegistro;
cmd.Parameters.Add("@flgErroProcessamento", SqlDbType.Bit);
cmd.Parameters["@flgErroProcessamento"].Value = FlgErro;
cmd.Parameters.Add("@dscErroProcessamento", SqlDbType.NVarChar, -1);
cmd.Parameters["@dscErroProcessamento"].Value = DscErro;
cmd.Parameters.Add("@etapaProcessamento", SqlDbType.NVarChar, -1);
cmd.Parameters["@etapaProcessamento"].Value = etapaProcessamento;
}
public DateTime _parametroData(string query)
{
DateTime _dateRegistro = DateTime.Now;
try
{
OpenConection();
ObjectToQuery ResultSet = new ObjectToQuery();
using (_connection)
{
SqlCommand command = new SqlCommand(query, _connection);
SqlDataReader reader = command.ExecuteReader();
var _Workitem = new ObjectToQuery();
while (reader.Read())
{
_Workitem.DtRegistro = Convert.ToDateTime(reader["Dt_RegistroTFS"]);
}
if (reader.HasRows)
{
_dateRegistro = _Workitem.DtRegistro;
}
}
}
catch (Exception e)
{
var error = e;
}
finally
{
CloseConnection();
}
return(_dateRegistro);
}
public Dictionary <int, string> _dicionarioWorkItemData(string query)
{
Dictionary <int, string> _dados = new Dictionary <int, string>();
try
{
OpenConection();
List <ObjectToQuery> ResultSet = new List <ObjectToQuery>();
using (_connection)
{
SqlCommand command = new SqlCommand(query, _connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var _Workitem = new ObjectToQuery();
_Workitem.IdWorkItem = reader["Id_WorkItem"].ToString();
ResultSet.Add(_Workitem);
}
}
foreach (var item in ResultSet)
{
_dados.Add(Convert.ToInt32(item.IdWorkItem), "");
}
}
catch (Exception e)
{
var error = e;
}
finally
{
CloseConnection();
}
return(_dados);
}
public void UpdateWorkItem(string idWI, string _dataWI, int ativo)
{
string _dataRegistro = DateTime.Now.ToString();
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.IdWorkItem = idWI;
_objectToQuery.JsonWorkItem = _dataWI;
_objectToQuery.Ativo = ativo;
try
{
String query = "UPDATE [dbo].[TFS_WorkItem]";
query += "SET [Json_WorkItem] = @Json_WorkItem, [Ativo] = @Ativo ";
query += "WHERE [Id_WorkItem] = @Id_WorkItem ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
}
catch (Exception e)
{
throw e;
}
}
public void InsertWorkItem(string idWI, string _dataWI, int ativo)
{
string _dataRegistro = DateTime.Now.ToString();
ObjectToQuery _objectToQuery = new ObjectToQuery();
_objectToQuery.IdWorkItem = idWI;
_objectToQuery.JsonWorkItem = _dataWI;
_objectToQuery.Ativo = ativo;
try
{
String query = " INSERT INTO [dbo].[TFS_WorkItem] ";
query += " ([Id_WorkItem],[Json_WorkItem], [Ativo] ) VALUES";
query += " (@Id_WorkItem, @Json_WorkItem, @Ativo ) ";
_parameters(_objectToQuery, query);
conncetion.ExecuteQueries(cmd);
}
catch (Exception e)
{
throw e;
}
}
