Esempio n. 1
0
        public List <BarangInfo> getAllBarang()
        {
            Koneksi       con    = new Koneksi();
            SqlConnection sqlcon = con.getConnection();

            using (sqlcon){
                sqlcon.Open();
                string            sql     = "select * from barang";
                SqlCommand        sqlcom  = new SqlCommand(sql, sqlcon);
                List <BarangInfo> objList = new List <BarangInfo>();
                using (sqlcom)
                {
                    SqlDataReader dr = sqlcom.ExecuteReader();
                    while (dr.Read())
                    {
                        //gunakan setter method dari BarangInfo
                        BarangInfo objBarang = new BarangInfo();
                        objBarang.IDBarang    = dr.GetString(0);
                        objBarang.NamaBarang  = dr.GetString(1);
                        objBarang.StokBarang  = dr.GetInt32(2);
                        objBarang.HargaBarang = dr.GetInt32(3);
                        objList.Add(objBarang);
                    }
                }
                sqlcon.Close();

                return(objList);
            }
        }
Esempio n. 2
0
        public List <BarangInfo> getBarangByID(string id)
        {
            Koneksi           con     = new Koneksi();
            SqlConnection     sqlcon  = con.getConnection();
            List <BarangInfo> objList = new List <BarangInfo>();

            using (sqlcon)
            {
                sqlcon.Open();
                string     sql    = "select * from barang where idbarang = @id";
                SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
                using (sqlcom)
                {
                    sqlcom.Parameters.AddWithValue("@id", id);
                    SqlDataReader dr = sqlcom.ExecuteReader();
                    if (dr.Read())
                    {
                        //gunakan setter method dari BarangInfo
                        BarangInfo objBarang = new BarangInfo();
                        objBarang.IDBarang    = dr.GetString(0);
                        objBarang.NamaBarang  = dr.GetString(1);
                        objBarang.StokBarang  = dr.GetInt32(2);
                        objBarang.HargaBarang = dr.GetInt32(3);
                        objList.Add(objBarang);
                    }
                }
                sqlcon.Close();

                return(objList);
            }
        }
Esempio n. 3
0
        public string deleteBarang(string id)
        {
            Koneksi       kon    = new Koneksi();
            SqlConnection sqlcon = kon.getConnection();
            string        msg    = string.Empty;

            using (sqlcon){
                sqlcon.Open();
                string     sql    = "delete from barang where idbarang = @id";
                SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
                using (sqlcom){
                    sqlcom.Parameters.AddWithValue("@id", id);
                    int res = sqlcom.ExecuteNonQuery();
                    msg = (res != 0? "Data has been deleted." : "Error !");
                }
                sqlcon.Close();
            }
            return(msg);
        }
Esempio n. 4
0
        public string insertBarang(BarangInfo data)
        {
            Koneksi       con    = new Koneksi();
            SqlConnection sqlcon = con.getConnection();
            string        msg    = string.Empty;

            using (sqlcon)
            {
                sqlcon.Open();
                string     sql    = "insert into barang values (@id, @nama, @stok, @harga)";
                SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
                using (sqlcom)
                {
                    sqlcom.Parameters.AddWithValue("@id", data.IDBarang);
                    sqlcom.Parameters.AddWithValue("@nama", data.NamaBarang);
                    sqlcom.Parameters.AddWithValue("@stok", data.StokBarang);
                    sqlcom.Parameters.AddWithValue("@harga", data.HargaBarang);
                    int res = sqlcom.ExecuteNonQuery();
                    msg = (res != 0 ? "Data has been saved." : "Error !");
                }
                sqlcon.Close();
            }
            return(msg);
        }