//запись данных в БД
private void button1_Click(object sender, EventArgs e)
{
string phone = maskedTextBox4.Text, mail = maskedTextBox5.Text;
if (phone == "+7- - - -" && mail == " @")
{
MessageBox.Show("Необходимо заполнить одно из полей", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (phone == "+7- - - -")
{
phone = "";
}
if (mail == " @")
{
mail = "";
}
klient klient = new klient(maskedTextBox1.Text, maskedTextBox2.Text, maskedTextBox3.Text, phone, mail);
@base @base = new @base(
"insert into klient (phone, mail) values ('" + klient.get_phone() + "', '" + klient.get_mail() + "') " +
"declare @id int " +
"select @id = MAX(Id) from klient " +
"insert into man (fam, name, otch, dop_info) values (N'" + klient.get_fam() + "', N'" + klient.get_name() + "', N'" + klient.get_oth() + "', @id)");
@base.zapis_v_bd();
MessageBox.Show("Данные записанны");
}
}
private void K_Button_Zatwierdź_Numer_Klienta_Click(object sender, RoutedEventArgs e)
{
Klienci = Klienci.Odczytaj_Klientów_XML("klienci.xml") as klienci;
lista_klientów = new ObservableCollection <klient>(Klienci.Klienci);
bool numer = false;
klient_Window.Numer_klienta = TextBox_Numer_Klienta.Text;
numer = Klienci.sprawdzenie(klient_Window);
Klient_Menu_Window klient_menu = new Klient_Menu_Window();
if (numer)
{
klient_Window = Klienci.Pobierz(klient_Window.Numer_klienta) as klient;
string nazwa = "klient.xml";
XmlSerializer serializer = new XmlSerializer(typeof(klient));
StreamWriter writer = new StreamWriter(nazwa);
serializer.Serialize(writer, klient_Window);
writer.Close();
klient_menu.Show();
}
else
{
MessageBox.Show("Podano zły numer");
}
}
public ActionResult DeleteConfirmed(int id)
{
klient klient = db.klients.Find(id);
db.klients.Remove(klient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id_klient,imie,nazwisko,pesel,email,id_adres")] klient klient)
{
if (ModelState.IsValid)
{
db.Entry(klient).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_adres = new SelectList(db.adres, "id_adres", "miasto", klient.id_adres);
return(View(klient));
}
public ActionResult CreateKlient(klient newKlient)
{
try
{
_db.klients.Add(newKlient);
_db.SaveChanges();
return(RedirectToAction("Klient"));
}
catch
{
return(View(newKlient));
}
}
// GET: klients/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
klient klient = db.klients.Find(id);
if (klient == null)
{
return(HttpNotFound());
}
return(View(klient));
}
// GET: klients/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
klient klient = db.klients.Find(id);
if (klient == null)
{
return(HttpNotFound());
}
ViewBag.id_adres = new SelectList(db.adres, "id_adres", "miasto", klient.id_adres);
return(View(klient));
}
public ActionResult DeleteKlient(klient klientToDelete)
{
try
{
var orginalKlient = _db.klients.Find(klientToDelete.id);
if (!ModelState.IsValid)
{
return(View(orginalKlient));
}
_db.klients.Remove(orginalKlient);
_db.SaveChanges();
return(RedirectToAction("Klient"));
}
catch
{
return(View(klientToDelete));
}
}
public ActionResult EditKlient(klient klientToEdit)
{
var orginalKlient = _db.klients.Find(klientToEdit.id);
try
{
if (TryUpdateModel(orginalKlient,
new string[] { "imie", "nazwisko", "ulica", "miasto", "numer_domu", "kod", "nip", "nr_telefonu" }))
{
_db.SaveChanges();
}
return(RedirectToAction("Klient"));
}
catch
{
return(View(orginalKlient));
}
}
private void Rezerwuj_button_Click(object sender, RoutedEventArgs e)
{
int zaznaczony = listbox_oferta_window.SelectedIndex;
samochody zaznaczony2 = listbox_oferta_window.SelectedItem as samochody;
klient k = new klient();
XmlSerializer serializer = new XmlSerializer(typeof(klient));
StreamReader reader = new StreamReader("klient.xml");
k = serializer.Deserialize(reader) as klient;
reader.Close();
rezerwacja r1 = new rezerwacja();
r1.rezerwuj(zaznaczony2, k);
k.Wypożyczone_klienta(Oferta);
MessageBox.Show("Zarezerwowano:\n" + zaznaczony2);
ls.Add(zaznaczony2);
ZapiszXML(ls);
lista.RemoveAt(zaznaczony);
Oferta.Oferta.Remove(zaznaczony2);
}
public Klient_Window(klient klient) : this()
{
this.klient_Window = klient;
TextBox_Numer_Klienta.Text = klient.Numer_klienta;
}
