public Aru Update(Aru entity) { using (SqlConnection connection = new SqlConnection(Connection.String)) { SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "AruUpdate"; command.Parameters.Add(new SqlParameter("@Id", entity.Id)); command.Parameters.Add(new SqlParameter("@Nev", entity.Nev)); command.Parameters.Add(new SqlParameter("@Leiras", entity.Leiras)); command.Parameters.Add(new SqlParameter("@Mennyiseg", entity.Mennyiseg)); command.Parameters.Add(new SqlParameter("@Ar", entity.Ar)); command.Parameters.Add(new SqlParameter("@Kep", entity.Kep)); connection.Open(); int result = (int)command.ExecuteNonQuery(); if (result < 1) { throw new Exception("Error in UpdateAru stored procedure."); } return(entity); } }
private void data_download() { var res = from i in context.Raktars orderby i.Kategoria, i.Marka, i.Termek_nev descending select i; foreach (var i in res) { Aru keszlet_sor = new Aru(); keszlet_sor.ID = Convert.ToInt32(i.ID); keszlet_sor.Termek = i.Termek.ToString(); keszlet_sor.Keszlet_db = Convert.ToInt32(i.keszlet_db); keszlet_sor.Egysegar_ft = Convert.ToInt32(i.Egysegar_ft); keszlet_sor.Kategoria = i.Kategoria.ToString(); keszlet_sor.Marka = i.Marka.ToString(); keszlet_sor.Termek_nev = i.Termek_nev.ToString(); keszlet_sor.Kiirasra = false; keszlet_sor.KeszletErtek = keszlet_sor.Egysegar_ft * keszlet_sor.Keszlet_db; aru_lista.Add(keszlet_sor); if (osszesKat.Contains(i.Kategoria.ToString()) == false) { osszesKat.Add(i.Kategoria.ToString()); } } }
public Aru GetByName(string nev) { Aru result = null; using (SqlConnection connection = new SqlConnection(Connection.String)) { SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "AruGetByName"; command.Parameters.Add(new SqlParameter("@Nev", nev)); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { result = Mapentity(reader); } } } return(result); }
private void Lekeres_Click(object sender, RoutedEventArgs e) { if (UgyfelCB.SelectedItem == null || VasaroltAruCB.SelectedItem == null || darabCB.SelectedItem == null || _aruService.Elerheto(int.Parse(VasaroltAruCB.SelectedItem.ToString().Split(' ')[0])) == 0 || HataridoDP.SelectedDate == null) { MessageBox.Show("Kötelező minden elemet kiválasztani!"); return; } teljesarL.Content = ""; Kapcsolat temp = new Kapcsolat(); temp.UgyfelID = _ugyfelService.GetByID(int.Parse(UgyfelCB.SelectedItem.ToString().Split(' ')[0])).ResponseObject.Id; temp.AruID = _aruService.GetByID(int.Parse(VasaroltAruCB.SelectedItem.ToString().Split(' ')[0])).ResponseObject.Id; temp.Darab = int.Parse(darabCB.SelectedItem.ToString()); temp.HatarIdo = DateTime.Parse(HataridoDP.SelectedDate.ToString()); temp.TeljesAr = Convert.ToInt16(_aruService.GetByID(int.Parse(VasaroltAruCB.SelectedItem.ToString().Split(' ')[0])).ResponseObject.Ar) * int.Parse(darabCB.SelectedItem.ToString()); DateTime val = _kapcsolatService.Create(temp).ResponseObject.Datum; if (val != null) { Aru gep = new Aru(_aruService.GetByID(temp.AruID).ResponseObject); gep.Mennyiseg -= temp.Darab; _aruService.Update(gep); MessageBox.Show("Sikeres vásárlás rögzítés!"); Frissit(int.Parse(VasaroltAruCB.SelectedItem.ToString().Split(' ')[0])); FeltoltLista(); } else { MessageBox.Show("Hiba a vásárlás rögzítésében!"); } }
private Aru Mapentity(SqlDataReader data) { Aru result = new Aru(); result.Id = int.Parse(data["Id"].ToString()); result.Nev = data["Nev"].ToString(); result.Leiras = data["Leiras"].ToString(); result.Mennyiseg = int.Parse(data["Mennyiseg"].ToString()); result.Ar = int.Parse(data["Ar"].ToString()); result.Kep = data["Kep"].ToString(); return(result); }
private void Felvitel_Click(object sender, RoutedEventArgs e) { string richText = new TextRange(LeirasTB.Document.ContentStart, LeirasTB.Document.ContentEnd).Text; if (NevTB.Text == "" || richText == "" || ArTB.Text == "" || DarabTB.Text == "" || KepTB.Text == "") { MessageBox.Show("Minden mező kitöltése kötelező!"); return; } if (System.Text.RegularExpressions.Regex.IsMatch(ArTB.Text, "[^0-99]") || int.Parse(ArTB.Text) < 0) { MessageBox.Show("Hibás a bevitt érték!"); ArTB.BorderBrush = Brushes.Red; } else if (System.Text.RegularExpressions.Regex.IsMatch(DarabTB.Text, "[^0-99]") || int.Parse(DarabTB.Text) < 0) { MessageBox.Show("Hibás a bevitt érték!"); DarabTB.BorderBrush = Brushes.Red; } else { Aru entity = new Aru() { Nev = NevTB.Text, Leiras = richText, Mennyiseg = int.Parse(DarabTB.Text), Ar = int.Parse(ArTB.Text), Kep = KepTB.Text }; ResponseMessage <Aru> request = _aruService.Create(entity); if (!request.IsSuccess) { MessageBox.Show(_aruService.Create(entity).ErrorMessage); return; } MessageBox.Show("Sikeres árufelvitel!"); NevTB.Text = ""; LeirasTB.Document.Blocks.Clear(); ArTB.Text = ""; DarabTB.Text = ""; KepTB.Text = ""; ArTB.BorderBrush = Brushes.Gray; DarabTB.BorderBrush = Brushes.Gray; } }
public ResponseMessage <Aru> Update(Aru entity) { ResponseMessage <Aru> response = new ResponseMessage <Aru>(); try { response.ResponseObject = _aruRepository.Update(entity); response.IsSuccess = true; response.ErrorMessage = "Success"; } catch (Exception ex) { response.IsSuccess = false; response.ErrorMessage = ex.Message; } return(response); }
public MainWindow() { DataContext = new Aru(); InitializeComponent(); }