protected void LoadAktvMhs()
{
if (this.DLTahun.SelectedItem.Text == "Tahun")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Tahun');", true);
return;
}
if (this.DLProdi.SelectedValue == "-1")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Program Studi');", true);
return;
}
if (this.DlSemester.SelectedValue == "semester")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Pilih Semester');", true);
return;
}
try
{
string CS = ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
//------------------------------------------------------------------------------------
con.Open();
SqlCommand CmdJadwal = new SqlCommand("SpGetAktvMhs", con);
CmdJadwal.CommandType = System.Data.CommandType.StoredProcedure;
CmdJadwal.Parameters.AddWithValue("@semester", this.DLTahun.SelectedValue.ToString() + this.DlSemester.SelectedItem.Text.Trim());
CmdJadwal.Parameters.AddWithValue("@idprodi", this.DLProdi.SelectedValue);
DataTable TableJadwal = new DataTable();
TableJadwal.Columns.Add("Nomor");
TableJadwal.Columns.Add("No");
TableJadwal.Columns.Add("NPM");
TableJadwal.Columns.Add("Nama");
TableJadwal.Columns.Add("IPS");
TableJadwal.Columns.Add("SKS-Sem");
TableJadwal.Columns.Add("IPK");
TableJadwal.Columns.Add("SKS-Total");
TableJadwal.Columns.Add("ThnAngkatan");
using (SqlDataReader rdr = CmdJadwal.ExecuteReader())
{
if (rdr.HasRows)
{
while (rdr.Read())
{
DataRow datarow = TableJadwal.NewRow();
datarow["Nomor"] = rdr["nomor"];
datarow["No"] = rdr["no"];
datarow["NPM"] = rdr["npm"];
datarow["Nama"] = rdr["nama"];
datarow["IPS"] = rdr["ips"];
datarow["SKS-Sem"] = rdr["sks_sem"];
datarow["IPK"] = rdr["ipk"];
datarow["SKS-Total"] = rdr["sks_total"];
datarow["ThnAngkatan"] = rdr["thn_angkatan"].ToString().Trim().Substring(0, 4);
TableJadwal.Rows.Add(datarow);
}
// Semester
_Semester = this.DLTahun.SelectedValue.ToString() + this.DlSemester.SelectedItem.Text.Trim();
//Fill Gridview
this.GVAktvMhs.DataSource = TableJadwal;
this.GVAktvMhs.DataBind();
MarkEdit(this.GVAktvMhs);
}
else
{
//clear Gridview
TableJadwal.Rows.Clear();
TableJadwal.Clear();
GVAktvMhs.DataSource = TableJadwal;
GVAktvMhs.DataBind();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('Data Tidak Ditemukan');", true);
}
}
}
}
catch (Exception ex)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true);
return;
}
}
protected void BtnAktvMhs_Click(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["FEEDER"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
try
{
con.Open();
SqlCommand CmdChPwd = new SqlCommand("SpFeederAktvMhs", con);
CmdChPwd.CommandType = System.Data.CommandType.StoredProcedure;
CmdChPwd.Parameters.AddWithValue("@semester", this.TbSemester.Text.Trim());
CmdChPwd.Parameters.AddWithValue("@IdProdi", this.DLProdi.SelectedValue);
DataTable TableJadwal = new DataTable();
TableJadwal.Columns.Add("Semester");
TableJadwal.Columns.Add("NPM");
TableJadwal.Columns.Add("Status");
TableJadwal.Columns.Add("IPS");
TableJadwal.Columns.Add("SKS Semester");
TableJadwal.Columns.Add("IPK");
TableJadwal.Columns.Add("SKS Total");
using (SqlDataReader rdr = CmdChPwd.ExecuteReader())
{
if (rdr.HasRows)
{
this.LbBtnAktvMhsResult.Text = "";
while (rdr.Read())
{
DataRow datarow = TableJadwal.NewRow();
datarow["Semester"] = rdr["smster"].ToString().ToUpper().Trim();
datarow["NPM"] = rdr["npm"].ToString().ToUpper().Trim();
datarow["Status"] = rdr["status"].ToString().ToUpper().Trim();
datarow["IPS"] = rdr["ips"].ToString().ToUpper().Trim();
datarow["SKS Semester"] = rdr["sks_sem"].ToString().ToUpper().Trim();
datarow["IPK"] = rdr["ipk"].ToString().ToUpper().Trim();
datarow["SKS Total"] = rdr["sks_total"].ToString().ToUpper().Trim();
TableJadwal.Rows.Add(datarow);
}
//Fill Gridview
this.GVAktvMhs.DataSource = TableJadwal;
this.GVAktvMhs.DataBind();
// Show panel Maba
this.PanelAktvMhs.Enabled = true;
this.PanelAktvMhs.Visible = true;
}
else
{
this.LbBtnAktvMhsResult.Text = "Data Tidak Ditemukan";
this.LbBtnAktvMhsResult.ForeColor = System.Drawing.Color.Blue;
// hide panel Maba
this.PanelAktvMhs.Enabled = false;
this.PanelAktvMhs.Visible = false;
//clear Gridview
TableJadwal.Rows.Clear();
TableJadwal.Clear();
this.GVAktvMhs.DataSource = TableJadwal;
GVAktvMhs.DataBind();
}
}
}
catch (Exception ex)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ex", "alert('" + ex.Message.ToString() + "');", true);
return;
}
}
}
