Find someone via email

Find someone via email Intro: This is a service that allows people get the physical location of others by sending them an email with a link. This link goes to a page which makes uses HTML5 geolocation to detect the user's location, and if successful, sends this information back via email. Technical intro: The project must be developed in ASP.NET / C# / and a SQL server database. The design is not very important, but it would be nice to have it designed big & chunky using a free Bootstrap template. ---- Database ---- Table:EmailTracker - id int - senderEmail varchar(200) - senderName varchar(200) - recipientIP varchar(16) - recipientLatidude float - recipientLongitude float - DateSent DateTime default getdate() - DateReceived DateTime ---Stored Procedures--- sp_createEmailTracker (senderEmail, senderName) - inserts a new row in the EmailTracker table, returns @@identity as id sp_updateEmailTracker (recipientIP, recipientLatidude,recipientLongitude, DateReceived,id ) - updates a row in the Email Tracker table, returns senderEmail, senderName ----- ASPX Pages ---- [login to view URL] - User enters email address, and name - Presses create * this calls sp_createEmailTracker, reads back {id} * This creates a shortened url to http://<currentDomain>/[login to view URL]{id} - any url shortening system is ok, but ideally [login to view URL] -> [login to view URL] * This shortened link is shown on screen, with instructions to email to the sought person. [login to view URL] - Shows a spiner in the middle of the page, with a message "Please accept the security prompt to continue" - Calls [login to view URL] - On Success, fire postback, then call sp_updateEmailTracker with lat / lon / ip - Then sends email back to Sender, with details lat / lon / ip / current time (Include link to [login to view URL]{lat],{lon}) ---- [login to view URL] ----- DSN - Connection string to database EmailServer - SMTP server address EmailUsername - SMTP username EmailPassword - SMTP password EmailSender - Email "from" address