public int Add(Poll obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTPoll;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterDate = new SqlParameter(PN_DATE, SqlDbType.NVarChar);
parameterDate.Value = obj.Date;
parameterDate.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDate);
SqlParameter parameterCreatedBy = new SqlParameter(PN_CREATEDBY, SqlDbType.Int);
parameterCreatedBy.Value = obj.CreatedBy;
parameterCreatedBy.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCreatedBy);
SqlParameter parameterIsClosed = new SqlParameter(PN_ISCLOSED, SqlDbType.Int);
parameterIsClosed.Value = obj.IsClosed;
parameterIsClosed.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsClosed);
SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Int);
parameterIsDeleted.Value = obj.IsDeleted;
parameterIsDeleted.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsDeleted);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
public static void Update(Poll obj)
{
PollDataMapper objCaller = new PollDataMapper();
objCaller.Update(obj);
}
public static int Add(Poll obj)
{
PollDataMapper objCaller = new PollDataMapper();
return objCaller.Add(obj);
}
public void PopulatePoll(SqlDataReader _dtr, Poll obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_DATE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Date = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_CREATEDBY);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreatedBy = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_ISCLOSED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsClosed = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(PollDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
}
private void EditMode()
{
if (ObjectID > 0)
{
TG.ExpressCMS.DataLayer.Entities.Poll _Poll = new TG.ExpressCMS.DataLayer.Entities.Poll();
_Poll = PollManager.GetByID(ObjectID);
if (null == _Poll)
return;
txtDate.Text = _Poll.Date;
txtName.Text = _Poll.Name;
chkClosed.Checked = _Poll.IsClosed;
plcControls.Visible = true;
BindGridDet();
upnlPollDetails.Update();
}
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
Poll _Poll = new TG.ExpressCMS.DataLayer.Entities.Poll();
if (ObjectID <= 0)
{
try
{
_Poll.Date = DateTime.Now.ToString("dd/MM/yyyy");
_Poll.CreatedBy = SecurityContext.LoggedInUser.ID;
_Poll.IsClosed = chkClosed.Checked;
_Poll.IsDeleted = false;
_Poll.Name = txtName.Text;
PollManager.Add(_Poll);
AddMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
_Poll = PollManager.GetByID(ObjectID);
_Poll.Date = DateTime.Now.ToString("dd/MM/yyyy");
_Poll.CreatedBy = SecurityContext.LoggedInUser.ID;
_Poll.IsClosed = chkClosed.Checked;
_Poll.IsDeleted = false;
_Poll.Name = txtName.Text;
if (null == _Poll)
{
dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures);
return;
}
PollManager.Update(_Poll);
EditMode();
dvProblems.InnerText = "Saved Successfully";
}
catch (Exception ex)
{
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
BindGridDet();
}
public Poll GetPoll(SqlDataReader _dtr, IList<Poll> colobj)
{
Poll obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new Poll();
colobj.Add(obj);
}
return obj;
}
public IList<Poll> GetAll()
{
Poll obj = null;
IList<Poll> colobj = new List<Poll>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLPoll;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new Poll();
colobj = new List<Poll>();
while (_dtreader.Read())
{
obj = GetPoll(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, Poll obj)
{
PopulatePoll(_dtr, obj);
}
public Poll GetByID(int ID)
{
Poll obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTPoll;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_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)
{
obj = new Poll();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
