/// <summary> /// opslaan in XML /// </summary> /// <param name="project"></param> /// <returns></returns> public bool AddProject(Project project) { List<Project> projects = new List<Project>(); if(xml.XMLRead(out projects, out error)) { projects.Add(project); return xml.XMLWriter(projects, out error); } return false; }
public bool SetProject(Project pr) { return xml.SetProject(pr, out error); }
/// <summary> /// project uit XML bestand halen /// </summary> /// <param name="project">out project. ophalen</param> /// <param name="error">out error</param> /// <returns></returns> public bool GetProject(out Project project, out string error) { project = new Project(-1, string.Empty); error = string.Empty; try { DataContractSerializer dcs = new DataContractSerializer(typeof(Project), new List<Type> { typeof(Project), typeof(Project) }); using (FileStream f = new FileStream(@"./Resources/Saves/Project.XML", FileMode.Open, FileAccess.Read)) { project = dcs.ReadObject(f) as Project; } return true; } catch (Exception e) { error = e.Message; return false; } }
/// <summary> /// projecten ophalen /// /// </summary> /// <param name="projecten">out lijst projecten</param> /// <param name="error">out string error</param> /// <returns></returns> public bool GetProjecten(out List<Project> projecten, out string error) { projecten = new List<Project>(); error = string.Empty; try { string query = "SELECT * FROM Project"; using (OracleConnection conn = new OracleConnection(connectionString)) { OracleCommand command = new OracleCommand(query, conn); conn.Open(); OracleDataReader reader = command.ExecuteReader(); while (reader.Read()) { //item = Convert.ToInt32(reader["item"]); int id=Convert.ToInt32(reader["ID"]); string gebied = Convert.ToString(reader["gebied"]); Project proj = new Project(id, gebied); List<Bezoek> bezoeken =new List<Bezoek>(); if(!GetBezoeken(out bezoeken, proj.ID, out error)) return false; foreach (Bezoek bez in bezoeken) { proj.Bezoeken.Add(bez); } projecten.Add(proj); } reader.Close(); } if (projecten.Count < 1) { error = "Kon geen dieren vinden."; return false; } return true; } catch (Exception e) { // set error message and return false error = e.Message; return false; } }
/// <summary> /// /// </summary> /// <param name="project"></param> /// <param name="error"></param> /// <returns></returns> public bool SetProject(Project project, out string error) { error = string.Empty; try { DataContractSerializer dcs = new DataContractSerializer(typeof(Project), new List<Type> { typeof(Project), typeof(Project) }); using (FileStream f = new FileStream(@"./Resources/Saves/Project.XML", FileMode.Create, FileAccess.Write)) { dcs.WriteObject(f, project); } return true; } catch (Exception e) { error = e.Message; return false; } }