public static void Update(Forum obj) { if (obj == null) throw new Exception("Object is null"); ForumDataMapper objCaller = new ForumDataMapper(); objCaller.Update(obj); }
public static int Add(Forum obj) { if (obj == null) throw new Exception("Object is null"); ForumDataMapper objCaller = new ForumDataMapper(); return objCaller.Add(obj); }
public int Add(Forum obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SP_ADD_FORUM; #region [Parameters] SqlParameter parameter = new SqlParameter(PN_FORUM_ID, System.Data.SqlDbType.Int); parameter.Direction = System.Data.ParameterDirection.Output; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_CREATED_BY, System.Data.SqlDbType.Int); parameter.Value = obj.CreatedBy; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_CREATION_TOT_DAY, System.Data.SqlDbType.Int); parameter.Value = Helper.HelperMethods.GetTotalDays(obj.CreationDate); parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_CREATION_TOT_SECOND, System.Data.SqlDbType.Int); parameter.Value = Helper.HelperMethods.GetTotalSeconds(obj.CreationDate); parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_IS_DELETED, System.Data.SqlDbType.Bit); parameter.Value = obj.IsDeleted; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_NAME, System.Data.SqlDbType.NVarChar); parameter.Value = obj.Name; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_DETAILS_HTML, System.Data.SqlDbType.NText); parameter.Value = obj.DetailsHtml; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_DETAILS_TEXT, System.Data.SqlDbType.NText); parameter.Value = obj.DetailsText; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_GROUP_ID, System.Data.SqlDbType.Int); parameter.Value = obj.ForumGroupID; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_IS_ACTIVE, System.Data.SqlDbType.Bit); parameter.Value = obj.IsActive; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_LAST_POST_ID, System.Data.SqlDbType.Int); parameter.Value = obj.LastForumPostID; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_LAST_THREAD_ID, System.Data.SqlDbType.Int); parameter.Value = obj.LastForumThreadID; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_MOST_ACCESS_THREAD_ID, System.Data.SqlDbType.Int); parameter.Value = obj.MostAccessForumThreadID; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_NUMBER_VIEWS, System.Data.SqlDbType.Int); parameter.Value = obj.NumberForumViews; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_TOTAL_POSTS, System.Data.SqlDbType.Int); parameter.Value = obj.TotalPosts; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); parameter = new SqlParameter(PN_FORUM_TOTAL_THREADS, System.Data.SqlDbType.Int); parameter.Value = obj.TotalThreads; parameter.Direction = System.Data.ParameterDirection.Input; _command.Parameters.Add(parameter); #endregion _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(_command.Parameters[PN_FORUM_ID].Value); return obj.ID; }
private void GetEntityFromReader(SqlDataReader _dtr, Forum obj) { PopulateForum(_dtr, obj); }
public Forum GetForum(SqlDataReader _dtr, IList<Forum> colobj) { Forum obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_FORUM_ID].ToString())).FirstOrDefault(); if (null == obj) { obj = new Forum(); colobj.Add(obj); } return obj; }
public Forum GetPublishedByID(int ID, bool IsActive) { Forum obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SP_GET_PUBLISHED_FORUM_BY_ID; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_FORUM_ID, SqlDbType.Int); parameterID.Value = ID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); parameterID = new SqlParameter(PN_FORUM_IS_ACTIVE, SqlDbType.Int); parameterID.Value = IsActive; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); #endregion _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { while (_dtreader.Read()) { if (obj == null) obj = new Forum(); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public void PopulateForum(SqlDataReader _dtr, Forum obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_CREATED_BY); if (!_dtr.IsDBNull(columnIndex)) { obj.CreatedBy = _dtr.GetInt32((columnIndex)); } #region GetDateTime int TotalDays = 0, TotalSeconds = 0; columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_CREATION_TOT_DAY); if (!_dtr.IsDBNull(columnIndex)) { TotalDays = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_CREATION_TOT_SECOND); if (!_dtr.IsDBNull(columnIndex)) { TotalSeconds = _dtr.GetInt32((columnIndex)); } obj.CreationDate = Helper.HelperMethods.ConvertToDateTime(TotalDays, TotalSeconds); #endregion columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_DETAILS_HTML); if (!_dtr.IsDBNull(columnIndex)) { obj.DetailsHtml = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_DETAILS_TEXT); if (!_dtr.IsDBNull(columnIndex)) { obj.DetailsText = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_GROUP_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ForumGroupID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_IS_ACTIVE); if (!_dtr.IsDBNull(columnIndex)) { obj.IsActive = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_IS_DELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_LAST_POST_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.LastForumPostID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_LAST_THREAD_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.LastForumThreadID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_MOST_ACCESS_THREAD_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.MostAccessForumThreadID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_NUMBER_VIEWS); if (!_dtr.IsDBNull(columnIndex)) { obj.NumberForumViews = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_TOTAL_POSTS); if (!_dtr.IsDBNull(columnIndex)) { obj.TotalPosts = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumDataMapper.CN_FORUM_TOTAL_THREADS); if (!_dtr.IsDBNull(columnIndex)) { obj.TotalThreads = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ForumThreadDataMapper.CN_FORUM_THREAD_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.LastThreadName = _dtr.GetString(columnIndex); } columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.ForumGroupName = _dtr.GetString(columnIndex); } }