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增加一條紀錄"); }