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; } }