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