protected void btnOkay_OnClick(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { if (string.IsNullOrEmpty(txtNewFolder.Text)) { return; } using (var helper = new DbHelper.WorkingWithFiles()) { var folder = new Academic.DbEntities.UserFile() { Id = FolderId , DisplayName = txtNewFolder.Text , FileType = "Folder" , CreatedBy = user.Id , CreatedDate = DateTime.Now , IsFolder = true , FileSizeInBytes = 0 , IsServerFile = IsServerFile , SchoolId = user.SchoolId }; if (ParentFolderId > 0) { folder.FolderId = ParentFolderId; } var saved = helper.AddOrUpdateFolder(folder); txtNewFolder.Text = ""; if (SaveEvent != null) { if (saved != null) { SaveEvent(this, new MessageEventArgs() { SaveSuccess = true, SavedId = saved.Id, SavedName = saved.DisplayName }); } else { SaveEvent(this, new MessageEventArgs() { SaveSuccess = false }); } } } } }
void FilePickerDialog1_UploadClicked(object sender, Academic.ViewModel.FileResourceEventArgs e) { //save file information to database var user = Page.User as CustomPrincipal; if (user != null) { using (var helper = new DbHelper.WorkingWithFiles()) { var fileName = Path.GetFileName(e.FilePath); var fi = new Academic.DbEntities.UserFile() { Id = e.Id, CreatedBy = user.Id , CreatedDate = DateTime.Now , DisplayName = e.FileDisplayName //Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.PrivateFiesLocation //CourseFilesLocation //StaticValue.UserImageDirectory , FileName = fileName //Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = e.FileSizeInBytes //imageFile.ContentLength , FileType = e.FileType //imageFile.ContentType , IconPath = e.IconPath , IsFolder = false , IsServerFile = IsServerFile , SchoolId = user.SchoolId //SubjectId = SubjectId //, //Void = !f.Visible }; var folderId = FolderId; if (folderId > 0) { fi.FolderId = folderId; } var saved = helper.AddOrUpdateFile(fi); if (saved != null) { //Response.Redirect("~/Views/Course/Section/Master/CourseSectionListing.aspx?SubId=" + SubjectId + "&edit=1#section_" + SectionId); FilePickerDialog1.CloseDialog(); FileListingUc1.ResetView(); } } } }
public string GetImageUrl(object imageId) { if (imageId != null) { var id = Convert.ToInt32(imageId.ToString()); using (var helper = new DbHelper.WorkingWithFiles()) { return(helper.GetImageUrl(id)); } } return(""); }
protected void btnDialogOk_Click(object sender, EventArgs e) { using (var helper = new DbHelper.WorkingWithFiles()) { var saved = helper.DeleteFile(FileId); dialogdiv.Visible = false; if (OkClick != null) { OkClick(sender, new IdAndNameEventArgs()); } } }
private void TrimFirstLetterFromImageFileName(DbHelper.WorkingWithFiles fhelper, Academic.DbEntities.UserFile image) { if (trimLoop < 10) { if (!char.IsLetterOrDigit(image.FileName[0])) { image.FileName = image.FileName.Substring(1); TrimFirstLetterFromImageFileName(fhelper, image); GetNewGuid(fhelper, image); } trimLoop++; } }
private void GetNewGuid(DbHelper.WorkingWithFiles fhelper, Academic.DbEntities.UserFile image) { //var existingFile = Context.File.FirstOrDefault(x => x.FileName == image.FileName); if (guidLoop < 10) { if (fhelper.DoesFileExists(image.FileName)) { image.FileName = Guid.NewGuid().ToString() + GetExtension(image.DisplayName, image.FileType);//.GetHashCode().ToString(); GetNewGuid(fhelper, image); TrimFirstLetterFromImageFileName(fhelper, image); } guidLoop++; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var fId = Request.QueryString["fId"]; var fileId = Convert.ToInt32(fId); using (var helper = new DbHelper.WorkingWithFiles()) { var file = helper.GetFile(fileId); if (file != null && file.FileType != "Folder") { Response.ContentType = file.FileType;//"application/octet-stream"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + file.FileName); //, "attachment; filename=logfile.txt"); Response.TransmitFile(Server.MapPath(file.FileDirectory + file.FileName)); //"~/logfile.txt")); Response.End(); } Response.End(); } } }
private void SaveFile(int userId, int schoolId, Academic.DbEntities.User.Users savedUser) { using (var helper = new DbHelper.User()) using (var fileHelper = new DbHelper.WorkingWithFiles()) { //var savedUser = helper.AddOrUpdateUser(createdUser, cmbRole.SelectedValue, FileUpload1.PostedFile); //if (savedUser != null) //{ //public bool UploadToFolder(HttpPostedFileBase file) //{ // var filename = Path.GetFileName(file.FileName); // var path = Path.Combine(Server.MapPath("~/Content/Upload"), filename); // file.SaveAs(path); // return true; //} //save image //first entry to database : table File --its image if (FileUpload1.HasFile) { var imageFile = FileUpload1.PostedFile; var userPhotoFolder = fileHelper.GetUserPhotoFolder(schoolId); if (userPhotoFolder != null) { var image = new Academic.DbEntities.UserFile() { CreatedBy = userId , CreatedDate = DateTime.Now , DisplayName = Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.UserImageDirectory , FileName = Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = imageFile.ContentLength , FileType = imageFile.ContentType , IsServerFile = true , SchoolId = schoolId , FolderId = userPhotoFolder.Id }; using (var fhelper = new DbHelper.WorkingWithFiles()) { GetNewGuid(fhelper, image); //TrimFirstLetterFromImageFileName(image); if (trimLoop > 9 || guidLoop > 9) { //cancel all save } else { var savedFile = fhelper.AddOrUpdateFile(image); if (savedFile != null) { //save the image with this name //var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath(DbHelper.StaticValues.UserImageDirectory), image.FileName); imageFile.SaveAs(path); //add the image Id to user helper.UpdateUsersImage(savedUser.Id, savedFile.Id); } } } } else { lblSaveError.Visible = true; lblSaveError.Text = "'User Photos' directory not found."; } if (savedUser != null) { ResetTextAndCombos(); } } //else // label.Text = "Error while saving."; //} } }
private void LoadFileResource(int folderId) { var type = (IsServerFile ? "server" : "private"); var user = Page.User as CustomPrincipal; if (user != null) { var isServerFile = IsServerFile; using (var helper = new DbHelper.WorkingWithFiles()) { List <UserFile> fileR; #region Sitemap and fileR value assign var sitemap = new List <IdAndName>() { new IdAndName() { Id = 0, Name = (isServerFile?"Server":"Private") + " files", Void = true , Value = "~/Views/FileManagement/?folId=0&type=" + type } }; if (folderId == 0) { fileR = helper.ListUserFiles(user.Id, folderId, isServerFile, user.SchoolId); } else { var parent = helper.GetFolderOfFilesList(user.Id, folderId, isServerFile, user.SchoolId); if (parent == null) { Response.Redirect("~/Views/FileManagement/?folId=0&type=" + type, false); return; } else { fileR = parent.FilesInThisFolder.Where(x => x.IsServerFile == isServerFile) .OrderBy(x => x.DisplayName) .ToList(); UserFile temp = parent; var tempSiteMap = new List <IdAndName>(); do { tempSiteMap.Add(new IdAndName() { Id = temp.Id, Name = temp.DisplayName, Void = true , Value = "~/Views/FileManagement/?folId=" + (temp.Id) + "&type=" + type }); temp = temp.Folder; } while (temp != null); tempSiteMap.Reverse(); sitemap.AddRange(tempSiteMap); } } sitemap[sitemap.Count - 1].Void = false; sitemap[sitemap.Count - 1].Value = ""; SiteMapUc.SetData(sitemap); #endregion if (fileR != null) { var i = 1; #region Folders var folders = fileR.Where(x => x.IsFolder).ToList(); if (folders.Any()) { foreach (var f in folders) { var file = new FileResourceEventArgs() { Id = f.Id, Visible = true, FileType = f.FileType, IconPath = (f.IsConstantAndNotEditable ?? false) ? DbHelper.StaticValues.FolderIconLockedDirectory : DbHelper.StaticValues.FolderIconDirectory, //changed here ---- + "/" FilePath = f.FileDirectory + f.FileName, FileDisplayName = f.DisplayName, FileNameActualName = f.FileName, FileSizeInBytes = f.FileSizeInBytes, LocalId = i.ToString(), IsConstantAndNotEditable = f.IsConstantAndNotEditable ?? false }; PopulateSingleData(file, true); i++; } } else { //hide folder panel pnlFoldersPanel.Visible = false; } #endregion #region Files var files = fileR.Where(x => !x.IsFolder).ToList(); if (files.Any()) { foreach (var f in files) { var file = new FileResourceEventArgs() { Id = f.Id, Visible = true, FileType = f.FileType, IconPath = string.IsNullOrEmpty(f.IconPath) ? f.FileDirectory + "/" + f.FileName : f.IconPath, //changed here FilePath = f.FileDirectory + f.FileName, FileDisplayName = f.DisplayName, FileNameActualName = f.FileName, FileSizeInBytes = f.FileSizeInBytes, LocalId = i.ToString(), IsConstantAndNotEditable = f.IsConstantAndNotEditable ?? false }; PopulateSingleData(file, false); i++; } } else { //hide folder panel pnlFilesPanel.Visible = false; } #endregion } } } }
protected void btnSave_Click(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { using (var fileHelper = new DbHelper.WorkingWithFiles()) using (var helper = new DbHelper.User()) { if (helper.DoesUserNameExist(user.SchoolId,UserId, txtUserName.Text)) { valiUserName.ErrorMessage = "Username already exists"; valiUserName.IsValid = false; } if (Page.IsValid) { var dob = DateTime.MinValue; try { dob = Convert.ToDateTime(txtDOB.Text); } catch { } var date = DateTime.Now.Date; var createdUser = new Academic.DbEntities.User.Users() { SchoolId = user.SchoolId, City = txtCity.Text, Country = txtCountry.Text, CreatedDate = date, Email = txtEmail.Text, FirstName = txtFirstName.Text, MiddleName = txtMidName.Text, LastName = txtLastName.Text, IsActive = true, IsDeleted = false, UserName = txtUserName.Text, Password = txtPassword.Text, Id = UserId, Phone = txtPhone1.Text, //Description = txtDescription.Text, }; if (cmbGender.SelectedValue!=""&& cmbGender.SelectedValue!="0") { createdUser.GenderId = Convert.ToInt32(cmbGender.SelectedValue); } if (dob != DateTime.MinValue) createdUser.DOB = dob; var userPhotoDirectory = fileHelper.GetUserPhotoFolder(user.SchoolId); if (userPhotoDirectory != null) { var files = FilesDisplay.GetFiles(); UserFile image = null; 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.UserImageDirectory, //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, SchoolId = user.SchoolId, IsServerFile = true, IsConstantAndNotEditable = false, FolderId = userPhotoDirectory.Id, //SubjectId = SubjectId, }; if (f.Id > 0) { image.ModifiedBy = user.Id; image.ModifiedDate = DateTime.Now; } } } } //var userRole = new Academic.DbEntities.User.UserRole() //{ // RoleId = Convert.ToInt32(ddlRole.SelectedValue), // UserId = UserId //}; var savedUser = helper.AddOrUpdateUser(createdUser, ddlRole.SelectedValue, image); if (savedUser != null) { if (UserId > 0) { Response.Redirect("~/Views/User/Detail.aspx?uId=" + UserId); } else { Response.Redirect("List.aspx"); } } } else { //show error of "Folder unable to find" lblSaveStatus.Text = "'User Photos' directory not found."; lblSaveStatus.Visible = true; } } } } }
protected void Page_Load(object sender, EventArgs e) { var user = Page.User as CustomPrincipal; if (user != null) { lblConfirmCheck.Visible = false; lblPasswordError.Visible = false; lblQuestionSaveError.Visible = false; lblQuestionError.Visible = false; if (!IsPostBack) { txtearlierPswrd1.Text = ""; using (var helper = new DbHelper.User()) using (var file = new DbHelper.WorkingWithFiles()) { var usr = helper.GetUser(user.Id); if (usr != null) { if (SiteMap.CurrentNode != null) { var list = new List <IdAndName>() { new IdAndName() { Name = SiteMap.RootNode.Title , Value = SiteMap.RootNode.Url , Void = true }, new IdAndName() { Name = SiteMap.CurrentNode.Title //,Value = SiteMap.CurrentNode.ParentNode.Url //,Void=true } }; SiteMapUc.SetData(list); } lblName.Text = usr.FullName; lblEmail.Text = string.IsNullOrEmpty(usr.Email)? " - ":usr.Email; lblUsername.Text = usr.UserName; img.ImageUrl = file.GetImageUrl(usr.UserImageId ?? 0); ddlQuestion.DataSource = DbHelper.StaticValues.SecurityQuestion(); ddlQuestion.DataBind(); try { var progBatch = usr.Student.FirstOrDefault().StudentBatch.FirstOrDefault().ProgramBatch; //batch.ProgramBatch.NameFromBatch; phProfileInfo.Controls.Add(new Literal() { Text = "<tr><td class='data-type'>" + "Batch" + "</td><td class='data-value'>" + progBatch.Batch.Name + "</td></tr>" }); phProfileInfo.Controls.Add(new Literal() { Text = "<tr><td class='data-type'>" + "Program" + "</td><td class='data-value'>" + progBatch.Program.Name + "</td></tr>" }); phProfileInfo.Visible = true; } catch {} } } SetView(); } } }
private void SaveFile(int userId, Academic.DbEntities.User.Users savedUser) { using (var helper = new DbHelper.User()) { //var savedUser = helper.AddOrUpdateUser(createdUser, cmbRole.SelectedValue, FileUpload1.PostedFile); //if (savedUser != null) //{ //public bool UploadToFolder(HttpPostedFileBase file) //{ // var filename = Path.GetFileName(file.FileName); // var path = Path.Combine(Server.MapPath("~/Content/Upload"), filename); // file.SaveAs(path); // return true; //} //save image //first entry to database : table File --its image if (FileUpload1.HasFile) { var imageFile = FileUpload1.PostedFile; var image = new Academic.DbEntities.UserFile() { CreatedBy = userId , CreatedDate = DateTime.Now , DisplayName = Path.GetFileName(imageFile.FileName) , FileDirectory = DbHelper.StaticValues.UserImageDirectory , FileName = Guid.NewGuid().ToString() + GetExtension(imageFile.FileName, imageFile.ContentType) , FileSizeInBytes = imageFile.ContentLength , FileType = imageFile.ContentType , }; using (var fhelper = new DbHelper.WorkingWithFiles()) { GetNewGuid(fhelper, image); //TrimFirstLetterFromImageFileName(image); if (trimLoop > 9 || guidLoop > 9) { //cancel all save } else { var savedFile = fhelper.AddOrUpdateFile(image); if (savedFile != null) { //save the image with this name //var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath(DbHelper.StaticValues.UserImageDirectory), image.FileName); imageFile.SaveAs(path); //add the image Id to user helper.UpdateUsersImage(savedUser.Id, savedFile.Id); // return true; } } } } //} //Label label = (Label)this.Page.FindControl("lblBodyMessage"); //if (label != null) //{ if (savedUser != null) { //label.Text = "Save Successful."; //Page.Response.Redirect("List.aspx"); ResetTextAndCombos(); } //else // label.Text = "Error while saving."; //} } }