public static void Update(AuditorInfo _AuditorInfo) { _AdoHelper.ExecuteNonQuery(ConnectionString,CommandType.StoredProcedure, "AuditorUpdate", new SqlParameter("@AuditorId", _AuditorInfo.AuditorId), new SqlParameter("@NombreAuditor", _AuditorInfo.NombreAuditor) ); }
public static int Insert(AuditorInfo _AuditorInfo) { //Execute the query and return the new Guid object retval= _AdoHelper.ExecuteScalar(ConnectionString,"AuditorInsert", new SqlParameter("@NombreAuditor", _AuditorInfo.NombreAuditor) ); return Int32.Parse(retval.ToString()); }
/// <summary> /// Creates a new instance of the Auditor class and populates it with data from the specified SqlDataReader. /// </summary> private static AuditorInfo MakeAuditor(SqlDataReader dataReader) { AuditorInfo auditor = new AuditorInfo(); if (dataReader.IsDBNull(AuditorId) == false) auditor.AuditorId = dataReader.GetInt32(AuditorId); if (dataReader.IsDBNull(NombreAuditor) == false) auditor.NombreAuditor = dataReader.GetString(NombreAuditor); return auditor; }