protected void Page_Load(object sender, EventArgs e)
{
var x = Int32.Parse("" + Session["role"]);
if (x == 0)
{
user = Session["user"] as tb_mahasiswa;
}
else
{
user = Session["user"];
}
/*for (int i = 0; i < Session.Count; i++)
* {
* string value = "Key: " + Session.Keys[i] + ", Value: " + Session[Session.Keys[i]].ToString();
*
* Response.Write(value);
* }*/
if (user == null)
{
Response.Redirect("default.aspx");
return;
}
using (dbDataContext db = new dbDataContext())
{
s1.InnerText = db.tb_proposals.Count() + "";
s2.InnerText = db.tb_mahasiswas.Count() + "";
s3.InnerText = db.tb_dosens.Count() + "";
s4.InnerText = db.tb_kaprodis.Count() + "";
int tipe = Int32.Parse("" + Session["role"]);
if (tipe == 0)
{
tb_mahasiswa user = Session["user"] as tb_mahasiswa;
t1.Text = user.nim;
t2.Text = user.nama;
t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault();
t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault();
}
else if (tipe == 2)
{
tb_dosen user = Session["user"] as tb_dosen;
t1.Text = user.nid;
t2.Text = user.nama;
t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault();
t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault();
}
else
{
tb_kaprodi user = Session["user"] as tb_kaprodi;
t1.Text = user.username;
t2.Text = user.nama;
t3.Text = (from c in db.tb_fakultas where c.id_fakultas == user.id_fakultas select c.nama_fakultas).FirstOrDefault();
t4.Text = (from c in db.tb_jurusans where c.id_jurusan == user.id_jurusan select c.nama_jurusan).FirstOrDefault();
}
}
}
private void LoadData()
{
tb_kaprodi user = Session["user"] as tb_kaprodi;
//DataTable dt = new DataTable();
//string querystring = "select A.id_proposal, B.nim, A.tgl_submit, A.status_proposal, A.judul_skripsi , B.nama, C.nama as dosen_1, D.nama as dosen_2 from tb_proposal as A left join tb_mahasiswa as B on B.id_mahasiswa = A.id_mahasiswa left join tb_dosen as C on C.id_dosen = A.id_pembimbing_1 left join tb_dosen as D on D.id_dosen = A.id_pembimbing_2 where B.id_jurusan = "+user.id_jurusan;
//using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["bimbingan_onlineConnectionString"].ToString()))
//{
// SqlCommand command = new SqlCommand(
// querystring, connection);
// connection.Open();
// using (SqlDataReader reader = command.ExecuteReader())
// {
// dt.Load(reader);
// }
//}
//var count = 0;
//List<tb_pengajuan> tbp = new List<tb_pengajuan>();
//foreach (DataRow dr in dt.Rows)
//{
// tb_pengajuan tb = new tb_pengajuan()
// {
// nim = (string)dr["nim"],
// nama = (string)dr["nama"],
// judul_skripsi = (dr["judul_skripsi"] == null) ? String.Empty : (string)dr["judul_skripsi"],
// tgl_submit= (DateTime)dr["tgl_submit"],
// status_proposal = (dr["status_proposal"] == null) ? String.Empty : (string)dr["status_proposal"],
// id_proposal = (int)dr["id_proposal"],
// dosen_1 = (dr["dosen_1"] == null) ? (string)dr["dosen_1"] : String.Empty,
// dosen_2 = (dr["dosen_2"] == null) ? (string)dr["dosen_2"] : String.Empty
// };
// tbp.Add(tb);
// count++;
//}
//jumlah_mhs = count;
//this.GridView1.DataSource = tbp;
dbDataContext db = new dbDataContext();
this.GridView1.DataSource = (from c in db.v_proposals
where c.id_jurusan == user.id_jurusan
orderby c.tgl_submit descending
select c).ToList();
this.GridView1.DataBind();
}
protected void Unnamed_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (d1.SelectedValue.Equals("Disetujui") && d2.SelectedValue.ToString() != "0" && d3.SelectedValue.ToString() != "0")
{
tb_kaprodi user = Session["user"] as tb_kaprodi;
using (dbDataContext db = new dbDataContext())
{
int id = Int32.Parse(Request.QueryString["id"]);
tb_proposal model = (from c in db.tb_proposals where c.id_proposal == id select c).FirstOrDefault();
model.status_proposal = d1.SelectedValue;
try
{
model.id_pembimbing_1 = Int32.Parse(d2.SelectedValue);
}
catch
{
}
try
{
model.id_pembimbing_2 = Int32.Parse(d3.SelectedValue);
}
catch
{
}
model.id_kaprodi = user.id_pengguna;
model.catatan_kaprodi = catatan_kaprodi.Text;
db.SubmitChanges();
Response.Redirect("list_pengajuan.aspx");
}
}
else
{
show_error.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
show_error.Visible = false;
int id = Int32.Parse(Request.QueryString["id"]);
tb_kaprodi us = Session["user"] as tb_kaprodi;
using (dbDataContext db = new dbDataContext())
{
tb_proposal model = (from c in db.tb_proposals where c.id_proposal == id select c).FirstOrDefault();
if (model != null)
{
t1.Text = model.judul_skripsi;
catatan_kaprodi.Text = model.catatan_kaprodi;
tb_mahasiswa tm = (from c in db.tb_mahasiswas where c.id_mahasiswa == model.id_mahasiswa select c).FirstOrDefault();
nama_mhs.Text = tm.nama;
ipk_mhs.Text = tm.ipk + "";
nim_mhs.Text = tm.nim;
alamat.Text = tm.alamat;
telp.Text = tm.telp;
fakultas.Text = (from c in db.tb_fakultas where c.id_fakultas == tm.id_fakultas select c.nama_fakultas).FirstOrDefault();
jurusan.Text = (from c in db.tb_jurusans where c.id_jurusan == tm.id_jurusan select c.nama_jurusan).FirstOrDefault();
List <file_info> fi = new List <file_info>();
string path = Server.MapPath(@"jangan_buang\" + model.id_proposal + "\\");
foreach (string fileName in Directory.GetFiles(path))
{
// fileName is the file name
file_info fi_i = new file_info();
fi_i.nama_file = fileName;
fi_i.lokasi_file = @"jangan_buang\" + model.id_proposal + "\\" + Path.GetFileName(fileName);
fi.Add(fi_i);
}
RptDownload.DataSource = fi;
RptDownload.DataBind();
var data = (from c in db.tb_dosens where c.id_jurusan == us.id_jurusan orderby c.nama select c).ToList();
data.Insert(0, new tb_dosen()
{
nama = "-",
nid = "",
});
d3.DataSource = data;
d3.DataTextField = "nama";
d3.DataValueField = "id_dosen";
d3.DataBind();
d2.DataSource = data;
d2.DataTextField = "nama";
d2.DataValueField = "id_dosen";
d2.DataBind();
}
else
{
Response.Redirect("list_pengajuan.aspx");
}
}
}
}
