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 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);
}
}
}
static void Main(string[] args)
{
USer uSer = new USer();
Department department = new Department();
//Ifactory factory = new sqlServerFactory();
//IUser iu = factory.CreateUser();
IUser iu = DataAccess.CreateUser();
iu.Insert(uSer);
iu.GetUser(1);
//IDepartment id = factory.CreatDepartment();
IDepartment id = DataAccess.CreateDepartment();
id.Insert(department);
id.GetDepartment(1);
Console.Read();
}
public void Insert(USer user)
{
Console.WriteLine("在Access中給User增加一條紀錄");
}
public void Insert(USer user)
{
Console.WriteLine("在SQL Server中給User增加一條紀錄");
}
