public BindingIP GetBinding(string id)
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
DataTable dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_WHERE, defaultTable, "ID=" + id));
BindingIP b = new BindingIP();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
try {
b = new BindingIP()
{
ID = dr["ID"].ToSafeInteger(),
IPAddress = SimpleEncryption.Decrypt(dr["IPAddress"].ToSafeString()),
Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
Path = SimpleEncryption.Decrypt(dr["Path"].ToSafeString()),
AutoBind = dr["AutoBind"].ToSafeInteger(),
Code = dr["Code"].ToSafeString()
};
} catch { /*@Ignore exception*/ }
}
}
return(b);
}
public List <BindingIP> GetBindings(bool autoBinded = false)
{
DataTable dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_DESC, defaultTable, "ID"));
if (autoBinded)
{
dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_WHERE, defaultTable, "AutoBind = 1"));
}
List <BindingIP> pwds = new List <BindingIP>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
BindingIP cmd = new BindingIP()
{
ID = dr["ID"].ToSafeInteger(),
IPAddress = SimpleEncryption.Decrypt(dr["IPAddress"].ToSafeString()),
Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
Path = SimpleEncryption.Decrypt(dr["Path"].ToSafeString()),
AutoBind = dr["AutoBind"].ToSafeInteger(),
Code = dr["Code"].ToSafeString()
};
pwds.Add(cmd);
}
}
return(pwds);
}
public string GetIPAddress(string id)
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
BindingIP bind = GetBinding(id);
if (bind != null)
{
if (!string.IsNullOrEmpty(bind.IPAddress))
{
return(bind.IPAddress);
}
}
return(string.Empty);
}
public void Add(BindingIP c)
{
Dictionary <string, object> data = new Dictionary <string, object>();
string code = (c.Path + c.Description).RemoveNonAlphaNumeric().ToLower();
data.Add("Description", SimpleEncryption.Encrypt(c.Description));
data.Add("IPAddress", SimpleEncryption.Encrypt(c.IPAddress));
data.Add("Path", SimpleEncryption.Encrypt(c.Path));
data.Add("AutoBind", c.AutoBind);
data.Add("Code", code);
if (sqlite.IsExist(defaultTable, "Code", code.ToStringType()))
{
sqlite.Update(defaultTable, data, "Code", code);
}
else
{
sqlite.Insert(defaultTable, data);
}
}
