private void LoadData()
        {
            tb_mahasiswa  user = Session["user"] as tb_mahasiswa;
            dbDataContext db   = new dbDataContext();

            this.GridView1.DataSource = (from c in db.tb_mahasiswas
                                         orderby c.nim descending
                                         select c).ToList();
            this.GridView1.DataBind();
        }
        private void LoadData()
        {
            tb_mahasiswa  user = Session["user"] as tb_mahasiswa;
            dbDataContext db   = new dbDataContext();

            this.GridView1.DataSource = (from c in db.v_proposals
                                         where c.id_mahasiswa == user.id_mahasiswa
                                         orderby c.tgl_submit descending
                                         select c).ToList();
            this.GridView1.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());
                }
            }
        }
        protected void Unnamed_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                using (dbDataContext db = new dbDataContext())
                {
                    int          id    = Int32.Parse(Request.QueryString["id"]);
                    tb_mahasiswa user  = Session["user"] as tb_mahasiswa;
                    tb_proposal  model = (from c in db.tb_proposals where c.id_proposal == id select c).FirstOrDefault();
                    model.tgl_submit    = DateTime.Now;
                    model.id_mahasiswa  = user.id_mahasiswa;
                    model.judul_skripsi = t1.Text.Trim();
                    string dir = Server.MapPath("file_pengajuan");

                    if (!Directory.Exists(dir))
                    {
                        Directory.CreateDirectory(dir);
                    }


                    if (Request.Files != null)
                    {
                        int  i           = 1;
                        bool isValidFile = false;
                        foreach (var file in f1.PostedFiles)
                        {
                            string[] validFileTypes = { "pdf", "docx", "PDF", "DOCX" };
                            string   ext            = System.IO.Path.GetExtension(f1.PostedFile.FileName);

                            for (int x = 0; x < validFileTypes.Length; x++)
                            {
                                if (ext == "." + validFileTypes[x])
                                {
                                    isValidFile = true;
                                    break;
                                }
                            }
                        }


                        if (!isValidFile)
                        {
                            error_tipe.Visible = true;
                        }
                        else
                        {
                            foreach (var file in f1.PostedFiles)
                            {
                                string fn = i + "_" + file.FileName;

                                //file.SaveAs(dir + "/temp_laporan/" + fn);
                                string path = Server.MapPath(@"jangan_buang\" + model.id_proposal + "\\");
                                if (!Directory.Exists(path))
                                {
                                    Directory.CreateDirectory(path);
                                }
                                file.SaveAs(path + fn);

                                i++;
                            }
                            model.status_proposal = "Pending";
                            db.SubmitChanges();
                            Response.Redirect("pengajuan.aspx");
                        }
                    }
                    else
                    {
                        model.status_proposal = "Pending";
                        db.SubmitChanges();
                        Response.Redirect("pengajuan.aspx");
                    }
                }
            }
        }
示例#5
0
        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");
                    }
                }
            }
        }