public bool saveFolder(folderDTO obj)
{
folderDAO folderObjDAO = new folderDAO();
if (folderObjDAO.saveFolder(obj))
{
return(true);
}
return(false);
}
public List <folderDTO> loadFolders()
{
folderDTO obj = new folderDTO();
obj.createdBy = Convert.ToInt32(System.Web.HttpContext.Current.Request["createdBy"]);
obj.parentFolderId = Convert.ToInt32(System.Web.HttpContext.Current.Request["parentFolderId"]);
folderBA folderBAObj = new folderBA();
List <folderDTO> folderList = folderBAObj.getAllFolders(obj);
return(folderList);
}
public static folderDTO createFolder(String child, int uid, int parentFolder)
{
String query = "";
String query1 = "";
folderDTO folder = new folderDTO();
folder.folderName = child;
folder.parentFolderId = parentFolder;
folder.id = uid;
if (parentFolder == 0)
{
query = String.Format("SELECT * FROM folderTable where folderName='{0}' and parentFolderId is NULL", child);
}
else
{
query = String.Format("SELECT * FROM folderTable where folderName='{0}' and parentFolderId='{1}'", child, parentFolder);
}
using (sqlConn connection = new sqlConn())
{
var reader = connection.ExcueteReader(query);
if (reader.Read())
{
return(null);
}
else
{
using (sqlConn connection1 = new sqlConn())
{
if (parentFolder == 0)
{
query1 = String.Format("INSERT INTO folderTable (folderName,id) VALUES ('{0}','{1}')", child, uid);
}
else
{
query1 = String.Format("INSERT INTO folderTable (folderName,parentFolderId,id) VALUES ('{0}','{1}','{2}')", child, parentFolder, uid);
}
int retValue = connection1.ExcueteQuery(query1);
if (retValue == 1)
{
String sql = "SELECT folderId FROM userInfo.folders ORDER BY folderId DESC LIMIT 1";
var result = connection1.ExcueteScalar(sql);
int id = Int32.Parse(result.ToString());
folder.folderId = id;
return(folder);
}
}
}
}
return(null);
}
public bool addNewFolder()
{
folderDTO obj = new folderDTO();
obj.name = System.Web.HttpContext.Current.Request["name"];
obj.parentFolderId = Convert.ToInt32(System.Web.HttpContext.Current.Request["parentFolderId"]);
obj.createdBy = Convert.ToInt32(System.Web.HttpContext.Current.Request["createdBy"]);
folderBA folderBAObj = new folderBA();
//folderBAObj.saveFolder(obj);
if (folderBAObj.saveFolder(obj))
{
return(true);
}
return(false);
}
public bool saveFolder(folderDTO obj)
{
String connString = @"Data Source=.\SQLEXPRESS2012; Initial Catalog=Assignment8; Integrated Security=True; Persist Security Info=True;";
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
String sqlQuery = "";
sqlQuery = String.Format(@"INSERT INTO dbo.folder(name, parentfolderid,
createdby,createdon,isactive)
VALUES('{0}','{1}','{2}','{3}','{4}')", obj.name, obj.parentFolderId, obj.createdBy, DateTime.Now, 1);
SqlCommand command = new SqlCommand(sqlQuery, conn);
int rowAffected = command.ExecuteNonQuery();
Console.WriteLine("{0} Row Affected", rowAffected);
return(true);
}
}
public ActionResult CreateFolders(String child, int uid, int parentFolder)
{
int id = 0;
bool flag = false;
folderDTO folder = folderBO.createFolder(child, uid, parentFolder);
if (folder != null)
{
id = folder.folderId;
flag = true;
}
var data = new
{
success = flag,
folderId = id
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
public static List <folderDTO> getFolders(int userId, int prntfId)
{
String query = "";
List <folderDTO> foldersList = new List <folderDTO>();
if (prntfId == 0)
{
query = String.Format("SELECT * FROM folderTable where id='{0}' and parentFolderId IS NULL", userId);
}
else
{
query = String.Format("SELECT * FROM folderTable where id='{0}' and parentFolderId='{1}'", userId, prntfId);
}
using (sqlConn connection = new sqlConn())
{
var reader = connection.ExcueteReader(query);
if (reader != null)
{
while (reader.Read())
{
folderDTO folder = new folderDTO();
folder.folderId = reader.GetInt32(0);
folder.folderName = reader.GetString(1);
if (prntfId == 0)
{
folder.parentFolderId = 0;
}
else
{
folder.parentFolderId = reader.GetInt32(2);
}
folder.id = reader.GetInt32(3);
foldersList.Add(folder);
}
}
else
{
foldersList = null;
}
return(foldersList);
}
}
public folderDTO getFolderById(int id)
{
String connString = @"Data Source=.\SQLEXPRESS2012; Initial Catalog=Assignment8; Integrated Security=True; Persist Security Info=True;";
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
String sqlQuery = "Select * from dbo.folder where id='" + id + "' and isactive='1'";
SqlCommand command = new SqlCommand(sqlQuery, conn);
SqlDataReader reader = command.ExecuteReader();
folderDTO folderObj = new folderDTO();
if (reader.Read() == true)
{
folderObj.id = reader.GetInt32(reader.GetOrdinal("id"));
folderObj.name = reader.GetString(reader.GetOrdinal("name"));
folderObj.parentFolderId = reader.GetInt32(reader.GetOrdinal("parentfolderid"));
folderObj.createdBy = reader.GetInt32(reader.GetOrdinal("createdby"));
}
return(folderObj);
}
}
public folderDTO getFolder(folderDTO obj)
{
folderDAO folderObjDAO = new folderDAO();
return(folderObjDAO.getFolder(obj));
}
public List <folderDTO> getAllFolders(folderDTO obj)
{
folderDAO folderObjDAO = new folderDAO();
return(folderObjDAO.getAllFolders(obj));
}
public void getMetaData()
{
folderDTO obj = new folderDTO();
obj.createdBy = Convert.ToInt32(System.Web.HttpContext.Current.Request["createdBy"]);
obj.parentFolderId = Convert.ToInt32(System.Web.HttpContext.Current.Request["parentFolderId"]);
folderBA folderBAObj = new folderBA();
List <folderDTO> folderList = folderBAObj.getAllFolders(obj);
String dest = "C:\\Users\\Muneeb\\Documents\\Visual Studio 2013\\Projects\\ead_s18_a8_bcsf15m030\\MyDrive\\Web API\\UploadedFiles\\metaInformation.pdf";
var writer = new PdfWriter(dest);
var pdf = new PdfDocument(writer);
var document = new Document(pdf);
int count = folderList.Count;
Queue <folderDTO> foldersQueue = new Queue <folderDTO>();
for (int i = 0; i < count; i++)
{
foldersQueue.Enqueue(folderList[i]);
}
fileDTO fileObj = new fileDTO();
fileObj.createdBy = Convert.ToInt32(System.Web.HttpContext.Current.Request["createdBy"]);
fileObj.parentFolderId = Convert.ToInt32(System.Web.HttpContext.Current.Request["parentFolderId"]);
fileBA fileBAObj = new fileBA();
List <fileDTO> fileList = fileBAObj.getAllFiles(fileObj);
count = fileList.Count;
Queue <fileDTO> filesQueue = new Queue <fileDTO>();
for (int i = 0; i < count; i++)
{
filesQueue.Enqueue(fileList[i]);
}
while (foldersQueue.Count > 0)
{
folderDTO folder = foldersQueue.Dequeue();
document.Add(new Paragraph("Name: " + folder.name));
document.Add(new Paragraph("Type: Folder"));
document.Add(new Paragraph("Size: None"));
if (folder.parentFolderId == 0)
{
document.Add(new Paragraph("Parent: Root"));
}
else
{
folderDTO folder1 = folderBAObj.getFolder(folder);
document.Add(new Paragraph("Parent: " + folder1.name));
}
document.Add(new Paragraph(""));
folder.parentFolderId = folder.id;
folderList = folderBAObj.getAllFolders(folder);
count = folderList.Count;
for (int i = 0; i < count; i++)
{
foldersQueue.Enqueue(folderList[i]);
}
fileList = fileBAObj.getAllFilesById(folder.parentFolderId);
count = fileList.Count;
for (int i = 0; i < count; i++)
{
filesQueue.Enqueue(fileList[i]);
}
}
while (filesQueue.Count > 0)
{
fileDTO file = filesQueue.Dequeue();
document.Add(new Paragraph("Name: " + file.name));
document.Add(new Paragraph("Type: File"));
document.Add(new Paragraph("Size: " + file.fileSizeinKb + " KB"));
if (file.parentFolderId == 0)
{
document.Add(new Paragraph("Parent: Root"));
}
else
{
folderDTO folder1 = folderBAObj.getFolderById(file.parentFolderId);
document.Add(new Paragraph("Parent: " + folder1.name));
}
document.Add(new Paragraph(""));
}
document.Add(new Paragraph(""));
document.Close();
return;
}
