public int Add(ForumGroup obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SP_ADD_FORUM_GROUP;
#region [Parameters]
SqlParameter parameter = new SqlParameter(PN_FORUM_GROUP_ID, System.Data.SqlDbType.Int);
parameter.Direction = System.Data.ParameterDirection.Output;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_GROUP_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_GROUP_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_GROUP_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_GROUP_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_GROUP_NAME, System.Data.SqlDbType.NVarChar);
parameter.Value = obj.Name;
parameter.Direction = System.Data.ParameterDirection.Input;
_command.Parameters.Add(parameter);
parameter = new SqlParameter(PN_FORUM_GROUP_ORDER_ID, System.Data.SqlDbType.Int);
parameter.Value = obj.OrderID;
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_GROUP_ID].Value);
return obj.ID;
}
public void PopulateForumGroup(SqlDataReader _dtr, ForumGroup obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_CREATED_BY);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreatedBy = _dtr.GetInt32((columnIndex));
}
#region GetDateTime
int TotalDays = 0, TotalSeconds = 0;
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_CREATION_TOT_DAY);
if (!_dtr.IsDBNull(columnIndex))
{
TotalDays = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_CREATION_TOT_SECOND);
if (!_dtr.IsDBNull(columnIndex))
{
TotalSeconds = _dtr.GetInt32((columnIndex));
}
obj.CreationDate = Helper.HelperMethods.ConvertToDateTime(TotalDays, TotalSeconds);
#endregion
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_IS_DELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(ForumGroupDataMapper.CN_FORUM_GROUP_ORDER_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.OrderID = _dtr.GetInt32((columnIndex));
}
}
public static void Update(ForumGroup obj)
{
ForumGroupDataMapper objCaller = new ForumGroupDataMapper();
objCaller.Update(obj);
}
public static int Add(ForumGroup obj)
{
ForumGroupDataMapper objCaller = new ForumGroupDataMapper();
return objCaller.Add(obj);
}
private void GetEntityFromReader(SqlDataReader _dtr, ForumGroup obj)
{
PopulateForumGroup(_dtr, obj);
}
public ForumGroup GetForumGroup(SqlDataReader _dtr, IList<ForumGroup> colobj)
{
ForumGroup obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_FORUM_GROUP_ID].ToString())).FirstOrDefault();
if (null == obj)
{
obj = new ForumGroup();
colobj.Add(obj);
}
return obj;
}
public ForumGroup GetByID(int ID)
{
ForumGroup obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SP_GET_FORUM_GROUP_BY_ID;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_FORUM_GROUP_ID, SqlDbType.Int);
parameterID.Value = ID;
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 ForumGroup();
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
void btnSave_Click(object sender, EventArgs e)
{
try
{
ForumGroup forumGroup = new ForumGroup();
forumGroup.Name = txtName.Text;
forumGroup.CreatedBy = SecurityContext.LoggedInUser.ID;
forumGroup.CreationDate = DateTime.Now;
forumGroup.IsDeleted = false;
forumGroup.OrderID = 0;
ForumGroupManager.Add(forumGroup);
dvProblems.InnerText = "Saved Successfully";
AddMode();
BindGrid();
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
upnlGrid.Update();
}
