private static List <Cultivation> GetCultivations(string query) { List <Cultivation> cultivations = new List <Cultivation>(); foreach (var cultivation in pgSqlSingleManager.ExecuteSQL(query)) { Cultivation newCultivation = new Cultivation() { id = Int32.Parse(cultivation["id"]), name = cultivation["name"], plant = Plant.GetPlant(Int32.Parse(cultivation["plant"])), pieces = Int32.Parse(cultivation["pieces"]), tunnel = Tunnel.GetTunnel(Int32.Parse(cultivation["tunnel"])), start_date = DateTime.Parse(cultivation["start_date"]), end_date = null }; if (cultivation["end_date"] != "") { newCultivation.end_date = DateTime.Parse(cultivation["end_date"]); } cultivations.Add(newCultivation); } return(cultivations); }
private static List <AvrDevice> GetAvrDevices(string query, bool getTunnelInfo) { List <AvrDevice> avrDevices = new List <AvrDevice>(); foreach (var avrDevice in pgSqlSingleManager.ExecuteSQL(query)) { AvrDevice newAvrDevice = new AvrDevice() { id = Int32.Parse(avrDevice["id"]), ip = avrDevice["ip"], last_update = null }; if (getTunnelInfo) { newAvrDevice.tunnel = Tunnel.GetTunnel(Int32.Parse(avrDevice["tunnel"])); } if (avrDevice["last_update"] != "") { newAvrDevice.last_update = DateTime.Parse(avrDevice["last_update"]); } avrDevices.Add(newAvrDevice); } return(avrDevices); }
public static Cultivation UpdateCultivation(Cultivation cultivation) { string endDateValue = ""; if (cultivation.end_date == null) { endDateValue = "null"; } else { endDateValue = $"'{cultivation.end_date}'"; } string sql = $"update cultivation.cultivation set " + $"name = '{cultivation.name}', pieces = {cultivation.pieces}, tunnel = {cultivation.tunnel.id}," + $" start_date = '{cultivation.start_date}', end_date = {endDateValue} " + $"where id = {cultivation.id} "; pgSqlSingleManager.ExecuteSQL(sql); var cultivationResult = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.cultivation where id = {cultivation.id}"); Cultivation updatedCultivation = new Cultivation { id = Int32.Parse(cultivationResult[0]["id"]), name = cultivationResult[0]["name"], pieces = Int32.Parse(cultivationResult[0]["pieces"]), plant = Plant.GetPlant(Int32.Parse(cultivationResult[0]["plant"])), tunnel = Tunnel.GetTunnel(Int32.Parse(cultivationResult[0]["tunnel"])), start_date = DateTime.Parse(cultivationResult[0]["start_date"]) }; return(updatedCultivation); }
public static Tunnel GetTunnel(int id) { var sqlresults = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.tunnels where id = {id}"); Tunnel resultTunnel = new Tunnel(); foreach (var c_result in sqlresults) { resultTunnel = new Tunnel() { id = Int32.Parse(c_result["id"]), name = c_result["name"] }; } return(resultTunnel); }
public static Tunnel CreateTunnel(string name) { var tunnelMaxResult = pgSqlSingleManager.ExecuteSQL($"select max(id) from cultivation.tunnels"); Tunnel lastTunnel = new Tunnel(); Int32.TryParse(tunnelMaxResult[0]["max"], out lastTunnel.id); pgSqlSingleManager.ExecuteSQL($"insert into cultivation.tunnels (id,name) values ({lastTunnel.id + 1},'{name}')"); var tunnelResult = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.tunnels where id = {lastTunnel.id + 1}"); Tunnel newTunnel = new Tunnel { id = Int32.Parse(tunnelResult[0]["id"]), name = tunnelResult[0]["name"] }; return(newTunnel); }
//Do przerobienia - plant to nie ten plant public static Cultivation CreateCultivation(string name, int plant, int pieces, int tunnel, DateTime start_date) { Cultivation lastCultivation = new Cultivation() { id = GetMax("cultivation.cultivation") }; pgSqlSingleManager.ExecuteSQL($"insert into cultivation.cultivation (id,name,plant,pieces,tunnel,start_date) " + $"values ({lastCultivation.id + 1},'{name}',{plant},{pieces},{tunnel},'{start_date}')"); var cultivationResult = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.cultivation where id = {lastCultivation.id + 1}"); Cultivation newCultivation = new Cultivation { id = Int32.Parse(cultivationResult[0]["id"]), name = cultivationResult[0]["name"], pieces = Int32.Parse(cultivationResult[0]["pieces"]), plant = Plant.GetPlant(Int32.Parse(cultivationResult[0]["plant"])), tunnel = Tunnel.GetTunnel(Int32.Parse(cultivationResult[0]["tunnel"])), start_date = DateTime.Parse(cultivationResult[0]["start_date"]) }; return(newCultivation); }
public static Tunnel UpdateTunnel(Tunnel oldTunnel, string newName) { oldTunnel.name = newName; pgSqlSingleManager.ExecuteSQL($"update cultivation.tunnels set name = '{newName}' where id = {oldTunnel.id} and name = '{oldTunnel.name}'"); return(GetTunnel(oldTunnel.id)); }