public static bool DeleteFilesInFolder(tblFileInformation folder, int profileID)
{
List <tblFileInformation> files = GetAllFilesInFolder(folder, profileID);
if (files != null && files.Count > 0)
{
foreach (tblFileInformation info in files)
{
GoProGoDC.FileDC.tblFileInformations.DeleteOnSubmit(info);
}
}
GoProGoDC.FileDC.SubmitChanges();
return(true);
}
private void GetIDAndActivate()
{
try
{
_ID = Request.QueryString["ID"];
if (!string.IsNullOrEmpty(_ID))
{
tblActivationRequest actReq = (from req in GoProGoDC.ProfileDC.tblActivationRequests
where req.ActivationID.ToString() == _ID && !req.IsFulfilled
select req).SingleOrDefault <tblActivationRequest>();
if (actReq != null && actReq.IsFulfilled == false)
{
MembershipUser user = Membership.GetUser(actReq.tblProfile.UserID);
if (!user.IsApproved)
{
//Approved user account first
user.IsApproved = true;
Membership.UpdateUser(user);
//Following line will submit changes in DB for creating file
tblFileInformation fileInfo = VirtualFS.CreateFolder(user.UserName, actReq.tblProfile.ID, null);
actReq.tblProfile.RootFolderID = fileInfo.ID;
actReq.IsFulfilled = true;
//Following line will submit changes to update Profile
GoProGoDC.ProfileDC.SubmitChanges(ConflictMode.FailOnFirstConflict);
pnlSuccess.Visible = true;
}
}
else
{
pnlFailure.Visible = true;
}
}
else
{
throw new Exception("Invalid request.");
}
}
catch (Exception ex)
{
((PublicMaster)this.Master).ShowMessage(ex.Message, MessageType.Error);
}
}
public static tblFileInformation CreateFile(int?profileID, string path, long contentLength, AccessTypes accessType, FileTypes fileType, FileExtensions fileExtension, tblFileInformation folder)
{
tblFileInformation fileInfo = new tblFileInformation()
{
AccessTypeID = (int)accessType,
ContentLength = contentLength,
FileExtensionID = (int)fileExtension,
Path = System.IO.Path.GetDirectoryName(path),
PhysicalFileName = System.IO.Path.GetFileName(path),
ProfileID = profileID,
CreatedDate = DateTime.Now,
ParentID = folder.ID,
FullPath = path
};
GoProGoDC.FileDC.tblFileInformations.InsertOnSubmit(fileInfo);
GoProGoDC.FileDC.SubmitChanges();
return(fileInfo);
}
public static tblFileInformation CreateFolder(string name, int profileID, int?parentID)
{
tblFileInformation fileInfo = new tblFileInformation()
{
AccessTypeID = 4,
ContentLength = 0,
FileExtensionID = 7,
Path = string.Empty,
PhysicalFileName = name,
ProfileID = profileID,
CreatedDate = DateTime.Now,
ParentID = parentID,
FullPath = name
};
GoProGoDC.FileDC.tblFileInformations.InsertOnSubmit(fileInfo);
GoProGoDC.FileDC.SubmitChanges();
return(fileInfo);
}
public static List <tblFileInformation> GetAllFilesInFolder(tblFileInformation folder, int profileID)
{
return(GoProGoDC.FileDC.tblFileInformations.Where(a => a.ParentID == folder.ID && a.ProfileID == profileID).ToList <tblFileInformation>());
}
public static List <tblFileInformation> GetAllFoldersInFolder(tblFileInformation folder, int profileID)
{
return(GoProGoDC.FileDC.tblFileInformations.Where(a => a.ParentID == folder.ID && a.tblFileExtension.FileExtensionTypeID == (int)FileTypes.Folder && a.ProfileID == profileID).ToList <tblFileInformation>());
}
private void detach_tblFileInformations(tblFileInformation entity)
{
this.SendPropertyChanging();
entity.tlkpAccessType = null;
}
private void attach_tblFileInformations(tblFileInformation entity)
{
this.SendPropertyChanging();
entity.tblFileInformation1 = this;
}
partial void DeletetblFileInformation(tblFileInformation instance);
partial void UpdatetblFileInformation(tblFileInformation instance);
partial void InserttblFileInformation(tblFileInformation instance);
private void detach_tblFileInformations(tblFileInformation entity)
{
this.SendPropertyChanging();
entity.tblFileExtension = null;
}
