示例#1
0
        private Field Free(string DirEmployeeLogin, string DirEmployeePswd, bool bEncode)
        {
            Field field = new Field();


            #region Проверяем

            if (String.IsNullOrEmpty(DirEmployeeLogin) && String.IsNullOrEmpty(DirEmployeePswd))
            {
                field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg4;
                return(field);
            }

            #endregion


            #region Декодируем

            if (bEncode)
            {
                Account.EncodeDecode encode = new Account.EncodeDecode();
                DirEmployeeLogin = encode.UnionDecode(DirEmployeeLogin);
                field.LoginFull  = DirEmployeeLogin;
                DirEmployeePswd  = encode.UnionDecode(DirEmployeePswd);
            }

            #endregion


            #region Проверяем Логин и Пароль

            using (DbConnectionSklad db = new DbConnectionSklad("ConnStr"))
            {
                db.Database.Connection.Open();

                var query = db.DirEmployees.Where(x => x.DirEmployeeLogin == DirEmployeeLogin && x.DirEmployeePswd == DirEmployeePswd && x.Del == false && x.DirEmployeeActive == true).ToList();
                if (query.Count > 0)
                {
                    Models.Sklad.Dir.DirEmployee dirEmployee = query[0];

                    field.Access        = true;
                    field.DirEmployeeID = Convert.ToInt32(dirEmployee.DirEmployeeID);
                    //field.SysDirRightsID = dirEmployee.SysDirRightsID;
                }
                else
                {
                    field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg4;
                    return(field);
                }
            }

            #endregion


            return(field);
        }
示例#2
0
        private bool FreeUpdate(string AdminsLogin, string AdminsPswd, bool bEncode)
        {
            #region Проверяем

            if (String.IsNullOrEmpty(AdminsLogin) && String.IsNullOrEmpty(AdminsPswd))
            {
                return(false);
            }

            #endregion


            #region Декодируем

            if (bEncode)
            {
                Account.EncodeDecode encode = new Account.EncodeDecode();
                AdminsLogin = encode.UnionDecode(AdminsLogin);
                AdminsPswd  = encode.UnionDecode(AdminsPswd);
            }

            #endregion


            #region Проверяем Логин и Пароль

            using (DbConnectionSklad db = new DbConnectionSklad("ConnStr"))
            {
                db.Database.Connection.Open();

                var query = db.DirEmployees.Where(x => x.DirEmployeeLogin == AdminsLogin && x.DirEmployeePswd == AdminsPswd && x.Del == false && x.DirEmployeeActive == true).ToList();
                if (query.Count > 0)
                {
                    Models.Sklad.Dir.DirEmployee dirEmployee = query[0];

                    //Только с правами Администратора можно обновлять!

                    /*if (dirEmployee.SysDirRightsID == 1) return true;
                     * else return false;*/

                    return(true);
                }
                else
                {
                    return(false);
                }
            }

            #endregion
        }
示例#3
0
        private bool ComercialUpdate(string AdminsLogin, string AdminsPswd, bool bEncode)
        {
            Function.Variables.ConnectionString connectionString = new Function.Variables.ConnectionString();


            #region Проверяем "IsNullOrEmpty"

            if (String.IsNullOrEmpty(AdminsLogin) && String.IsNullOrEmpty(AdminsPswd))
            {
                return(false);
            }

            #endregion


            #region Декодируем Логин и Пароль

            if (bEncode)
            {
                Account.EncodeDecode encode = new Account.EncodeDecode();
                AdminsLogin = encode.UnionDecode(AdminsLogin);
                AdminsPswd  = encode.UnionDecode(AdminsPswd);
            }

            #endregion


            #region Проверяем Логин и Пароль

            using (DbConnectionLogin db = new DbConnectionLogin("ConnStrMSSQL"))
            {
                db.Database.Connection.Open();

                var query = db.SysAdmins.Where(x => x.AdminsLogin == AdminsLogin && x.AdminsPswd == AdminsPswd && x.AdminsActive == true).ToList();
                if (query.Count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }

            #endregion
        }
示例#4
0
        private Field Comercial(string DirEmployeeLogin, string DirEmployeePswd, bool bEncode)
        {
            Function.Variables.ConnectionString connectionString = new Function.Variables.ConnectionString();
            Field field = new Field();


            #region Проверяем "IsNullOrEmpty"

            if (String.IsNullOrEmpty(DirEmployeeLogin) && String.IsNullOrEmpty(DirEmployeePswd))
            {
                field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg4;
                return(field);
            }

            #endregion


            #region Декодируем Логин и Пароль

            if (bEncode)
            {
                Account.EncodeDecode encode = new Account.EncodeDecode();
                DirEmployeeLogin = encode.UnionDecode(DirEmployeeLogin);
                field.LoginFull  = DirEmployeeLogin;
                DirEmployeePswd  = encode.UnionDecode(DirEmployeePswd);
            }

            #endregion


            #region  азщепляем Логин на 2-е составные части Логин@МояКомпания

            if (DirEmployeeLogin.IndexOf("@") == -1)
            {
                field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg26;
                return(field);
            }
            else
            {
                string _Login = DirEmployeeLogin;
                int    p1     = _Login.IndexOf("@");
                DirEmployeeLogin = _Login;
                DirEmployeeLogin = DirEmployeeLogin.Remove(p1, DirEmployeeLogin.Length - p1);
                field.Login      = _Login.Remove(0, p1 + 1);
            }

            #endregion


            #region Получаем DirCustomersID (из MS SQL)

            //Получаем ID-шник в БД MS SQL
            field.DirCustomersID = connectionString.mDirCustomersID(field.Login);
            //Полученные варианты
            if (field.DirCustomersID == -1) //Не найден такой User.
            {
                field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg1 + DirEmployeeLogin;
                return(field);
            }
            else if (field.DirCustomersID == 0) //Найден такой User, но не активен (долго не заходил в свой аккаунт)
            {
                field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg2();
                return(field);
            }

            #endregion


            #region Проверяем Логин и Пароль

            //using (DbConnectionSklad db = new DbConnectionSklad(GetSQLiteBasicConnStr_DirCustomersID(field.DirCustomersID)))
            using (DbConnectionSklad db = new DbConnectionSklad(connectionString.Return(field.DirCustomersID, null, true)))
            {
                db.Database.Connection.Open();

                var query = db.DirEmployees.Where(x => x.DirEmployeeLogin == DirEmployeeLogin && x.DirEmployeePswd == DirEmployeePswd && x.Del == false && x.DirEmployeeActive == true).ToList();
                if (query.Count > 0)
                {
                    Models.Sklad.Dir.DirEmployee dirEmployee = query[0];

                    field.Access        = true;
                    field.DirEmployeeID = Convert.ToInt32(dirEmployee.DirEmployeeID);

                    //field.SysDirRightsID = dirEmployee.SysDirRightsID;
                    //field.RetailOnly = Convert.ToBoolean(dirEmployee.RetailOnly);
                }
                else
                {
                    field.Access = false; field.Msg = Classes.Language.Sklad.Language.msg4;
                    return(field);
                }
            }

            #endregion


            return(field);
        }