public void Search(string textSearch, ComboBox cb, ListBox lb)
{
USer user = new USer();
UserID = user.UserID;
string condition = textSearch;
int categoryID = int.Parse((cb.SelectedItem as ComboBoxItem).Value.ToString());
lb.DataSource = null;
using (AnnonserEntities1 db = new AnnonserEntities1())
{
List <Advert> adverts;
if (categoryID == 0)
{
adverts = db.Adverts.Where(a => a.Title.Contains(condition)).ToList();
}
else
{
adverts = db.Adverts.Where(a => a.Title.Contains(condition) && a.CategoryID == categoryID).ToList();
}
lb.DisplayMember = "Title";
lb.DataSource = adverts;
}
}
public string GetCategoryName(int?categoryId)
{
using (AnnonserEntities1 db = new AnnonserEntities1())
{
Category category = db.Categories.Where(x => x.CategoryID == categoryId).SingleOrDefault();
if (category != null)
{
return(category.Categoryname);
}
else
{
return("");
}
}
}
public string GetUsername(int userId)
{
using (AnnonserEntities1 db = new AnnonserEntities1())
{
USer user = db.USers.Where(x => x.UserID == userId).SingleOrDefault();
if (user != null)
{
return($"{user.Firstname} {user.Lastname}");
}
else
{
return("");
}
}
}
public int GetUSerID(string username, string password)
{
using (AnnonserEntities1 db = new AnnonserEntities1())
{
USer user = db.USers.Where(x => x.Username == username && x.Password == password).SingleOrDefault();
if (user != null)
{
return(user.UserID);
}
else
{
MessageBox.Show("User not found.");
return(0);
}
}
}
public int Login(string username, string password)
{
using (AnnonserEntities1 db = new AnnonserEntities1())
{
USer user = db.USers.Where(x => x.Username == username && x.Password == password).SingleOrDefault();
if (user != null)
{
return(user.UserID);
}
else
{
MessageBox.Show("Inloggning misslyckades");
return(0);
}
}
}
public void ListBoxSelect(ListBox lb, TextBox description, TextBox titel, TextBox price, TextBox location, TextBox seller)
{
if (lb.SelectedValue != null)
{
string firstname = seller.Text;
using (AnnonserEntities1 db = new AnnonserEntities1())
{
int advertID = int.Parse(lb.SelectedValue.ToString());
Advert advert = db.Adverts.Where(s => s.AdID == advertID).SingleOrDefault();
description.Text = advert.Description;
titel.Text = advert.Title;
price.Text = (advert.Price).ToString();
location.Text = advert.Location;
seller.Text = ur.GetUsername(advert.UserID);
}
}
}
