public void GetData()
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.KamarBLL bll = new NineOrchidBLL.KamarBLL();
SortedList sl = new SortedList();
sl.Add("@idxKamar-varchar-10", ID);
DataTable dt = bll.GetContent(sl);
KategoriKamar.Text = dt.Rows[0]["kategori_kmr"].ToString();
no_kamar.Text = dt.Rows[0]["no_kamar"].ToString();
no_kamar.Enabled = false;
if (dt.Rows[0]["peruntukan"].ToString() == "Pria")
{
peruntukanddl.SelectedValue = "1";
}
else if (dt.Rows[0]["peruntukan"].ToString() == "Wanita")
{
peruntukanddl.SelectedValue = "2";
}
else
{
peruntukanddl.SelectedValue = "3";
}
if (dt.Rows[0]["isAC"].ToString() == "iya")
{
CheckBoxAC.Checked = true;
}
else
{
CheckBoxAC.Checked = false;
}
if (dt.Rows[0]["isTV"].ToString() == "iya")
{
CheckBoxTV.Checked = true;
}
else
{
CheckBoxTV.Checked = false;
}
trf_harian.Text = dt.Rows[0]["trf_harian"].ToString();
trf_bulanan.Text = dt.Rows[0]["trf_bulanan"].ToString();
trf_tiga_bulanan.Text = dt.Rows[0]["trf_tiga_bulanan"].ToString();
ket.Text = dt.Rows[0]["ket"].ToString();
}
public void getData(string action)
{
string ID = Request.QueryString["rowid"];
if (action == "1")
{
NineOrchidBLL.GedungBLL bll = new NineOrchidBLL.GedungBLL();
SortedList sl = new SortedList();
sl.Add("@idxGedung-int", ID);
DataTable dt = bll.GetContent(sl);
string x = dt.Rows[0]["gedung_nm"].ToString();
lblFileName.Text = x;
}
else if (action == "2")
{
NineOrchidBLL.KamarBLL bll = new NineOrchidBLL.KamarBLL();
SortedList sl = new SortedList();
sl.Add("@idxKamar-varchar-10", ID);
DataTable dt = bll.GetContent(sl);
string x = dt.Rows[0]["idxKamar"].ToString();
lblFileName.Text = x;
}
else if (action == "3")
{
NineOrchidBLL.PerusahaanBLL bll = new NineOrchidBLL.PerusahaanBLL();
SortedList sl = new SortedList();
sl.Add("@idxPerusahaan-int", ID);
DataTable dt = bll.GetContent(sl);
string x = dt.Rows[0]["idxPerusahaan"].ToString();
lblFileName.Text = x;
}
else if (action == "5")
{
NineOrchidBLL.PenghuniBLL bll = new NineOrchidBLL.PenghuniBLL();
SortedList sl = new SortedList();
sl.Add("@idxPenghuni-int", ID);
DataTable dt = bll.GetContent(sl);
string x = dt.Rows[0]["idxPenghuni"].ToString();
lblFileName.Text = x;
}
else
{
lblFileName.Text = "";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.KamarBLL bll = new NineOrchidBLL.KamarBLL();
SortedList sl = new SortedList();
sl.Add("@idxKamar-varchar-10", ID);
sl.Add("@kategori_kmr-varchar-20", KategoriKamar.Text);
sl.Add("@peruntukan-varchar-10", peruntukanddl.SelectedValue);
sl.Add("@isAC-bit", CheckBoxAC.Checked);
sl.Add("@isTV-bit", CheckBoxTV.Checked);
sl.Add("@trf_harian-varchar-50", trf_harian.Text);
sl.Add("@trf_bulanan-varchar-50", trf_bulanan.Text);
sl.Add("@trf_tiga_bulanan-varchar-50", trf_tiga_bulanan.Text);
sl.Add("@ket-varchar-10", ket.Text);
bll.Update(sl);
Response.Redirect("~/Pages/Project/MasterKamar.aspx");
}
public void delete(string action)
{
if (action == "1")
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.GedungBLL bll = new NineOrchidBLL.GedungBLL();
SortedList sl = new SortedList();
sl.Add("@idxGedung-int", ID);
bll.Delete(sl);
}
else if (action == "2")
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.KamarBLL bll = new NineOrchidBLL.KamarBLL();
SortedList sl = new SortedList();
sl.Add("@idxKamar-varchar-10", ID);
bll.Delete(sl);
}
else if (action == "3")
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.PerusahaanBLL bll = new NineOrchidBLL.PerusahaanBLL();
SortedList sl = new SortedList();
sl.Add("@idxPerusahaan-INT", ID);
bll.Delete(sl);
}
else if (action == "4")
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.KerabatBLL bll = new NineOrchidBLL.KerabatBLL();
SortedList sl = new SortedList();
sl.Add("@idxKerabat-INT", ID);
bll.Delete(sl);
}
else if (action == "5")
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.PenghuniBLL bll = new NineOrchidBLL.PenghuniBLL();
SortedList sl = new SortedList();
sl.Add("@idxPenghuni-INT", ID);
bll.Delete(sl);
}
}
public void GetData()
{
string ID = Request.QueryString["rowid"];
NineOrchidBLL.KamarBLL bll = new NineOrchidBLL.KamarBLL();
SortedList sl = new SortedList();
sl.Add("@idxKamar-varchar-10", ID);
DataTable dt = bll.GetContent(sl);
KategoriKamar.Text = dt.Rows[0]["kategori_kmr"].ToString();
no_kamar.Text = dt.Rows[0]["no_kamar"].ToString();
peruntukan.Text = dt.Rows[0]["peruntukan"].ToString();
lantai_kmr.Text = dt.Rows[0]["lantai_kmr"].ToString();
gedungkos.Text = dt.Rows[0]["gedung_nm"].ToString();
if (dt.Rows[0]["isAC"].ToString() == "iya")
{
CheckBoxAC.Checked = true;
}
else
{
CheckBoxAC.Checked = false;
}
if (dt.Rows[0]["isTV"].ToString() == "iya")
{
CheckBoxTV.Checked = true;
}
else
{
CheckBoxTV.Checked = false;
}
trf_harian.Text = dt.Rows[0]["trf_harian"].ToString();
trf_bulanan.Text = dt.Rows[0]["trf_bulanan"].ToString();
trf_tiga_bulanan.Text = dt.Rows[0]["trf_tiga_bulanan"].ToString();
ket.Text = dt.Rows[0]["ket"].ToString();
stat_kamar.Text = dt.Rows[0]["stat_kmr"].ToString();
var a = dt.Rows[0]["foto1"].ToString();
if (!string.IsNullOrEmpty(a))
{
byte[] data = (byte[])dt.Rows[0]["foto1"];
image1.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
var b = dt.Rows[0]["foto2"].ToString();
if (!string.IsNullOrEmpty(b))
{
byte[] data = (byte[])dt.Rows[0]["foto2"];
image2.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
var c = dt.Rows[0]["foto3"].ToString();
if (!string.IsNullOrEmpty(c))
{
byte[] data = (byte[])dt.Rows[0]["foto3"];
image3.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
var d = dt.Rows[0]["foto4"].ToString();
if (!string.IsNullOrEmpty(d))
{
byte[] data = (byte[])dt.Rows[0]["foto4"];
image4.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
var e = dt.Rows[0]["foto5"].ToString();
if (!string.IsNullOrEmpty(e))
{
byte[] data = (byte[])dt.Rows[0]["foto5"];
image5.ImageUrl = "data:image;base64," + Convert.ToBase64String(data);
}
}
