/// <summary> /// Updates a record in the <c>Vote</c> table. /// </summary> /// <param name="value">The <see cref="VoteRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(VoteRow value) { string sqlStr = "UPDATE [dbo].[Vote] SET " + "[UserID]=" + _db.CreateSqlParameterName("@UserID") + ", " + "[Vote_Title]=" + _db.CreateSqlParameterName("@Vote_Title") + ", " + "[Vote_StartDate]=" + _db.CreateSqlParameterName("@Vote_StartDate") + ", " + "[Vote_EndDate]=" + _db.CreateSqlParameterName("@Vote_EndDate") + ", " + "[Vote_Parent]=" + _db.CreateSqlParameterName("@Vote_Parent") + ", " + "[Vote_Parent_Image]=" + _db.CreateSqlParameterName("@Vote_Parent_Image") + ", " + "[Vote_InitContent]=" + _db.CreateSqlParameterName("@Vote_InitContent") + ", " + "[Cat_ID]=" + _db.CreateSqlParameterName("@Cat_ID") + " WHERE " + "[Vote_ID]=" + _db.CreateSqlParameterName("@Vote_ID"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "@UserID", value.UserID); AddParameter(cmd, "@Vote_Title", value.Vote_Title); AddParameter(cmd, "@Vote_StartDate", value.IsVote_StartDateNull ? DBNull.Value : (object)value.Vote_StartDate); AddParameter(cmd, "@Vote_EndDate", value.IsVote_EndDateNull ? DBNull.Value : (object)value.Vote_EndDate); AddParameter(cmd, "@Vote_Parent", value.IsVote_ParentNull ? DBNull.Value : (object)value.Vote_Parent); AddParameter(cmd, "@Vote_Parent_Image", value.Vote_Parent_Image); AddParameter(cmd, "@Vote_InitContent", value.Vote_InitContent); AddParameter(cmd, "@Cat_ID", value.Cat_ID); AddParameter(cmd, "@Vote_ID", value.Vote_ID); return(0 != cmd.ExecuteNonQuery()); }
/// <summary> /// Adds a new record into the <c>Vote</c> table. /// </summary> /// <param name="value">The <see cref="VoteRow"/> object to be inserted.</param> public virtual void Insert(VoteRow value) { string sqlStr = "INSERT INTO [dbo].[Vote] (" + "[UserID], " + "[Vote_Title], " + "[Vote_StartDate], " + "[Vote_EndDate], " + "[Vote_Parent], " + "[Vote_Parent_Image], " + "[Vote_InitContent], " + "[Cat_ID]" + ") VALUES (" + _db.CreateSqlParameterName("@UserID") + ", " + _db.CreateSqlParameterName("@Vote_Title") + ", " + _db.CreateSqlParameterName("@Vote_StartDate") + ", " + _db.CreateSqlParameterName("@Vote_EndDate") + ", " + _db.CreateSqlParameterName("@Vote_Parent") + ", " + _db.CreateSqlParameterName("@Vote_Parent_Image") + ", " + _db.CreateSqlParameterName("@Vote_InitContent") + ", " + _db.CreateSqlParameterName("@Cat_ID") + ");SELECT @@IDENTITY"; IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "@UserID", value.UserID); AddParameter(cmd, "@Vote_Title", value.Vote_Title); AddParameter(cmd, "@Vote_StartDate", value.IsVote_StartDateNull ? DBNull.Value : (object)value.Vote_StartDate); AddParameter(cmd, "@Vote_EndDate", value.IsVote_EndDateNull ? DBNull.Value : (object)value.Vote_EndDate); AddParameter(cmd, "@Vote_Parent", value.IsVote_ParentNull ? DBNull.Value : (object)value.Vote_Parent); AddParameter(cmd, "@Vote_Parent_Image", value.Vote_Parent_Image); AddParameter(cmd, "@Vote_InitContent", value.Vote_InitContent); AddParameter(cmd, "@Cat_ID", value.Cat_ID); value.Vote_ID = Convert.ToInt32(cmd.ExecuteScalar()); }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="VoteRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="VoteRow"/> object.</returns> protected virtual VoteRow MapRow(DataRow row) { VoteRow mappedObject = new VoteRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Vote_ID" dataColumn = dataTable.Columns["Vote_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_ID = (int)row[dataColumn]; } // Column "UserID" dataColumn = dataTable.Columns["UserID"]; if (!row.IsNull(dataColumn)) { mappedObject.UserID = (string)row[dataColumn]; } // Column "Vote_Title" dataColumn = dataTable.Columns["Vote_Title"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_Title = (string)row[dataColumn]; } // Column "Vote_StartDate" dataColumn = dataTable.Columns["Vote_StartDate"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_StartDate = (DateTime)row[dataColumn]; } // Column "Vote_EndDate" dataColumn = dataTable.Columns["Vote_EndDate"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_EndDate = (DateTime)row[dataColumn]; } // Column "Vote_Parent" dataColumn = dataTable.Columns["Vote_Parent"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_Parent = (int)row[dataColumn]; } // Column "Vote_Parent_Image" dataColumn = dataTable.Columns["Vote_Parent_Image"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_Parent_Image = (string)row[dataColumn]; } // Column "Vote_InitContent" dataColumn = dataTable.Columns["Vote_InitContent"]; if (!row.IsNull(dataColumn)) { mappedObject.Vote_InitContent = (string)row[dataColumn]; } // Column "Cat_ID" dataColumn = dataTable.Columns["Cat_ID"]; if (!row.IsNull(dataColumn)) { mappedObject.Cat_ID = (int)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="VoteRow"/> objects.</returns> protected virtual VoteRow[] 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 vote_IDColumnIndex = reader.GetOrdinal("Vote_ID"); int userIDColumnIndex = reader.GetOrdinal("UserID"); int vote_TitleColumnIndex = reader.GetOrdinal("Vote_Title"); int vote_StartDateColumnIndex = reader.GetOrdinal("Vote_StartDate"); int vote_EndDateColumnIndex = reader.GetOrdinal("Vote_EndDate"); int vote_ParentColumnIndex = reader.GetOrdinal("Vote_Parent"); int vote_Parent_ImageColumnIndex = reader.GetOrdinal("Vote_Parent_Image"); int vote_InitContentColumnIndex = reader.GetOrdinal("Vote_InitContent"); int cat_IDColumnIndex = reader.GetOrdinal("Cat_ID"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { VoteRow record = new VoteRow(); recordList.Add(record); record.Vote_ID = Convert.ToInt32(reader.GetValue(vote_IDColumnIndex)); if (!reader.IsDBNull(userIDColumnIndex)) { record.UserID = Convert.ToString(reader.GetValue(userIDColumnIndex)); } record.Vote_Title = Convert.ToString(reader.GetValue(vote_TitleColumnIndex)); if (!reader.IsDBNull(vote_StartDateColumnIndex)) { record.Vote_StartDate = Convert.ToDateTime(reader.GetValue(vote_StartDateColumnIndex)); } if (!reader.IsDBNull(vote_EndDateColumnIndex)) { record.Vote_EndDate = Convert.ToDateTime(reader.GetValue(vote_EndDateColumnIndex)); } if (!reader.IsDBNull(vote_ParentColumnIndex)) { record.Vote_Parent = Convert.ToInt32(reader.GetValue(vote_ParentColumnIndex)); } if (!reader.IsDBNull(vote_Parent_ImageColumnIndex)) { record.Vote_Parent_Image = Convert.ToString(reader.GetValue(vote_Parent_ImageColumnIndex)); } if (!reader.IsDBNull(vote_InitContentColumnIndex)) { record.Vote_InitContent = Convert.ToString(reader.GetValue(vote_InitContentColumnIndex)); } record.Cat_ID = Convert.ToInt32(reader.GetValue(cat_IDColumnIndex)); if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((VoteRow[])(recordList.ToArray(typeof(VoteRow)))); }
/// <summary> /// Deletes the specified object from the <c>Vote</c> table. /// </summary> /// <param name="value">The <see cref="VoteRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(VoteRow value) { return(DeleteByPrimaryKey(value.Vote_ID)); }