protected void BtnTest_Click(object sender, EventArgs e) { //***** COMMAND READER Koneksi cn = new Koneksi(); //List<string> hasil = cn.KelasKoneksi_SelectGlobal("select * from Login_user where Username_login = '******'", "1"); //foreach (string a in hasil) //{ // Response.Write("<script language=javascript>alert('hasil :" + a + " ');</script>"); //} //Label1.Text = hasil[0].ToString(); //Label2.Text = hasil[1].ToString(); //***** EXEC SCALAR //string hasil = cn.Exec_scalar("select count(*) from Login_User"); //Response.Write("<script language=javascript>alert('hasil :" + hasil + " ');</script>"); //***** CRUD FUNCTION //string sql = "Update Login_User set UserName_Login = '******' where id_login = "******""; string sql = "delete from Login_user where id_login = "******""; string hasil = cn.KelasKoneksi_CRUD(sql); if (hasil == "1") { Response.Write("<script language=javascript>alert('Sukses Update Data');</script>"); } //***** GET DATASET //DataSet ds = new DataSet(); //string sql = "Select * from Login_user"; //ds = cn.getDataSet(sql); //ListViewDataLogin.DataSource = ds; //ListViewDataLogin.DataBind(); }
protected void BtnUpdate_Click(object sender, EventArgs e) { //get listview item chk foreach (ListViewDataItem item in ListViewMasterStock.Items) { CheckBox chkSelect = (CheckBox)item.FindControl("chkbar"); if (chkSelect != null) { int ID = Convert.ToInt32(chkSelect.Attributes["value"]); if (chkSelect.Checked && !this.ID_bar.Contains(ID)) { this.ID_bar.Add(ID); } else if (!chkSelect.Checked && this.ID_bar.Contains(ID)) { this.ID_bar.Remove(ID); } } } foreach (int item in ID_bar) { Koneksi cn = new Koneksi(); string sqlupdt = "update stock set status_barang = " + Convert.ToInt32(DropDownListUpdateStatus.SelectedValue) + " where id_barang = " + item + ""; Hasil = cn.KelasKoneksi_CRUD(sqlupdt); if (Hasil == "1") { Response.Write("<script language='javascript'>window.alert('Berhasil Update Data dengan ID :" + Convert.ToString(item) + "');window.location='../Halaman/Master.aspx';</script>"); } else { Response.Write("<script language='javascript'>window.alert('Gagal Update Data dengan ID : " + Convert.ToString(item) + "');window.location='../Halaman/Master.aspx';</script>"); } } }
protected void BtnBatalKeranjang_Click(object sender, EventArgs e) { //delete KeranjangBelanja berdasarkan memid Koneksi cn = new Koneksi(); Hasil = cn.KelasKoneksi_CRUD("delete from keranjangbelanja where member_id = " + Convert.ToInt32(memid) + ""); if (Hasil == "1") { Response.Write("<script language='javascript'>window.alert('Berhasil Delete Data dengan ID :" + Convert.ToString(memid) + "');window.location='../Halaman/Form_Pengguna.aspx';</script>"); } else { Response.Write("<script language='javascript'>window.alert('Gagal Delete Data dengan ID : " + Convert.ToString(memid) + "');window.location='../Halaman/Form_Pengguna.aspx';</script>"); } }
protected void BtnSimpanKeranjang_Click(object sender, EventArgs e) { //get chk keranjang belanja //get listview item chk foreach (ListViewDataItem item in ListViewHakAkses.Items) { CheckBox chkSelect = (CheckBox)item.FindControl("chkbar"); if (chkSelect != null) { int ID = Convert.ToInt32(chkSelect.Attributes["value"]); if (chkSelect.Checked && !this.ID_bar.Contains(ID)) { this.ID_bar.Add(ID); } else if (!chkSelect.Checked && this.ID_bar.Contains(ID)) { this.ID_bar.Remove(ID); } } } //insert ke KeranjangBelanja foreach (int item in ID_bar) { Koneksi cn = new Koneksi(); //get nama barang string sqlnama = "select nama_barang from stock where id_barang = " + item + ""; List <string> namaBarang = cn.KelasKoneksi_SelectGlobal(sqlnama, "4"); string sqlupdt = "insert into KeranjangBelanja values (" + memid + "," + item + ",'" + namaBarang[0].ToString() + "', " + Convert.ToInt32(TxtJumlah.Text) + ", GETDATE())";//insert ke KeranjangBelanja Hasil = cn.KelasKoneksi_CRUD(sqlupdt); if (Hasil == "1") { Response.Write("<script language='javascript'>window.alert('Berhasil Insert Data dengan ID :" + Convert.ToString(item) + "');window.location='../Halaman/Form_Pengguna.aspx';</script>"); } else { Response.Write("<script language='javascript'>window.alert('Gagal Insert Data dengan ID : " + Convert.ToString(item) + "');window.location='../Halaman/Form_Pengguna.aspx';</script>"); } } }
protected void BtnUpdate_Click(object sender, EventArgs e) { //get listview item chk foreach (ListViewDataItem item in ListViewHakAkses.Items) { CheckBox chkSelect = (CheckBox)item.FindControl("ChkIDMem"); if (chkSelect != null) { int ID = Convert.ToInt32(chkSelect.Attributes["value"]); if (chkSelect.Checked && !this.ID_Mem.Contains(ID)) { this.ID_Mem.Add(ID); } else if (!chkSelect.Checked && this.ID_Mem.Contains(ID)) { this.ID_Mem.Remove(ID); } } } //insert value Koneksi cn = new Koneksi(); foreach (int item in ID_Mem) { Hasil = cn.KelasKoneksi_CRUD("Update User_Akses set id_akses = " + Convert.ToInt32(DropDownListHakAkses.SelectedValue) + " where Member_id = " + item + ""); } if (Hasil == "1") { ListViewHakAkses.DataBind(); Response.Write("<script language='javascript'>window.alert('Berhasil Update Data');</script>"); } else { ListViewHakAkses.DataBind(); Response.Write("<script language='javascript'>window.alert('Terdapat Error Update Data : " + Hasil + "');</script>"); } }