protected void DeleteAll()
{
Collection <Zakaznik> odpadlici = Zakaznik.Requests();
foreach (Zakaznik zakaznik in odpadlici)
{
Zakaznik.delete(zakaznik);
}
GetData();
}
protected void GetData()
{
Collection <Zakaznik> zakaznici = Zakaznik.SelectAll();
Collection <Zakaznik> odpadlici = Zakaznik.Requests();
BindingList <Zakaznik> bindingList = new BindingList <Zakaznik>(zakaznici);
BindingList <Zakaznik> bindingList2 = new BindingList <Zakaznik>(odpadlici);
dataGridView1.DataSource = bindingList;
dataGridView2.DataSource = bindingList2;
}
private static void PrepareCommand(SqlCommand command, Zakaznik zakaznik)
{
command.Parameters.AddWithValue("@cislo_RP", zakaznik.cislo_RP);
command.Parameters.AddWithValue("@jmeno", zakaznik.jmeno);
command.Parameters.AddWithValue("@prijmeni", zakaznik.prijmeni);
command.Parameters.AddWithValue("@mesto", zakaznik.mesto);
command.Parameters.AddWithValue("@ulice", zakaznik.ulice);
command.Parameters.AddWithValue("@cislo_popisne", zakaznik.cislo_popisne);
command.Parameters.AddWithValue("@psc", zakaznik.psc);
command.Parameters.AddWithValue("@email", zakaznik.email);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
Zakaznik pot = Zakaznik.getById(Int32.Parse(TextBox2.Text));
if (pot.Email == TextBox1.Text)
{
Session["login"] = pot;
}
}
}
private Zakaznik GetSelectedZak()
{
// The "SelectionMode" property of the data grid view must be set to "FullRowSelect".
if (zakGrid.SelectedRows.Count == 1)
{
Zakaznik zakaznik = zakGrid.SelectedRows[0].DataBoundItem as Zakaznik;
return(zakaznik);
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
rezervace = new List <Rezervace>();
zakaznici = new List <Zakaznik>();
zakaznik = new Zakaznik();
faktura = new Faktura();
platba = new Platba();
auta = new List <Auto>();
zakaznici = mapper.FindZak();
vsichniZak.DataSource = zakaznici;
vsichniZak.DataBind();
}
public static int Update(Zakaznik zakaznik, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
int returnCommand1, returnCommand2, returnCommand3;
SqlCommand command1 = db.CreateCommand(SQL_UPDATE_KONTAKT);
command1.Parameters.AddWithValue("@tel", zakaznik.tel);
command1.Parameters.AddWithValue("@tel2", zakaznik.tel2);
command1.Parameters.AddWithValue("@email", zakaznik.email);
command1.Parameters.AddWithValue("@idKontakt", zakaznik.idKontakt);
returnCommand1 = db.ExecuteNonQuery(command1);
// mesto = @mesto, ulice = @ulice, cisloPopisne = @cisloPopisne, psc = @psc where idBydliste = @idBydliste;"
SqlCommand command2 = db.CreateCommand(SQL_UPDATE_BYDLISTE);
command2.Parameters.AddWithValue("@mesto", zakaznik.mesto);
command2.Parameters.AddWithValue("@ulice", zakaznik.ulice);
command2.Parameters.AddWithValue("@cisloPopisne", zakaznik.cisloPopisne);
command2.Parameters.AddWithValue("@psc", zakaznik.psc);
command2.Parameters.AddWithValue("@idBydliste", zakaznik.idBydliste);
returnCommand2 = db.ExecuteNonQuery(command2);
// jmeno = @jmeno, prijmeni = @prijmeni where idZakaznik = @idZakaznik
SqlCommand command3 = db.CreateCommand(SQL_UPDATE);
command3.Parameters.AddWithValue("@jmeno", zakaznik.mesto);
command3.Parameters.AddWithValue("@prijmeni", zakaznik.ulice);
command3.Parameters.AddWithValue("@idZakaznik", zakaznik.idZakaznik);
returnCommand3 = db.ExecuteNonQuery(command3);
if (pDb == null)
{
db.Close();
}
return(returnCommand1 & returnCommand2 & returnCommand3);
}
public Zakaznik ToDTO()
{
Zakaznik zakaznik = new Zakaznik()
{
idz = idz,
jmeno = jmeno,
Prijmeni = Prijmeni,
Datum_narozeni = Datum_narozeni,
tel_cislo = tel_cislo,
Email = Email
};
return(zakaznik);
}
protected void EditRecord()
{
Zakaznik selectedZak = GetSelectedZak();
if (selectedZak != null)
{
DetailZakaznik form = new DetailZakaznik();
if (form.OpenRecord(selectedZak.idZak))
{
form.ShowDialog();
GetData();
}
}
}
private void BindData()
{
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
Collection <Prostor> prostory = Prostor.SelectAll();
Collection <Zbran> zbrane = Zbran.SelectAvailable(strelba.Zacatek, strelba.Zacatek.AddMinutes(double.Parse(txtMin.Text)));
Collection <Zakaznik> zakaznici = Zakaznik.SelectAll();
Collection <Zamestnanec> zamestnanci = Zamestnanec.SelectAll();
foreach (Prostor prostor in prostory)
{
comboBox1.Items.Add(prostor.Id.ToString() + " " + prostor.Vzdalenost.ToString() + "m");
if (prostor.Id == strelba.Prostor.Id)
{
comboBox1.SelectedIndex = comboBox1.Items.Count - 1;
}
}
foreach (Zbran zbran in zbrane)
{
comboBox2.Items.Add(zbran.Nazev);
if (zbran.Id == strelba.Zbran.Id)
{
comboBox2.SelectedIndex = comboBox2.Items.Count - 1;
}
}
foreach (Zakaznik zakaznik in zakaznici)
{
comboBox3.Items.Add(zakaznik.Email);
if (zakaznik.Id == strelba.Zakaznik.Id)
{
comboBox3.SelectedIndex = comboBox3.Items.Count - 1;
}
}
foreach (Zamestnanec zamestnanec in zamestnanci)
{
comboBox4.Items.Add(zamestnanec.Email);
if (zamestnanec.Id == strelba.Zamestnanec.Id)
{
comboBox4.SelectedIndex = comboBox4.Items.Count - 1;
}
}
}
public async Task <string> AddOrder(Zakaznik uzivatel, Auto auto)
{
string url = "https://student.sps-prosek.cz/~merxbiv14/prog/";
var client = new RestClient(url);
var request = new RestRequest("prog.php", Method.POST);
request.AddHeader("Content-type", "application/json");
request.AddParameter("koupit", JsonConvert.SerializeObject(uzivatel));
request.AddParameter("auto", JsonConvert.SerializeObject(auto));
IRestResponse response = client.Execute(request);
string persons = response.Content;
return(persons);
}
public void testTabulkyZakaznik(Database db)
{
Console.Out.WriteLine("-------------------------------------------------------------------------------");
Console.Out.WriteLine("Test tabulky Zakaznik:");
Zakaznik zakaznik = new Zakaznik();
zakaznik.jmeno = "Adam";
zakaznik.prijmeni = "Lasák";
zakaznik.tel = 739141091;
zakaznik.tel2 = 0;
zakaznik.email = "*****@*****.**";
zakaznik.mesto = "Kobeřice";
zakaznik.ulice = "Nádražní";
zakaznik.cisloPopisne = 35;
zakaznik.psc = 74727;
EvidenceZakaznika.Insert(zakaznik, db);
Console.Out.WriteLine("Nový zákazník vložen!\n");
Collection <Zakaznik> zakaznici = new Collection <Zakaznik>();
zakaznici = EvidenceZakaznika.Select(db);
Console.Out.WriteLine("Select z tabulky Zakaznik:");
foreach (Zakaznik select in zakaznici)
{
Console.Out.WriteLine("\t" + select.idZakaznik + " " + select.jmeno + " " + select.prijmeni + " " + select.mesto + " " + select.ulice + " " + select.cisloPopisne + " " + select.psc);
}
Console.Out.WriteLine("\nPoslední záznam z tabulky osoba byl upraven! (město, tel. číslo, email)");
zakaznik.tel = 123456789;
zakaznik.email = "*****@*****.**";
zakaznik.mesto = "Opava";
EvidenceZakaznika.Update(zakaznik, db);
Console.Out.WriteLine("\nDetail posledního záznamu z tabulky osoba:");
Zakaznik selectDetail = new Zakaznik();
selectDetail = EvidenceZakaznika.SelectDetail(zakaznik.idZakaznik - 1, db);
Console.Out.WriteLine("\t" + selectDetail.idZakaznik + " " + selectDetail.jmeno + " " + selectDetail.prijmeni + " " + selectDetail.mesto + " " + selectDetail.ulice + " " + selectDetail.cisloPopisne + " " + selectDetail.psc + " " + selectDetail.tel + " " + selectDetail.tel2 + " " + selectDetail.email);
Console.Out.WriteLine("Poslední záznam z tabulky osoba byl odstraněn!");
EvidenceZakaznika.Delete(zakaznik.idZakaznik, db);
Console.Out.WriteLine("-------------------------------------------------------------------------------\n");
Console.ReadKey();
}
public bool OpenRecord(object primaryKey)
{
if (primaryKey != null)
{
int idZak = (int)primaryKey;
zakaznik = Zakaznik.getById(idZak);
newRecord = false;
}
else
{
zakaznik = new Zakaznik();
newRecord = true;
}
BindData();
return(true);
}
private void button2_Click(object sender, EventArgs e)
{
//přidání zakoše
if (seznamZak.SelectedIndex == -1)
{
MessageBox.Show("Nebyl vybrán zákazník!");
}
else
{
string zak = seznamZak.GetItemText(seznamZak.SelectedItem);
string[] udajeZak = zak.Split(' ');
string ridicak = udajeZak[2];
zakaznik = mapper.FindZak(ridicak);
rezervace.idZakaznika = zakaznik.ID;
}
}
private bool GetData()
{
Collection <Zakaznik> zakaznici = Zakaznik.SelectAll();
Collection <Zamestnanec> zamestnanci = Zamestnanec.SelectAll();
Collection <Zbran> zbrane = Zbran.SelectAvailable(DateTime.Now, DateTime.Now.AddMinutes(double.Parse(txtMin.Text)));
Collection <Prostor> prostory = Prostor.SelectAll();
strelba.Zacatek = DateTime.Now;
strelba.Konec = DateTime.Now.AddMinutes(Double.Parse(txtMin.Text));
strelba.Zakaznik = zakaznici[comboBox3.SelectedIndex];
strelba.Zamestnanec = zamestnanci[comboBox4.SelectedIndex];
strelba.Prostor = prostory[comboBox1.SelectedIndex];
strelba.Zbran = zbrane[comboBox2.SelectedIndex];
return(true);
}
private static Zakaznik MapZakToObj(SqlDataReader reader)
{
Zakaznik zakaznik = new Zakaznik();
zakaznik.ID = reader.GetInt32(0);
zakaznik.Jmeno = reader.GetString(1);
zakaznik.Prijmeni = reader.GetString(2);
zakaznik.Mesto = reader.GetString(3);
zakaznik.Ulice = reader.GetString(4);
zakaznik.CisloPopisne = reader.GetInt32(5);
zakaznik.PSC = reader.GetInt32(6);
zakaznik.Email = reader.GetString(7);
zakaznik.cisloRidicskehoPrukazu = reader.GetString(8);
return(zakaznik);
}
public bool OpenRecord(object primaryKey)
{
if (primaryKey != null)
{
int idZak = (int)primaryKey;
zakaznik = ZakaznikTable.select(idZak);
newRecord = false;
}
else
{
zakaznik = new Zakaznik();
zakaznik.Datum_narozeni = new DateTime(2000, 01, 01);
newRecord = true;
}
BindData();
return(true);
}
public static Collection <Zakaznik> ZakazniciKteriNezaplatili(Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_3);
SqlDataReader reader = db.Select(command);
Collection <Zakaznik> zakazky = new Collection <Zakaznik>();
// z.idZakaznik, z.jmeno, z.prijmeni, b.mesto, b.cisloPopisne, b.psc, k.tel, k.tel2, k.email
while (reader.Read())
{
int i = -1;
Zakaznik select = new Zakaznik();
select.idZakaznik = reader.GetInt32(++i);
select.jmeno = reader.GetString(++i);
select.prijmeni = reader.GetString(++i);
select.mesto = reader.GetString(++i);
select.cisloPopisne = reader.GetInt32(++i);
select.psc = reader.GetInt32(++i);
select.tel = reader.GetInt32(++i);
select.tel2 = reader.GetInt32(++i);
select.email = reader.GetString(++i);
zakazky.Add(select);
}
reader.Close();
if (pDb == null)
{
db.Close();
}
return(zakazky);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Zakaznik c = (Zakaznik)Session["login"];
if (c != null)
{
Label1.Text = c.Jmeno;
Label2.Text = c.Prijmeni;
Label3.Text = c.Email;
}
}
if (IsPostBack)
{
Zakaznik c = (Zakaznik)Session["login"];
c.DelRequest();
}
}
protected bool SaveRecord()
{
if (GetData())
{
if (newRecord)
{
Zakaznik.insert(zakaznik);
}
else
{
Zakaznik.update(zakaznik);
}
return(true);
}
else
{
return(false);
}
}
private static Collection <Zakaznik> Read(SqlDataReader reader)
{
Collection <Zakaznik> zakaznici = new Collection <Zakaznik>();
while (reader.Read())
{
Zakaznik zakaznik = new Zakaznik();
int i = -1;
zakaznik.idz = reader.GetInt32(++i);
zakaznik.jmeno = reader.GetString(++i);
zakaznik.Prijmeni = reader.GetString(++i);
zakaznik.Datum_narozeni = reader.GetDateTime(++i);
zakaznik.tel_cislo = reader.GetInt32(++i);
zakaznik.Email = reader.GetString(++i);
zakaznici.Add(zakaznik);
}
return(zakaznici);
}
public int DeleteZak(Zakaznik zakaznik)
{
SqlConnectionStringBuilder builder = DBConnector.GetBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
sb.Clear();
sb.Append("DELETE FROM vis.zakaznik where id_zakaznika = @id");
string sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithValue("@id", zakaznik.ID);
}
}
return(0);
}
private void pridatZakB_Click(object sender, EventArgs e)
{
string cisloR = cisloRPText.Text;
if (new ZakaznikTable().select(cisloR) != null)
{
zakaznik = new ZakaznikTable().select(cisloR);
rezervace.cislo_rp = cisloR;
rekapR.Items.RemoveAt(5);
rekapR.Items.Insert(5, cisloR);
rekapR.Items.RemoveAt(7);
rekapR.Items.Insert(7, zakaznik.CeleJmeno);
pridatZakB.Enabled = false;
odebratZakB.Enabled = true;
}
else
{
MessageBox.Show("Takový zákazník není v systému");
}
}
private static Collection <Zakaznik> CtiZakaznika(SqlDataReader reader, bool select)
{
Collection <Zakaznik> zakaznici = new Collection <Zakaznik>();
// z.idZakaznik, z.jmeno, z.prijmeni, b.mesto, b.cisloPopisne, b.psc
// z.idZakaznik, z.jmeno, z.prijmeni, b.mesto, b.cisloPopisne, b.psc, k.tel, k.tel2, k.email
while (reader.Read())
{
int i = -1;
Zakaznik zakaznik = new Zakaznik();
if (select) // jednoduchy vypis
{
zakaznik.idZakaznik = reader.GetInt32(++i);
zakaznik.jmeno = reader.GetString(++i);
zakaznik.prijmeni = reader.GetString(++i);
zakaznik.mesto = reader.GetString(++i);
zakaznik.ulice = reader.GetString(++i);
zakaznik.cisloPopisne = reader.GetInt32(++i);
zakaznik.psc = reader.GetInt32(++i);
}
else // vypis s detailem
{
zakaznik.idZakaznik = reader.GetInt32(++i);
zakaznik.jmeno = reader.GetString(++i);
zakaznik.prijmeni = reader.GetString(++i);
zakaznik.mesto = reader.GetString(++i);
zakaznik.cisloPopisne = reader.GetInt32(++i);
zakaznik.psc = reader.GetInt32(++i);
zakaznik.tel = reader.GetInt32(++i);
zakaznik.tel2 = reader.GetInt32(++i);
zakaznik.email = reader.GetString(++i);
}
// if (!reader.IsDBNull(++i))
zakaznici.Add(zakaznik);
}
return(zakaznici);
}
private static Collection <Zakaznik> Read(SqlDataReader reader)
{
Collection <Zakaznik> zakazniks = new Collection <Zakaznik>();
while (reader.Read())
{
int i = -1;
Zakaznik zakaznik = new Zakaznik();
zakaznik.cislo_RP = reader.GetString(++i);
zakaznik.jmeno = reader.GetString(++i);
zakaznik.prijmeni = reader.GetString(++i);
zakaznik.mesto = reader.GetString(++i);
zakaznik.ulice = reader.GetString(++i);
zakaznik.cislo_popisne = reader.GetInt32(++i);
zakaznik.psc = reader.GetInt32(++i);
zakaznik.email = reader.GetString(++i);
zakazniks.Add(zakaznik);
}
return(zakazniks);
}
public Zakaznik FindZak(string ridicak)
{
string sql = ("Select * from vis.Zakaznik where cislo_ridickeho_prukazu = @ridicak");
Zakaznik zakaznik = null;
using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@ridicak", ridicak);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
zakaznik = MapZakToObj(reader);
}
}
}
}
return(zakaznik);
}
public Zakaznik FindZak(int id)
{
string sql = ("Select * from vis.Zakaznik where id_zakaznika = @id");
Zakaznik zakaznik = null;
using (SqlConnection connection = new SqlConnection(DBConnector.GetBuilder().ConnectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(sql, connection))
{
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
zakaznik = MapZakToObj(reader);
}
}
}
}
return(zakaznik);
}
/// <summary>
/// Rozprasuje xml dokument s univerzitama
/// </summary>
public override void ZiskejData()
{
Zakaznik zakaznik;
XmlNode lRoot = dokument.DocumentElement;
//pruchod vnorenymi uzly korenoveho elementu
foreach (XmlNode lNode in lRoot.ChildNodes)
{
if (lNode.Name.Equals("nasazeniAplikace"))
{
zakaznik = new Zakaznik();
//ziskani atributu konkretniho elementu
XmlNodeList univerzita = lNode.ChildNodes;
foreach (XmlNode childNode in univerzita)
{
switch (true)
{
case bool b when childNode.Name.Equals("celyNazevSkoly"):
zakaznik.NazevSkoly = childNode.FirstChild.Value;;
break;
case bool b when childNode.Name.Equals("url"):
zakaznik.UrlSkoly = childNode.FirstChild.Value;
break;
case bool b when childNode.Name.Equals("provozniServer"):
zakaznik.UrlSkoly = childNode.FirstChild.Value;
if (childNode.FirstChild.Value.Equals("A"))
{
Uzivatel.Zakaznici.Add(zakaznik);
}
break;
}
}
}
}
}
public static Zakaznik Detail(int idZ)
{
var db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SqlSelectById);
command.Parameters.AddWithValue("@idZ", idZ);
SqlDataReader reader = db.Select(command);
Collection <Zakaznik> zakaznici = Read(reader);
Zakaznik zakaznik = null;
if (zakaznici.Count == 1)
{
zakaznik = zakaznici[0];
}
reader.Close();
db.Close();
return(zakaznik);
}
private void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string zak = listZaks.SelectedItem.ToString();
string[] jp = zak.Split(' ');
int id = Int32.Parse(jp[0]);
string jmeno = jp[1];
string prijmeni = jp[2];
Zakaznik zakaznik = mapper.FindZak(id);
List <Rezervace> rezervaces = new List <Rezervace>();
rezervaces = mapper.FindRezZ(zakaznik.ID);
BindingSource binding = new BindingSource();
binding.DataSource = rezervaces;
zakInfoR.DataSource = binding;
/*foreach(PropertyDescriptor descriptor in TypeDescriptor.GetProperties(zakaznik))
* {
* object value = descriptor.GetValue(zakaznik);
* infoOZak.Items.Add(value);
* }*/
infoOZak.Items.Clear();
infoOZak.Items.Add("ID zákazníka - " + zakaznik.ID);
infoOZak.Items.Add("Jméno a Příjmení - " + zakaznik.Jmeno + " " + zakaznik.Prijmeni);
infoOZak.Items.Add("Adresa - " + zakaznik.Mesto + " " + zakaznik.Ulice + " " + zakaznik.CisloPopisne);
infoOZak.Items.Add("PSČ - " + zakaznik.PSC);
infoOZak.Items.Add("Email - " + zakaznik.Email);
infoOZak.Items.Add("Číslo řidičského průkazu - " + zakaznik.cisloRidicskehoPrukazu);
}
