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();
}
