Beispiel #1
0
        public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
        {
            if (!ModelState.IsValid)
            {
                return View(model);
            }

            // This doesn't count login failures towards account lockout
            // To enable password failures to trigger account lockout, change to shouldLockout: true
            var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: false);
            
            switch (result)
            {
                case SignInStatus.Success:
                    var user = await UserManager.FindByEmailAsync(model.Email);
                   
                        UserTracking NewUser = new UserTracking();
                        NewUser.IPAddress = Request.ServerVariables["REMOTE_ADDR"];
                        NewUser.user_Id = user.Id;
                        NewUser.insert(NewUser);

                    return RedirectToLocal(returnUrl);
                case SignInStatus.LockedOut:
                    return View("Lockout");
                case SignInStatus.RequiresVerification:
                    return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
                case SignInStatus.Failure:
                default:
                    ModelState.AddModelError("", "Invalid login attempt.");
                    return View(model);
            }

        }
Beispiel #2
0
        public ActionResult Index(int? page, UserTracking U)
        {
            ModelState.SetModelValue("StartDate", new ValueProviderResult(DateTime.Now, null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("EndDate", new ValueProviderResult(DateTime.Today, null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("StartDateHours", new ValueProviderResult("12", null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("EndDateHours", new ValueProviderResult("11", null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("StartDateMinutes", new ValueProviderResult("00", null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("EndDateMinutes", new ValueProviderResult("50", null, CultureInfo.InvariantCulture));
            ModelState.SetModelValue("EndDateAmPm", new ValueProviderResult("Pm", null, CultureInfo.InvariantCulture));
            ViewBag.GetHours = U.GetHours();
            ViewBag.GetMins = U.GetMins();
            ViewBag.GetAmPm = U.GetAmPm();
            DateTime startDate = U.StartDate;
            if (page.HasValue)
            {
                if (U.StartDateAmPm.ToUpper() == "PM")
                {
                    U.StartDateHours = (U.StartDateHours % 12) + 12;
                }

                if (U.EndDateAmPm.ToUpper() == "PM")
                {
                    U.EndDateHours = (U.EndDateHours % 12) + 12;
                }
                ModelState.SetModelValue("StartDateHours", new ValueProviderResult("12", null, CultureInfo.InvariantCulture));
                ModelState.SetModelValue("EndDateHours", new ValueProviderResult("11", null, CultureInfo.InvariantCulture));
                ModelState.SetModelValue("StartDateMinutes", new ValueProviderResult("00", null, CultureInfo.InvariantCulture));
                ModelState.SetModelValue("EndDateMinutes", new ValueProviderResult("50", null, CultureInfo.InvariantCulture));
                ModelState.SetModelValue("EndDateAmPm", new ValueProviderResult("Pm", null, CultureInfo.InvariantCulture));
                DateTime StartDate = U.StartDate;
                TimeSpan ts = new TimeSpan(U.StartDateHours, U.StartDateMinutes, 0);
                startDate = startDate.Date + ts;
                DateTime EndDate = U.EndDate;
                TimeSpan ts1 = new TimeSpan(U.EndDateHours, U.EndDateMinutes, 0);
                EndDate = EndDate.Date + ts1;
                ViewBag.GetHours = U.GetHours();
                ViewBag.GetMins = U.GetMins();
                ViewBag.GetAmPm = U.GetAmPm();
                if (U.RadioButtonSelectedValue == "1")
                {
                    U.UserTrackingList = U.UserTrackingReport();
                    U.UserTrackingList = U.UserTrackingList.Where(a => a.TimeStamp >= startDate && a.TimeStamp <= EndDate).ToList();
                    U.PagedUserTrackingList = U.UserTrackingList.ToPagedList(page ?? 1, 10);
                    return View(U);
                }
                else
                {
                    U.SearchedDataList = U.SearchDataReport();
                    U.SearchedDataList = U.SearchedDataList.Where(a => a.TimeStamp >= startDate && a.TimeStamp <= EndDate).ToList();
                    U.PagedUserTrackingList = U.SearchedDataList.ToPagedList(page ?? 1, 10);
                    return View(U);
                }
            }

            return View();
        }
Beispiel #3
0
        public List<UserTracking> UserTrackingReport()
        {
            List<UserTracking> UTList = new List<UserTracking>();

            string cs = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
            using (MySqlConnection con = new MySqlConnection(cs))
            {
                con.Open();
                MySqlCommand cmd = new MySqlCommand("Sp_UserTrackingReport", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                MySqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    UserTracking UT = new UserTracking();
                    UT.IPAddress = rdr["IPAddress"].ToString();
                    UT.TimeStamp = Convert.ToDateTime(rdr["TimeIn"]);
                    UT.user_Id = rdr["userid"].ToString();
                    UT.Name = rdr["Name"].ToString();
                    UT.CompanyName = rdr["CompanyName"].ToString();
                    UT.Email = rdr["Email"].ToString();
                    UT.PhoneNumber = rdr["PhoneNumber"].ToString();
                    UTList.Add(UT);
                }
            }
            return UTList;
        }
Beispiel #4
0
        public void insert(UserTracking user)
        {
            string cs = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

            using (MySqlConnection con = new MySqlConnection(cs))
            {
                con.Open();

                MySqlCommand cmd = new MySqlCommand("Sp_AddUserTracking", con);

                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@_User_Id", user_Id);
                cmd.Parameters.AddWithValue("@_IPAddress", IPAddress);
                cmd.Parameters.AddWithValue("@_TimeStamp", DateTime.Now);
                cmd.ExecuteNonQuery();

            }
        }
Beispiel #5
0
        public async Task<ActionResult> Register(RegisterViewModel model)
        {
            if (ModelState.IsValid)
            {
                var user = new ApplicationUser { UserName = model.Email, Email = model.Email , Name =model.Name ,
                   PhoneNumber=model.PhoneNumber,PhoneNumber2 = model.PhoneNumber2,
                    CompanyEmail = model.CompanyEmail ,CompanyName=model.CompanyName,Address = model.Address,
                    Address2 = model.Address2,
                    City =model.City, State=model.State,Zip=model.Zip,Fax=model.Fax};
                var result = await UserManager.CreateAsync(user, model.Password);
                if (result.Succeeded)
                {
                    await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false);
                   
                    UserTracking NewUser = new UserTracking();
                    NewUser.IPAddress = Request.ServerVariables["REMOTE_ADDR"];
                    NewUser.user_Id = user.Id;
                    NewUser.insert(NewUser);

                    // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
                    // Send an email with this link
                    // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
                    // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
                    // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");

                    return RedirectToAction("Index", "Home");
                }
                AddErrors(result);
            }

            // If we got this far, something failed, redisplay form
            return View(model);
        }
Beispiel #6
0
 protected void Session_Start(object sender, EventArgs e)
 {
     UserTracking NewUser = new UserTracking();
     NewUser.IPAddress = Request.ServerVariables["REMOTE_ADDR"];
     NewUser.insert(NewUser);
 }