/// <summary>
 /// Adds a new user.
 /// </summary>
 /// <param name="sessionID">The sessionID of the current session</param>
 /// <param name="username">The username.</param>
 /// <param name="password">The password.</param>
 /// <param name="firstname">The firstname.</param>
 /// <param name="lastname">The lastname.</param>
 /// <param name="roles">The roles.</param>
 public void AddUser(string sessionID, string username, string password, string firstname, string lastname, List<string> roles)
 {
     UsersTableAdapter uta = new UsersTableAdapter();
     int id = (int)((decimal)(uta.InsertAndGetIdentity(username, password, "", firstname, lastname)));
     foreach (string role in roles)
     {
         RolesTableAdapter rta = new RolesTableAdapter();
         rta.Insert(id, role);
     }
 }
Example #2
0
        private void initalLogin()
        {
            pnlContent.Enabled = false;
            btnLogin.Enabled   = false;

            var UsersTableAdapter = new UsersTableAdapter();
            var users             = UsersTableAdapter.GetDataByUserLogIn(cbxUsername.Text.Trim().ToLower(), tbxPassword.Text.Trim().ToLower());

            if (users.Count == 0)
            {
                this.pnlContent.Enabled = true;
                this.btnLogin.Enabled   = true;
                this.tbxPassword.Text   = String.Empty;
                MessageBox.Show("ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", "ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                var list = Properties.Settings.Default.fUsernameList;

                var lists = list.Split('|');
                if (lists.Length > 0 && list.Trim().Length != 0)
                {
                    var result = string.Empty;
                    for (var i = 0; i < lists.Length; i++)
                    {
                        if (!cbxUsername.Text.Trim().Equals(lists[i]))
                        {
                            if (i == 0)
                            {
                                result += lists[i];
                            }
                            else
                            {
                                result += "|" + lists[i];
                            }
                        }
                    }

                    result = String.Format("{0}|{1}", cbxUsername.Text.Trim(), result);
                    Properties.Settings.Default.fUsernameList = result;
                    Properties.Settings.Default.Save();
                }
                else
                {
                    Properties.Settings.Default.fUsernameList = cbxUsername.Text;
                    Properties.Settings.Default.Save();
                }
                var log = new UserLogTableAdapter();
                log.Insert(TypeUtil.User, users[0].UserID.ToString(), users[0].UserID, TypeUtil.EVENT_USER_LOGIN, DateTime.Now);

                MainForm.User = users[0];
                DialogResult  = System.Windows.Forms.DialogResult.Yes;
            }
        }
Example #3
0
 /// <summary>
 /// Initializes the Buffer Class
 /// </summary>
 public static void Initialize()
 {
     _utDisposed          = false;
     _ptDisposed          = false;
     _rqDisposed          = false;
     _userTable           = new UsersTableAdapter();
     _pkmnTable           = new PokemonTableAdapter();
     _requTable           = new RequirementsTableAdapter();
     _userTable.Disposed += (sender, args) => _utDisposed = true;
     _pkmnTable.Disposed += (sender, args) => _ptDisposed = true;
     _requTable.Disposed += (sender, args) => _rqDisposed = true;
 }
Example #4
0
 public Object QueryUserIdByName(string name)
 {
     try
     {
         UsersTableAdapter userAdapter = new UsersTableAdapter();
         return(userAdapter.QueryUserIdByName(name));
     }
     catch (Exception e)
     {
         Log4NetHelper.WriteErrorLog(typeof(UserManager), e);
     }
     return(null);
 }
Example #5
0
        private void btnFill_Click(object sender, RoutedEventArgs e)
        {
            ds = new UserCityDataSet();
            UsersTableAdapter daUser = new UsersTableAdapter();

            daUser.Fill(ds.Users);

            CitiesTableAdapter daCity = new CitiesTableAdapter();

            daCity.Fill(ds.Cities);

            dgUser.ItemsSource = ds.Users.DefaultView;
            dgCity.ItemsSource = ds.Cities.DefaultView;
        }
Example #6
0
 public bool DeleteUser(int Original_ID, string usr, string pass)
 {
     if (authenticate(usr, pass, 27) == false)
     {
         return(false);
     }
     try
     {
         UsersTableAdapter u = new UsersTableAdapter();
         u.DeleteQuery(Original_ID);
     }
     catch (Exception e) { return(false); }
     return(true);
 }
Example #7
0
 public bool UpdateUser(string username, string password, int phone, string fname, string lname, short type, string airport, int Original_ID, string usr, string pass)
 {
     if (authenticate(usr, pass, 29) == false)
     {
         return(false);
     }
     try
     {
         UsersTableAdapter u = new UsersTableAdapter();
         u.UpdateQuery(username, password, phone, fname, lname, type, airport, Original_ID);
     }
     catch (Exception e) { return(false); }
     return(true);
 }
Example #8
0
 public bool InsertUser(string username, string password, int phone, string fname, string lname, short type, string airport, string usr, string pass)
 {
     if (authenticate(usr, pass, 28) == false)
     {
         return(false);
     }
     try
     {
         UsersTableAdapter u = new UsersTableAdapter();
         u.Insert(username, password, phone, fname, lname, type, airport);
     }
     catch (Exception e) { return(false); }
     return(true);
 }
Example #9
0
        /// <summary>
        /// Verify user login
        /// </summary>
        /// <param name="username">username</param>
        /// <param name="password">passsword</param>
        /// <returns>is login success</returns>
        public bool VerifyUserLogin(string userName, string password)
        {
            UsersTableAdapter userAdapter = new UsersTableAdapter();
            int?userNameCheck             = userAdapter.VerifyUserName(userName);

            if (!userNameCheck.HasValue || userNameCheck.Value != onlyOneRecord)
            {
                throw new UserNameNotExistentException();
            }

            int?result = userAdapter.VerifyLogin(userName, password);

            return(result.HasValue && result.Value == onlyOneRecord);
        }
        protected void Login()
        {
            UsersTableAdapter ta = new UsersTableAdapter();

            DataSet1.UsersDataTable userDataTable = new DataSet1.UsersDataTable();
            ta.Fill(userDataTable);
            string passWord = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.password.ToString()).First());

            if (TextBoxPw.Text == passWord)
            {
                Session["UserName"]   = TextBoxUser.Text;
                Session["PersonName"] = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.personName.ToString()).First());
                Response.Redirect("OrderPage.aspx", true);
            }
        }
Example #11
0
        protected void CreateNewUser()
        {
            UsersTableAdapter ta = new UsersTableAdapter();

            ta.Fill(ds.Users);
            DataRow dr = ds.Users.NewRow();

            dr["userName"]      = TextBoxUsername.Text;
            dr["password"]      = TextBoxPw.Text;
            dr["personName"]    = TextBoxName.Text;
            dr["personAddress"] = TextBoxAddress.Text;
            ds.Tables["Users"].Rows.Add(dr);
            ta.Update(ds.Users);
            LabelError.Text = "Account Created Successfully";
            Response.Redirect("Default.aspx");
        }
Example #12
0
        private bool InitDataset(string userName, string password)
        {
            bool result = false;

            System.Data.SqlClient.SqlConnectionStringBuilder builder =
                new System.Data.SqlClient.SqlConnectionStringBuilder(Properties.Settings.Default.DetroitConnectionString);
            builder.UserID             = userName;
            builder.Password           = password;
            builder.IntegratedSecurity = false;
            Security.Properties.Settings.ChangeConnectionString(builder.ConnectionString);


            this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "builder.ConnectionString = " + builder.ConnectionString);
            this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "DetroitConnectionString = " + Properties.Settings.Default.DetroitConnectionString.ToString());



            // test connection ?!
            //
            try
            {
                string        cnStr = builder.ConnectionString;
                SqlConnection cn    = new SqlConnection();
                cn.ConnectionString = cnStr;
                cn.Open();

                this.detroit                     = new Detroit();
                this.usersTableAdapter           = new UsersTableAdapter();
                this.permissionsTableAdapter     = new PermissionsTableAdapter();
                this.userPermissionsTableAdapter = new UserPermissionsTableAdapter();

                result = true;
                return(result);
            }
            catch (SqlException ex)
            {
                this.logProvider.LogAlert(AlertType.Info, DateTime.Now.ToString() + " --- " + "Security", "There is no access to SQL database.");
                //MessageBox.Show("There is no access to SQL database. User \"" + userName + "\". \n Please, try again.", "SQL connecting ...", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return(false);
            }
            //
        }
Example #13
0
 private void btnlogin_Click(object sender, EventArgs e)
 {
     if (txbusername.Text != String.Empty && txbpassword.Text != String.Empty)
     {
         //do login
         _userTa = new UsersTableAdapter();
         _dt     = new DataTable();
         _dt     = _userTa.DoLogin(txbusername.Text, txbpassword.Text);
         if (_dt.Rows.Count > 0)
         {
             frmManager frm = new frmManager();
             frm.Show();
             this.Hide();
         }
     }
     else
     {
         MessageBox.Show("Fields musst not be empty");
     }
 }
Example #14
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
            UsersTableAdapter myUsersAd = new UsersTableAdapter();
            POSDataSet.UsersDataTable myUsersTbl = new POSDataSet.UsersDataTable();
            myUsersTbl = myUsersAd.GetUsersDataBy();

            bool UserRecordFound = false;

            foreach (DataRow myRow in myUsersTbl.Rows)
                {

                    if (myRow["User_Name"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim())
                    {
                        global.user_id = Convert.ToInt32(myRow["User_ID"]);
                        global.user_type = Convert.ToByte(myRow["Type"].ToString());
                        global.user_name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myRow["User_Name"].ToString());
                        global.password = myRow["Password"].ToString().Trim();

                        UserRecordFound = true;

                        new homescreen().Show();
                        this.Hide();
                        //this.Close();

                        break;
                    }

                }

                if (!UserRecordFound)
                {
                    MessageBox.Show("Invalid User Name/Password\nPlease Try Again");
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("Unable to Load Database\n" + exc.Message);
            }
        }
Example #15
0
    protected void loginButton_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
        conn.Open();
        String checkUser = "******" + username.Text + "'";
        SqlCommand com = new SqlCommand(checkUser, conn);
        int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
        conn.Close();
        if (temp == 1)
        {
            conn.Open();
            string checkPassQuery = "select password from Users where username='******'";
            SqlCommand comm = new SqlCommand(checkPassQuery, conn);
            string pass = comm.ExecuteScalar().ToString();
            string loginPasswd = passsword.Text;

            if (pass == loginPasswd)
            {
                Session["loggedInUser"] = username.Text;
                UsersTableAdapter U = new UsersTableAdapter();
                string role = U.getRoleByUsername(username.Text);
                string avatar = U.getImage(username.Text);
                Session["userRole"] = role;
                Session["avatar"] = avatar;
                Response.Write("Passwd is correct");
                Response.Redirect("Default.aspx");
            }
            else
            {
                gresit.Visible = true;
            }

        }
        else
        {
            gresit.Visible = true;
        }
        conn.Close();
    }
Example #16
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
                UsersTableAdapter         myUsersAd  = new UsersTableAdapter();
                POSDataSet.UsersDataTable myUsersTbl = new POSDataSet.UsersDataTable();
                myUsersTbl = myUsersAd.GetUsersDataBy();

                bool UserRecordFound = false;

                foreach (DataRow myRow in myUsersTbl.Rows)
                {
                    if (myRow["User_Name"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim())
                    {
                        global.user_id   = Convert.ToInt32(myRow["User_ID"]);
                        global.user_type = Convert.ToByte(myRow["Type"].ToString());
                        global.user_name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myRow["User_Name"].ToString());
                        global.password  = myRow["Password"].ToString().Trim();

                        UserRecordFound = true;

                        new homescreen().Show();
                        this.Hide();
                        //this.Close();

                        break;
                    }
                }

                if (!UserRecordFound)
                {
                    MessageBox.Show("Invalid User Name/Password\nPlease Try Again");
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("Unable to Load Database\n" + exc.Message);
            }
        }
Example #17
0
        //private static void StartIcon()
        //{
        //    var icon = new NotifyIcon();
        //    icon.Icon = new Icon("Icon.ico");
        //    icon.Visible = true;
        //    icon.DoubleClick += new EventHandler(Icon_DoubleClick);
        //    icon.Text = "Aura Server Console";

        //    ShowWindow(GetConsoleWindow(), showWindow ? 0 : 1);

        //}

        //private static void Icon_DoubleClick(object sender, EventArgs e)
        //{
        //    showWindow = !showWindow;
        //    ShowWindow(GetConsoleWindow(), showWindow ? 0 : 1);

        //}

        private static void StartDataBases()
        {
            //настраиваем соединения с БД


            DataBaseCreator creator = new DataBaseCreator();

            creator.CreateDataBaseForLogs(dbForLogsFileName);
            creator.CreateMainDataBase(dbFileName);
            creator.UpdateTables(dbFileName);
            creator = null;

            LogManager.Instance.InitializeLogManager(dbForLogsFileName);

            dataBase = new DataBaseManager();
            dataBase.ConnectToDataBase(dbFileName);

            usersDataBase          = new UsersTableAdapter(dataBase);
            purchasesDataBase      = new PurchasesTableAdapter(dataBase);
            organisationsDataBase  = new OrganisationsDataBaseAdapter(dataBase);
            reportsDataBaseAdapter = new ReportsDataBaseAdapter(dataBase);

            Console.WriteLine("Connection to DBs established successfully");
        }
 /// <summary>
 /// Changes the user password.
 /// </summary>
 /// <param name="sessionID">The sessionID of the current session</param>
 /// <param name="EmployeeID">The employee ID.</param>
 /// <param name="password">The new password.</param>
 public void ChangeUserPassword(string sessionID, int EmployeeID, string password)
 {
     UsersTableAdapter uta = new UsersTableAdapter();
     uta.UpdatePassword(password, EmployeeID);
 }
Example #19
0
 public DatabaseUsers()
 {
     Adapter = new UsersTableAdapter();
 }
 /// <summary>
 /// Removes the user.
 /// </summary>
 /// <param name="sessionID">The sessionID of the current session</param>
 /// <param name="EmployeeID">The employee ID.</param>
 public void RemoveUser(string sessionID, int EmployeeID)
 {
     UsersTableAdapter uta = new UsersTableAdapter();
     uta.DeleteUser(EmployeeID);
 }
 /// <summary>
 /// Gets all employees.
 /// </summary>
 /// <param name="sessionID">The sessionID of the current session</param>
 /// <returns></returns>
 public List<EmployeeData> GetAllEmployees(string sessionID)
 {
     UsersTableAdapter uta = new UsersTableAdapter();
     List<EmployeeData> re = new List<EmployeeData>();
     var rows = uta.GetData();
     foreach (var row in rows)
     {
         EmployeeData ed = new EmployeeData();
         ed.id = row.ID;
         ed.name = row.FirstName + " " + row.LastName;
         ed.roles = getRoles(row.ID);
         ed.username = row.Username;
         re.Add(ed);
     }
     return re;
 }
Example #22
0
    public User GetUserByID(int ID)
    {
        List<User> lstUsers = new List<User>();

        UsersTableAdapter usersAdapter = new UsersTableAdapter();
        PostAroundMeDataSet.UsersDataTable dtResult = usersAdapter.GetUserByID(ID);

        lstUsers = UserTranslator(dtResult);

        return lstUsers.FirstOrDefault();
    }
Example #23
0
 public int GetUserIdByFacebookId(string fid)
 {
     int retVal = 0;
     UsersTableAdapter usersAdapter = new UsersTableAdapter();
     Object obj = usersAdapter.GetUserIdByFacebookId(fid);
     if (obj != null)
         retVal = Convert.ToInt32(obj);
     return retVal;
 }
Example #24
0
    public int InsertUpdateUser(User user)
    {
        int result = 0;

        UsersTableAdapter usersAdapter = new UsersTableAdapter();

        Object obj = usersAdapter.InsertUpdateUser(user.firstName, user.lastName, user.email, user.phone1, user.phone2, user.address, user.longtitude, user.latidute, user.avatarImageUrl, user.gender, user.facebookID, user.birthday, user.regDate, user.link, user.timezone, user.facebookToken);
        if (obj != null)
            result = Convert.ToInt32(obj);

        return result;
    }
Example #25
0
        public Object queryUserIdByName(string name)
        {
            UsersTableAdapter userAdapter = new UsersTableAdapter();

            return(userAdapter.QueryUserIdByName(name));
        }
Example #26
0
        private void btnModify_Click(object sender, RoutedEventArgs e)
        {
            UsersTableAdapter daUser = new UsersTableAdapter();

            daUser.Update(ds.Users);
        }
 /// <summary>
 /// Gets the payrole report.
 /// </summary>
 /// <param name="sessionID">The sessionID of the current session</param>
 /// <param name="startTime">The start time of the report.</param>
 /// <param name="endTime">The end time of the report.</param>
 /// <returns></returns>
 public PayroleReport GetPayroleReport(string sessionID, DateTime startTime, DateTime endTime)
 {
     PayroleReport re = new PayroleReport();
     UsersTableAdapter uta = new UsersTableAdapter();
     RolePayrateTableAdapter rta = new RolePayrateTableAdapter();
     var payoutTable = rta.GetData();
     var employees = uta.GetData();
     decimal totalPayout = 0;
     re.Employees = new List<EmployeePayout>();
     foreach (var employee in employees)
     {
         EmployeePayout ep = GetEmployeePayout(employee, startTime, endTime, payoutTable);
         if (ep != null)
         {
             totalPayout += ep.TotalPayment;
             re.Employees.Add(ep);
         }
     }
     re.TotalPayout = totalPayout;
     re.StartReportTimeframe = startTime;
     re.EndReportTimeframe = endTime;
     return re;
 }
Example #28
0
 public LoginWindow(UsersTableAdapter dataBase)
 {
     InitializeComponent();
     usersDataBase = dataBase;
 }
 public UsersDataBaseForm(UsersTableAdapter adapter)
 {
     InitializeComponent();
     this.adapter = adapter;
     ReloadTable(adapter.GetUsersInTable());
 }