public static int Insert(AuditoriaControlInfo _AuditoriaControlInfo) { //Execute the query and return the new Guid object retval = _AdoHelper.ExecuteScalar(ConnectionString, "AuditoriaControlInsert", new SqlParameter("@Descripcion", _AuditoriaControlInfo.Descripcion), new SqlParameter("@Activo", _AuditoriaControlInfo.Activo), new SqlParameter("@DMS", _AuditoriaControlInfo.DMS), new SqlParameter("@Area", _AuditoriaControlInfo.Area) ); return Int32.Parse(retval.ToString()); }
/// <summary> /// Creates a new instance of the AuditoriaControl class and populates it with data from the specified SqlDataReader. /// </summary> private static AuditoriaControlInfo MakeAuditoriaControl(SqlDataReader dataReader) { AuditoriaControlInfo auditoriaControl = new AuditoriaControlInfo(); if (dataReader.IsDBNull(AuditoriaControlId) == false) auditoriaControl.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(Descripcion) == false) auditoriaControl.Descripcion = dataReader.GetString(Descripcion); if (dataReader.IsDBNull(Activo) == false) auditoriaControl.Activo = dataReader.GetBoolean(Activo); if (dataReader.IsDBNull(DMS) == false) auditoriaControl.DMS = dataReader.GetBoolean(DMS); if (dataReader.IsDBNull(Area) == false) auditoriaControl.Area = dataReader.GetString(Area); return auditoriaControl; }
public static void Delete(AuditoriaControlInfo _AuditoriaControlInfo) { _AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "AuditoriaControlDelete", new SqlParameter("@AuditoriaControlId", _AuditoriaControlInfo.AuditoriaControlId) ); }
public static void Update(AuditoriaControlInfo _AuditoriaControlInfo) { _AdoHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "AuditoriaControlUpdate", new SqlParameter("@AuditoriaControlId", _AuditoriaControlInfo.AuditoriaControlId), new SqlParameter("@Descripcion", _AuditoriaControlInfo.Descripcion), new SqlParameter("@Activo", _AuditoriaControlInfo.Activo), new SqlParameter("@DMS", _AuditoriaControlInfo.DMS), new SqlParameter("@Area", _AuditoriaControlInfo.Area) ); }