Esempio n. 1
0
        // btn delete
        private void buttonUpdate_Click(object sender, EventArgs e)
        {
            pelajar      = new Pelajar();
            gateway      = new Gateway();
            pelajar.Roll = textBoxRoll.Text;
            gateway.Delete(pelajar);

            MessageBox.Show("Deleted");
            ResetField();
        }
Esempio n. 2
0
        private void MasukanData()
        {
            Pelajar pelajar = new Pelajar();

            pelajar.Roll    = textBoxRoll.Text;
            pelajar.Bahasa  = Convert.ToDecimal(textBoxBahasa.Text);
            pelajar.English = Convert.ToDecimal(textBoxEnglish.Text);
            pelajar.Science = Convert.ToDecimal(textBoxScience.Text);
            Gateway gateway = new Gateway();

            gateway.SaveData(pelajar);
            MessageBox.Show("Saved");
            ResetField();
        }
Esempio n. 3
0
        public bool Delete(Pelajar pelajar)
        {
            string        conn          = "Data Source=DESKTOP-V5VOD86\\SQLEXPRESS;Initial Catalog=Universitas;Integrated Security=True";
            SqlConnection sqlConnection = new SqlConnection(conn);

            sqlConnection.Open();

            string     query      = @"DELETE FROM Mahasiswa WHERE Roll = " + pelajar.Roll;
            SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);

            sqlCommand.ExecuteNonQuery();
            sqlConnection.Close();
            return(true);
        }
Esempio n. 4
0
        // button update
        private void button1_Click(object sender, EventArgs e)
        {
            Pelajar pelajar = new Pelajar();
            Gateway gateway = new Gateway();

            pelajar.Roll    = textBoxRoll.Text;
            pelajar.Bahasa  = Convert.ToDecimal(textBoxBahasa.Text);
            pelajar.English = Convert.ToDecimal(textBoxEnglish.Text);
            pelajar.Science = Convert.ToDecimal(textBoxScience.Text);
            gateway.Update(pelajar);

            MessageBox.Show("Updated");

            ResetField();
        }
Esempio n. 5
0
        private void buttonLihat_Click(object sender, EventArgs e)
        {
            pelajar = new Pelajar();
            gateway = new Gateway();

            pelajar = gateway.Get(textBoxRoll.Text);

            textBoxEnglish.Text = pelajar.English.ToString();
            textBoxScience.Text = pelajar.Science.ToString();
            textBoxBahasa.Text  = pelajar.Bahasa.ToString();

            buttonSimpan.Enabled = false;
            buttonDelete.Enabled = true;
            buttonUpdate.Enabled = true;
        }
Esempio n. 6
0
        public bool Update(Pelajar pelajar)
        {
            //pelajar = new Pelajar();
            string        conn          = "Data Source=DESKTOP-V5VOD86\\SQLEXPRESS;Initial Catalog=Universitas;Integrated Security=True";
            SqlConnection sqlConnection = new SqlConnection(conn);

            sqlConnection.Open();

            string     query      = @"UPDATE Mahasiswa SET Bahasa = " + pelajar.English + ",English = " + pelajar.Bahasa + ", Science = " + pelajar.Science + "WHERE Roll = " + pelajar.Roll;
            SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);

            sqlCommand.ExecuteNonQuery();
            sqlConnection.Close();
            return(true);
        }
Esempio n. 7
0
        public bool SaveData(Pelajar pelajar)
        {
            //string conn = "Data Source=DESKTOP-V5VOD86\\SQLEXPRESS;Initial Catalog=Universitas;Integrated Security=True";
            //SqlConnection sqlConnection = new SqlConnection(conn);
            //sqlConnection.Open();

            msConn().Open();

            string     query   = @"INSERT INTO Mahasiswa VALUES(" + pelajar.Roll + "," + pelajar.English + "," + pelajar.Bahasa + "," + pelajar.Science + ")";
            SqlCommand command = new SqlCommand(query, msConn());

            command.ExecuteNonQuery();
            //sqlConnection.Close();
            msConn().Close();
            return(true);
        }
Esempio n. 8
0
        public Pelajar Get(string roll)
        {
            pelajar = new Pelajar();
            string        conn          = "Data Source=DESKTOP-V5VOD86\\SQLEXPRESS;Initial Catalog=Universitas;Integrated Security=True";
            SqlConnection sqlConnection = new SqlConnection(conn);

            sqlConnection.Open();

            string     query   = @"SELECT * FROM Mahasiswa WHERE Roll = " + roll.Trim();
            SqlCommand command = new SqlCommand(query, sqlConnection);

            SqlDataReader sqlDataReader = command.ExecuteReader();

            while (sqlDataReader.Read())
            {
                pelajar.Id      = Convert.ToInt32(sqlDataReader["Id"].ToString());
                pelajar.Roll    = sqlDataReader["Roll"].ToString();
                pelajar.English = Convert.ToDecimal(sqlDataReader["English"].ToString());
                pelajar.Bahasa  = Convert.ToDecimal(sqlDataReader["Bahasa"].ToString());
                pelajar.Science = Convert.ToDecimal(sqlDataReader["Science"].ToString());
            }
            return(pelajar);
        }