public int Add(MaiciousRequest obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTMaiciousRequest;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterIPAddress = new SqlParameter(PN_IPADDRESS, SqlDbType.NVarChar);
parameterIPAddress.Value = obj.IPAddress;
parameterIPAddress.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIPAddress);
SqlParameter parameterUrl = new SqlParameter(PN_URL, SqlDbType.NVarChar);
parameterUrl.Value = obj.Url;
parameterUrl.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterUrl);
SqlParameter parameterDateTime = new SqlParameter(PN_DATETIME, SqlDbType.NVarChar);
parameterDateTime.Value = obj.DateTime;
parameterDateTime.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDateTime);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
protected void Application_BeginRequest(object sender, EventArgs e)
{
TG.ExpressCMS.DataLayer.Entities.MaiciousRequest _req = new DataLayer.Entities.MaiciousRequest();
if (HttpContext.Current.Request.Url.ToString().Contains("contactus"))
{
_req.DateTime = DateTime.Now.ToString("dd/MM/yyyy");
_req.IPAddress = HttpContext.Current.Request.UserHostAddress + " " + HttpContext.Current.Request.UserHostName;
_req.Url = HttpContext.Current.Request.Url.ToString();
MaiciousRequestManager.Add(_req);
}
//if (HttpContext.Current.Request.Url.ToString().Contains("/UserPages/NewsDetails.aspx?NewsID="))
//{
// int index = HttpContext.Current.Request.Url.ToString().LastIndexOf("ID=");
// string d = (HttpContext.Current.Request.Url.ToString().Substring(index + 2, HttpContext.Current.Request.Url.ToString().Length - index - 2));
// d = d.Replace("=", "");
// HttpContext.Current.RewritePath("~/News/" + d);
//}
}
public static int Add(MaiciousRequest obj)
{
MaiciousRequestDataMapper objCaller = new MaiciousRequestDataMapper();
return objCaller.Add(obj);
}
public void PopulateMaiciousRequest(SqlDataReader _dtr, MaiciousRequest obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(MaiciousRequestDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MaiciousRequestDataMapper.CN_IPADDRESS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IPAddress = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MaiciousRequestDataMapper.CN_URL);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Url = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MaiciousRequestDataMapper.CN_DATETIME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.DateTime = _dtr.GetString((columnIndex));
}
////#PutNextFunctionhere#////
}
public MaiciousRequest GetMaiciousRequest(SqlDataReader _dtr, IList<MaiciousRequest> colobj)
{
MaiciousRequest obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new MaiciousRequest();
colobj.Add(obj);
}
return obj;
}
public IList<MaiciousRequest> GetAll()
{
MaiciousRequest obj = null;
IList<MaiciousRequest> colobj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLMaiciousRequest;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new MaiciousRequest();
colobj = new List<MaiciousRequest>();
while (_dtreader.Read())
{
obj = GetMaiciousRequest(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
//public MaiciousRequest GetByID(int ID)
//{
// MaiciousRequest obj = null;
// _connection.ConnectionString = _ConnectionString;
// _command.Connection = _connection;
// _command.CommandType = CommandType.StoredProcedure;
// _command.CommandText = SELECTMaiciousRequest;
// #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 MaiciousRequest();
// if (_dtreader.Read())
// GetEntityFromReader(_dtreader, obj);
// }
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// _dtreader.Close();
// _connection.Close();
// }
// return obj;
//}
#endregion;
#region[Get Entity from reader]
private void GetEntityFromReader(SqlDataReader _dtr, MaiciousRequest obj)
{
PopulateMaiciousRequest(_dtr, obj);
}
