public static int Add(ForumPost obj)
{
if (obj == null)
throw new Exception("Object is null");
ForumPostDataMapper objCaller = new ForumPostDataMapper();
return objCaller.Add(obj);
}
public static void Update(ForumPost obj)
{
if (obj == null)
throw new Exception("Object is null");
ForumPostDataMapper objCaller = new ForumPostDataMapper();
objCaller.Update(obj);
}
public void PopulateForumPost(SqlDataReader _dtr, ForumPost obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_CREATED_BY);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreatedBy = _dtr.GetInt32((columnIndex));
}
#region GetDateTime
int TotalDays = 0, TotalSeconds = 0;
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_CREATION_TOT_DAY);
if (!_dtr.IsDBNull(columnIndex))
{
TotalDays = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_CREATION_TOT_SECOND);
if (!_dtr.IsDBNull(columnIndex))
{
TotalSeconds = _dtr.GetInt32((columnIndex));
}
obj.CreationDate = Helper.HelperMethods.ConvertToDateTime(TotalDays, TotalSeconds);
#endregion
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_DETAILS_HTML);
if (!_dtr.IsDBNull(columnIndex))
{
obj.DetailsHtml = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_DETAILS_TEXT);
if (!_dtr.IsDBNull(columnIndex))
{
obj.DetailsText = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_FORUM_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ForumID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_STATUS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Status = (RootEnums.ForumPostStatus)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_IS_DELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_PARENT_POST_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ParentPostID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumPostDataMapper.CN_FORUM_POST_THREAD_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ForumThreadID = _dtr.GetInt32((columnIndex));
}
}
private void GetEntityFromReader(SqlDataReader _dtr, ForumPost obj)
{
PopulateForumPost(_dtr, obj);
PopulateForumUserSummary(_dtr, obj.UserSummary);
}
public ForumPost GetForumPost(SqlDataReader _dtr, IList<ForumPost> colobj)
{
ForumPost obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_FORUM_POST_ID].ToString())).FirstOrDefault();
if (null == obj)
{
obj = new ForumPost();
colobj.Add(obj);
}
return obj;
}
public int Add(ForumPost obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SP_ADD_FORUM_POST;
#region [Parameters]
SqlParameter parameter = new SqlParameter(PN_FORUM_POST_ID, System.Data.SqlDbType.Int);
parameter.Direction = System.Data.ParameterDirection.Output;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_POST_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_POST_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_POST_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_POST_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_POST_NAME, System.Data.SqlDbType.NVarChar);
parameter.Value = obj.Name;
parameter.Direction = System.Data.ParameterDirection.Input;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_POST_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_POST_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_POST_FORUM_ID, System.Data.SqlDbType.Int);
parameter.Value = obj.ForumID;
parameter.Direction = System.Data.ParameterDirection.Input;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_POST_STATUS, System.Data.SqlDbType.Int);
parameter.Value = (int)obj.Status;
parameter.Direction = System.Data.ParameterDirection.Input;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_POST_PARENT_POST_ID, System.Data.SqlDbType.Int);
parameter.Value = obj.ParentPostID;
parameter.Direction = System.Data.ParameterDirection.Input;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_POST_THREAD_ID, System.Data.SqlDbType.Int);
parameter.Value = obj.ForumThreadID;
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_POST_ID].Value);
return obj.ID;
}
public ForumPost GetByID(int ID, int IsDeleted)
{
ForumPost obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SP_GET_FORUM_POST_BY_ID;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_FORUM_POST_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
parameterID = new SqlParameter(PN_FORUM_POST_IS_DELETED, SqlDbType.Int);
parameterID.Value = IsDeleted;
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 ForumPost();
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
