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_dosen user = Session["user"] as tb_dosen;
dbDataContext db = new dbDataContext();
this.GridView1.DataSource = (from c in db.tb_dosens
orderby c.nid descending
select c).ToList();
this.GridView1.DataBind();
}
private void LoadData()
{
tb_dosen user = Session["user"] as tb_dosen;
dbDataContext db = new dbDataContext();
this.GridView1.DataSource = (from c in db.v_rooms
where c.id_pembimbing == user.id_dosen
orderby c.tgl_room descending
select c).ToList();
this.GridView1.DataBind();
}
private void LoadData()
{
tb_dosen user = Session["user"] as tb_dosen;
dbDataContext db = new dbDataContext();
int id = Int32.Parse(Request.QueryString["id"]);
this.GridView1.DataSource = (from c in db.v_chats
where c.id_room == id
orderby c.id_chat descending
select c).ToList();
this.GridView1.DataBind();
}
protected void Unnamed_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (dbDataContext db = new dbDataContext())
{
tb_dosen user = Session["user"] as tb_dosen;
tb_room model = new tb_room();
model.tgl_room = DateTime.Parse(t2.Text.Trim());
model.id_proposal = Int32.Parse(t1.SelectedValue);
model.id_mahasiswa = (from c in db.tb_proposals where c.id_proposal == model.id_proposal select c.id_mahasiswa).FirstOrDefault();
model.id_pembimbing = user.id_dosen;
db.tb_rooms.InsertOnSubmit(model);
db.SubmitChanges();
Response.Redirect("bimbingan.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack) // fungsi untuk cek postback kala
{
using (dbDataContext db = new dbDataContext())
{
tb_dosen user = Session["user"] as tb_dosen;
var data = (from c in db.v_proposals
where c.status_proposal == "Disetujui" && c.id_pembimbing_1 == user.id_dosen ||
c.id_pembimbing_2 == user.id_dosen
select new
{
c.id_proposal,
judul_skripsi = c.judul_skripsi + " - " + c.nama + " - " + c.nim
}).ToList();
t1.DataSource = data;
t1.DataTextField = "judul_skripsi";
t1.DataValueField = "id_proposal";
t1.DataBind();
}
}
}
protected void Unnamed_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (dbDataContext db = new dbDataContext())
{
int id = Int32.Parse(Request.QueryString["id"]);
var model = (from c in db.v_rooms where c.id_room == id select c).FirstOrDefault();
tb_mahasiswa user = Session["user"] as tb_mahasiswa;
if (user != null)
{
tb_chat c = new tb_chat();
c.id_room = id;
c.id_sender = user.id_mahasiswa;
c.isi = t4.Text.Trim();
c.status = 0;
c.id_recipient = model.id_pembimbing;
db.tb_chats.InsertOnSubmit(c);
}
else
{
tb_dosen user2 = Session["user"] as tb_dosen;
if (user2 != null)
{
tb_chat c = new tb_chat();
c.id_room = id;
c.status = 1;
c.id_sender = user2.id_dosen;
c.isi = t4.Text.Trim();
c.id_recipient = model.id_mahasiswa;
db.tb_chats.InsertOnSubmit(c);
}
}
db.SubmitChanges();
Response.Redirect(Request.UrlReferrer.ToString());
}
}
}