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"); } } } }