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.";
//}
}
}
