public static settings read_settings(core c, db_provider conn)
{
return(new settings(conn.dt_table(c.config.get_query("lib-base.get-settings").text)
.Rows.Cast <DataRow>().Select(r => new setting((int)r["setting_id"]
, (string)r["setting_name"], db_provider.str_val(r["setting_var"])
, db_provider.str_val(r["machine_name"]))).ToList()));
}
public static doc_task open_index(core c, string folder_path)
{
doc_task res = null;
string i_name = c.config.get_var("lib-vars.index-folder").value
, fp = Path.Combine(folder_path, i_name);
return(File.Exists(fp) ? new doc_task(fp) : null);
}
public void save_into_folder(core c, string folder_path)
{
string i_name = c.config.get_var("lib-vars.index-folder").value
, fp = Path.Combine(folder_path, i_name);
this.save(fp);
FileInfo fi = new FileInfo(fp); _lwt = sys.without_ms(fi.LastWriteTime);
}
public static setting get_setting(core c, db_provider conn, string setting_name)
{
DataRow r = conn.first_row(c.parse_query("lib-base.get-setting", new string[, ] {
{ "setting-name", setting_name }
}));
return(r == null ? null : new setting((int)r["setting_id"], (string)r["setting_name"]
, db_provider.str_val(r["setting_var"]), db_provider.str_val(r["machine_name"])));
}
public static doc_task create_index(core c, string folder_path)
{
doc_task res = new doc_task()
{
xml = "<root/>", created = true
};
string i_name = c.config.get_var("lib-vars.index-folder").value
, fp = Path.Combine(folder_path, i_name);
res.save(fp);
return(res);
}
public static bool exists_index(core c, string folder_path)
{
return(File.Exists(Path.Combine(folder_path, c.config.get_var("lib-vars.index-folder").value)));
}
public bo(db_provider conn, core c, config cfg, int user_id = 0, string user_name = "")
{
this.db_conn = conn; this.core = c; this.config = cfg; this.user_id = user_id; this.user_name = user_name;
}
static public task parse_task(core c, int synch_folder_id, string path, DateTime ct, DateTime lwt
, List <string> users, List <free_label> labels, long?folder_id = null, long?file_id = null, bool set_index = false)
{
try {
if (!folder_id.HasValue && !file_id.HasValue)
{
throw new Exception("il task dev'essere un file o un folder");
}
string[] parts = Path.GetFileName(path).Split(new char[] { '.' });
if (parts.Length <= 1)
{
return(null);
}
// task
if (folder_id.HasValue && parts[parts.Length - 1] != "task")
{
return(null);
}
else if (file_id.HasValue && parts[parts.Length - 1] != "task" && parts[parts.Length - 2] != "task")
{
return(null);
}
// leggo il doc. indice
doc_task it = null;
if (folder_id.HasValue && set_index)
{
it = doc_task.exists_index(c, path) ? doc_task.open_index(c, path) : doc_task.create_index(c, path);
}
// parse nome cartella
string title = "", user = it != null ? it.user : "", stato = it != null ? it.stato : "", priorita = it != null ? it.priorita : ""
, tipo = it != null ? it.tipo : "", stima = it != null ? it.stima : "";
DateTime?dt = null, dt2 = null;
for (int i = 0; i < parts.Length; i++)
{
string p = parts[i]; if (p == "task")
{
break;
}
// date
if (dn_lib.tools.strings.is_int(p) && (p.Length == 6 || p.Length == 8))
{
if (!dt.HasValue)
{
parse_date(p, out dt);
}
else if (!dt2.HasValue)
{
parse_date(p, out dt2);
}
if (dt.HasValue && dt2.HasValue && dt2 < dt)
{
DateTime tmp = dt2.Value; dt = dt2; dt2 = tmp;
}
if (it != null && it.created && dt.HasValue)
{
it.dt_create = dt;
}
if (it != null && it.created && dt2.HasValue)
{
it.dt_upd = dt2;
}
continue;
}
// state
free_label lbl = labels.FirstOrDefault(x => !string.IsNullOrEmpty(x.stato) && x.free_txt.ToLower() == p.ToLower());
if (lbl != null)
{
stato = lbl.stato; if (it != null)
{
it.stato = stato;
}
continue;
}
// priorita
lbl = labels.FirstOrDefault(x => !string.IsNullOrEmpty(x.priorita) && x.free_txt.ToLower() == p.ToLower());
if (lbl != null)
{
priorita = lbl.priorita; if (it != null)
{
it.priorita = priorita;
}
continue;
}
// tipo
lbl = labels.FirstOrDefault(x => !string.IsNullOrEmpty(x.tipo) && x.free_txt.ToLower() == p.ToLower());
if (lbl != null)
{
tipo = lbl.tipo; if (it != null)
{
it.tipo = tipo;
}
continue;
}
// stima
lbl = labels.FirstOrDefault(x => !string.IsNullOrEmpty(x.stima) && x.free_txt.ToLower() == p.ToLower());
if (lbl != null)
{
stima = lbl.stima; if (it != null)
{
it.stima = stima;
}
continue;
}
// user
if (user == "" && users.FirstOrDefault(x => x.ToLower() == p.ToLower()) != null)
{
user = p; if (it != null)
{
it.user = user;
}
continue;
}
// title
if (title == "")
{
title = p;
}
}
return(new task(synch_folder_id, file_id, folder_id, title, user, stato, priorita, tipo, stima
, it != null ? it.dt_create : (dt.HasValue ? dt : ct), it != null ? it.dt_upd : (DateTime?)null, lwt, it)
{
path = path
});
} catch (Exception ex) { log.log_err(ex); return(null); }
}
public synch(db_provider conn, core c, config cfg, int user_id = 0, string user_name = "")
: base(conn, c, cfg, user_id, user_name)
{
}
