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 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; }