protected void UploadButton_Click(object sender, EventArgs e) { String savePath = @"~/files/"; try { foreach (RepeaterItem item in rptVrijstellingen.Items) { FileUpload file = (FileUpload)item.FindControl("FileUpload1"); if (file.HasFile) { TextBox EVK = (TextBox)item.FindControl("EVK"); TextBox SP = (TextBox)item.FindControl("SP"); DropDownList dropRapport = (DropDownList)item.FindControl("dropRapport"); HiddenField hiddenid = (HiddenField)item.FindControl("hiddenid"); String fileName = file.FileName; savePath += fileName; file.SaveAs(Server.MapPath(savePath + fileName)); ExternVak ev = new ExternVak(); ev.externvakNaam = EVK.Text; ev.externvakStudiepunt = SP.Text; studenten.insertExternvak(ev); insertid = ev.pk_externvakID; Bijlage bij = new Bijlage(); System.Threading.Thread.Sleep(3000); bij.fk_externvakID = insertid; bij.pk_bijlageID = Convert.ToInt16(dropRapport.SelectedValue); studenten.update(bij); Bijlage s = new Bijlage(); s.bijlageTitel = fileName; s.bijlageURL = savePath; s.bijlageType = "2"; s.fk_externvakID = insertid; studenten.insertFile(s); Evk ek = new Evk(); ek.fk_vakID = Convert.ToInt16(hiddenid.Value); ek.fk_externvakID = insertid; ek.fk_studentID = studentid; studenten.updateEVK(ek); } else { throw new Exception("Gelieve bij alle vakken een file toe te voegen of gegeven aan mevrouw Van Orlé aan te vinken en een afspraak te maken."); } } Response.Redirect("s_upload_bijlagen.aspx"); } catch (Exception ex) { UploadStatusLabel.Text = ex.Message; } }
public void updateEVK(Evk ek) { var recordToUpdate = (from p in dc.Evks where p.fk_studentID == ek.fk_studentID && p.fk_vakID == ek.fk_vakID select p).FirstOrDefault(); recordToUpdate.fk_externvakID = ek.fk_externvakID; dc.SubmitChanges(); }
public void insertVakkenEvk(Evk e) { try { DALevk.insertEvkVakken(e); } catch { throw new Exception("Vakken saven gaat niet."); } }
protected void btnSave_Click(object sender, EventArgs e) { foreach (var i in values) { Evk evk = new Evk(); lblFeeback.Text += i; evk.fk_studentID = 1; evk.fk_vakID = Convert.ToInt16(i); try { BLLevk.insertVakkenEvk(evk); lblFeeback.Text="bewaard, klik op volgonde om je evk informatie aan te vullen."; lblFeeback.Style.Add("Color","green"); } catch(Exception ex) { lblFeeback.Text=ex.Message.ToString(); lblFeeback.Style.Add("Color","red"); } } }
protected void btnSave_Click(object sender, EventArgs e) { foreach (var i in values) { Evk evk = new Evk(); lblFeeback.Text += i; evk.fk_studentID = 1; evk.fk_vakID = Convert.ToInt16(i); try { BLLevk.insertVakkenEvk(evk); lblFeeback.Text = "bewaard, klik op volgonde om je evk informatie aan te vullen."; lblFeeback.Style.Add("Color", "green"); } catch (Exception ex) { lblFeeback.Text = ex.Message.ToString(); lblFeeback.Style.Add("Color", "red"); } } }
private void attach_Evks(Evk entity) { this.SendPropertyChanging(); entity.ExternVak = this; }
public void insertEvkVakken(Evk e) { dc.Evks.InsertOnSubmit(e); dc.SubmitChanges(); }
public void updateEVK(Evk ek) { DALstudent.updateEVK(ek); }
private void detach_tblEvks(Evk entity) { this.SendPropertyChanging(); entity.Vak = null; }
private void attach_Evks(Evk entity) { this.SendPropertyChanging(); entity.Student = this; }
private void attach_tblEvks(Evk entity) { this.SendPropertyChanging(); entity.Vak = this; }
partial void DeleteEvk(Evk instance);
partial void UpdateEvk(Evk instance);
partial void InsertEvk(Evk instance);
private void detach_Evks(Evk entity) { this.SendPropertyChanging(); entity.Student = null; }