protected void BtnSubmit_Click(object sender, EventArgs e)
{
//deklarasi variabel
string nama = string.Empty;
string email = string.Empty;
string pass = string.Empty;
string ttl = string.Empty;
nama = TxtNama.Text;
email = TxtEmail.Text;
pass = TxtPswd.Text;
ttl = TxtTTL.Text;
//Pemanggilan fungsi
Koneksi cn = new Koneksi();
string Hasil = cn.KelasKoneksi_Insert(nama, pass, email, ttl);
if (Hasil == "1")
{
string sqlselect = "select max(member_id) as member_id from Ms_member";
List <string> memberid = cn.KelasKoneksi_SelectGlobal(sqlselect, "5");
foreach (string item in memberid)
{
string isipesan = "<div style='background:linear-gradient(#c0c0c0, #f5f5f5);border-bottom:1px solid #d60000;padding:5px;font-family:verdana;'>Pemberitahuan IT Web System</div><div style='font-family:verdana;font-size:10pt;padding:4px;margin:5px auto;border-left:3px solid #0080c0;'><div style='margin:0 auto;background: #FFfFD5;width:50%;padding:5px;border-radius:4px;border-left:3px solid #0080c0;font-family:verdana;font-size:10pt;'> Selamat, Registrasi Anda Berhasil!<br/> Berikut Adalah Detail Akun Anda Untuk Login ; <br/> Username : "******"<br/>Password : "******"<br/> Jaga selalu Kerahasiaan Akun Anda. Kami Tidak Bertanggung Jawab atas Kelalaian yang di sebabkan Oleh Pengguna. <br/><span style='color:blue;font-size:8pt;'></span></div><br/><br><center style='color: blue; '></center><br/><center>Atas perhatian dan kerjasamanya kami ucapkan terimakasih.</center><br/><br/><br/><strong style='color:blue;font-family:verdana;'>Regards,<br/><i style='font-size:8pt;color:#666;'>Web System | IT Departement</i></strong><br/><strong>IT Group</strong><br/><i>PT. YourCompanyName</i><br/><span style='font-size:9pt;color:#666;'>Jakarta - Indonesia<br/>Branch Address</span><br/>Phone Number<br/>Website : <a href=# target='_blank'>Your Web</a><br/></div>";
HasilEmail = cn.email_otomatis(email, isipesan);
//Response.Write("<script language='javascript'>window.alert('Sukses Menyimpan Data !');window.location='../Login.aspx';</script>");
}
if (HasilEmail == "OK")
{
Response.Write("<script language='javascript'>window.alert('Sukses Menyimpan Data, Cek Email Anda Segera !');window.location='../Login.aspx';</script>");
}
else
{
Response.Write("<script language='javascript'>window.alert('Gagal Menyimpan Data!');window.location='../Login.aspx';</script>");
}
//kirim email id login dan passwordnya
//redirect ke menu login
}
else
{
Response.Write("<script language=javascript>alert('gagal Insert Data, dengan Error : " + Hasil + "');</script>");
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
//ke tb userakses berdasarkan member id
//Panggil Kelas Konksi Login
Koneksi cn = new Koneksi();
bool hasil;
hasil = cn.KelasKoneksi_Login(TxtUsername.Text, TxtPasswd.Text);
if (Validate())
{
if (hasil)
{
Session["Member_ID"] = TxtUsername.Text;
//ke tb userakses berdasarkan member id -- 1:menu master 2:menu pengguna
string sql_akses = "select id_akses from User_akses where Member_id = " + Convert.ToInt32(TxtUsername.Text) + "";
List <string> akses = cn.KelasKoneksi_SelectGlobal(sql_akses, "3");
if (akses.Count == 0)
{
Response.Write("<script language='javascript'>window.alert('Gagal Login! Hak Akses Anda tidak Di Temukan');window.location='../Login.aspx';</script>");
}
else
{
if (akses[0].ToString() == "1")
{
Response.Write("<script language='javascript'>window.alert('Berhasil Login!');window.location='../Halaman/Master.aspx';</script>");
}
else
{
Response.Write("<script language='javascript'>window.alert('Berhasil Login!');window.location='../Halaman/Form_Pengguna.aspx';</script>");
}
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Gagal Login!');window.location='../Login.aspx';</script>");
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Gagal menyimpan, Harap Centang Captcha !')", true);
}
}
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>");
}
}
}