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); }
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 CultivationComment AddCultivationComents(string text, int breeding) { Cultivation lastBreedingComments = new Cultivation() { id = GetMax("cultivation.cultivation_comments") }; pgSqlSingleManager.ExecuteSQL($"insert into cultivation.cultivation_comments (id,text,cultivation,create_date) " + $"values ({lastBreedingComments.id + 1},'{text}',{breeding},'{DateTime.Now}')"); var breedingCommentResult = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.cultivation_comments where id = {lastBreedingComments.id + 1}"); CultivationComment newBreedingComment = new CultivationComment { id = Int32.Parse(breedingCommentResult[0]["id"]), text = breedingCommentResult[0]["text"], cultivation = Int32.Parse(breedingCommentResult[0]["cultivation"]), create_date = DateTime.Parse(breedingCommentResult[0]["create_date"]) }; return(newBreedingComment); }
//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 Cultivation CreateCultivation(Cultivation cultivation) { return(CreateCultivation(cultivation.name, cultivation.plant.id, cultivation.pieces, cultivation.tunnel.id, cultivation.start_date)); }