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>");
}
}
