public static int Insert(AuditoriaTipoInfo _AuditoriaTipoInfo) { //Execute the query and return the new Guid object retval= _AdoHelper.ExecuteScalar(ConnectionString,"AuditoriaTipoInsert", new SqlParameter("@Descripcion", _AuditoriaTipoInfo.Descripcion), new SqlParameter("@DMS", _AuditoriaTipoInfo.DMS) ); return Int32.Parse(retval.ToString()); }
public static void Update(AuditoriaTipoInfo _AuditoriaTipoInfo) { _AdoHelper.ExecuteNonQuery(ConnectionString,CommandType.StoredProcedure, "AuditoriaTipoUpdate", new SqlParameter("@AuditoriaTipoId", _AuditoriaTipoInfo.AuditoriaTipoId), new SqlParameter("@Descripcion", _AuditoriaTipoInfo.Descripcion), new SqlParameter("@DMS", _AuditoriaTipoInfo.DMS) ); }
public static void Delete(AuditoriaTipoInfo _AuditoriaTipoInfo) { _AdoHelper.ExecuteNonQuery(ConnectionString,CommandType.StoredProcedure, "AuditoriaTipoDelete", new SqlParameter("@AuditoriaTipoId", _AuditoriaTipoInfo.AuditoriaTipoId) ); }
/// <summary> /// Creates a new instance of the AuditoriaTipo class and populates it with data from the specified SqlDataReader. /// </summary> private static AuditoriaTipoInfo MakeAuditoriaTipo(SqlDataReader dataReader) { AuditoriaTipoInfo auditoriaTipo = new AuditoriaTipoInfo(); if (dataReader.IsDBNull(AuditoriaTipoId) == false) auditoriaTipo.AuditoriaTipoId = dataReader.GetInt32(AuditoriaTipoId); if (dataReader.IsDBNull(Descripcion) == false) auditoriaTipo.Descripcion = dataReader.GetString(Descripcion); if (dataReader.IsDBNull(DMS) == false) auditoriaTipo.DMS = dataReader.GetBoolean(DMS); return auditoriaTipo; }