public backup(deeper.frmwrk.lib_page page, System.Xml.XmlNode pageNode)
: base(page, pageNode)
{
//
// TODO: Add constructor logic here
//
}
public static string folder_path(db.db_schema conn, deeper.frmwrk.lib_page page, long id_folder, string base_path = "")
{
string folders_tbl = conn.meta_doc.table_from_code(deeper.db.meta_table.align_codes.folders);
string fld_path = conn.dt_table(string.Format("select dbo.getPathOfFolder({0}) as fld from {1} where {2} = {3}", conn.schema.pkOfTable(folders_tbl), folders_tbl,
conn.schema.pkOfTable(folders_tbl), id_folder)).Rows[0]["fld"].ToString();
if (fld_path[0] == '/' || fld_path[0] == '\\')
{
fld_path = fld_path.Substring(1);
}
return(System.IO.Path.Combine(string.IsNullOrEmpty(base_path) ? page.cfg_var("filesFolder") : base_path, fld_path).Replace('/', '\\'));
}
public static string file_path(deeper.frmwrk.lib_page page, long id_file)
{
db.db_schema db = page.conn_db_user(true);
string files_tbl = db.meta_doc.table_from_code(deeper.db.meta_table.align_codes.files);
string fld_path = db.dt_table(string.Format("select dbo.getPathOfFolder(idfolder) + '/' + filename + '.' + ext as path_file from " + files_tbl + " where idfile = {0}", id_file)).Rows[0]["path_file"].ToString();
if (fld_path[0] == '/' || fld_path[0] == '\\')
{
fld_path = fld_path.Substring(1);
}
return(System.IO.Path.Combine(page.cfg_var("filesFolder"), fld_path).Replace('/', '\\'));
}
public static void mountBackup(int id, deeper.frmwrk.lib_page page, bool onlyData = false, string logid = "", string name_db = "")
{
xmlDoc doc = new xmlDoc(Path.Combine(page.cfg_var("backupsFolder"), page.cfg_var("fsIndex")));
string index_path = page.classPage.extract_dbpck(Path.Combine(page.cfg_var("backupsFolder")
, doc.get_value("/root/files/file[@idfile=" + id.ToString() + "]", "name")));
// aggiorno db
db.db_schema db = name_db != "" ? page.conn_db(name_db, true) : page.conn_db_user(true);
db.upgrade_data(page.conn_schema(index_path), onlyData, false
, doc.get_value("/root/files/file[@idfile=" + id.ToString() + "]", "title"));
// copio i files in locale
page.files_from_backup(index_path);
}
public static int ins_file(db.db_schema db, string path_file, deeper.frmwrk.lib_page page)
{
string rel_path = strings.rel_path(page.cfg_var("filesFolder"), path_file).Replace("\\", "/");
string files_tbl = db.meta_doc.table_from_code(deeper.db.meta_table.align_codes.files);
// folders
int id_folder = ins_folder(rel_path.Substring(0, rel_path.LastIndexOf('/')), page);
// files
DataTable dt = db.dt_table("select tbl.* from "
+ " (select idfile, dbo.getPathOfFolder(idfolder) + '/' + filename + '.' + ext as path_file from files) tbl "
+ " where tbl.path_file = " + db.val_toqry(rel_path, deeper.db.fieldType.VARCHAR));
if (dt.Rows.Count >= 1)
{
return(int.Parse(dt.Rows[0]["idfile"].ToString()));
}
return((int)db.exec(string.Format("insert into " + files_tbl + " (idfolder, ext, filename, title, note, dtins) values ({0}, {1}, {2}, null, null, getdate()) ", id_folder
, db.val_toqry(Path.GetExtension(path_file).Substring(1), deeper.db.fieldType.VARCHAR), db.val_toqry(Path.GetFileNameWithoutExtension(path_file), deeper.db.fieldType.VARCHAR)), true));
}
// /cartellona/catellina/cartellozza
public static int ins_folder(string path_folder, deeper.frmwrk.lib_page page)
{
db.db_schema db = null;
bool identity_folders = false;
try {
db = page.conn_db_user(true);
path_folder = path_folder.Replace("\\", "/");
string folders_tbl = db.meta_doc.table_from_code(deeper.db.meta_table.align_codes.folders);
DataTable dt = db.dt_table("select tbl.* from "
+ " (select idfolder, dbo.getPathOfFolder(idfolder) as path_folder from folders) tbl "
+ " where tbl.path_folder = " + db.val_toqry(path_folder, deeper.db.fieldType.VARCHAR));
if (dt.Rows.Count >= 1)
{
return(int.Parse(dt.Rows[0]["idfolder"].ToString()));
}
int id_parent = -1;
string tmp_folder = "";
string[] sub_folders = path_folder.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = -1; i < sub_folders.Count(); i++)
{
// folder vuoto
if (i < 0)
{
if (db.get_count("select count(*) from " + folders_tbl + " where idfolder = 0") == 0)
{
db.set_identity("folders", true);
identity_folders = true;
db.exec("insert into " + folders_tbl + " (idfolder, idfolderpadre, foldername, note, dtins) values (0, 0, '', null, getdate())", true);
db.set_identity("folders", false);
identity_folders = false;
}
id_parent = 0;
continue;
}
tmp_folder += "/" + sub_folders[i];
dt = db.dt_table("select tbl.* from "
+ " (select idfolder, dbo.getPathOfFolder(idfolder) as path_folder from folders) tbl "
+ " where tbl.path_folder = " + db.val_toqry(tmp_folder, deeper.db.fieldType.VARCHAR));
if (dt.Rows.Count >= 1)
{
id_parent = int.Parse(dt.Rows[0]["idfolder"].ToString());
}
else
{
id_parent = (int)db.exec("insert into " + folders_tbl + " (idfolderpadre, foldername, note, dtins) values (" + id_parent.ToString() + ", "
+ db.val_toqry(sub_folders[i], deeper.db.fieldType.VARCHAR) + ", null, getdate())", true);
}
continue;
}
return(id_parent);
} catch (Exception ex) { throw ex; } finally {
if (db != null && identity_folders)
{
db.set_identity("folders", false);
}
}
}
public db_utilities(deeper.frmwrk.lib_page page, XmlNode pageNode)
: base(page, pageNode)
{
}
public checkdelete(deeper.frmwrk.lib_page page, XmlNode pageNode)
: base(page, pageNode)
{
}
public parser(lib_page page)
{
_page = page;
_eval = new System.Xml.XPath.XPathDocument(new System.IO.StringReader("<r/>")).CreateNavigator();
}
public lib_fncs(lib_page page)
{
_page = page;
}
