public ActionStatus Exists(UserIPAddress inUserIPAddressDto) { ActionStatus status = new ActionStatus(); try { UserIPAddressDalc dalc = new UserIPAddressDalc(); bool Exists = dalc.Exists(inUserIPAddressDto); status.IsSuccessful = !Exists; } catch (MNException mnEx) { //TODO: Log error throw mnEx; } catch (Exception ex) { //TODO: Log error throw ex; } if (!status.IsSuccessful) { status.Messages.Add( new ActionMessage("An IP Address that matches this range already exists.")); } return(status); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { var request = filterContext.HttpContext.Request; UserLog audit = new UserLog() { UserName = (request.IsAuthenticated) ? filterContext.HttpContext.User.Identity.Name : "Anonymous", IPAddress = UserIPAddress.FindUserIp(), Browser = request.Browser.Browser, BrowserVersion = request.Browser.Version, Language = request.ServerVariables["HTTP_ACCEPT_LANGUAGE"].Substring(0, 2), AreaAccessed = request.Url.LocalPath, Device = request.Browser.MobileDeviceManufacturer, IsMobile = request.Browser.IsMobileDevice, DeviceModel = request.Browser.MobileDeviceModel, Platform = request.Browser.Platform, MacAddress = PCMacAddress.GetMACAddress(), CreatedDate = DateTime.Now }; ApplicationDbContext context = new ApplicationDbContext(); context.UserLogs.Add(audit); context.SaveChanges(); base.OnActionExecuting(filterContext); }
public UserIPAddress GetUserByIP(UserIPAddress inUserIPAddressDto) { UserIPAddress outUserIPAddressDto = null; try { UserIPAddressDalc dalc = new UserIPAddressDalc(); outUserIPAddressDto = dalc.GetUserByIP(inUserIPAddressDto); } catch (MNException mnEx) { //TODO: Log error throw mnEx; } catch (Exception ex) { //TODO: Log error throw ex; } return(outUserIPAddressDto); }
public List <UserIPAddress> GetList(UserIPAddress inUserIPAddressDto) { List <UserIPAddress> userIPAddresses = null; try { UserIPAddressDalc dalc = new UserIPAddressDalc(); userIPAddresses = dalc.GetList(inUserIPAddressDto); } catch (MNException mnEx) { //TODO: Log error throw mnEx; } catch (Exception ex) { //TODO: Log error throw ex; } return(userIPAddresses); }
public ActionStatus Delete(UserIPAddress inUserIPAddressDto) { ActionStatus status = new ActionStatus(); try { UserIPAddressDalc dalc = new UserIPAddressDalc(); dalc.Delete(inUserIPAddressDto); status.IsSuccessful = true; status.Messages.Add(new ActionMessage("IP Address deleted successfully.")); } catch (MNException mnEx) { //TODO: Log error throw mnEx; } catch (Exception ex) { //TODO: Log error throw ex; } if (!status.IsSuccessful) { status.Messages.Add( new ActionMessage("Could not delete IP Address.")); } return(status); }
private void SetUserIPValues() { string selVal = ddlAccountType.SelectedValue; int accountType = Convert.ToInt32(selVal); if (accountType.Equals(Constants.Account_Type_Institutional)) { DivIP.Visible = true; UserIPAddress userIPAddressDto = new UserIPAddress(); userIPAddressDto.UserId = Convert.ToInt32(_UserIdParam); UserIPAddressFacade facade = new UserIPAddressFacade(); GvIPAddresses.DataSource = facade.GetList(userIPAddressDto); GvIPAddresses.DataBind(); } else { DivIP.Visible = false; } }
public override DbCommandWrapper InitializeCommand(Database db, DataTransferObject criteria) { UserIPAddress userIPAddressDto = criteria as UserIPAddress; //Create a database command object within which T-SQL commands can //be executed. DbCommandWrapper cw = DbCommandFactory.GetStoredProcCommandWrapper(db, "spInsertUserIPAddress"); //Parameters are added here, update each line to reflect the parameter from //the subscription object cw.AddInParameter("UserId", DbType.Int32, userIPAddressDto.UserId); cw.AddInParameter("IPOctet1Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet1); cw.AddInParameter("IPOctet2Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet2); cw.AddInParameter("IPOctet3Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet3); cw.AddInParameter("IPOctet3End", DbType.Int32, userIPAddressDto.EndAddress.Octet3); cw.AddInParameter("IPOctet4Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet4); cw.AddInParameter("IPOctet4End", DbType.Int32, userIPAddressDto.EndAddress.Octet4); //Return the commandwrapper object to DALCHelper where the stored proc //will be executed return(cw); }
public ActionResult AdminResetRequest(string Email) { if (Email != null) { ResetPassword _reset = new ResetPassword(); int CheckExistance = db.Admins.Where(x => x.Email == Email).Select(y => y.UserId).FirstOrDefault(); if (CheckExistance > 0) { //make 2 random Number var random = new Random(); string RandomNumber1 = string.Empty; for (int i = 0; i < 10; i++) { RandomNumber1 = String.Concat(RandomNumber1, random.Next(10).ToString()); } string RandomNumber2 = string.Empty; for (int i = 0; i < 8; i++) { RandomNumber2 = String.Concat(RandomNumber2, random.Next(8).ToString()); } UserIPAddress _ipAddress = new UserIPAddress(); _reset.UserIP = _ipAddress.GetUserIp(); _reset.Email = Email; _reset.RandomNumber = RandomNumber1; _reset.RandomNumber2 = RandomNumber2; _reset.DateTime = DateTime.Now; _reset.AccountId = CheckExistance; db.ResetPassword.Add(_reset); db.SaveChanges(); string Sub = "Reset Password"; string Link = "http://localhost:56969/ResetPassword/AdminReset?Id1=" + RandomNumber1 + "&Id2=" + RandomNumber2; string Message = "<a href='" + Link + "'><b>localhost:56969/ResetPassword/FacultyReset?Id1=" + RandomNumber1 + "&Id2=" + RandomNumber2 + "</b></a> : Ip Address : " + _reset.UserIP; try { Mail _mail = new Mail(); _mail.SendMail(_reset.Email, Sub, Message); } catch (Exception) { ViewBag.Message = "Internet Not Supporting at this time try again later"; return(View()); } ViewBag.Message = "Check Your Email You have received a Link to reset your password"; return(View()); } } ViewBag.Message = "Enter Valid Email"; return(View()); }
public override DbCommandWrapper InitializeCommand(Database db, DataTransferObject criteria) { UserIPAddress userDto = criteria as UserIPAddress; DbCommandWrapper cw = DbCommandFactory.GetStoredProcCommandWrapper(db, "spDeleteUserIPAddress"); cw.AddInParameter("UserIPId", DbType.Int32, userDto.UserIPId); return(cw); }
public override DataTransferObject ConvertResultsDto(DbCommandWrapper cw, IDataReader reader) { UserIPAddress userIPAddressDto = null; if (reader.Read()) { userIPAddressDto = new UserIPAddress(); userIPAddressDto.UserId = Convert.ToInt32(reader["UserId"]); } return(userIPAddressDto); }
public async Task <IActionResult> Index() { UserIPAddress userIpAddress = new UserIPAddress(); FullInfoModel fullInfo; string ip = await userIpAddress.GetUserIPAddressAsync(); using (WebClient httpClient = new WebClient()) { string jsonData = httpClient.DownloadString($"http://free.ipwhois.io/json/{ip}"); fullInfo = JsonConvert.DeserializeObject <FullInfoModel>(jsonData); } return(View(fullInfo)); }
public override DbCommandWrapper InitializeCommand(Database db, DataTransferObject criteria) { UserIPAddress userIPAddressDto = criteria as UserIPAddress; DbCommandWrapper cw = DbCommandFactory.GetStoredProcCommandWrapper(db, "spGetUserIPAddressByIP"); cw.AddInParameter("@IPOctet1", DbType.Int32, userIPAddressDto.BeginAddress.Octet1); cw.AddInParameter("@IPOctet2", DbType.Int32, userIPAddressDto.BeginAddress.Octet2); cw.AddInParameter("@IPOctet3", DbType.Int32, userIPAddressDto.BeginAddress.Octet3); cw.AddInParameter("@IPOctet4", DbType.Int32, userIPAddressDto.BeginAddress.Octet4); return(cw); }
public ActionStatus Add(UserIPAddress inUserIPAddressDto) { ActionStatus status = new ActionStatus(); try { UserIPAddressDalc dalc = new UserIPAddressDalc(); //Start tran Start(); dalc.Add(inUserIPAddressDto); //commit tran SetComplete(); status.IsSuccessful = true; status.Messages.Add(new ActionMessage("IP Address successfully added.")); } catch (MNException mnEx) { //TODO: Log error //abort tran SetAbort(); throw mnEx; } catch (Exception ex) { //TODO: Log error //abort tran SetAbort(); throw ex; } if (!status.IsSuccessful) { status.Messages.Add( new ActionMessage("Could not add IP Address.")); } return(status); }
public bool Exists(UserIPAddress inUserIPAddressDto) { IDataReader rdr = ExecuteQueryReader(new UserIPAddressExistsHelper(), inUserIPAddressDto); bool found = false; if (rdr != null) { if (rdr.Read()) { Int32 exists = (Int32)rdr["Exists"]; found = (exists > 0); } } return(found); }
protected void BtnAddIP_Click(object sender, EventArgs e) { UserIPAddress userIPAddressDto = new UserIPAddress(); userIPAddressDto.UserId = Convert.ToInt32(_UserIdParam); userIPAddressDto.BeginAddress = new IPAddress(); userIPAddressDto.BeginAddress.Octet1 = Convert.ToInt32(TbIPOctet1.Text); userIPAddressDto.BeginAddress.Octet2 = Convert.ToInt32(TbIPOctet2.Text); userIPAddressDto.BeginAddress.Octet3 = Convert.ToInt32(TbIPOctet3.Text); userIPAddressDto.BeginAddress.Octet4 = Convert.ToInt32(TbIPOctet4.Text); userIPAddressDto.EndAddress = new IPAddress(); userIPAddressDto.EndAddress.Octet3 = Convert.ToInt32(TbIPOctet3End.Text); userIPAddressDto.EndAddress.Octet4 = Convert.ToInt32(TbIPOctet4End.Text); UserIPAddressFacade facade = new UserIPAddressFacade(); ActionStatus status = facade.Exists(userIPAddressDto); if (status.IsSuccessful) { status = facade.Add(userIPAddressDto); if (status.IsSuccessful) { SetUserIPValues(); } else { LblStatus.Text = GetFormattedMessages(status); } } else { LblStatus.Text = GetFormattedMessages(status); } }
public override DbCommandWrapper InitializeCommand(Database db, DataTransferObject criteria) { UserIPAddress userIPAddressDto = criteria as UserIPAddress; DbCommandWrapper cw = DbCommandFactory.GetStoredProcCommandWrapper(db, "spAdminExistsUserIPAddress"); cw.AddInParameter("IPOctet1Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet1); cw.AddInParameter("IPOctet2Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet2); cw.AddInParameter("IPOctet3Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet3); cw.AddInParameter("IPOctet3End", DbType.Int32, userIPAddressDto.EndAddress.Octet3); cw.AddInParameter("IPOctet4Begin", DbType.Int32, userIPAddressDto.BeginAddress.Octet4); cw.AddInParameter("IPOctet4End", DbType.Int32, userIPAddressDto.EndAddress.Octet4); return(cw); }
protected void GvIPAddresses_RowDeleting(object sender, GridViewDeleteEventArgs e) { DataKey key = GvIPAddresses.DataKeys[e.RowIndex]; bool isDeleted = false; if (key != null) { int UserIPId; int.TryParse(key.Value.ToString(), out UserIPId); if (UserIPId > 0) { UserIPAddressFacade facade = new UserIPAddressFacade(); UserIPAddress userIPAddressDto = new UserIPAddress(); userIPAddressDto.UserIPId = UserIPId; ActionStatus status = facade.Delete(userIPAddressDto); LblStatus.Text = GetFormattedMessages(status); isDeleted = status.IsSuccessful; } } if (isDeleted) { SetUserIPValues(); } else { e.Cancel = true; } }
public List <UserIPAddress> GetList(UserIPAddress inUserIPAddressDto) { return(ExecuteQueryList <UserIPAddress>(new UserIPAddressListSelectHelper(), inUserIPAddressDto)); }
public Login AuthenticateIP(Login inLoginDto) { if (null == inLoginDto) { throw new ArgumentNullException("inLoginDto"); } if (null == inLoginDto.IPAddress) { throw new ArgumentNullException("IPAddress"); } Login outLoginDto = null; try { string[] octets = inLoginDto.IPAddress.Split(new char[] { '.' }); UserIPAddress inUserIPAddressDto = new UserIPAddress(); inUserIPAddressDto.BeginAddress.Octet1 = Convert.ToInt32(octets[0]); inUserIPAddressDto.BeginAddress.Octet2 = Convert.ToInt32(octets[1]); inUserIPAddressDto.BeginAddress.Octet3 = Convert.ToInt32(octets[2]); inUserIPAddressDto.BeginAddress.Octet4 = Convert.ToInt32(octets[3]); UserIPAddressDalc dalc = new UserIPAddressDalc(); UserIPAddress outUserIPAddressDto = dalc.GetUserByIP(inUserIPAddressDto); if (outUserIPAddressDto != null) { UserFacade userFacade = new UserFacade(); User inUserDto = new User(); inUserDto.UserId = outUserIPAddressDto.UserId; User outUserDto = userFacade.GetUser(inUserDto); if (outUserDto != null) { outLoginDto = new Login(); outLoginDto.EmailAddress = outUserDto.EmailAddress; } } } catch (MNException mnEx) { //TODO: Log error throw mnEx; } catch (Exception ex) { //TODO: Log error throw ex; } return(outLoginDto); }
public UserIPAddress GetUserByIP(UserIPAddress inUserIPAddressDto) { return(ExecuteQueryDto(new UserIPAddressByIPSelectHelper(), inUserIPAddressDto) as UserIPAddress); }
public int Delete(UserIPAddress inUserIPAddressDto) { return(ExecuteNonQuery(new UserIPAddressDeleteHelper(), inUserIPAddressDto)); }
public int Add(UserIPAddress inUserIPAddressDto) { return(ExecuteNonQuery(new UserIPAddressInsertHelper(), inUserIPAddressDto)); }