private void btn_sacuvaj_Click(object sender, RoutedEventArgs e)
{
int broj = Convert.ToInt32(tb_sifNaloga.Text);
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
try
{
var podaciDC = from x in DC.RadNalogs where x.sifraNaloga == broj select x;
foreach (RadNalog rn in podaciDC)
{
rn.status = ((ComboBoxItem)comboBox.SelectedItem).Content.ToString();
rn.opisKva = new TextRange(rtb_opisKvara.Document.ContentStart, rtb_opisKvara.Document.ContentEnd).Text;
rn.rezDel = new TextRange(rtb_spisakDelova.Document.ContentStart, rtb_spisakDelova.Document.ContentEnd).Text;
rn.spisPoslova = new TextRange(rtb_spisakPoslova.Document.ContentStart, rtb_spisakPoslova.Document.ContentEnd).Text;
}
DC.SubmitChanges();
MessageBox.Show("Uspesno ste izvrsili izmene!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception)
{
MessageBox.Show("errror", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btn_dodaj_Click(object sender, RoutedEventArgs e)
{
bool pom = false;
ServisRacunaraDataContext s = new ServisRacunaraDataContext();
try
{
RezervniDeo rd = new RezervniDeo();
rd.barkod = Convert.ToInt32(tb_barkod.Text);
rd.marka = ((ComboBoxItem)cb_marka.SelectedItem).Content.ToString();
rd.vrsta = ((ComboBoxItem)cb_vrsta.SelectedItem).Content.ToString();
rd.model = tb_model.Text;
rd.kolicina = Convert.ToInt32(tb_kolicina.Text);
rd.cena = Convert.ToInt32(tb_cena.Text);
s.RezervniDeos.InsertOnSubmit(rd);
s.SubmitChanges();
pom = true;
}
catch (Exception)
{
MessageBox.Show("Barkod vec postoji u bazi!", "Obavestenje!", MessageBoxButton.OK, MessageBoxImage.Error);
}
if (pom)
{
MessageBox.Show("Uspesno ste ubacili novi rezervni deo u bazu!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}
private void btn_kreirajZahtev_Click(object sender, RoutedEventArgs e)
{
bool pom = false;
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
try
{
ZahtevServ zs = new ZahtevServ();
zs.serviser = lbl_serviser.Content.ToString();
zs.datum = lbl_vreme.Content.ToString();
zs.tekst = new TextRange(rtb_zahtev.Document.ContentStart, rtb_zahtev.Document.ContentEnd).Text;
DC.ZahtevServs.InsertOnSubmit(zs);
DC.SubmitChanges();
pom = true;
}
catch (Exception)
{
}
if (pom)
{
MessageBox.Show("Uspesno ste kreirali zahtev!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btn_sacuvaj_Click(object sender, RoutedEventArgs e)
{
int broj = Convert.ToInt32(tb_barkod.Text);
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
try
{
var podaciDC = from x in DC.RezervniDeos where x.barkod == broj select x;
foreach (RezervniDeo rd in podaciDC)
{
rd.cena = Convert.ToInt32(tb_cena.Text);
rd.kolicina = Convert.ToInt32(tb_kolicina.Text);
rd.model = tb_model.Text;
rd.marka = ((ComboBoxItem)cb_marka.SelectedItem).Content.ToString();
rd.vrsta = ((ComboBoxItem)cb_vrsta.SelectedItem).Content.ToString();
}
DC.SubmitChanges();
MessageBox.Show("Uspesno ste izvrsili izmene!", "Obavestenje!", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
catch (Exception)
{
MessageBox.Show("Dosle je do greske prilikom snimanja!", "Obavestenje!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btn_brisi_Click(object sender, RoutedEventArgs e)
{
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
ZahtevServ rc = (from x in DC.ZahtevServs where x.brZahteva == broj select x).SingleOrDefault();
DC.ZahtevServs.DeleteOnSubmit(rc);
DC.SubmitChanges();
MessageBox.Show("Zahtev je uspesno obrisan!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
private void button_Click(object sender, RoutedEventArgs e)
{
int broj = Convert.ToInt32(tb_sifraRacuna.Text);
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
RacunVlasnika rc = (from x in DC.RacunVlasnikas where x.sifraRacuna == broj select x).SingleOrDefault();
DC.RacunVlasnikas.DeleteOnSubmit(rc);
DC.SubmitChanges();
MessageBox.Show("Racuna je uspesno obrisan!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
private void btn_sacuvaj_Click(object sender, RoutedEventArgs e)
{
bool pom = false;
ServisRacunaraDataContext s = new ServisRacunaraDataContext();
try
{
RadNalog rn = new RadNalog();
rn.radnik = tb_imeRadnika.Text;
rn.vreme = tb_vreme.Text;
rn.sifraNaloga = Convert.ToInt32(tb_sifNaloga.Text);
rn.status = ((ComboBoxItem)comboBox.SelectedItem).Content.ToString();
rn.imePrezime = tb_imePrezime.Text;
rn.brLicne = Convert.ToInt32(tb_brLicne.Text);
rn.adresa = tb_adresa.Text;
rn.mail = tb_mail.Text;
rn.telefon = tb_telefon.Text;
rn.sifraRac = tb_sifRacunara.Text;
rn.opisPro = new TextRange(rtb_opisProb.Document.ContentStart, rtb_opisProb.Document.ContentEnd).Text;
s.RadNalogs.InsertOnSubmit(rn);
s.SubmitChanges();
pom = true;
}
catch (Exception)
{
MessageBox.Show("Sifra radnog naloga vec postoji, morate uzeti drugu!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Error);
}
if (pom)
{
MessageBox.Show("Uspesno ste kreirali radni nalog!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
tb_adresa.Clear();
tb_brLicne.Clear();
tb_imePrezime.Clear();
tb_mail.Clear();
tb_sifNaloga.Clear();
tb_sifRacunara.Clear();
tb_telefon.Clear();
rtb_opisProb.Document.Blocks.Clear();
comboBox.SelectedIndex = -1;
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
bool pom = false;
ServisRacunaraDataContext DC = new ServisRacunaraDataContext();
try
{
RacunVlasnika rv = new RacunVlasnika();
rv.sifraNaloga = Convert.ToInt32(cb.SelectedValue.ToString());
rv.radnik = tb_imeRadnika.Text;
rv.vreme = tb_vreme.Text;
rv.imePrezime = tb_imePrezime.Text;
rv.brLicne = Convert.ToInt32(tb_brLicne.Text);
rv.telefon = tb_telefon.Text;
rv.mail = tb_mail.Text;
rv.sifraRac = tb_sifRacunara.Text;
rv.opisKva = new TextRange(rtb_opisKvara.Document.ContentStart, rtb_opisKvara.Document.ContentEnd).Text;
rv.spisPoslova = new TextRange(rtb_SpisakPoslova.Document.ContentStart, rtb_SpisakPoslova.Document.ContentEnd).Text;
rv.rezDel = new TextRange(rtb_SpisakRezDel.Document.ContentStart, rtb_SpisakRezDel.Document.ContentEnd).Text;
rv.cenaDelova = tb_cenaDelova.Text;
rv.cenaUsluga = tb_cenaUsluga.Text;
rv.cenaUkupna = tb_ukupnaCena.Text;
DC.RacunVlasnikas.InsertOnSubmit(rv);
DC.SubmitChanges();
pom = true;
}
catch (Exception)
{
MessageBox.Show("Doslo je do greskee!");
}
if (pom)
{
MessageBox.Show("Uspesno ste kreirali racun!", "Obavestenje", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}