private void LoadFileResource() { using (var helper = new DbHelper.ActAndRes()) { var files = new List <FileResourceEventArgs>(); var fileR = helper.GetFileResource(FileResourceId); if (fileR != null) { txtName.Text = fileR.Name; CKEditor1.Text = fileR.Description; chkDisplayDescription.Checked = fileR.ShowDescriptionOnCoursePage; chkShowSize.Checked = fileR.ShowSize; chkShowType.Checked = fileR.ShowType; chkShowUploadModifiedDate.Checked = fileR.ShowUploadModifiedDate; ddlDisplay.SelectedIndex = fileR.Display; var i = 1; foreach (var f in fileR.FileResourceFiles) { files.Add(new FileResourceEventArgs() { Id = f.SubFileId, Visible = true, FileType = f.SubFile.FileType, IconPath = f.SubFile.IconPath, FilePath = f.SubFile.FileDirectory + "/" + f.SubFile.FileName, FileDisplayName = f.SubFile.DisplayName, FileSizeInBytes = f.SubFile.FileSizeInBytes , LocalId = i.ToString() }); i++; } FilesDisplay1.SetInitialValues(files); RestrictionUC.SetActivityResource(false, ((int)Enums.Resources.File) + 1, fileR.Id); } } }
protected void btnSave_Click(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { var file = new Academic.DbEntities.ActivityAndResource.FileResource() { Id = FileResourceId, Name = txtName.Text , Description = CKEditor1.Text , //Display = (byte)ddlDisplay.SelectedIndex //, ShowSize = chkShowSize.Checked , ShowType = chkShowType.Checked , ShowUploadModifiedDate = chkShowUploadModifiedDate.Checked , ShowDescriptionOnCoursePage = chkDisplayDescription.Checked , }; if (ddlDisplay.SelectedIndex == 0) { file.Display = 2; } else { file.Display = 4; } //files var list = new List <Academic.DbEntities.Subjects.SubjectFile>(); var files = FilesDisplay1.GetFiles(); if (files != null) { foreach (var f in files) { var fileName = Path.GetFileName(f.FilePath); var fi = new Academic.DbEntities.Subjects.SubjectFile() { Id = f.Id, CreatedBy = user.Id , CreatedDate = DateTime.Now , DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory , FileName = fileName //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength , FileType = f.FileType //imageFile.ContentType , IconPath = f.IconPath , SubjectId = SubjectId , Void = !f.Visible }; list.Add(fi); } } var restriction = RestrictionUC.GetRestriction(); if (!RestrictionUC.IsValid) { return; } using (var helper = new DbHelper.ActAndRes()) { var saved = helper.AddOrUpdateFileResource(file, list, SectionId, restriction); if (saved != null) { Response.Redirect(DbHelper.StaticValues.WebPagePath.CourseDetailPage(SubjectId, SectionId)); //Response.Redirect("~/Views/Course/Section/Master/CourseSectionListing.aspx?SubId=" + SubjectId + "&edit=1#section_" + SectionId); } } } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { var date = DateTime.Now; var submission = new Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissions() { Id = SubmissionId , AssignmentId = AssignmentId , UserClassId = UserClassId }; if (pnlText.Visible) { submission.SubmissionText = CKEditor1.Text; } if (SubmissionId > 0) { submission.ModifiedDate = date; } else { submission.SubmittedDate = date; } #region Files var list = new List <Academic.DbEntities.UserFile>(); if (pnlFileSubmit.Visible) { var files = FilesDisplay1.GetFiles(); if (files != null) { foreach (var f in files) { var fileName = Path.GetFileName(f.FilePath); var fi = new Academic.DbEntities.UserFile() { Id = f.Id, CreatedBy = user.Id , CreatedDate = DateTime.Now , DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory , FileName = fileName //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength , FileType = f.FileType //imageFile.ContentType , IconPath = f.IconPath //, //SubjectId = SubjectId , Void = !f.Visible }; list.Add(fi); } } // var files = FilesDisplay1.GetFiles(); // var filelist = new List<Academic.DbEntities.UserFile>(); // //var files = FilesDisplay1.GetFiles(); // if (files != null) // { // var sublist = new // List<Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissionFiles>(); // foreach (var f in files) // { // var subFile = new Academic.DbEntities.ActivityAndResource.AssignmentItems.AssignmentSubmissionFiles() // { // AssignmentSubmissionsId = SubmissionId // ,FileSubmittedDate = date // }; // var fileName = Path.GetFileName(f.FilePath); // var fi = new Academic.DbEntities.UserFile() // { // CreatedBy = user.Id // , // CreatedDate = date // , // DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName) // , // FileDirectory = DbHelper.StaticValues.CourseFilesLocation //StaticValue.UserImageDirectory // , // FileName = fileName // //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) // , // FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength // , // FileType = f.FileType //imageFile.ContentType // , // IconPath = f.IconPath // , // Id = f.Id // , // //SubjectId = SubjectId // }; // filelist.Add(fi); // } // } } #endregion using (var helper = new DbHelper.Assignments()) { var saved = helper.AddOrUpdateAssignmentSubmission(submission, list); if (saved != null) { Response.Redirect("~/Views/ActivityResource/Assignments/AssignmentView.aspx?SubId=" + SubjectId + "&arId=" + AssignmentId + "&secId=" + SectionId ); } else { lblError.Visible = true; } } } }
void LoadActivity(int assignmentId) { using (var helper = new DbHelper.ActAndRes()) { var ass = helper.GetAssignment(assignmentId); if (ass != null) { var submission = ass.Submissions.FirstOrDefault(x => x.UserClassId == UserClassId); if (submission != null) { var files = new List <FileResourceEventArgs>(); SubmissionId = submission.Id; if (ass.OnlineText) { CKEditor1.Text = submission.SubmissionText; } if (ass.FileSubmission) { FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0; var i = 1; foreach (var f in submission.AssignmentSubmissionFiles) { files.Add(new FileResourceEventArgs() { Id = f.UserFileId, Visible = true, FileType = f.UserFile.FileType, IconPath = f.UserFile.IconPath, FilePath = f.UserFile.FileDirectory + "/" + f.UserFile.FileName, FileDisplayName = f.UserFile.DisplayName, FileSizeInBytes = f.UserFile.FileSizeInBytes , LocalId = i.ToString() }); i++; } FilesDisplay1.SetInitialValues(files); } } AssignmentId = assignmentId; lblName.Text = ass.Name; lblDescription.Text = ass.Description; if (ass.FileSubmission || ass.OnlineText) { if (ass.FileSubmission) { pnlFileSubmit.Visible = true; lblFileLimit.Text = "(File Limit : " + (ass.MaximumNoOfUploadedFiles ?? 0) + " files, " + " Maximum size per file: " + (ass.MaximumSubmissionSize ?? 0) + "KB)"; //FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0; } else { pnlFileSubmit.Visible = false; pnlFileSubmit.Controls.Clear(); } if (ass.OnlineText) { //lblScript.Text = WordLimitScript(ass.WordLimit ?? 0); lblWordLimit.Text = "(Word Limit : " + (ass.WordLimit ?? 0) + " words)"; pnlText.Visible = true; } else { pnlText.Visible = false; pnlText.Controls.Clear(); } } else { btnSubmit.Visible = false; } } } }
private void PopulateSchoolInfo(CustomPrincipal user) { using (var helper = new DbHelper.Office()) { var sch = helper.GetSchoolOfUser(user.Id); if (sch != null) { CKEditor1.Text = sch.Description; hidSchoolId.Value = sch.Id.ToString(); txtAddress.Text = sch.Address; txtName.Text = sch.Name; txtEmailGeneral.Text = sch.EmailGeneral; //txtEmailMarketing.Text = sch.EmailMarketing; //txtEmailSupport.Text = sch.EmailSupport; txtPhoneMain.Text = sch.PhoneMain; //txtPhoneAfterHours.Text = sch.PhoneAfterHours; hidImageId.Value = sch.ImageId.ToString(); //txtStreet.Text = sch.Street; txtWeb.Text = sch.Website; hidUserId.Value = sch.UserId.ToString(); //cmbSchoolType.SelectedValue = sch.SchoolTypeId.ToString(); var f = helper.GetSchoolImage(sch.ImageId); if (f != null) { //var fileName = Path.GetFileName(f.FilePath); var image = new FileResourceEventArgs() { Id = f.Id, //CreatedBy = user.Id //, //CreatedDate = DateTime.Now //, FileDisplayName = f.DisplayName //Path.GetFileName(imageFile.FileName) //, // FileDirectory = DbHelper.StaticValues.SchoolFileLocation //StaticValue.UserImageDirectory // , //FileName = fileName , FilePath = DbHelper.StaticValues.SchoolFileLocation + f.FileName //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength , FileType = f.FileType //imageFile.ContentType , IconPath = f.IconPath , //SubjectId = SubjectId }; FilesDisplay1.SetInitialValues(new List <FileResourceEventArgs>() { image }); } } if (SiteMap.CurrentNode != null) { var list = new List <IdAndName>() { new IdAndName() { Name = SiteMap.RootNode.Title , Value = SiteMap.RootNode.Url , Void = true }, new IdAndName() { Name = sch == null?SiteMap.CurrentNode.ParentNode.Title:sch.Name , Value = SiteMap.CurrentNode.ParentNode.Url , Void = true }, new IdAndName() { Name = "Edit" } }; SiteMapUc.SetData(list); } } }
//private void PopulateCountry() //{ // List<string> countries = new List<string>(); // var getCultureInfo = CultureInfo.GetCultures(CultureTypes.SpecificCultures); // foreach (var c in getCultureInfo) // { // var getRegionInfo = // new RegionInfo(c.LCID); // var name = getRegionInfo.EnglishName.Split(new char[] { '(' })[0]; // if (!countries.Contains(name)) // { // countries.Add(name); // } // } // countries.Sort(); // var i = 0; // try // { // i = countries.IndexOf("Nepal"); // } // catch // { // } // if (i != 0) // countries.Insert(0, "Select"); // ddlCountry.DataSource = countries; // ddlCountry.DataBind(); // ddlCountry.SelectedIndex = i; //} protected void btnSave_Click(object sender, EventArgs e) { //if (cmbSchoolType.SelectedValue == "" || cmbSchoolType.SelectedValue == "0") //{ // valiSchType.IsValid = false; //} //if (ddlCountry.SelectedIndex == 0) // valiCountry.IsValid = false; if (IsValid) { var user = User as CustomPrincipal; if (user == null) { return; } var school = new Academic.DbEntities.Office.School() { Id = user.SchoolId, Name = txtName.Text, Address = txtAddress.Text, EmailGeneral = txtEmailGeneral.Text, EmailMarketing = "", //txtEmailMarketing.Text, EmailSupport = "", //txtEmailSupport.Text, IsActive = chkActive.Checked, PhoneMain = txtPhoneMain.Text, PhoneAfterHours = "", //txtPhoneAfterHours.Text, Description = CKEditor1.Text, //SchoolTypeId = Convert.ToInt32(cmbSchoolType.Text), Website = txtWeb.Text, CreatedDate = DateTime.Now, ImageId = Convert.ToInt32(hidImageId.Value) }; if (user.SchoolId <= 0) { school.UserId = user.Id; } using (var helper = new DbHelper.Office()) { var files = FilesDisplay1.GetFiles(); var image = new UserFile(); if (files != null) { if (files.Count >= 1) { var f = files[0]; //foreach (var f in files) { var fileName = Path.GetFileName(f.FilePath); image = new Academic.DbEntities.UserFile() { Id = f.Id, CreatedBy = user.Id , CreatedDate = DateTime.Now , DisplayName = f.FileDisplayName //Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.SchoolFileLocation //StaticValue.UserImageDirectory , FileName = fileName //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = f.FileSizeInBytes //imageFile.ContentLength , FileType = f.FileType //imageFile.ContentType , IconPath = f.IconPath , //SubjectId = SubjectId }; if (f.Id > 0) { image.ModifiedBy = user.Id; image.ModifiedDate = DateTime.Now; } } } } var saved = helper.AddOrUpdateSchool(school, image);//FileUpload1.PostedFile //update cookie -- add school Id to the cookie //Page.User.Identity.Name; if (saved != null) { if (user.SchoolId <= 0) { var ok = UpdateSchoolInfoInCookie(user, saved.Id); if (ok) { Response.Redirect("~/ViewsSite/User/Dashboard/Dashboard.aspx"); } else { lblMsg.Text = "Error while saving."; } //---not needed, since redirect is done above //SchoolTypeUC.SavedId = 0; //lblMsg.Visible = true; //lblMsg.Text = "Save Successful."; } else { Response.Redirect("~/About.aspx"); //"//~/Views/Office/"); } } else { lblMsg.Text = "Error while saving."; } } } else { lblMsg.Text = "Some fields are invalid or not filled."; } }
private void LoadSubmission() { using (var helper = new DbHelper.ActAndRes()) { var userClassId = UserClassId; var actres = helper.GetActivityResource(ActivityResourceId); if (actres != null) { var grd = (actres.ActivityGradings.FirstOrDefault(x => x.UserClassId == userClassId)); var ass = helper.GetAssignment(ActivityId); if (ass != null) { var sub = ass.Submissions.FirstOrDefault(x => x.UserClassId == userClassId); lblName.Text = ass.Name; lblDescription.Text = ass.Description; if (sub != null) { if (ass.FileSubmission) { var files = new List <FileResourceEventArgs>(); FilesDisplay1.NumberOfFilesToUpload = ass.MaximumNoOfUploadedFiles ?? 0; var i = 1; foreach (var f in sub.AssignmentSubmissionFiles) { files.Add(new FileResourceEventArgs() { Id = f.UserFileId, Visible = true, FileType = f.UserFile.FileType, IconPath = f.UserFile.IconPath, FilePath = f.UserFile.FileDirectory + "/" + f.UserFile.FileName, FileDisplayName = f.UserFile.DisplayName, FileSizeInBytes = f.UserFile.FileSizeInBytes , LocalId = i.ToString() }); i++; } FilesDisplay1.SetInitialValues(files); } if (grd != null) { var user = grd.UserClass.User; lblStudentName.Text = user.FirstName + (string.IsNullOrEmpty(user.MiddleName)? "": " " + user.MiddleName) + (string.IsNullOrEmpty(user.LastName) ? "" : " " + user.LastName); lblEmail.Text = user.Email; lblClassName.Text = grd.UserClass.SubjectClass.GetName; var std = user.Student.FirstOrDefault(); if (std != null) { lblRoll.Text = std.CRN; } txtRemarks.Text = grd.Remarks; } else { using (var clsHelper = new DbHelper.Classes()) { var uc = clsHelper.GetUserClass(userClassId); if (uc != null) { var user = uc.User; lblStudentName.Text = user.FirstName + (string.IsNullOrEmpty(user.MiddleName) ? "" : " " + user.MiddleName) + (string.IsNullOrEmpty(user.LastName) ? "" : " " + user.LastName); lblEmail.Text = user.Email; lblClassName.Text = uc.SubjectClass.GetName; var std = user.Student.FirstOrDefault(); if (std != null) { lblRoll.Text = std.CRN; } } else { Response.Redirect("~/Views/All_Resusable_Codes/Error/ErrorPage.aspx"); } } } if (ass.OnlineText) { pnlText.Visible = true; txtSubmittedText.Text = sub.SubmissionText; lblWordLimit.Text = "(Word limit : " + (ass.WordLimit ?? 0) + " words)"; } if (ass.FileSubmission) { pnlFileSubmit.Visible = true; lblFileLimit.Text = "(Maximum No. of files allowed : " + (ass.MaximumNoOfUploadedFiles ?? 0) + ", Maximum file size : " + (ass.MaximumSubmissionSize ?? 0) + "KB)"; //each file load } if (ass.GradeType.RangeOrValue) //value { var values = ass.GradeType.GradeValues.ToList(); ddlGrade.Visible = true; var lst = new List <Academic.DbEntities.Grades.GradeValue>(); var maxid = 0; try { maxid = Convert.ToInt32(ass.MaximumGrade); } catch { } var max = values.FirstOrDefault(x => x.Id == maxid); if (max != null) { lblMaximumGrade.Text = max.Value; foreach (var gv in ass.GradeType.GradeValues) { if ((gv.EquivalentPercentOrPostition ?? 0).CompareTo( (max.EquivalentPercentOrPostition ?? 0)) <= 0) { lst.Add(gv); } } } var minid = 0; try { minid = Convert.ToInt32(ass.GradeToPass); } catch { } var min = values.FirstOrDefault(x => x.Id == minid); if (min != null) { lblMinimumGradeToPass.Text = min.Value; } ddlGrade.DataSource = lst; ddlGrade.DataBind(); if (grd != null) { try { if ((grd.ObtainedGradeId ?? 0) > 0) { ddlGrade.SelectedValue = (grd.ObtainedGradeId ?? 0).ToString(); } } catch { } } } else//range { txtGrade.Visible = true; lblMaximumGrade.Text = ass.MaximumGrade; lblMinimumGradeToPass.Text = ass.GradeToPass; if (grd != null) { txtGrade.Text = (grd.ObtainedGradeMarks ?? 0).ToString("F"); } } } } } } }