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); }