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