public Collection <Kontrola_kvality_spalovani> Select()
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
List <XElement> elementy = xDoc.Descendants("Kontroly_kvality_spalovani").Descendants("Kontrola_kvality_spalovani").ToList();
Collection <Kontrola_kvality_spalovani> vsechnyKontroly = new Collection <Kontrola_kvality_spalovani>();
int id;
DateTime datum;
int idStavby;
foreach (XElement element in elementy)
{
Kontrola_kvality_spalovani kontrola = new Kontrola_kvality_spalovani();
int.TryParse(element.Attribute("Id_kontroly").Value, out id);
DateTime.TryParse(element.Attribute("Datum_kontroly").Value, out datum);
kontrola.Duvod_kontroly = element.Attribute("Duvod_kontroly").Value;
int.TryParse(element.Attribute("Id_stavby").Value, out idStavby);
kontrola.Id_kontroly = id;
kontrola.Datum_kontroly = datum;
kontrola.Id_stavby = idStavby;
vsechnyKontroly.Add(kontrola);
kontrola = null;
}
return(vsechnyKontroly);
}
/*
* public static int Sequence(Database Db = null)
* {
* Database db;
* if (Db == null)
* {
* db = new Database();
* db.Connect();
* }
* else
* {
* db = (Database)Db;
* }
*
* OracleCommand command = db.CreateCommand(SQL_SEQUENCE);
* OracleDataReader reader = db.Select(command);
*
* int hodnota = 0;
* while (reader.Read() != false)
* {
* hodnota = reader.GetInt32(0);
* }
*
* reader.Close();
*
* if (Db == null)
* {
* db.Close();
* }
*
* return hodnota;
* }*/
/*
* public static int Insert(Kontrola_kvality_spalovani kontrola)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_INSERT);
* PrepareCommand(command, kontrola);
* int ret = db.ExecuteNonQuery(command);
* db.Close();
* return ret;
* }*/
/*
* public static int Update(Kontrola_kvality_spalovani kontrola)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_UPDATE);
* PrepareCommand(command, kontrola);
* int ret = db.ExecuteNonQuery(command);
* db.Close();
* return ret;
* }*/
/*
* public static Collection<Kontrola_kvality_spalovani> Select(Database Db = null)
* {
* Database db;
* if (Db == null)
* {
* db = new Database();
* db.Connect();
* }
* else
* {
* db = (Database)Db;
* }
*
* OracleCommand command = db.CreateCommand(SQL_SELECT);
* OracleDataReader reader = db.Select(command);
*
* Collection<Kontrola_kvality_spalovani> Kontroly = Read(reader, false);
* reader.Close();
*
* if (Db == null)
* {
* db.Close();
* }
*
* return Kontroly;
* }*/
/*
* public static Kontrola_kvality_spalovani Select_id(int idKontroly, Database Db = null)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_SELECT_ID);
*
* command.Parameters.AddWithValue(":id", idKontroly);
* OracleDataReader reader = db.Select(command);
*
* Collection<Kontrola_kvality_spalovani> kontroly = Read(reader, true);
* Kontrola_kvality_spalovani kontrola = null;
* if (kontroly.Count == 1)
* {
* kontrola = kontroly[0];
* }
* reader.Close();
* db.Close();
* return kontrola;
* }*/
private static void PrepareCommand(OracleCommand command, Kontrola_kvality_spalovani Kontrola)
{
command.BindByName = true;
command.Parameters.AddWithValue(":id", Kontrola.Id_kontroly);
command.Parameters.AddWithValue(":datum_kontroly", Kontrola.Datum_kontroly);
command.Parameters.AddWithValue(":duvod_kontroly", Kontrola.Duvod_kontroly);
command.Parameters.AddWithValue(":id_stavby", Kontrola.Id_stavby);
}
public void Update(Kontrola_kvality_spalovani kontrola)
{
Database db = new Database();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, kontrola);
int ret = db.ExecuteNonQuery(command);
db.Close();
}
public void Insert(Kontrola_kvality_spalovani kontrola)
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
XElement result = new XElement("Kontrola_kvality_spalovani",
new XAttribute("Id_kontroly", kontrola.Id_kontroly),
new XAttribute("Datum_kontroly", kontrola.Datum_kontroly.ToShortDateString()),
new XAttribute("Duvod_kontroly", kontrola.Duvod_kontroly),
new XAttribute("Id_stavby", kontrola.Id_stavby));
xDoc.Root.Element("Kontroly_kvality_spalovani").Add(result);
xDoc.Save(ConstantsXml.FilePath);
}
public Kontrola_kvality_spalovani Select_id(int idKontroly)
{
Collection <Kontrola_kvality_spalovani> vsechnyKontroly = this.Select();
Kontrola_kvality_spalovani vybranaKontrola = null;
foreach (Kontrola_kvality_spalovani kontrola in vsechnyKontroly)
{
if (kontrola.Id_kontroly == idKontroly)
{
vybranaKontrola = kontrola;
}
}
return(vybranaKontrola);
}
public void Update(Kontrola_kvality_spalovani kontrola)
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
var q = from node in xDoc.Descendants("Kontroly_kvality_spalovani").Descendants("Kontrola_kvality_spalovani")
let attr = node.Attribute("Id_kontroly")
where (attr != null && attr.Value == kontrola.Id_kontroly.ToString())
select node;
q.ToList().ForEach(x => {
x.Attribute("Datum_kontroly").Value = kontrola.Datum_kontroly.ToShortDateString();
x.Attribute("Duvod_kontroly").Value = kontrola.Duvod_kontroly;
x.Attribute("Id_stavby").Value = kontrola.Id_stavby.ToString();
});
xDoc.Save(ConstantsXml.FilePath);
}
private static Collection <Kontrola_kvality_spalovani> Read(OracleDataReader reader, bool complete)
{
Collection <Kontrola_kvality_spalovani> Kontroly = new Collection <Kontrola_kvality_spalovani>();
while (reader.Read())
{
int i = -1;
Kontrola_kvality_spalovani Kontrola = new Kontrola_kvality_spalovani();
Kontrola.Id_kontroly = reader.GetInt32(++i);
Kontrola.Datum_kontroly = reader.GetDateTime(++i);
if (complete)
{
Kontrola.Duvod_kontroly = reader.GetString(++i);
}
Kontrola.Id_stavby = reader.GetInt32(++i);
Kontroly.Add(Kontrola);
}
return(Kontroly);
}
public Kontrola_kvality_spalovani Select_id(int idKontroly)
{
Database db = new Database();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue(":id", idKontroly);
OracleDataReader reader = db.Select(command);
Collection <Kontrola_kvality_spalovani> kontroly = Read(reader, true);
Kontrola_kvality_spalovani kontrola = null;
if (kontroly.Count == 1)
{
kontrola = kontroly[0];
}
reader.Close();
db.Close();
return(kontrola);
}
