protected void BtnViewKRS_Click(object sender, EventArgs e)
{
try
{
//1. ---------- Gridview SKS ------------------
string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
// --------------------- Fill Gridview ------------------------
SqlCommand CmdListKRS = new SqlCommand("SpListKrsMhs2", con);
CmdListKRS.CommandType = System.Data.CommandType.StoredProcedure;
CmdListKRS.Parameters.AddWithValue("@npm", this.Session["Name"].ToString());
CmdListKRS.Parameters.AddWithValue("@semester", this.DLTahun.SelectedItem.Text + this.DLSemester.SelectedItem.Text);
DataTable TableKRS = new DataTable();
TableKRS.Columns.Add("Key");
TableKRS.Columns.Add("Kode");
TableKRS.Columns.Add("Mata Kuliah");
TableKRS.Columns.Add("SKS");
TableKRS.Columns.Add("Dosen");
TableKRS.Columns.Add("Kelas");
TableKRS.Columns.Add("Hari");
TableKRS.Columns.Add("Mulai");
TableKRS.Columns.Add("Selesai");
TableKRS.Columns.Add("Ruang");
using (SqlDataReader rdr = CmdListKRS.ExecuteReader())
{
if (rdr.HasRows)
{
this.PanelListKRS.Enabled = true;
this.PanelListKRS.Visible = true;
while (rdr.Read())
{
DataRow datarow = TableKRS.NewRow();
datarow["Key"] = rdr["no_jadwal"];
datarow["Kode"] = rdr["kode_makul"];
datarow["Mata Kuliah"] = rdr["makul"];
datarow["SKS"] = rdr["sks"];
datarow["Dosen"] = rdr["nama"];
datarow["Kelas"] = rdr["kelas"];
datarow["Hari"] = rdr["hari"];
datarow["Mulai"] = rdr["jm_awal_kuliah"];
datarow["Selesai"] = rdr["jm_akhir_kuliah"];
datarow["Ruang"] = rdr["nm_ruang"];
TableKRS.Rows.Add(datarow);
}
//Fill Gridview
this.GVListKrs.DataSource = TableKRS;
this.GVListKrs.DataBind();
//this.DLSemester.SelectedValue = "Semester";
}
else
{
//clear Gridview
TableKRS.Rows.Clear();
TableKRS.Clear();
GVListKrs.DataSource = TableKRS;
GVListKrs.DataBind();
this.PanelListKRS.Enabled = false;
this.PanelListKRS.Visible = false;
this.DLSemester.SelectedValue = "Semester";
//this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('KRS Semester Ini Belum Ada');", true);
string message = "alert('KRS Semester Ini Belum Ada')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
}
}
}
}
catch (Exception ex)
{
this.PanelListKRS.Enabled = false;
this.PanelListKRS.Visible = false;
this.DLSemester.SelectedValue = "Semester";
string message = "alert('" + ex.Message.ToString() + "')";
ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true);
//this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true);
//return;
}
}
protected void BtnFilter_Click(object sender, EventArgs e)
{
//form validation
if (this.TBNpm.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Isi NPM');", true);
return;
}
if (this.RBList.Checked == false)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Aksi KRS');", true);
return;
}
if (this.DLTahun.SelectedItem.Text == "Tahun" || this.DLTahun.SelectedItem.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Tahun');", true);
return;
}
if (this.DLSemester.SelectedItem.Text == "Semester")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Semester');", true);
return;
}
// ------- Read Data Mahasiswa ----------
try
{
mhs.ReadMahasiswa(this.TBNpm.Text);
LbNama.Text = mhs.nama.ToString();
LbKelas.Text = mhs.kelas.ToString();
LbProdi.Text = mhs.Prodi.ToString();
LbTahun.Text = mhs.thn_angkatan.ToString();
LbNpm.Text = mhs.npm.ToString();
LbIdProdi.Text = mhs.id_prodi.ToString();
if (this.Session["Prodi"].ToString() != mhs.Prodi.ToString())
{
PanelListKRS.Visible = false;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Mahasiswa Tidak Ditemukan');", true);
return;
}
}
catch (Exception)
{
LbNama.Text = "Nama";
LbKelas.Text = "Kelas";
LbProdi.Text = "Program Studi";
LbTahun.Text = "Tahun Angkatan";
LbNpm.Text = "NPM";
LbIdProdi.Text = "";
//clear Gridview
DataTable TableKP = new DataTable();
TableKP.Rows.Clear();
TableKP.Clear();
//this.GVAmbilKRS.DataSource = TableKP;
//this.GVAmbilKRS.DataBind();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Mahasiswa tidak ditemukan');", true);
return;
}
//--------------------------- LIHAT KRS ------------------------------ //
if (this.RBList.Checked)
{
_TotalSKS = 0;
_TotalEditSKS = 0;
try
{
//1. ---------- Gridview SKS ------------------
string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
con.Open();
// --------------------- Fill Gridview ------------------------
SqlCommand CmdListKRS = new SqlCommand("SpListKrsMhs2", con);
CmdListKRS.CommandType = System.Data.CommandType.StoredProcedure;
CmdListKRS.Parameters.AddWithValue("@npm", this.TBNpm.Text);
CmdListKRS.Parameters.AddWithValue("@semester", this.DLTahun.SelectedItem.Text + this.DLSemester.SelectedItem.Text);
DataTable TableKRS = new DataTable();
TableKRS.Columns.Add("Key");
TableKRS.Columns.Add("Kode");
TableKRS.Columns.Add("Mata Kuliah");
TableKRS.Columns.Add("SKS");
TableKRS.Columns.Add("Dosen");
TableKRS.Columns.Add("Kelas");
TableKRS.Columns.Add("Hari");
TableKRS.Columns.Add("Mulai");
TableKRS.Columns.Add("Selesai");
TableKRS.Columns.Add("Ruang");
using (SqlDataReader rdr = CmdListKRS.ExecuteReader())
{
if (rdr.HasRows)
{
this.PanelListKRS.Enabled = true;
this.PanelListKRS.Visible = true;
while (rdr.Read())
{
DataRow datarow = TableKRS.NewRow();
datarow["Key"] = rdr["no_jadwal"];
datarow["Kode"] = rdr["kode_makul"];
datarow["Mata Kuliah"] = rdr["makul"];
datarow["SKS"] = rdr["sks"];
datarow["Dosen"] = rdr["nama"];
datarow["Kelas"] = rdr["kelas"];
datarow["Hari"] = rdr["hari"];
datarow["Mulai"] = rdr["jm_awal_kuliah"];
datarow["Selesai"] = rdr["jm_akhir_kuliah"];
datarow["Ruang"] = rdr["nm_ruang"];
TableKRS.Rows.Add(datarow);
}
//Fill Gridview
this.GVListKrs.DataSource = TableKRS;
this.GVListKrs.DataBind();
this.DLSemester.SelectedIndex = 0;
}
else
{
//clear Gridview
TableKRS.Rows.Clear();
TableKRS.Clear();
GVListKrs.DataSource = TableKRS;
GVListKrs.DataBind();
this.PanelListKRS.Enabled = false;
this.PanelListKRS.Visible = false;
this.DLSemester.SelectedIndex = 0;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('KRS Semester Ini Belum Ada');", true);
}
}
}
}
catch (Exception ex)
{
this.PanelListKRS.Enabled = false;
this.PanelListKRS.Visible = false;
this.DLSemester.SelectedIndex = 0;
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true);
return;
}
}
}