protected void DLRuangProdi_SelectedIndexChanged(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
SqlCommand CmdDosen = new SqlCommand("SELECT * FROM bak_ruang WHERE id_prog_study=@id_prodi", con);
CmdDosen.CommandType = System.Data.CommandType.Text;
CmdDosen.Parameters.AddWithValue("@id_prodi", this.DLRuangProdi.SelectedValue);
DataTable TableRuang = new DataTable();
TableRuang.Columns.Add("No");
TableRuang.Columns.Add("Ruang");
TableRuang.Columns.Add("Kapasitas");
using (SqlDataReader rdr = CmdDosen.ExecuteReader())
{
if (rdr.HasRows)
{
this.PanelDetailRuang.Enabled = true;
this.PanelDetailRuang.Visible = true;
while (rdr.Read())
{
DataRow datarow = TableRuang.NewRow();
datarow["No"] = rdr["no"];
datarow["Ruang"] = rdr["nm_ruang"];
datarow["Kapasitas"] = rdr["kapasitas"];
TableRuang.Rows.Add(datarow);
}
//Fill Gridview
this.GVRuang.DataSource = TableRuang;
this.GVRuang.DataBind();
}
else
{
//clear Gridview
TableRuang.Rows.Clear();
TableRuang.Clear();
GVRuang.DataSource = TableRuang;
GVRuang.DataBind();
this.PanelDetailRuang.Enabled = false;
this.PanelDetailRuang.Visible = false;
}
}
}
}
protected void ListRuangByProdi()
{
string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
//-----------------------------------------List All Ruang Kuliah -------------------------------------------
con.Open();
SqlCommand CmdRuang = new SqlCommand("SpRuangByProdi", con);
CmdRuang.CommandType = System.Data.CommandType.StoredProcedure;
if (this.DLMasterProdi.SelectedValue == "00-000")
{
// All Prodi
this.PanelDataRuang.Visible = true;
this.PanelDataRuang.Enabled = true;
this.PanelAddRuang.Visible = false;
this.PanelAddRuang.Enabled = false;
this.PanelEditRuang.Visible = false;
this.PanelEditRuang.Enabled = false;
}
else if (this.DLMasterProdi.SelectedValue == "-1")
{
this.PanelDataRuang.Visible = false;
this.PanelDataRuang.Enabled = false;
this.PanelAddRuang.Visible = false;
this.PanelAddRuang.Enabled = false;
this.PanelEditRuang.Visible = false;
this.PanelEditRuang.Enabled = false;
return;
}
else
{
// By Prodi
CmdRuang.Parameters.AddWithValue("@IdProdi", this.DLMasterProdi.SelectedValue);
this.PanelDataRuang.Visible = true;
this.PanelDataRuang.Enabled = true;
this.PanelAddRuang.Visible = false;
this.PanelAddRuang.Enabled = false;
this.PanelEditRuang.Visible = false;
this.PanelEditRuang.Enabled = false;
}
DataTable TableRuang = new DataTable();
TableRuang.Columns.Add("No");
TableRuang.Columns.Add("Id Ruang");
TableRuang.Columns.Add("Ruang");
TableRuang.Columns.Add("Kapasitas");
TableRuang.Columns.Add("Program Studi");
TableRuang.Columns.Add("Keterangan");
using (SqlDataReader rdr = CmdRuang.ExecuteReader())
{
if (rdr.HasRows)
{
this.PanelDataRuang.Visible = true;
this.PanelDataRuang.Enabled = true;
while (rdr.Read())
{
DataRow datarow = TableRuang.NewRow();
datarow["No"] = rdr["nomor"];
datarow["Id Ruang"] = rdr["no"];
datarow["Ruang"] = rdr["nm_ruang"];
datarow["Kapasitas"] = rdr["kapasitas"];
datarow["Program Studi"] = rdr["prog_study"];
if (rdr["status"].ToString() == "1")
{
datarow["Keterangan"] = "Aktif";
}
else
{
datarow["Keterangan"] = "Non Aktif";
}
TableRuang.Rows.Add(datarow);
}
//Fill Gridview
this.GVRuang.DataSource = TableRuang;
this.GVRuang.DataBind();
}
else
{
//clear Gridview
TableRuang.Rows.Clear();
TableRuang.Clear();
GVRuang.DataSource = TableRuang;
GVRuang.DataBind();
}
}
}
}