protected void btnVybrat_Click(object sender, EventArgs e)
{
Literal stavbaLiteral = (sender as Button).NamingContainer.FindControl("ltrIdStavby") as Literal;
Literal zpusobLiteral = (sender as Button).NamingContainer.FindControl("ltrTypVytapeni") as Literal;
if (stavbaLiteral != null && zpusobLiteral != null)
{
int.TryParse(stavbaLiteral.Text.ToString(), out stavbaId);
zpusobTyp = zpusobLiteral.Text.ToString();
}
else
{
stavbaId = -1;
zpusobTyp = "";
}
konkretniZpusob = zpusob.Select_id(stavbaId, zpusobTyp);
konkretniStavba = stavba.Select_id(konkretniZpusob.Id_stavby);
object stavbaZpusob = new { konkretniStavba.Id_stavby, konkretniStavba.Typ_stavby, konkretniStavba.Ulice, konkretniStavba.Cislo_popisne, konkretniZpusob.Typ_vytapeni, konkretniZpusob.Platnost_od, konkretniZpusob.Platnost_do };
stavbyZpusoby.Clear();
stavbyZpusoby.Add(stavbaZpusob);
DetailsViewZpusobu.DataSource = stavbyZpusoby;
DetailsViewZpusobu.DataBind();
}
/*
* public static int Insert(Zpusob_vytapeni zpusob_vytapeni)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_INSERT);
* PrepareCommand(command, zpusob_vytapeni);
* int ret = db.ExecuteNonQuery(command);
* db.Close();
* return ret;
* }*/
/*
* public static int Update(Zpusob_vytapeni zpusob_vytapeni)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_UPDATE);
* PrepareCommand(command, zpusob_vytapeni);
* int ret = db.ExecuteNonQuery(command);
* db.Close();
* return ret;
* }*/
/*
* public static int Delete(Zpusob_vytapeni zpusob_vytapeni)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_DELETE);
* PrepareCommand(command, zpusob_vytapeni);
* int ret = db.ExecuteNonQuery(command);
* db.Close();
* return ret;
* }*/
/*
* public static Collection<Zpusob_vytapeni> 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<Zpusob_vytapeni> Zpusoby_vytapeni = Read(reader, false);
* reader.Close();
*
* if (Db == null)
* {
* db.Close();
* }
*
* return Zpusoby_vytapeni;
* }*/
/*
* public static Zpusob_vytapeni Select_id(int idStavba, string zpusobVytapeni, Database Db = null)
* {
* Database db = new Database();
* db.Connect();
* OracleCommand command = db.CreateCommand(SQL_SELECT_ID);
*
* command.Parameters.AddWithValue(":id", idStavba);
* command.Parameters.AddWithValue(":zpusob_vytapeni", zpusobVytapeni);
* OracleDataReader reader = db.Select(command);
*
* Collection<Zpusob_vytapeni> zpusoby_vytapeni = Read(reader, true);
* Zpusob_vytapeni zpusob_vytapeni = null;
* if (zpusoby_vytapeni.Count == 1)
* {
* zpusob_vytapeni = zpusoby_vytapeni[0];
* }
* reader.Close();
* db.Close();
* return zpusob_vytapeni;
* }*/
private static void PrepareCommand(OracleCommand command, Zpusob_vytapeni Zpusob_vytapeni)
{
command.BindByName = true;
command.Parameters.AddWithValue(":zpusob_vytapeni", Zpusob_vytapeni.Typ_vytapeni);
command.Parameters.AddWithValue(":platnost_od", Zpusob_vytapeni.Platnost_od);
command.Parameters.AddWithValue(":platnost_do", Zpusob_vytapeni.Platnost_do == null ? DBNull.Value : (object)Zpusob_vytapeni.Platnost_do);
command.Parameters.AddWithValue(":id_stavby", Zpusob_vytapeni.Id_stavby);
}
public void Delete(Zpusob_vytapeni zpusob_vytapeni)
{
Database db = new Database();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_DELETE);
PrepareCommand(command, zpusob_vytapeni);
int ret = db.ExecuteNonQuery(command);
db.Close();
}
public void Insert(Zpusob_vytapeni zpusob_vytapeni)
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
XElement result = new XElement("Zpusob_vytapeni",
new XAttribute("Typ_vytapeni", zpusob_vytapeni.Typ_vytapeni),
new XAttribute("Platnost_od", zpusob_vytapeni.Platnost_od.ToShortDateString()),
new XAttribute("Platnost_do", zpusob_vytapeni.Platnost_do == null ? DBNull.Value : (object)zpusob_vytapeni.Platnost_do.ToString()),
new XAttribute("Id_stavby", zpusob_vytapeni.Id_stavby));
xDoc.Root.Element("Zpusoby_vytapeni").Add(result);
xDoc.Save(ConstantsXml.FilePath);
}
public void Delete(Zpusob_vytapeni zpusob_vytapeni)
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
var q = from node in xDoc.Descendants("Zpusoby_vytapeni").Descendants("Zpusob_vytapeni")
let attr = node.Attribute("Typ_vytapeni")
let attr1 = node.Attribute("Id_stavby")
where (attr != null && attr.Value == zpusob_vytapeni.Typ_vytapeni) && (attr1 != null && attr1.Value == zpusob_vytapeni.Id_stavby.ToString())
select node;
q.ToList().ForEach(x => x.Attribute("Platnost_do").Value = zpusob_vytapeni.Platnost_do.ToString());
xDoc.Save(ConstantsXml.FilePath);
}
public Zpusob_vytapeni Select_id(int idStavba, string zpusobVytapeni)
{
Collection <Zpusob_vytapeni> vsechnyZpusoby = this.Select();
Zpusob_vytapeni vybranyZpusob = null;
foreach (Zpusob_vytapeni zpusob in vsechnyZpusoby)
{
if (zpusob.Id_stavby == idStavba && zpusob.Typ_vytapeni == zpusobVytapeni)
{
vybranyZpusob = zpusob;
}
}
return(vybranyZpusob);
}
private static Collection <Zpusob_vytapeni> Read(OracleDataReader reader, bool complete)
{
Collection <Zpusob_vytapeni> Zpusoby_vytapeni = new Collection <Zpusob_vytapeni>();
while (reader.Read())
{
int i = -1;
Zpusob_vytapeni Zpusob_vytapeni = new Zpusob_vytapeni();
Zpusob_vytapeni.Typ_vytapeni = reader.GetString(++i);
if (complete)
{
Zpusob_vytapeni.Platnost_od = reader.GetDateTime(++i);
if (!reader.IsDBNull(++i))
{
Zpusob_vytapeni.Platnost_do = reader.GetDateTime(i);
}
}
Zpusob_vytapeni.Id_stavby = reader.GetInt32(++i);
Zpusoby_vytapeni.Add(Zpusob_vytapeni);
}
return(Zpusoby_vytapeni);
}
public Collection <Zpusob_vytapeni> Select()
{
XDocument xDoc = XDocument.Load(ConstantsXml.FilePath);
List <XElement> elementy = xDoc.Descendants("Zpusoby_vytapeni").Descendants("Zpusob_vytapeni").ToList();
Collection <Zpusob_vytapeni> vsechnyZpusoby = new Collection <Zpusob_vytapeni>();
DateTime platnostOd;
DateTime platnostDo;
int idStavby;
foreach (XElement element in elementy)
{
Zpusob_vytapeni zpusob = new Zpusob_vytapeni();
zpusob.Typ_vytapeni = element.Attribute("Typ_vytapeni").Value;
DateTime.TryParse(element.Attribute("Platnost_od").Value, out platnostOd);
try
{
DateTime.TryParse(element.Attribute("Platnost_do").Value, out platnostDo);
zpusob.Platnost_do = platnostDo;
}
catch (Exception e)
{
zpusob.Platnost_do = null;
}
int.TryParse(element.Attribute("Id_stavby").Value, out idStavby);
zpusob.Platnost_od = platnostOd;
zpusob.Id_stavby = idStavby;
vsechnyZpusoby.Add(zpusob);
zpusob = null;
}
return(vsechnyZpusoby);
}
public Zpusob_vytapeni Select_id(int idStavba, string zpusobVytapeni)
{
Database db = new Database();
db.Connect();
OracleCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue(":id", idStavba);
command.Parameters.AddWithValue(":zpusob_vytapeni", zpusobVytapeni);
OracleDataReader reader = db.Select(command);
Collection <Zpusob_vytapeni> zpusoby_vytapeni = Read(reader, true);
Zpusob_vytapeni zpusob_vytapeni = null;
if (zpusoby_vytapeni.Count == 1)
{
zpusob_vytapeni = zpusoby_vytapeni[0];
}
reader.Close();
db.Close();
return(zpusob_vytapeni);
}
