Exemplo n.º 1
0
        public systemUsers checkSystemUser(string userName, string password)
        {
            systemUsers systemUserData = new systemUsers();

            if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password))
            {
                return(null);
            }

            using (systemUserDatabaseLogicLayer systemUserDatabase = new systemUserDatabaseLogicLayer())
            {
                SqlDataReader reader = systemUserDatabase.checkSystemUser(new systemUsers()
                {
                    userName = userName,
                    password = password
                });

                while (reader.Read())
                {
                    systemUserData.id       = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0);
                    systemUserData.userName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
                    systemUserData.password = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
                }
                reader.Close();
                systemUserDatabase.connectionWizard();
            }

            return(systemUserData);
        }
        public SqlDataReader checkSystemUser(systemUsers data)
        {
            command             = new System.Data.SqlClient.SqlCommand("checkSystemUser", connection);
            command.CommandType = System.Data.CommandType.StoredProcedure;

            command.Parameters.Add("@userName", SqlDbType.NVarChar).Value  = data.userName;
            command.Parameters.Add("@passwords", SqlDbType.NVarChar).Value = data.password;

            connectionWizard();

            return(command.ExecuteReader());
        }
Exemplo n.º 3
0
        private void btnControl_Click(object sender, EventArgs e)
        {
            systemUserService userService    = new systemUserService();
            systemUsers       systemUserData = userService.checkSystemUser(txtUserName.Text, txtPassword.Text);

            if (systemUserData == null || systemUserData.id == Guid.Empty)
            {
                MessageBox.Show("Girmiş olduğunuz bilgiler hatalı", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                applicationStatics.currentSystemUser = systemUserData;
                mainForm main = new mainForm();
                main.Show();
                this.Hide();
            }
        }