public DistanceClass(JObject jo)
{
JObject sys1, sys2;
sys1 = (JObject)jo["sys1"];
sys2 = (JObject)jo["sys2"];
JArray submitted_by = (JArray)jo["submitted_by"];
id_edsm = jo["id"].Value <long>();
NameA = sys1["name"].Value <string>();
NameB = sys2["name"].Value <string>();
Dist = jo["distance"].Value <float>();
if (submitted_by != null && submitted_by.Count > 0)
{
CommanderCreate = submitted_by[0]["cmdrname"].Value <string>();
}
else
{
CommanderCreate = "";
}
CreateTime = jo["date"].Value <DateTime>();
Status = DistancsEnum.EDSC;
}
public DistanceClass(DataRow dr)
{
id = (int)(long)dr["id"];
NameA = (string)dr["NameA"];
NameB = (string)dr["NameB"];
Dist = Convert.ToDouble(dr["Dist"]);
CommanderCreate = (string)dr["commanderCreate"];
CreateTime = (DateTime)dr["CreateTime"];
CreateTime = CreateTime.ToUniversalTime();
Status = (DistancsEnum)(long)dr["status"];
}
public DistanceClass(DataRow dr)
{
id = (int)(long)dr["id"];
NameA = (string)dr["NameA"];
NameB = (string)dr["NameB"];
Dist = Convert.ToDouble(dr["Dist"]);
CommanderCreate = (string)dr["commanderCreate"];
CreateTime = (DateTime)dr["CreateTime"];
CreateTime = CreateTime.ToUniversalTime();
Status = (DistancsEnum)(long)dr["status"];
}
public static bool Delete(DistancsEnum distsource)
{
using (SQLiteConnectionED cn = new SQLiteConnectionED())
{
using (DbCommand cmd = cn.CreateCommand("Delete from Distances where Status=@Status"))
{
cmd.AddParameterWithValue("@Status", (int)distsource);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
}
}
return(true);
}
public DistanceClass(DbDataReader dr)
{
id = (long)dr["id"];
if (System.DBNull.Value != dr["id_edsm"])
id_edsm = (long)dr["id_edsm"];
NameA = (string)dr["NameA"];
NameB = (string)dr["NameB"];
Dist = Convert.ToDouble(dr["Dist"]);
CommanderCreate = (string)dr["commanderCreate"];
CreateTime = (DateTime)dr["CreateTime"];
CreateTime = CreateTime.ToUniversalTime();
Status = (DistancsEnum)(long)dr["status"];
}
public DistanceClass(DbDataReader dr)
{
id = (long)dr["id"];
if (System.DBNull.Value != dr["id_edsm"])
{
id_edsm = (long)dr["id_edsm"];
}
NameA = (string)dr["NameA"];
NameB = (string)dr["NameB"];
Dist = Convert.ToDouble(dr["Dist"]);
CommanderCreate = (string)dr["commanderCreate"];
CreateTime = (DateTime)dr["CreateTime"];
CreateTime = CreateTime.ToUniversalTime();
Status = (DistancsEnum)(long)dr["status"];
}
public static bool Delete(DistancsEnum distsource)
{
using (SQLiteConnection cn = new SQLiteConnection(SQLiteDBClass.ConnectionString))
{
cn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 30;
cmd.CommandText = "Delete from Distances where Status=@Status";
cmd.Parameters.AddWithValue("@Status", (int)distsource);
SQLiteDBClass.SqlNonQueryText(cn, cmd);
}
cn.Close();
}
return true;
}
public static bool Delete(DistancsEnum distsource)
{
using (SQLiteConnection cn = new SQLiteConnection(SQLiteDBClass.ConnectionString))
{
cn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 30;
cmd.CommandText = "Delete from Distances where Status=@Status";
cmd.Parameters.AddWithValue("@Status", (int)distsource);
SQLiteDBClass.SqlNonQueryText(cn, cmd);
}
cn.Close();
}
return(true);
}
public DistanceClass(JObject jo)
{
JObject sys1, sys2;
sys1 = (JObject)jo["sys1"];
sys2 = (JObject)jo["sys2"];
JArray submitted_by = (JArray)jo["submitted_by"];
id_edsm = jo["id"].Value<long>();
NameA = sys1["name"].Value<string>();
NameB = sys2["name"].Value<string>();
Dist = jo["distance"].Value<float>();
if (submitted_by != null && submitted_by.Count > 0)
{
CommanderCreate = submitted_by[0]["cmdrname"].Value<string>();
}
else
CommanderCreate = "";
CreateTime = jo["date"].Value<DateTime>();
Status = DistancsEnum.EDSC;
}
public static bool Delete(DistancsEnum distsource)
{
using (SQLiteConnectionSystem cn = new SQLiteConnectionSystem())
{
using (DbCommand cmd = cn.CreateCommand("Delete from Distances where Status=@Status"))
{
cmd.AddParameterWithValue("@Status", (int)distsource);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
}
}
return true;
}
