/// <summary> /// Updates a record in the <c>aspnet_WebEvent_Events</c> table. /// </summary> /// <param name="value">The <see cref="aspnet_WebEvent_EventsRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(aspnet_WebEvent_EventsRow value) { IDbCommand cmd = _db.CreateCommand("dbo._aspnet_WebEvent_Events_Update", true); AddParameter(cmd, "EventTimeUtc", value.EventTimeUtc); AddParameter(cmd, "EventTime", value.EventTime); AddParameter(cmd, "EventType", value.EventType); AddParameter(cmd, "EventSequence", value.EventSequence); AddParameter(cmd, "EventOccurrence", value.EventOccurrence); AddParameter(cmd, "EventCode", value.EventCode); AddParameter(cmd, "EventDetailCode", value.EventDetailCode); AddParameter(cmd, "Message", value.Message); AddParameter(cmd, "ApplicationPath", value.ApplicationPath); AddParameter(cmd, "ApplicationVirtualPath", value.ApplicationVirtualPath); AddParameter(cmd, "MachineName", value.MachineName); AddParameter(cmd, "RequestUrl", value.RequestUrl); AddParameter(cmd, "ExceptionType", value.ExceptionType); AddParameter(cmd, "Details", value.Details); AddParameter(cmd, "EventId", value.EventId); return(0 != cmd.ExecuteNonQuery()); }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="aspnet_WebEvent_EventsRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="aspnet_WebEvent_EventsRow"/> object.</returns> protected virtual aspnet_WebEvent_EventsRow MapRow(DataRow row) { aspnet_WebEvent_EventsRow mappedObject = new aspnet_WebEvent_EventsRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "EventId" dataColumn = dataTable.Columns["EventId"]; if (!row.IsNull(dataColumn)) { mappedObject.EventId = (string)row[dataColumn]; } // Column "EventTimeUtc" dataColumn = dataTable.Columns["EventTimeUtc"]; if (!row.IsNull(dataColumn)) { mappedObject.EventTimeUtc = (System.DateTime)row[dataColumn]; } // Column "EventTime" dataColumn = dataTable.Columns["EventTime"]; if (!row.IsNull(dataColumn)) { mappedObject.EventTime = (System.DateTime)row[dataColumn]; } // Column "EventType" dataColumn = dataTable.Columns["EventType"]; if (!row.IsNull(dataColumn)) { mappedObject.EventType = (string)row[dataColumn]; } // Column "EventSequence" dataColumn = dataTable.Columns["EventSequence"]; if (!row.IsNull(dataColumn)) { mappedObject.EventSequence = (decimal)row[dataColumn]; } // Column "EventOccurrence" dataColumn = dataTable.Columns["EventOccurrence"]; if (!row.IsNull(dataColumn)) { mappedObject.EventOccurrence = (decimal)row[dataColumn]; } // Column "EventCode" dataColumn = dataTable.Columns["EventCode"]; if (!row.IsNull(dataColumn)) { mappedObject.EventCode = (int)row[dataColumn]; } // Column "EventDetailCode" dataColumn = dataTable.Columns["EventDetailCode"]; if (!row.IsNull(dataColumn)) { mappedObject.EventDetailCode = (int)row[dataColumn]; } // Column "Message" dataColumn = dataTable.Columns["Message"]; if (!row.IsNull(dataColumn)) { mappedObject.Message = (string)row[dataColumn]; } // Column "ApplicationPath" dataColumn = dataTable.Columns["ApplicationPath"]; if (!row.IsNull(dataColumn)) { mappedObject.ApplicationPath = (string)row[dataColumn]; } // Column "ApplicationVirtualPath" dataColumn = dataTable.Columns["ApplicationVirtualPath"]; if (!row.IsNull(dataColumn)) { mappedObject.ApplicationVirtualPath = (string)row[dataColumn]; } // Column "MachineName" dataColumn = dataTable.Columns["MachineName"]; if (!row.IsNull(dataColumn)) { mappedObject.MachineName = (string)row[dataColumn]; } // Column "RequestUrl" dataColumn = dataTable.Columns["RequestUrl"]; if (!row.IsNull(dataColumn)) { mappedObject.RequestUrl = (string)row[dataColumn]; } // Column "ExceptionType" dataColumn = dataTable.Columns["ExceptionType"]; if (!row.IsNull(dataColumn)) { mappedObject.ExceptionType = (string)row[dataColumn]; } // Column "Details" dataColumn = dataTable.Columns["Details"]; if (!row.IsNull(dataColumn)) { mappedObject.Details = (string)row[dataColumn]; } return(mappedObject); }
/// <summary> /// Reads data from the provided data reader and returns /// an array of mapped objects. /// </summary> /// <param name="reader">The <see cref="System.Data.IDataReader"/> object to read data from the table.</param> /// <param name="startIndex">The index of the first record to map.</param> /// <param name="length">The number of records to map.</param> /// <param name="totalRecordCount">A reference parameter that returns the total number /// of records in the reader object if 0 was passed into the method; otherwise it returns -1.</param> /// <returns>An array of <see cref="aspnet_WebEvent_EventsRow"/> objects.</returns> protected virtual aspnet_WebEvent_EventsRow[] MapRecords(IDataReader reader, int startIndex, int length, ref int totalRecordCount) { if (0 > startIndex) { throw new ArgumentOutOfRangeException("startIndex", startIndex, "StartIndex cannot be less than zero."); } if (0 > length) { throw new ArgumentOutOfRangeException("length", length, "Length cannot be less than zero."); } int eventIdColumnIndex = reader.GetOrdinal("EventId"); int eventTimeUtcColumnIndex = reader.GetOrdinal("EventTimeUtc"); int eventTimeColumnIndex = reader.GetOrdinal("EventTime"); int eventTypeColumnIndex = reader.GetOrdinal("EventType"); int eventSequenceColumnIndex = reader.GetOrdinal("EventSequence"); int eventOccurrenceColumnIndex = reader.GetOrdinal("EventOccurrence"); int eventCodeColumnIndex = reader.GetOrdinal("EventCode"); int eventDetailCodeColumnIndex = reader.GetOrdinal("EventDetailCode"); int messageColumnIndex = reader.GetOrdinal("Message"); int applicationPathColumnIndex = reader.GetOrdinal("ApplicationPath"); int applicationVirtualPathColumnIndex = reader.GetOrdinal("ApplicationVirtualPath"); int machineNameColumnIndex = reader.GetOrdinal("MachineName"); int requestUrlColumnIndex = reader.GetOrdinal("RequestUrl"); int exceptionTypeColumnIndex = reader.GetOrdinal("ExceptionType"); int detailsColumnIndex = reader.GetOrdinal("Details"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { aspnet_WebEvent_EventsRow record = new aspnet_WebEvent_EventsRow(); recordList.Add(record); record.EventId = Convert.ToString(reader.GetValue(eventIdColumnIndex)); record.EventTimeUtc = Convert.ToDateTime(reader.GetValue(eventTimeUtcColumnIndex)); record.EventTime = Convert.ToDateTime(reader.GetValue(eventTimeColumnIndex)); record.EventType = Convert.ToString(reader.GetValue(eventTypeColumnIndex)); record.EventSequence = Convert.ToDecimal(reader.GetValue(eventSequenceColumnIndex)); record.EventOccurrence = Convert.ToDecimal(reader.GetValue(eventOccurrenceColumnIndex)); record.EventCode = Convert.ToInt32(reader.GetValue(eventCodeColumnIndex)); record.EventDetailCode = Convert.ToInt32(reader.GetValue(eventDetailCodeColumnIndex)); if (!reader.IsDBNull(messageColumnIndex)) { record.Message = Convert.ToString(reader.GetValue(messageColumnIndex)); } if (!reader.IsDBNull(applicationPathColumnIndex)) { record.ApplicationPath = Convert.ToString(reader.GetValue(applicationPathColumnIndex)); } if (!reader.IsDBNull(applicationVirtualPathColumnIndex)) { record.ApplicationVirtualPath = Convert.ToString(reader.GetValue(applicationVirtualPathColumnIndex)); } record.MachineName = Convert.ToString(reader.GetValue(machineNameColumnIndex)); if (!reader.IsDBNull(requestUrlColumnIndex)) { record.RequestUrl = Convert.ToString(reader.GetValue(requestUrlColumnIndex)); } if (!reader.IsDBNull(exceptionTypeColumnIndex)) { record.ExceptionType = Convert.ToString(reader.GetValue(exceptionTypeColumnIndex)); } if (!reader.IsDBNull(detailsColumnIndex)) { record.Details = Convert.ToString(reader.GetValue(detailsColumnIndex)); } if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((aspnet_WebEvent_EventsRow[])(recordList.ToArray(typeof(aspnet_WebEvent_EventsRow)))); }
/// <summary> /// Deletes the specified object from the <c>aspnet_WebEvent_Events</c> table. /// </summary> /// <param name="value">The <see cref="aspnet_WebEvent_EventsRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(aspnet_WebEvent_EventsRow value) { return(DeleteByPrimaryKey(value.EventId)); }