private void StudentDocumentsEntityForm_Load(object sender, EventArgs e) { try { GetDocumentTypes(); if (String.IsNullOrEmpty(Id)) { this.Text = "Добавление документа"; MesAccept = "Документ успешно добавлен"; sd.StudentId = StudentId; } else { metroTextBoxId.Enabled = false; this.Text = "Редактирование документа"; using (ApplicationDbContext context = new ApplicationDbContext()) { sd = context.StudentDocuments.Find(Id); metroTextBoxId.Text = sd.StudentDocumentId; metroTextBoxName.Text = sd.StudentDocumentName; metroComboBoxType.SelectedValue = sd.DocumentTypeId; metroTextBoxFrom.Text = sd.StudentDoucmentFrom; metroTextBoxTo.Text = sd.StudentDocumentTo; dateTimePickerDate.Value = sd.StudentDocumentDateCreation; richTextBoxDescription.Text = sd.StudentDocumentDescription; } MesAccept = "Документ успешно изменен"; } } catch (Exception gg) { MessageBox.Show(gg.Message, "SWA", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ActionResult DeleteConfirmed(int id) { StudentDocument studentDocument = db.StudentDocuments.Find(id); db.StudentDocuments.Remove(studentDocument); db.SaveChanges(); return(RedirectToAction("Index")); }
public static Student AsEntity(this StudentDocument document) => new Student( document.UserId, document.FirstName, document.LastName, document.CreatedAt, document.Courses.Select(course => new ParticipationInCourse( course.Id, course.CourseId, new Progress(course.Progress.Value))));
public ActionResult Edit([Bind(Include = "Id,Name,Description,UploadDate,ActivityId,FileName,ContentLength,ContentType")] StudentDocument studentDocument) { if (ModelState.IsValid) { db.Entry(studentDocument).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ActivityId = new SelectList(db.Activities, "Id", "Name", studentDocument.ActivityId); return(View(studentDocument)); }
// POST: odata/StudentDocuments public async Task <IHttpActionResult> Post(StudentDocument studentDocument) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.StudentDocuments.Add(studentDocument); await db.SaveChangesAsync(); return(Created(studentDocument)); }
// DELETE: odata/StudentDocuments(5) public async Task <IHttpActionResult> Delete([FromODataUri] short key) { StudentDocument studentDocument = await db.StudentDocuments.FindAsync(key); if (studentDocument == null) { return(NotFound()); } db.StudentDocuments.Remove(studentDocument); await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }
// GET: StudentDocuments/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentDocument studentDocument = db.StudentDocuments.Find(id); if (studentDocument == null) { return(HttpNotFound()); } return(View(studentDocument)); }
public IHttpActionResult AddDocument(StudentDocumentUpload data) { var student = _context.Students.SingleOrDefault(x => x.Id == data.Student); if (student == null) { return(Content(HttpStatusCode.NotFound, "Student not found")); } var document = data.Document; var currentUserId = User.Identity.GetUserId(); var uploader = _context.Staff.Single(x => x.UserId == currentUserId); if (uploader == null) { return(Content(HttpStatusCode.BadRequest, "Uploader not found")); } document.UploaderId = uploader.Id; document.IsGeneral = false; document.Approved = true; document.Date = DateTime.Now; var isUriValid = Uri.TryCreate(document.Url, UriKind.Absolute, out var uriResult) && (uriResult.Scheme == Uri.UriSchemeHttp || uriResult.Scheme == Uri.UriSchemeHttps); if (!isUriValid) { return(Content(HttpStatusCode.BadRequest, "The URL entered is not valid")); } _context.Documents.Add(document); _context.SaveChanges(); var studentDocument = new StudentDocument { DocumentId = document.Id, StudentId = data.Student }; _context.StudentDocuments.Add(studentDocument); _context.SaveChanges(); return(Ok("Document added")); }
// GET: StudentDocuments/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentDocument studentDocument = db.StudentDocuments.Find(id); if (studentDocument == null) { return(HttpNotFound()); } ViewBag.ActivityId = new SelectList(db.Activities, "Id", "Name", studentDocument.ActivityId); return(View(studentDocument)); }
private void OnStudentChanged(object sender, RecordChangedEventArgs <StudentDocument> e) { StudentDocument changedEntity = e.Entity; Logger.Debug($"Change detected:{changedEntity.StudentId}"); try { redisService.AddToSet(changedEntity.StudentId, "StudentDocument"); } catch (Exception ex) { Logger.Error(ex, "Can't handle changes for students"); } }
public static StudentDto AsDto(this StudentDocument document) => new StudentDto { UserId = document.UserId, FirstName = document.FirstName, LastName = document.LastName, Courses = document.Courses.Select(course => new ParticipationInCourseDto { Id = course.Id, CourseId = course.CourseId, Progress = new ProgressDto { Value = course.Progress.Value } }), CreatedAt = document.CreatedAt };
public ActionResult Create([Bind(Include = "Id,Name,Description,ActivityId,FileName,ContentLength,ContentType")] StudentDocument studentDocument, HttpPostedFileBase fileName) { studentDocument.UploadDate = DateTime.Now; studentDocument.ApplicationUserId = User.Identity.GetUserId(); if (ModelState.IsValid) { try { if (fileName.ContentLength > 0) { string _FileName = Path.GetFileName(fileName.FileName); string localPath = "~/UploadedFiles"; studentDocument.Activity = db.Activities.Find(studentDocument.ActivityId); studentDocument.ApplicationUser = db.Users.Find(studentDocument.ApplicationUserId); localPath += "/Course_" + studentDocument.Activity.Module.CourseId + "/Module_" + studentDocument.Activity.ModuleId + "/Activity_" + studentDocument.ActivityId + "/" + User.Identity.GetUserName(); if (!Directory.Exists(Server.MapPath(localPath))) { Directory.CreateDirectory(Server.MapPath(localPath)); } string _path = Path.Combine(Server.MapPath(localPath), _FileName); studentDocument.ContentLength = fileName.ContentLength; studentDocument.FileName = fileName.FileName; studentDocument.ContentType = fileName.ContentType; studentDocument.ApplicationUserId = User.Identity.Name; fileName.SaveAs(_path); } db.StudentDocuments.Add(studentDocument); db.SaveChanges(); ViewBag.Message = "Filen: " + fileName.FileName + " är nu uppladdad!!"; return(RedirectToAction("Index")); } catch { ViewBag.Message = "Kunde inte ladda upp filen!!"; } return(RedirectToAction("Create")); } //ViewBag.ActivityId = new SelectList(db.Activities, "Id", "Name", studentDocument.ActivityId); return(View(studentDocument)); }
public ActionResult Download(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentDocument studentDocument = db.StudentDocuments.Find(id); if (studentDocument == null) { return(HttpNotFound()); } string _FileName = Path.GetFileName(studentDocument.FileName); string localPath = "~/UploadedFiles"; localPath += "/Course_" + studentDocument.Activity.Module.CourseId + "/Module_" + studentDocument.Activity.ModuleId + "/Activity_" + studentDocument.ActivityId + "/" + studentDocument.ApplicationUser.UserName; string _path = Path.Combine(Server.MapPath(localPath), _FileName); return(new FilePathResult(_path, studentDocument.ContentType)); }
public async Task <IActionResult> OnPostNewDocAsync(int id) { if (ModelState.IsValid) { ApplicationUser UpUser = await UserManager.FindByIdAsync(UserManager.GetUserId(User)); var student = await Context.Student.FirstOrDefaultAsync( m => m.StudentId == id); var ext = Path.GetExtension(StudentDocument.Document.FileName); var docType = await Context.DocumentType.Where(d => d.Id == StudentDocument.DocumentTypeId).FirstOrDefaultAsync(); var SD = new StudentDocument { DocumentTypeId = StudentDocument.DocumentTypeId, UploadDT = DateTime.Now, UploadUser = UpUser, Student = student, FileName = student.FirstName + "_" + student.LastName + "-" + docType.Name + "-" + DateTime.Now.ToString("yyyy-dd-M-HH-mm-ss") + ext, ContentType = StudentDocument.Document.ContentType }; using (var memoryStream = new MemoryStream()) { await StudentDocument.Document.CopyToAsync(memoryStream); SD.Document = memoryStream.ToArray(); } Context.Add(SD); await Context.SaveChangesAsync(); return(RedirectToPage("./Details", new { id })); } return(RedirectToPage("./Details", new { id })); }
// PUT: odata/StudentDocuments(5) public async Task <IHttpActionResult> Put([FromODataUri] short key, Delta <StudentDocument> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } StudentDocument studentDocument = await db.StudentDocuments.FindAsync(key); if (studentDocument == null) { return(NotFound()); } patch.Put(studentDocument); try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentDocumentExists(key)) { return(NotFound()); } else { throw; } } return(Updated(studentDocument)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { //************************************************************************************* // checking user input of Resume file or text content var validResumeSwitch = ""; lblResumeFileName.Text = ""; if ((ResumeUpload.HasFile) && (txtResumeFormContent.Text.Trim().Length == 0)) // Only resume file was entered { string fileExt = System.IO.Path.GetExtension(ResumeUpload.FileName); //doc|.docx|.DOC|.DOCX|.txt|.TXT|.pdf|.PDF)" if (fileExt == ".doc" || fileExt == ".docx" || fileExt == ".DOC" || fileExt == ".DOCX" || fileExt == ".txt" || fileExt == ".TXT" || fileExt == ".pdf" || fileExt == ".PDF") { //swict for uploading resume file // set a switch for upload validResumeSwitch = "1"; // lblResumeFileName.Text = "Uploaded Resume File name: " + // ResumeUpload.PostedFile.FileName + "<br>" + // ResumeUpload.PostedFile.ContentLength + " kb<br>" + // "Content type: " + // ResumeUpload.PostedFile.ContentType; } else { lblResumeFileName.Text = "Please use one of the correct formats allowed: .docx, .doc, .txt, or .pdf"; } } else if ((ResumeUpload.HasFile == false) && (txtResumeFormContent.Text.Trim().Length > 0) && (!string.IsNullOrEmpty(txtResumeFormContent.Text))) // only resume form content was entered //resume form content // student.InternshipRequirement.FileUpload.Resume = txtResumeFormContent.Text; // set a switch for Resume upload { validResumeSwitch = "1"; // lblResumeFileName.Text = "form content text uploaded" + // txtResumeFormContent.Text.Length + " kb<br>"; } else if ((ResumeUpload.HasFile == false) && (txtResumeFormContent.Text.Trim().Length == 0)) { lblResumeFileName.Text = "Please attach resume in .docx, .doc, .txt, or .pdf format."; } else if ((ResumeUpload.HasFile == true) && (txtResumeFormContent.Text.Trim().Length > 0)) { // lblResumeFileName.Text = "Please use one, the resume file, or the textarea, but not both."; string fileExt = System.IO.Path.GetExtension(ResumeUpload.FileName); //doc|.docx|.DOC|.DOCX|.txt|.TXT|.pdf|.PDF)" if (fileExt == ".doc" || fileExt == ".docx" || fileExt == ".DOC" || fileExt == ".DOCX" || fileExt == ".txt" || fileExt == ".TXT" || fileExt == ".pdf" || fileExt == ".PDF") { //swict for uploading resume file // set a switch for upload validResumeSwitch = "1"; // lblResumeFileName.Text = "Uploaded Resume File name: " + // ResumeUpload.PostedFile.FileName + "<br>" + // ResumeUpload.PostedFile.ContentLength + " kb<br>" + // "Content type: " + // ResumeUpload.PostedFile.ContentType; } else { lblResumeFileName.Text = "Please use one of the correct formats allowed: .docx, .doc, .txt, or .pdf"; } } else { // empty lblResumeFileName.Text = ""; }; // end of else //************************************************************************************* // checking user input of Transcript file or text content var validTranscriptSwitch = ""; lblTranscriptFileName.Text = ""; if ((TranscriptUpload.HasFile) && (txtTranscriptFormContent.Text.Trim().Length == 0)) // Only transcript file was entered { string fileExt = System.IO.Path.GetExtension(TranscriptUpload.FileName); //doc|.docx|.DOC|.DOCX|.txt|.TXT|.pdf|.PDF)" if (fileExt == ".doc" || fileExt == ".docx" || fileExt == ".DOC" || fileExt == ".DOCX" || fileExt == ".txt" || fileExt == ".TXT" || fileExt == ".pdf" || fileExt == ".PDF") { // switch for uploading Transcript file // set a switch for Transcript upload validTranscriptSwitch = "1"; // lblTranscriptFileName.Text = "Uploaded Transcript File name: " + // TranscriptUpload.PostedFile.FileName + "<br>" + // TranscriptUpload.PostedFile.ContentLength + " kb<br>" + // "Content type: " + // TranscriptUpload.PostedFile.ContentType; } else { lblTranscriptFileName.Text = "Please use one of the correct formats allowed: .docx, .doc, .txt, or .pdf"; } } else if ((TranscriptUpload.HasFile == false) && (txtTranscriptFormContent.Text.Trim().Length > 0) && (!string.IsNullOrEmpty(txtTranscriptFormContent.Text))) // only Transcript form content was entered //Transcript form content // student.InternshipRequirement.FileUpload.Transcript = txtTranscriptFormContent.Text; // set a switch for upload { validTranscriptSwitch = "1"; // lblTranscriptFileName.Text = "trnascript form content text uploaded" + // txtTranscriptFormContent.Text.Length + " kb<br>"; } else if ((TranscriptUpload.HasFile == false) && (txtTranscriptFormContent.Text.Trim().Length == 0)) { lblTranscriptFileName.Text = "Please attach transcript in .docx, .doc, .txt, or .pdf format."; } else if ((TranscriptUpload.HasFile == true) && (txtTranscriptFormContent.Text.Trim().Length > 0) && (!string.IsNullOrEmpty(txtTranscriptFormContent.Text))) { //lblTranscriptFileName.Text = "Please use one, the transcript file, or the textarea, but not both."; string fileExt = System.IO.Path.GetExtension(TranscriptUpload.FileName); //doc|.docx|.DOC|.DOCX|.txt|.TXT|.pdf|.PDF)" if (fileExt == ".doc" || fileExt == ".docx" || fileExt == ".DOC" || fileExt == ".DOCX" || fileExt == ".txt" || fileExt == ".TXT" || fileExt == ".pdf" || fileExt == ".PDF") { // switch for uploading Transcript file // set a switch for Transcript upload validTranscriptSwitch = "1"; // lblTranscriptFileName.Text = "Uploaded Transcript File name: " + // TranscriptUpload.PostedFile.FileName + "<br>" + // TranscriptUpload.PostedFile.ContentLength + " kb<br>" + // "Content type: " + // TranscriptUpload.PostedFile.ContentType; } else { lblTranscriptFileName.Text = "Please use one of the correct formats allowed: .docx, .doc, .txt, or .pdf"; } } else { // empty lblTranscriptFileName.Text = ""; }; // end of else //************************************************************************************* //************************************************************************************* // checking validation switches to see if both resume and transcript are input to load if ((validResumeSwitch == "1") && (validTranscriptSwitch == "1")) { if (ResumeUpload.HasFile == true) { lblResumeFileName.Text = "Uploaded Resume File name: " + ResumeUpload.PostedFile.FileName + " " + ResumeUpload.PostedFile.ContentLength + " kb "; // + "Content type: " + // ResumeUpload.PostedFile.ContentType; } else if (txtResumeFormContent.Text.Trim().Length > 0) { lblResumeFileName.Text = "Resume form content text uploaded " + txtResumeFormContent.Text.Length + " kb"; } ; if (txtResumeFormContent.Text.Trim().Length > 0) { // Encode the string input StringBuilder sb = new StringBuilder(HttpUtility.HtmlEncode(txtResumeFormContent.Text)); sb.Replace("&", "&"); // ampersand sb.Replace("<", "<"); // lessthan sb.Replace(">", ">"); // greaterthan sb.Replace("'", "'"); // apostrophe sb.Replace("\"", """); // double apostrophe txtResumeFormContent.Text = sb.ToString(); } ; if (TranscriptUpload.HasFile == true) { lblTranscriptFileName.Text = "Uploaded Transcript File name: " + TranscriptUpload.PostedFile.FileName + " " + TranscriptUpload.PostedFile.ContentLength + " kb "; // + "Content type: " + // TranscriptUpload.PostedFile.ContentType; } else if (txtTranscriptFormContent.Text.Trim().Length > 0) { lblTranscriptFileName.Text = "Transcript form content text uploaded " + txtTranscriptFormContent.Text.Length + " kb"; } ; if (txtTranscriptFormContent.Text.Trim().Length > 0) { // Encode the string input StringBuilder sb = new StringBuilder(HttpUtility.HtmlEncode(txtTranscriptFormContent.Text)); sb.Replace("&", "&"); // ampersand sb.Replace("<", "<"); // lessthan sb.Replace(">", ">"); // greaterthan sb.Replace("'", "'"); // apostrophe sb.Replace("\"", """); // double apostrophe txtTranscriptFormContent.Text = sb.ToString(); } ; // end of if stmt } // checking validation switches to see if both resume and transcript are input to load if ((validResumeSwitch == "1") && (validTranscriptSwitch == "1")) { if (ResumeUpload.HasFile) { var resume = new StudentDocument() { FileName = ResumeUpload.FileName, FileExt = "." + ResumeUpload.FileName.Split('.')[1], StudentID = student.StudentID, docType = ITMS.BusinessObjects.DocumentType.Resume, File = ResumeUpload.FileBytes }; resume.Save(); } // end of ((validResumeSwitch == "1") && (validTranscriptSwitch == "1")) // checking validation switches to see if both resume and transcript are input to load if ((validResumeSwitch == "1") && (validTranscriptSwitch == "1")) { if (TranscriptUpload.HasFile) { var transcript = new StudentDocument() { FileName = TranscriptUpload.FileName, FileExt = "." + TranscriptUpload.FileName.Split('.')[1], StudentID = student.StudentID, docType = ITMS.BusinessObjects.DocumentType.Transcript, File = TranscriptUpload.FileBytes }; transcript.Save(); } } ; // end of ((validResumeSwitch == "1") && (validTranscriptSwitch == "1")) } // end of try //-- Dioscar start-- //--skills section-- //var StudentID = "9874"; //temporary ID //var student = Student.Load(StudentID); var i = 0; //loop through each check box and set properties lblTestingErrors.Text = "<p>Selected Item(s):</p>"; for (i = 0; i < chkNetworking.Items.Count; i++) { if (chkNetworking.Items[i].Selected == true) { switch (chkNetworking.Items[i].Value) { case "1": student.InternshipRequirement.studentContent.CiscoRouter = chkNetworking.Items[i].Value; break; case "2": student.InternshipRequirement.studentContent.WAN = chkNetworking.Items[i].Value; break; case "3": student.InternshipRequirement.studentContent.TCPIP = chkNetworking.Items[i].Value; break; } } } for (i = 0; i < chkSecurity.Items.Count; i++) { if (chkSecurity.Items[i].Selected == true) { switch (chkSecurity.Items[i].Value) { case "4": student.InternshipRequirement.studentContent.Data = chkSecurity.Items[i].Value; break; case "5": student.InternshipRequirement.studentContent.Network = chkSecurity.Items[i].Value; break; } } } for (i = 0; i < chkProgramming.Items.Count; i++) { if (chkProgramming.Items[i].Selected == true) { switch (chkProgramming.Items[i].Value) { case "6": student.InternshipRequirement.studentContent.Java = chkProgramming.Items[i].Value; break; case "7": student.InternshipRequirement.studentContent.Csharp = chkProgramming.Items[i].Value; break; case "8": student.InternshipRequirement.studentContent.VBNET = chkProgramming.Items[i].Value; break; case "9": student.InternshipRequirement.studentContent.CplusPlus = chkProgramming.Items[i].Value; break; case "10": student.InternshipRequirement.studentContent.PHP = chkProgramming.Items[i].Value; break; case "11": student.InternshipRequirement.studentContent.ASPNET = chkProgramming.Items[i].Value; break; } } } for (i = 0; i < chkDatabase.Items.Count; i++) { if (chkDatabase.Items[i].Selected == true) { switch (chkDatabase.Items[i].Value) { case "12": student.InternshipRequirement.studentContent.SQL = chkDatabase.Items[i].Value; break; case "13": student.InternshipRequirement.studentContent.Oracle = chkDatabase.Items[i].Value; break; case "14": student.InternshipRequirement.studentContent.PMySQL = chkDatabase.Items[i].Value; break; } } } student.InternshipRequirement.studentContent.proInsert(student.StudentID); data_insert(student.StudentID); var ObjFileUpload = student.InternshipRequirement.studentContent.LoadItAll(student.StudentID); } catch (ApplicationException e3) { lblTestingErrors.Text = e3.Message; } catch (NotSupportedException e2) { lblTestingErrors.Text = e2.Message; } catch (Exception e1) { lblTestingErrors.Text = e1.Message; } }