public static DateTime?ExtractDT() { DateTime?FechaHora = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("System_DateTimeServer"); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { reader.Read(); FechaHora = (DateTime?)reader["HourDate"]; } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } return(FechaHora); } catch (Exception) { throw; } }
public bool Update(Project Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Projects_Update"); DataAccessEnterprise.AddParameter(_command, "@PROJ_ID", Item.PROJ_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_ID", Item.INVE_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Name", Item.PROJ_Name, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_OverallProfitability", Item.PROJ_OverallProfitability, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_ExecutionTime", Item.PROJ_ExecutionTime, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_InvestmentCapital", Item.PROJ_InvestmentCapital, SqlDbType.Decimal, 10, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Modality", Item.PROJ_Modality, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_PromotionDate", Item.PROJ_PromotionDate, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_ExpirationDate", Item.PROJ_ExpirationDate, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Progress", Item.PROJ_Progress, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Description", Item.PROJ_Description, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_State", Item.PROJ_State, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(Person Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Persons_Update"); DataAccessEnterprise.AddParameter(_command, "@PERS_ID", Item.PERS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_Names", Item.PERS_Names, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_LastName", Item.PERS_LastName, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_MotherLastName", Item.PERS_MotherLastName, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_BirthDate", Item.PERS_BirthDate, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabGEN", Item.TYPE_TabGEN, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodGEN", Item.TYPE_CodGEN, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabDOC", Item.TYPE_TabDOC, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodDOC", Item.TYPE_CodDOC, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(Investment Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Investments_Update"); DataAccessEnterprise.AddParameter(_command, "@INVE_ID", Item.INVE_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_ID", Item.USER_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Amount", Item.INVE_Amount, SqlDbType.Decimal, 10, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Date", Item.INVE_Date, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Observation", Item.INVE_Observation, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_CostEffectiveness", Item.INVE_CostEffectiveness, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_State", Item.INVE_State, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { //if (Int32.TryParse(_command.Parameters["@PERS_ID"].Value.ToString(), out Int32 _PERS_ID)) //{ Item.PERS_ID = _PERS_ID; } return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(SessionKey Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("SessionKeys_Update"); DataAccessEnterprise.AddParameter(_command, "@SESS_ID", Item.SESS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_Date", Item.SESS_Date, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PrivateKeyXML", Item.SESS_PrivateKeyXML, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PublicKeyXML", Item.SESS_PublicKeyXML, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PrivateKeyPEM", Item.SESS_PrivateKeyPEM, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PublicKeyPEM", Item.SESS_PublicKeyPEM, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(Media Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Media_Update"); DataAccessEnterprise.AddParameter(_command, "@MEDI_ID ", Item.MEDI_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_ID ", Item.PROJ_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_ID ", Item.EVEN_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Event ", Item.MEDI_Event, SqlDbType.Bit, 2, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Title ", Item.MEDI_Title, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Description", Item.MEDI_Description, SqlDbType.VarChar, 250, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Url ", Item.MEDI_Url, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabMED ", Item.TYPE_TabMED, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodMED ", Item.TYPE_CodMED, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(Type Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Types_Update"); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodTable", Item.TYPE_CodTable, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodType", Item.TYPE_CodType, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Desc1", Item.TYPE_Desc1, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Desc2", Item.TYPE_Desc2, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Num1", Item.TYPE_Num1, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Num2", Item.TYPE_Num2, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Status", Item.TYPE_Status, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Insert(Project Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Projects_Insert"); DataAccessEnterprise.AddParameter(_command, "@INVE_ID", Item.INVE_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Name", Item.PROJ_Name, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_OverallProfitability", Item.PROJ_OverallProfitability, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_ExecutionTime", Item.PROJ_ExecutionTime, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_InvestmentCapital", Item.PROJ_InvestmentCapital, SqlDbType.Decimal, 10, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Modality", Item.PROJ_Modality, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_PromotionDate", Item.PROJ_PromotionDate, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_ExpirationDate", Item.PROJ_ExpirationDate, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Progress", Item.PROJ_Progress, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_Description", Item.PROJ_Description, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PROJ_State", Item.PROJ_State, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { //if (Int32.TryParse(_command.Parameters["@PERS_ID"].Value.ToString(), out Int32 _PERS_ID)) //{ Item.PERS_ID = _PERS_ID; } return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public static void Register() { try { var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); var config = builder.Build(); var appConnection = new SqlConnection(config.GetSection("ConnectionStrings").GetSection("AppConnection").Value); if (appConnection != null) { string appStringConnection = appConnection.ConnectionString; DataAccessEnterprise.Initialize(appStringConnection); } } catch (Exception e) { string _mensaje = e.Message; } }
public bool Insert(Person Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Persons_Insert"); // _command.Connection = DataAccessEnterprise.BeginConnection(); // { DataAccessEnterprise.AddParameter(_command, "@PERS_Names", Item.PERS_Names, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_LastName", Item.PERS_LastName, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_MotherLastName", Item.PERS_MotherLastName, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_BirthDate", Item.PERS_BirthDate, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabGEN", Item.TYPE_TabGEN, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodGEN", Item.TYPE_CodGEN, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabDOC", Item.TYPE_TabDOC, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodDOC", Item.TYPE_CodDOC, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } // } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(User Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Users_Update"); DataAccessEnterprise.AddParameter(_command, "@USER_ID", Item.USER_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@PERS_ID", Item.PERS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Email", Item.USER_Email, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Password", Item.USER_Password, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Admin", Item.USER_Admin, SqlDbType.Bit, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Status", Item.USER_Status, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserModi", Item.AUDI_UserModi, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechModi", Item.AUDI_FechModi, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } return(false); }
public bool Insert(Type Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Types_Insert"); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodTable", Item.TYPE_CodTable, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodType", Item.TYPE_CodType, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Desc1", Item.TYPE_Desc1, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Desc2", Item.TYPE_Desc2, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Num1", Item.TYPE_Num1, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Num2", Item.TYPE_Num2, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_Status", Item.TYPE_Status, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { //if (Int32.TryParse(_command.Parameters["@PERS_ID"].Value.ToString(), out Int32 _PERS_ID)) //{ Item.PERS_ID = _PERS_ID; } return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Update(Log Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Logs_Update"); DataAccessEnterprise.AddParameter(_command, "@LOG_ID", Item.LOG_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@LOG_Date", Item.LOG_Date, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabAUD", Item.TYPE_TabAUD, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodAUD", Item.TYPE_CodAUD, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@LOG_Object", Item.LOG_Object, SqlDbType.VarChar, 30, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@LOG_Text", Item.LOG_Text, SqlDbType.Text, 250, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Insert(User Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Users_Insert"); DataAccessEnterprise.AddParameter(_command, "@PERS_ID", Item.PERS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Email", Item.USER_Email, SqlDbType.VarChar, 25, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Password", Item.USER_Password, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Admin", Item.USER_Admin, SqlDbType.Bit, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@USER_Status", Item.USER_Status, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { //if (Int32.TryParse(_command.Parameters["@PERS_ID"].Value.ToString(), out Int32 _PERS_ID)) //{ Item.PERS_ID = _PERS_ID; } return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } return(false); }
public bool Insert(Event Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Events_Insert"); DataAccessEnterprise.AddParameter(_command, "@PROJ_ID", Item.PROJ_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_StartDate", Item.EVEN_StartDate, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_EndingDate", Item.EVEN_EndingDate, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_State", Item.EVEN_State, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_Title", Item.EVEN_Title, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_Description", Item.EVEN_Description, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { //if (Int32.TryParse(_command.Parameters["@PERS_ID"].Value.ToString(), out Int32 _PERS_ID)) //{ Item.PERS_ID = _PERS_ID; } return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } return(false); }
public bool Insert(Media Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Media_Insert"); DataAccessEnterprise.AddParameter(_command, "@PROJ_ID ", Item.PROJ_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@EVEN_ID ", Item.EVEN_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Event ", Item.MEDI_Event, SqlDbType.Bit, 2, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Title ", Item.MEDI_Title, SqlDbType.VarChar, 50, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Description", Item.MEDI_Description, SqlDbType.VarChar, 250, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@MEDI_Url ", Item.MEDI_Url, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabMED ", Item.TYPE_TabMED, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodMED ", Item.TYPE_CodMED, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public static void Register() { try { var StringConnectionPath = HttpContext.Current.Server.MapPath("~/Web.config"); var StringConnectionMap = new ExeConfigurationFileMap() { ExeConfigFilename = StringConnectionPath }; var config = ConfigurationManager.OpenMappedExeConfiguration(StringConnectionMap, ConfigurationUserLevel.None); var appConnection = config.ConnectionStrings.ConnectionStrings["AppConnection"]; if (appConnection != null) { string appStringConnection = appConnection.ConnectionString; DataAccessEnterprise.Initialize(appStringConnection); } } catch (Exception e) { string _mensaje = e.Message; } }
public bool Insert(Investment Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Investments_Insert"); DataAccessEnterprise.AddParameter(_command, "@USER_ID", Item.USER_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Amount", Item.INVE_Amount, SqlDbType.Decimal, 10, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Date", Item.INVE_Date, SqlDbType.DateTime, 8, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_Observation", Item.INVE_Observation, SqlDbType.VarChar, 200, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_CostEffectiveness", Item.INVE_CostEffectiveness, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@INVE_State", Item.INVE_State, SqlDbType.Char, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Insert(SessionKey Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("SessionKeys_Insert"); DataAccessEnterprise.AddParameter(_command, "@SESS_ID", Item.SESS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_Date", Item.SESS_Date, SqlDbType.Date, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PrivateKeyXML", Item.SESS_PrivateKeyXML, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PublicKeyXML", Item.SESS_PublicKeyXML, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PrivateKeyPEM", Item.SESS_PrivateKeyPEM, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_PublicKeyPEM", Item.SESS_PublicKeyPEM, SqlDbType.VarChar, 100, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_UserCrea", Item.AUDI_UserCrea, SqlDbType.VarChar, 20, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@AUDI_FechCrea", Item.AUDI_FechCrea, SqlDbType.Date, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Delete(string codTable, string codType, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Types_Delete"); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodTable", codTable, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodType", codType, SqlDbType.VarChar, 3, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Delete(int SESS_ID, DateTime SESS_Date, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("SessionKeys_Delete"); DataAccessEnterprise.AddParameter(_command, "@SESS_ID", SESS_ID, SqlDbType.Int, 1, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@SESS_Date", SESS_Date, SqlDbType.DateTime, 8, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public bool Insert(Log Item, out LogError logError) { logError = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Logs_Insert"); DataAccessEnterprise.AddParameter(_command, "@LOG_Date", Item.LOG_Date, SqlDbType.DateTime, 0, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_TabAUD", Item.TYPE_TabAUD, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@TYPE_CodAUD", Item.TYPE_CodAUD, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@LOG_Object", Item.LOG_Object, SqlDbType.VarChar, 30, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "@LOG_Text", Item.LOG_Text, SqlDbType.Text, 250, ParameterDirection.Input); if (DataAccessEnterprise.ExecuteNonQuery(_command, null) > 0) { return(true); } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(false); }
public List <Event> SelectByProjectId(int project_id, out LogError logError) { logError = null; List <Event> _eventList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Events_SelectProj_id"); DataAccessEnterprise.AddParameter(_command, "@proj_id", project_id, SqlDbType.Int, 1, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _eventList = new List <Event>(); while (reader.Read()) { int even_id = (int)reader["even_id"]; int proj_id = (int)reader["proj_id"]; DateTime even_startdate = (DateTime)reader["even_startdate"]; DateTime even_endingdate = (DateTime)reader["even_endingdate"]; char even_state = Convert.ToChar(reader["even_state"]); string even_title = (string)reader["even_title"]; string even_description = (string)reader["even_description"]; string audi_usercrea = (string)reader["audi_usercrea"]; DateTime audi_fechcrea = (DateTime)reader["audi_fechcrea"]; string audi_usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?audi_fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _event = new Event() { EVEN_ID = even_id, PROJ_ID = proj_id, EVEN_StartDate = even_startdate, EVEN_EndingDate = even_endingdate, EVEN_State = even_state, EVEN_Title = even_title, EVEN_Description = even_description, AUDI_UserCrea = audi_usercrea, AUDI_FechCrea = audi_fechcrea, AUDI_UserModi = audi_usermodi, AUDI_FechModi = audi_fechmodi }; _eventList.Add(_event); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_eventList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_eventList); }
public List <Type> SelectAll(out LogError logError) { logError = null; List <Type> _typeList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Types_SelectAll"); _typeList = new List <Type>(); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _typeList = new List <Type>(); while (reader.Read()) { string CodTable = (string)reader["TYPE_CodTable"]; string CodType = (string)reader["TYPE_CodType"]; string Desc1 = (string)reader["TYPE_Desc1"]; string Desc2 = (string)reader["TYPE_Desc2"]; int Num1 = (int)reader["TYPE_Num1"]; int Num2 = (int)reader["TYPE_Num2"]; char Status = Convert.ToChar(reader["TYPE_Status"]); string audi_usercrea = (string)reader["audi_usercrea"]; DateTime audi_fechcrea = (DateTime)reader["audi_fechcrea"]; string audi_usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?audi_fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _type = new Type() { TYPE_CodTable = CodTable, TYPE_CodType = CodType, TYPE_Desc1 = Desc1, TYPE_Desc2 = Desc2, TYPE_Num1 = Num1, TYPE_Num2 = Num2, TYPE_Status = Status, AUDI_UserCrea = audi_usercrea, AUDI_FechCrea = audi_fechcrea, AUDI_UserModi = audi_usermodi, AUDI_FechModi = audi_fechmodi }; _typeList.Add(_type); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_typeList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_typeList); }
public List <Investment> SelectByUserId(int userId, out LogError logError) { logError = null; List <Investment> _investmentList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Investments_SelectByUser_Id"); DataAccessEnterprise.AddParameter(_command, "@user_id", userId, SqlDbType.Int, 1, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _investmentList = new List <Investment>(); while (reader.Read()) { int inve_id = (int)reader["inve_id"]; int user_id = (int)reader["user_id"]; decimal inve_amount = (decimal)reader["inve_amount"]; DateTime inve_date = (DateTime)reader["inve_date"]; string inve_observation = (string)reader["inve_observation"]; int inve_costeffectiveness = (int)reader["inve_costeffectiveness"]; char inve_state = Convert.ToChar(reader["inve_state"]); string audi_usercrea = (string)reader["audi_usercrea"]; DateTime audi_fechcrea = (DateTime)reader["audi_fechcrea"]; string audi_usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?audi_fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _investment = new Investment() { INVE_ID = inve_id, USER_ID = user_id, INVE_Amount = inve_amount, INVE_Date = inve_date, INVE_Observation = inve_observation, INVE_CostEffectiveness = inve_costeffectiveness, INVE_State = inve_state, AUDI_UserCrea = audi_usercrea, AUDI_FechCrea = audi_fechcrea, AUDI_UserModi = audi_usermodi, AUDI_FechModi = audi_fechmodi }; _investmentList.Add(_investment); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_investmentList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_investmentList); }
public List <Log> SelectAll(out LogError logError) { logError = null; List <Log> _logList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Logs_SelectAll"); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _logList = new List <Log>(); while (reader.Read()) { int log_id = (int)reader["log_id"]; DateTime log_date = (DateTime)reader["log_date"]; string TYPE_TabAUD = (string)reader["TYPE_TabAUD"]; string TYPE_CodAUD = (string)reader["TYPE_CodAUD"]; string LOG_Object = (string)reader["LOG_Object"]; string LOG_Text = (string)reader["LOG_Text"]; var _log = new Log() { LOG_ID = log_id, LOG_Date = log_date, TYPE_TabAUD = TYPE_TabAUD, TYPE_CodAUD = TYPE_CodAUD, LOG_Object = LOG_Object, LOG_Text = LOG_Text }; _logList.Add(_log); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_logList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_logList); }
public List <User> SelectByIdPerson(int PERS_ID, out LogError logError) { logError = null; List <User> _userList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Users_SelectAllByPERS_ID"); DataAccessEnterprise.AddParameter(_command, "@PERS_ID", PERS_ID, SqlDbType.Int, 1, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _userList = new List <User>(); while (reader.Read()) { int ID = (int)reader["USER_ID"]; int IDPers = (int)reader["PERS_ID"]; string Email = (string)reader["USER_Email"]; string Password = (string)reader["USER_Password"]; bool Admin = (bool)reader["USER_Admin"]; char Status = Convert.ToChar(reader["USER_Status"]); string audi_usercrea = (string)reader["audi_usercrea"]; DateTime audi_fechcrea = (DateTime)reader["audi_fechcrea"]; string audi_usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?audi_fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _user = new User() { USER_ID = ID, PERS_ID = IDPers, USER_Email = Email, USER_Password = Password, USER_Admin = Admin, USER_Status = Status, AUDI_UserCrea = audi_usercrea, AUDI_FechCrea = audi_fechcrea, AUDI_UserModi = audi_usermodi, AUDI_FechModi = audi_fechmodi }; _userList.Add(_user); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_userList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_userList); }
public Log SelectById(int id, out LogError logError) { logError = null; Log _log = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Logs_Select"); DataAccessEnterprise.AddParameter(_command, "@log_id", id, SqlDbType.Int, 1, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { reader.Read(); int log_id = (int)reader["log_id"]; DateTime log_date = (DateTime)reader["log_date"]; string TYPE_TabAUD = (string)reader["TYPE_TabAUD"]; string TYPE_CodAUD = (string)reader["TYPE_CodAUD"]; string LOG_Object = (string)reader["LOG_Object"]; string LOG_Text = (string)reader["LOG_Text"]; _log = new Log() { LOG_ID = log_id, LOG_Date = log_date, TYPE_TabAUD = TYPE_TabAUD, TYPE_CodAUD = TYPE_CodAUD, LOG_Object = LOG_Object, LOG_Text = LOG_Text }; } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_log == null) { logError = new LogError() { Message = "Registro no encontrado", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_log); }
public List <Media> SelectByIdTypeMED(string tabMED, string codMED, out LogError logError) { logError = null; List <Media> _mediaList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Media_SelectAllByTypeMED"); DataAccessEnterprise.AddParameter(_command, "TYPE_TabMED", tabMED, SqlDbType.VarChar, 3, ParameterDirection.Input); DataAccessEnterprise.AddParameter(_command, "TYPE_CodMED", codMED, SqlDbType.VarChar, 3, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _mediaList = new List <Media>(); while (reader.Read()) { int ID = (int)reader["MEDI_ID"]; int IDPROJ = (int)reader["PROJ_ID"]; int IDEVEN = (int)reader["EVEN_ID"]; bool Event = (bool)reader["MEDI_Event"]; string Title = (string)reader["MEDI_Title"]; string Description = (string)reader["MEDI_Description"]; string Url = (string)reader["MEDI_Url"]; string TabMED = (string)reader["TYPE_TabMED"]; string CodMED = (string)reader["TYPE_CodMED"]; string Usercrea = (string)reader["audi_usercrea"]; DateTime Fechcrea = (DateTime)reader["audi_fechcrea"]; string Usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?Fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _media = new Media() { MEDI_ID = ID, PROJ_ID = IDPROJ, EVEN_ID = IDEVEN, MEDI_Event = Event, MEDI_Title = Title, MEDI_Description = Description, MEDI_Url = Url, TYPE_TabMED = TabMED, TYPE_CodMED = CodMED, AUDI_UserCrea = Usercrea, AUDI_FechCrea = Fechcrea, AUDI_UserModi = Usermodi, AUDI_FechModi = Fechmodi }; _mediaList.Add(_media); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_mediaList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_mediaList); }
public List <Project> SelectByIdInvestment(int INVE_ID, out LogError logError) { logError = null; List <Project> _projectList = null; try { SqlCommand _command = DataAccessEnterprise.AsignProcedure("Projects_SelectAllByINVE_ID"); DataAccessEnterprise.AddParameter(_command, "@INVE_ID", INVE_ID, SqlDbType.Int, 1, ParameterDirection.Input); _command.Connection = DataAccessEnterprise.BeginConnection(); { SqlDataReader reader = _command.ExecuteReader(); if (reader.HasRows) { _projectList = new List <Project>(); while (reader.Read()) { int ID = (int)reader["PROJ_ID"]; int IDInvestment = (int)reader["INVE_ID"]; string Name = (string)reader["PROJ_Name"]; int OverallProfitability = (int)reader["PROJ_OverallProfitability"]; int ExecutionTime = (int)reader["PROJ_ExecutionTime"]; decimal InvestmentCapital = (decimal)reader["PROJ_InvestmentCapital"]; string Modality = (string)reader["PROJ_Modality"]; DateTime PromotionDate = (DateTime)reader["PROJ_PromotionDate"]; DateTime ExpirationDate = (DateTime)reader["PROJ_ExpirationDate"]; int Progress = (int)reader["PROJ_Progress"]; string Description = (string)reader["PROJ_Description"]; char State = Convert.ToChar(reader["PROJ_State"]); string Usercrea = (string)reader["audi_usercrea"]; DateTime Fechcrea = (DateTime)reader["audi_fechcrea"]; string Usermodi = reader["audi_usermodi"] == DBNull.Value ? null : (string)reader["audi_usermodi"]; DateTime?Fechmodi = reader["audi_fechmodi"] == DBNull.Value ? null : (DateTime?)reader["audi_fechmodi"]; var _project = new Project() { PROJ_ID = ID, INVE_ID = IDInvestment, PROJ_Name = Name, PROJ_OverallProfitability = OverallProfitability, PROJ_ExecutionTime = ExecutionTime, PROJ_InvestmentCapital = InvestmentCapital, PROJ_Modality = Modality, PROJ_PromotionDate = PromotionDate, PROJ_ExpirationDate = ExpirationDate, PROJ_Progress = Progress, PROJ_Description = Description, PROJ_State = State, AUDI_UserCrea = Usercrea, AUDI_FechCrea = Fechcrea, AUDI_UserModi = Usermodi, AUDI_FechModi = Fechmodi }; _projectList.Add(_project); } } //DataAccessEnterprise.EndConnection(); _command.Connection.Close(); } if (_projectList == null) { logError = new LogError() { Message = "Registros no encontrados", ErrorValidado = true, MensajeUsuario = "Error en procesar petición, El registro no existe" }; } } catch (SqlException e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = e.Number }; } catch (Exception e) { logError = new LogError() { Message = e.Message, StackTracer = e.StackTrace, NumberError = null }; } DataAccessEnterprise.EndConnection(); return(_projectList); }