Пример #1
0
        public ActionResult Register(user_login user_Login)
        {
            try
            {
                using (var db = new HRISContext())
                {
                    var chkUser = (from s in db.user_login where s.user_id == user_Login.user_id select s).FirstOrDefault();
                    if (chkUser == null)
                    {
                        var keyNew = PasswordHashHelper.GeneratePassword(10);
                        var pass   = PasswordHashHelper.EncodePassword(user_Login.password, keyNew);

                        user_Login.password = pass;
                        user_Login.vcode    = keyNew;

                        db.user_login.Add(user_Login);
                        db.SaveChanges();
                        ModelState.Clear();

                        return(RedirectToAction("LogIn", "Login"));
                    }
                    ViewBag.ErrorMessage = "User Already Exixts!";
                    return(View());
                }
            }
            catch (Exception e)
            {
                ViewBag.ErrorMessage = "Some exception occured" + e;
                return(View());
            }
        }
Пример #2
0
        public IHttpActionResult UserPassRecovery(dynamic obj)
        {
            JObject je     = new JObject();
            JObject jo     = new JObject();
            string  getStr = string.Empty;

            je = (JObject)JsonConvert.DeserializeObject(obj.ToString());

            SqlSugarClient sql = datahandle.GetDataConnect();
            //校验客户账户是否存在
            List <user_login> list_user = sql.Queryable <user_login>().Where(t =>
                                                                             t.userName == je["userName"].ToString()).ToList();

            if (list_user.Count > 0)
            {
                user_login user_LoginModel = list_user.First();
                user_LoginModel.userPwd = Md5Control.MD5Encrypt(je["userPwd"].ToString());
                int Result = sql.Updateable <user_login>(user_LoginModel).ExecuteCommand();
                if (Result == 1)
                {
                    jo.Add("Message", "修改完成");
                    jo.Add("Result", 1);
                }
                else
                {
                    jo.Add("Result", 0);
                    jo.Add("Message", "修改失败");
                }
            }
            return(Json(jo.ToString()));
        }
Пример #3
0
        public IHttpActionResult Putuser_login(int id, user_login user_login)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != user_login.ID)
            {
                return(BadRequest());
            }

            db.Entry(user_login).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!user_loginExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #4
0
 public bool DeleteAccount(user_login user, String username, String token)
 {
     if (new LoginDAOFirebase().CheckToken(username, token))
     {
         if (user.username == username || new LoginDAOSQL().CheckPermission(username) > new LoginDAOSQL().CheckPermission(user.username))
         {
             bool check = new LoginDAOSQL().DeleteAccount(user);
             if (check)
             {
                 new LoginDAOFirebase().History(username, "Xóa thành công tài khoản " + user.username);
             }
             else
             {
                 new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username);
             }
             return(check);
         }
         else
         {
             new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username);
             return(false);
         }
     }
     else
     {
         new LoginDAOFirebase().History(username, "Xóa thất bại tài khoản " + user.username);
         return(false);
     }
 }
Пример #5
0
 public bool InsertAccount(user_login user, String username, String token)
 {
     if (new LoginDAOFirebase().CheckToken(username, token))
     {
         if (new LoginDAOSQL().CheckPermission(username) > 1)
         {
             bool check = new LoginDAOSQL().InsertAccount(user);
             if (check)
             {
                 new LoginDAOFirebase().History(username, "Đăng ký thành công tài khoản " + user.username);
             }
             else
             {
                 new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username);
             }
             return(check);
         }
         else
         {
             new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username);
             return(false);
         }
     }
     else
     {
         new LoginDAOFirebase().History(username, "Đăng ký thất bại tài khoản " + user.username);
         return(false);
     }
 }
Пример #6
0
        public IHttpActionResult Getuser_login(int id)
        {
            user_login user_login = db.user_login.Find(id);

            if (user_login == null)
            {
                return(NotFound());
            }

            return(Ok(user_login));
        }
Пример #7
0
        public IHttpActionResult Postuser_login(user_login user_login)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.user_login.Add(user_login);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = user_login.ID }, user_login));
        }
Пример #8
0
        public IHttpActionResult Deleteuser_login(int id)
        {
            user_login user_login = db.user_login.Find(id);

            if (user_login == null)
            {
                return(NotFound());
            }

            db.user_login.Remove(user_login);
            db.SaveChanges();

            return(Ok(user_login));
        }
Пример #9
0
        public IHttpActionResult PwdUpdate(dynamic obj)
        {
            JObject je = new JObject();
            JObject jo = new JObject();

            try
            {
                je = (JObject)JsonConvert.DeserializeObject(obj.ToString());
                LoggerHelp.LogInfo("PwdUpdate接收数据:" + je);
                SqlSugarClient    sql         = datahandle.GetDataConnect();
                List <user_login> user_Logins = sql.Queryable <user_login>().Where(t =>
                                                                                   t.userName == je["userName"].ToString()).ToList();
                if (user_Logins.Count == 1)
                {
                    user_login user_Login = user_Logins[0];
                    if (user_Login.userPwd == Md5Control.MD5Encrypt(je["userPwdOld"].ToString()))
                    {
                        user_Login.userPwd = Md5Control.MD5Encrypt(je["userPwdNew"].ToString());
                        int Result = sql.Updateable(user_Login).ExecuteCommand();
                        if (Result == 1)
                        {
                            jo.Add("Result", 1);
                            jo.Add("Message", "密码更换成功");
                        }
                        else
                        {
                            jo.Add("Result", 0);
                            jo.Add("Message", "密码更换失败");
                        }
                    }
                    else
                    {
                        jo.Add("Result", 0);
                        jo.Add("Message", "原密码错误");
                    }
                }
                else
                {
                    jo.Add("Result", 0);
                    jo.Add("Message", "用户名不存在");
                }
            }
            catch (Exception error)
            {
                jo.Add("Result", 3);
                jo.Add("Message", error.Message);
            }
            LoggerHelp.LogInfo("PwdUpdate返回数据:" + jo);
            return(Json(jo.ToString()));
        }
Пример #10
0
 public bool DeleteAccount(user_login login)
 {
     try
     {
         user_login animal = db.user_logins.Single(u => u.ID == login.ID);
         db.user_logins.DeleteOnSubmit(animal);
         db.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Пример #11
0
 public bool InsertAccount(user_login login)
 {
     try
     {
         login.password = CreateMD5(login.password);
         db.user_logins.InsertOnSubmit(login);
         db.SubmitChanges();
         return(true);
     }
     catch
     {
         return(false);
     }
 }
Пример #12
0
        public IHttpActionResult GetRegisMsg(object obj)
        {
            JObject je = new JObject();
            JObject jo = new JObject();

            try
            {
                string getStr = string.Empty;
                je = (JObject)JsonConvert.DeserializeObject(obj.ToString());
                LoggerHelp.LogInfo("GetRegisMsg接收数据:" + je);
                //判断一下用户名是否存在是否被注册过
                SqlSugarClient    sql       = datahandle.GetDataConnect();
                List <user_login> list_user = sql.Queryable <user_login>().Where(t =>
                                                                                 t.userName == je["userName"].ToString()).ToList();
                if (list_user.Count > 0)
                {
                    jo.Add("Result", 3);
                    jo.Add("Message", "用户名已存在");
                }
                else
                {
                    user_login user = new user_login();
                    user.userName = je["userName"].ToString();
                    user.userPwd  = Md5Control.MD5Encrypt(je["userPwd"].ToString());
                    user.userID   = dataTransfer.StringToHexString(user.userName + je["userPwd"].ToString(), Encoding.UTF8);
                    //user.id = Convert.ToInt32(je["id"].ToString());
                    int Result = sql.Insertable(user).ExecuteCommand();
                    if (Result == 1)
                    {
                        jo.Add("Message", "注册成功");
                        jo.Add("Result", 1);
                    }
                    else
                    {
                        jo.Add("Result", 0);
                        jo.Add("Message", "注册失败");
                    }
                }
            }
            catch (Exception error)
            {
                jo.Add("Result", 4);
                jo.Add("Message", error.Message);
            }
            LoggerHelp.LogInfo("GetRegisMsg返回数据:" + jo);
            return(Json(jo.ToString()));
        }
Пример #13
0
        public IHttpActionResult LoginCheck(user_login user)
        {
            user_login foundUser = db.user_login.Where(a => a.user_username.Equals(user.user_username)).FirstOrDefault();

            if (foundUser == null)
            {
                return(NotFound());
            }
            else if (foundUser != null && user.user_password.Equals(foundUser.user_password))
            {
                return(Ok("Correct"));
            }
            else
            {
                return(NotFound());
            }
        }
Пример #14
0
        /// <summary>
        /// 用户注册
        /// </summary>
        /// <param name="phone">手机号</param>
        /// <param name="password">密码</param>
        /// <param name="name">用户名</param>
        /// <param name="code">验证码</param>
        /// <returns></returns>
        public ActionResult Regist(string phone, string password, string name, string code)
        {
            //验证验证码
            password = password.Trim();
            if (!yzm(phone, code))
            {
                return(Json(new { status = 1, desc = "验证码错误,请再申请一遍" }, JsonRequestBehavior.AllowGet));
            }
            ;
            var query = bd.user_login.Where(p => p.name == phone).AsNoTracking();

            if (query.Any())
            {
                return(Json(new { status = 1, desc = "该手机号已经注册,请登录" }, JsonRequestBehavior.AllowGet));
            }
            ;
            var log = new user
            {
                name            = name,
                phone           = phone,
                ins_date        = DateTime.Now,
                disabled        = false,
                last_login_date = DateTime.Now,
                last_login_ip   = GetUserIP()
            };

            bd.user.Add(log);
            bd.SaveChanges();
            var log_l = new user_login
            {
                ins_date = DateTime.Now,
                uid      = log.uid,
                name     = phone,
                password = Encrypt.DesEncrypt(password, "heiban"),
                type     = "phone"
            };

            bd.user_login.Add(log_l);
            bd.SaveChanges();
            string biaozhi = log.uid.ToString() + "asd" + DateTime.Now.ToString();

            Redis.setHash("user", log.uid.ToString(), biaozhi);
            return(Json(new { status = 0, desc = "注册成功", msg = new { uid = Encrypt.DesEncrypt(biaozhi, "heiban") } }, JsonRequestBehavior.AllowGet));
        }
Пример #15
0
        public object PostLoginInfo([FromBody] user_login userLogin)
        {
            using (var entities = new iBlogEntities())
            {
                var idEntity    = entities.user_login.SqlQuery("SELECT *  FROM user_login where user_id = " + userLogin.user_id);
                var isNUllCount = idEntity.ToList().Count;
                if (isNUllCount == 0)
                {
                    return("User ID Do Not Exist");
                }
                var check = userLogin.password.Equals(idEntity.ToArray()[0].password);
                if (check)
                {
                    return("Verified");
                }
            }

            return("User ID Do Not Exist or Wrong Password");
        }
Пример #16
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         obj = (user_login)Session["Uesrinfo"];
     }
     catch
     {
         obj = new user_login();
     }
     if (obj == null)
     {
         obj = new user_login();
     }
     if (!obj.islogin)
     {
         Response.Redirect(".");
     }
 }
Пример #17
0
        public ActionResult Edit(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            //var user_Login = (from u in db.user_login
            //                  where u.user_id == id
            //                  select u).ToList();
            user_login user_Login = db.user_login.Find(id);

            if (user_Login == null)
            {
                return(HttpNotFound());
            }

            return(View(user_Login));
        }
Пример #18
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (Session["loginform"].ToString() == captcha.Text)
            {
                string str   = "";
                bool   is_ok = false;
                int    j     = 0;
                PDBC   db    = new PDBC("honarjoo");
                db.Connect();
                using (DataTable dt = db.Select("SELECT [id],[name],[us],[pass] FROM [dbo].[login]"))
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        while (j == i)
                        {
                            if (dt.Rows[j].ItemArray[2].ToString() == inputun.Text && dt.Rows[j].ItemArray[3].ToString() == inputPass.Text)
                            {
                                str   = dt.Rows[j].ItemArray[1].ToString();
                                is_ok = true;
                                break;
                            }
                            j++;
                            db.DC();
                        }
                    }
                    if (is_ok == true)
                    {
                        user_login login = new user_login()
                        {
                            name    = str,
                            islogin = true
                        };

                        Session["Uesrinfo"] = login;
                        Response.Redirect("show.aspx");
                    }
                    else
                    {
                    }
                }
            }
        }
Пример #19
0
        public ActionResult Create(user_login user_Login)
        {
            try
            {
                var check = (from s in db.user_login where s.user_id == user_Login.user_id select s).FirstOrDefault();
                if (check == null)
                {
                    var keyNew = PasswordHashHelper.GeneratePassword(10);
                    var pass   = PasswordHashHelper.EncodePassword(user_Login.user_id + DateTime.Now.Year.ToString(), keyNew);

                    user_login _Login = new user_login
                    {
                        user_id      = user_Login.user_id,
                        password     = pass,
                        vcode        = keyNew,
                        role         = user_Login.role,
                        status       = user_Login.status,
                        date_created = DateTime.Now
                    };

                    karyawan karyawan = new karyawan
                    {
                        user_id = _Login.user_id
                    };

                    db.user_login.Add(_Login);
                    db.karyawan.Add(karyawan);
                    db.SaveChanges();

                    ModelState.Clear();

                    return(Json("0", JsonRequestBehavior.AllowGet));
                }

                return(Json("1", JsonRequestBehavior.AllowGet));
            }
            catch (DbEntityValidationException e)
            {
                return(Json("2", JsonRequestBehavior.AllowGet));
            }
        }
Пример #20
0
        public IHttpActionResult UserLogin(dynamic obj)
        {
            JObject je = new JObject();
            JObject jo = new JObject();

            try
            {
                je = (JObject)JsonConvert.DeserializeObject(obj.ToString());
                LoggerHelp.LogInfo("UserLogin接收数据:" + Md5Control.MD5Encrypt(je.ToString()));
                SqlSugarClient    sql       = datahandle.GetDataConnect();
                List <user_login> list_user = sql.Queryable <user_login>().Where(t =>
                                                                                 t.userName == je["userName"].ToString()).ToList();
                if (list_user.Count == 1)
                {
                    user_login user_Login = list_user[0];
                    if (user_Login.userPwd == Md5Control.MD5Encrypt(je["userPwd"].ToString()))
                    {
                        jo.Add("Result", 1);
                        jo.Add("Message", "登录成功");
                    }
                    else
                    {
                        jo.Add("Result", 0);
                        jo.Add("Message", "登录失败,密码错误");
                    }
                }
                else
                {
                    jo.Add("Result", 2);
                    jo.Add("Message", "用户不存在,请先注册!");
                }
            }
            catch (Exception error)
            {
                jo.Add("Result", -1);
                jo.Add("Message", error.Message);
            }
            LoggerHelp.LogInfo("UserLogin返回数据:" + jo);
            return(Json(jo.ToString()));
        }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            MatrixLinQDataContext con = new MatrixLinQDataContext();

            user_login uc = con.user_logins.SingleOrDefault(x => x.uName == Utility.UserName &&
                                                            x.uPassword == this.txtCurrentPassword.Text);

            if (uc != null)
            {
                uc.uPassword = newPass.Text;
                con.SubmitChanges();
                this.Dispose();
                MessageBox.Show("Password Changed");
            }
            else
            {
                MessageBox.Show("Error");
                txtCurrentPassword.Text = "";
                newPass.Text            = "";
                rePass.Text             = "";
            }
        }
Пример #22
0
        public string insertsToTUBUSER(string posted)
        {
            user_login obj = JsonConvert.DeserializeObject <user_login>(posted);

            sessionCaptcha = obj.captcha;

            string str   = "";
            bool   is_ok = false;
            int    j     = 0;
            PDBC   db    = new PDBC("honarjoo");

            db.Connect();
            using (DataTable dt = db.Select("SELECT [id],[name],[us],[pass] FROM [dbo].[login]"))
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    while (j == i)
                    {
                        if (dt.Rows[j].ItemArray[2].ToString() == obj.us && dt.Rows[j].ItemArray[3].ToString() == obj.pass)
                        {
                            str   = dt.Rows[j].ItemArray[1].ToString();
                            is_ok = true;
                            break;
                        }
                        j++;
                        db.DC();
                    }
                }
                if (is_ok == true)
                {
                    return(str);
                }
                else
                {
                    return("-1");
                }
            }
        }
Пример #23
0
        public ActionResult EditPost(user_login user_Login)
        {
            var user = db.user_login.Find(user_Login.user_id);

            user.role          = user_Login.role;
            user.status        = user_Login.status;
            user.date_modified = DateTime.Now;

            try
            {
                db.user_login.Attach(user);
                db.Entry(user).Property(x => x.role).IsModified          = true;
                db.Entry(user).Property(x => x.status).IsModified        = true;
                db.Entry(user).Property(x => x.date_modified).IsModified = true;
                db.SaveChanges();

                return(Json("0", JsonRequestBehavior.AllowGet));
            }
            catch (DataException)
            {
                return(Json("1", JsonRequestBehavior.AllowGet));
            }
        }
Пример #24
0
 public bool UpdateAccount(user_login login)
 {
     try
     {
         user_login data = db.user_logins.SingleOrDefault(Login => Login.ID == login.ID);
         if (data != null)
         {
             data.ID         = login.ID;
             data.username   = login.username;
             data.password   = CreateMD5(login.password);
             data.permission = login.permission;
             db.SubmitChanges();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch
     {
         return(false);
     }
 }
Пример #25
0
 public void AddUser(UserData item)
 {
     hasError = false;
     try
     {
         TraditionAssetEntities db = new TraditionAssetEntities();
         var data = new user_login()
         {
             username      = item.username,
             password      = item.password,
             is_active     = item.is_active,
             create_date   = DateTime.Now,
             modified_date = DateTime.Now
         };
         db.user_login.Add(data);
         db.SaveChanges();
         MessageBox.Show("Insert complete");
     }
     catch (Exception ex)
     {
         errorMessage = "Add error, " + ex.Message;
         hasError     = true;
     }
 }
Пример #26
0
        public ActionResult Index(user_login user_Login)
        {
            try
            {
                using (var db = new HRISContext())
                {
                    var user = db.user_login.FirstOrDefault(m => m.user_id == user_Login.user_id);

                    if (user != null)
                    {
                        var hashCode = user.vcode;
                        var encodingPasswordString = PasswordHashHelper.EncodePassword(user_Login.password, hashCode);
                        var query = db.karyawan
                                    .Join(db.user_login, k => k.user_id, u => u.user_id, (k, u) => new { k, u })
                                    .Where(x => x.u.user_id == user_Login.user_id && x.u.password.Equals(encodingPasswordString))
                                    .Select(x => new { x.k.user_id, x.k.karyawan_id, x.u.status })
                                    .FirstOrDefault();

                        if (query != null)
                        {
                            if (query.status)
                            {
                                Session["user_id"] = query.user_id;
                                Session["emp_id"]  = query.karyawan_id;
                                var emp_id    = (int)Session["emp_id"];
                                var hist_kary = db.hist_karyawan
                                                .OrderByDescending(x => x.tgl_mulai)
                                                .Where(x => x.karyawan_id == emp_id)
                                                .Select(x => new { x.gol_jabatan_id, x.divisi_id })
                                                .Take(1)
                                                .FirstOrDefault();
                                Session["pos"]       = hist_kary.gol_jabatan_id != null ? hist_kary.gol_jabatan_id : -1;
                                Session["divisi_id"] = hist_kary.divisi_id != null ? hist_kary.divisi_id : -1;

                                async.UpdateWorkdaysAndAge(emp_id);

                                if (user.role == "superuser")
                                {
                                    return(RedirectToAction("Index", "Home", new { area = "Admin" }));
                                }
                                else
                                {
                                    return(RedirectToAction("Index", "Home", new { area = "Employee" }));
                                }
                            }
                            else
                            {
                                ViewBag.ErrorMsg = "Your account has not been activated. Please contact administrator.";
                                return(View());
                            }
                        }

                        ViewBag.ErrorMsg = "Invalid username or password";
                        return(View());
                    }

                    ViewBag.ErrorMsg = "Invalid username or password";
                    return(View());
                }
            }
            catch (DataException e)
            {
                ViewBag.ErrorMsg = "Error :" + e.Message;
                return(View());
            }
        }