public void Init() { using (var session = SessionManager.BuildSessionFactory().OpenSession()) { using (var tx = session.BeginTransaction()) { IRepository repository = new NHibernateRepository(session); var admin = repository.Query<User>() .FirstOrDefault(u => u.Username == "admin") ?? new User(); admin.Username = "******"; admin.Password = "******"; admin.Email = "*****@*****.**"; admin.Role = "admin"; repository.Save(admin); var anon = repository.Query<User>() .FirstOrDefault(u => u.Username == "anonymous") ?? new User(); anon.Username = "******"; anon.Password = ""; anon.Role = "user"; repository.Save(anon); tx.Commit(); } session.Close(); } }
public void InsertNewItem() { NHibernateRepository repo = new NHibernateRepository(); int oldCount = repo.Query <Item>().Count; var item2 = new Item() { asset = "3143", campusCode = 8, description = "This is a good one", bldg = "332-00445", room = "312B", otherLocation = "otherlocation", acqDate = new DateTime(2008, 8, 29), totalCost = Convert.ToDecimal(330044.04), Model = "Model", serialNumber = "FFF00000422", isDelete = false, comments = "comments", }; IList <Staff> st = repo.Query <Staff>(); item2.Staffs = st[0]; repo.SaveOrUpdate(item2); Assert.AreEqual(repo.Query <Item>().Count, oldCount + 1); }
public void Init() { using (var session = SessionManager.BuildSessionFactory().OpenSession()) { using (var tx = session.BeginTransaction()) { IRepository repository = new NHibernateRepository(session); var admin = repository.Query <User>() .FirstOrDefault(u => u.Username == "admin") ?? new User(); admin.Username = "******"; admin.Password = "******"; admin.Email = "*****@*****.**"; admin.Role = "admin"; repository.Save(admin); var anon = repository.Query <User>() .FirstOrDefault(u => u.Username == "anonymous") ?? new User(); anon.Username = "******"; anon.Password = ""; anon.Role = "user"; repository.Save(anon); tx.Commit(); } session.Close(); } }
public void TestBasicQueryableForSession() { AnEntity ent = AnEntity.CreateSome(); sut.Save(ent); var result = from AnEntity en in sut.Query() where en.Name == ent.Name select en; Assert.That(result.Count(), Is.EqualTo(1)); }
private void ItemView_Load(object sender, EventArgs e) { if (isAddNew) { Addbtn.Enabled = true; Updatebtn.Enabled = false; IList <Staff> staffs = repo.Query <Staff>(); staffName = new string[staffs.Count]; index = 0; for (int i = 0; i < staffs.Count; i++) { staffName[i] = staffs[i].lastName + "," + staffs[i].firstName; } staffcomboBox.DataSource = staffName; staffcomboBox.SelectedItem = staffName[index]; isbinding = true; } else { Addbtn.Enabled = false; Updatebtn.Enabled = true; assettextBox.Text = it.asset; campusCodetextBox.Text = it.campusCode.ToString(); bldgtextBox.Text = it.bldg; roomtextBox.Text = it.room; dateTimePicker.Value = it.acqDate; costtextBox.Text = it.totalCost.ToString(); descriptiontextBox.Text = it.description; modeltextBox.Text = it.Model; otherLocationtextBox.Text = it.otherLocation; serialNumbertextBox.Text = it.serialNumber; Staff staff = it.Staffs; commentstextBox.Text = it.comments; IList <Staff> staffs = repo.Query <Staff>(); staffName = new string[staffs.Count]; index = 0; for (int i = 0; i < staffs.Count; i++) { staffName[i] = staffs[i].lastName + "," + staffs[i].firstName; if (staffs[i].firstName == it.Staffs.firstName && staffs[i].lastName == it.Staffs.lastName) { index = i; } } staffcomboBox.DataSource = staffName; staffcomboBox.SelectedItem = staffName[index]; isbinding = true; //staffcomboBox.ValueMember = it.Staffs.firstName + "," + it.Staffs.lastName; } }
public void Update() { NHibernateRepository repo = new NHibernateRepository(); IList <Staff> st = repo.Query <Staff>(); st[0].groupCode = "1345655"; repo.Update(st[0]); int id = st[0].staffID; Assert.AreEqual("13456", repo.Query <Staff>()[0].groupCode); }
public void QueryByCriteria() { NHibernateRepository repo = new NHibernateRepository(); var staffs = repo.Query <Staff>(Expression.Eq("staffID", 54)); Assert.AreEqual(1, staffs.Count); }
private void InventoryPage_Load(object sender, EventArgs e) { if (!user.IsAuthorized) { addBtn.Enabled = false; deleteBtn.Enabled = false; editBtn.Enabled = false; userAddBtn.Enabled = false; clearCheckedBtn.Enabled = false; backupBtn.Enabled = false; } NHibernateRepository repo = new NHibernateRepository(); if (tabControl.SelectedTab == tabControl.TabPages[0]) { showAllItems(repo); } editBtn.Enabled = false; IList <Staff> staffs = repo.Query <Staff>(); string[] staffName = new string[staffs.Count]; for (int i = 0; i < staffs.Count; i++) { staffName[i] = staffs[i].lastName + "," + staffs[i].firstName; } staffcomboBox.DataSource = staffName; }
private void AddBtn_Click(object sender, EventArgs e) { NHibernateRepository repo = new NHibernateRepository(); if (passwordtextBox.Text != confirmPasswordtextBox.Text) { MessageBox.Show("Please enter the same passord"); return; } if (userNametextBox.Text != "") { var users = repo.Query <User>(Expression.Eq("Name", userNametextBox.Text)); if (users.Count > 0) { MessageBox.Show("This user has already existed!"); return; } else { var newUser = new User { Name = userNametextBox.Text, Password = passwordtextBox.Text, IsAuthorized = authorizedcheckBox.Checked }; repo.Save(newUser); this.DialogResult = DialogResult.OK; this.Close(); return; } } }
public void showAllItems(NHibernateRepository repo) { IList <Item> items = null; if (expressions.Count > 0) { IList <ICriterion> localExpressions = new List <ICriterion>(expressions); items = repo.Query <Item>(localExpressions.ToArray()); } else { items = repo.Query <Item>(Expression.Eq("isDelete", false)); } List <Object> showedItems = new List <Object>(); Image smallImage = Image.FromFile("./Resources/img_icon.png"); var pic = ImageToByteArray(smallImage); for (int i = 0; i < items.Count; ++i) { Item item = items[i]; if (item.isDelete) { continue; } showedItems.Add(new ViewItem { IsChecked = item.isChecked, Asset = item.asset, Building = item.bldg, Room = item.room, SerialNumber = item.serialNumber, CampusCode = item.campusCode, Description = item.description, TotalCost = item.totalCost, OtherLocation = item.otherLocation, Model = item.Model, Picture = pic }); } this.curItems = showedItems; showPage(0); //itemsDataGridView.DataSource = showedItems; return; }
private void Addbtn_Click(object sender, EventArgs e) { Staff newStaff = new Staff(); if (firstNametextBox.Text != "" && lastNametextBox.Text != "" && groupCodetextBox.Text != "") { ICriterion criterion = Expression.Eq("groupCode", groupCodetextBox.Text); IList <Staff> testExistSameGroupCode = repo.Query <Staff>(criterion); if (testExistSameGroupCode.Count == 0) { newStaff.firstName = firstNametextBox.Text; newStaff.lastName = lastNametextBox.Text; newStaff.groupCode = groupCodetextBox.Text; } else { MessageBox.Show("this groupCode is used, you can't use this groupCode"); return; } } else { MessageBox.Show("Please check what you entered!"); return; } //do we need to check format??????????? if (phonetextBox.Text != "") { newStaff.phone = phonetextBox.Text; } if (emailtextBox.Text != "") { newStaff.email = emailtextBox.Text; } if (locationtextBox.Text != "") { newStaff.location = locationtextBox.Text; } repo.SaveOrUpdate(newStaff); this.DialogResult = DialogResult.OK; this.Close(); return; }
public void QueryUser() { var repo = new NHibernateRepository(); var users = repo.Query <User>(Expression.Eq("Name", "admin")); Assert.AreEqual(0, users.Count); User u = new User() { Name = "admin", Password = "******" }; repo.Save(u); }
private static LMConnect.Key.User OnValidationDelegate(string userName, string password) { using (ISession session = MvcApplication.SessionFactory.OpenSession()) { var repo = new NHibernateRepository(session); var user = repo.Query<LMConnect.Key.User>() .FirstOrDefault(u => u.Username == userName && u.Password == password); session.Close(); return user; } }
private static LMConnect.Key.User OnValidationDelegate(string userName, string password) { using (ISession session = MvcApplication.SessionFactory.OpenSession()) { var repo = new NHibernateRepository(session); var user = repo.Query <LMConnect.Key.User>() .FirstOrDefault(u => u.Username == userName && u.Password == password); session.Close(); return(user); } }
private IEnumerable <User> GetData() { User[] users; using (var sourceSession = SessionManager.BuildSessionFactory().OpenSession()) { IRepository repository = new NHibernateRepository(sourceSession); users = repository.Query <User>().ToArray(); sourceSession.Close(); } return(users); }
private void userNametextBox_TextChanged(object sender, EventArgs e) { if (!isAddNewUser && isLoad) { NHibernateRepository repo = new NHibernateRepository(); var users = repo.Query <User>(Expression.Eq("Name", userNametextBox.Text)); if (users.Count != 0) { MessageBox.Show("This username has already existed!"); return; } else { user.Name = userNametextBox.Text; } } }
public void showAllStaffs(NHibernateRepository repo) { var staffs = repo.Query <Staff>(); var showedStaffs = from staff in staffs let showedStaff = new { lastname = staff.lastName, firstname = staff.firstName, groupcode = staff.groupCode, email = staff.email, phone = staff.phone, location = staff.location } select showedStaff; staffDataGridView.DataSource = showedStaffs.ToList(); return; }
public void TestConnection() { var staff = new Staff() { groupCode = "GroupCode", lastName = "11Hello", firstName = "22World", email = "*****@*****.**", phone = "979979979", location = "HRBBf" }; NHibernateRepository repo = new NHibernateRepository(); //repo.DeleteByQuery("from Staff s"); repo.SaveOrUpdate(staff); Assert.AreEqual(repo.Query <Staff>().Count, 1); }
private bool validateUser(String userName, String password) { //if (userName == "admin" && password =="admin") // return true; //else // return false; var repo = new NHibernateRepository(); var users = repo.Query <User>(Expression.Eq("Name", userName)); if (1 != users.Count) { return(false); } if (users[0].Password != password) { return(false); } return(true); }
private void LoginBtn_Click(object sender, EventArgs e) { var repo = new NHibernateRepository(); ICriterion[] expressions = new ICriterion[2]; expressions[0] = Expression.Eq("Name", userNameTextbox.Text); expressions[1] = Expression.Eq("Password", pwdTextbox.Text); var users = repo.Query <User>(expressions); if (users.Count != 1) { CCWin.MessageBoxEx.Show("Username/password is incorrect!", "Error", MessageBoxButtons.OK); return; } user = users[0]; this.DialogResult = DialogResult.OK; this.Close(); //InventoryPage inventoryPage = new InventoryPage(); //inventoryPage.Show(); return; }
private void searchBtn_Click(object sender, EventArgs e) { // NHibernateRepository repo = new NHibernateRepository(); if (tabControl.SelectedTab == tabControl.TabPages[0]) { string name = staffcomboBox.SelectedItem.ToString(); expressions = new List <ICriterion>(); if (name != "All,") { char[] ch = new char[name.Length]; ch = name.ToCharArray(); int i; for (i = 0; i < name.Length; i++) { if (ch[i] == ',') { break; } } string lastName = name.Substring(0, i); string firstName = name.Substring(i + 1, name.Length - i - 1); var staffs = repo.Query <Staff>(Expression.Eq("staffID", -1)); if (lastName == "None" && firstName == "None") { expressions.Add(Expression.Eq("Staffs", staffs[0])); } else { expressions.Add(Expression.Like("firstName", "%" + firstName + "%")); expressions.Add(Expression.Like("lastName", "%" + lastName + "%")); } } if (assettextBox.Text != "") { expressions.Add(Expression.Like("asset", "%" + assettextBox.Text + "%")); } if (buildingtextBox.Text != "") { expressions.Add(Expression.Like("bldg", "%" + buildingtextBox.Text + "%")); } if (roomtextBox.Text != "") { expressions.Add(Expression.Like("room", roomtextBox.Text + "%")); } //if (startdateTimePicker.Value < enddateTimePicker.Value) // expressions.Add(Expression.Between("acqDate", startdateTimePicker.Value, enddateTimePicker.Value)); expressions.Add(Expression.Eq("isDelete", false)); var items = repo.Query <Item>(expressions.ToArray()); List <Object> showedItems = new List <Object>(); Image smallImage = Image.FromFile("./Resources/img_icon.png"); var pic = ImageToByteArray(smallImage); for (int i = 0; i < items.Count; ++i) { Item item = items[i]; if (item.isDelete) { continue; } showedItems.Add(new ViewItem { IsChecked = item.isChecked, Asset = item.asset, Building = item.bldg, Room = item.room, SerialNumber = item.serialNumber, CampusCode = item.campusCode, Description = item.description, TotalCost = item.totalCost, OtherLocation = item.otherLocation, Model = item.Model, Picture = pic }); } curItems = showedItems; showPage(0); //itemsDataGridView.DataSource = showedItems.ToList(); //itemsDataGridView.DataSource = Items.ToList(); } //search staff else { string name = staffcomboBox.SelectedItem.ToString(); List <ICriterion> expressions = new List <ICriterion>(); if (name != "All,") { char[] ch = new char[name.Length]; ch = name.ToCharArray(); int i; for (i = 0; i < name.Length; i++) { if (ch[i] == ',') { break; } } string lastName = name.Substring(0, i); string firstName = name.Substring(i + 1, name.Length - i - 1); if (lastName != "None" && firstName != "None") { expressions.Add(Expression.Like("firstName", "%" + firstName + "%")); expressions.Add(Expression.Like("lastName", "%" + lastName + "%")); } } var staffs = repo.Query <Staff>(expressions.ToArray()); var showedStaffs = from staff in staffs let showedStaff = new { lastname = staff.lastName, firstname = staff.firstName, groupcode = staff.groupCode, email = staff.email, phone = staff.phone, location = staff.location } select showedStaff; staffDataGridView.DataSource = showedStaffs.ToList(); } }
public void Query_should_start_a_linq_query_on_the_session() { _repo.Query <User>().ShouldBeOfType <IQueryable <User> >(); }
public void InsertStaffAndItem() { var staff1 = new Staff() { groupCode = "Codde", lastName = "22shi", firstName = "11wei", email = "*****@*****.**", phone = "119798989987", location = "1HRBB" }; byte[] bytes = { 201, 209 }; var item1 = new Item() { asset = "134410", campusCode = 78, description = "This is a good one", bldg = "02-00445", room = "312B", otherLocation = "otherlocation", acqDate = new DateTime(2008, 8, 29), totalCost = Convert.ToDecimal(330044.04), Model = "Model", serialNumber = "FFF00000422", groupCode = staff1.groupCode, lastName = staff1.lastName, firstName = staff1.firstName, isDelete = false, comments = "comments", picture = bytes, }; var item2 = new Item() { asset = "3143", campusCode = 18, description = "This is a good one", bldg = "332-00445", room = "312B", otherLocation = "otherlocation", acqDate = new DateTime(2008, 8, 29), totalCost = Convert.ToDecimal(330044.04), Model = "Model", serialNumber = "FFF00000422", groupCode = staff1.groupCode, lastName = staff1.lastName, firstName = staff1.firstName, isDelete = false, comments = "comments", picture = bytes, }; //staff1.Items = new HashSet<Item> { item1 }; item1.Staffs = staff1; item2.Staffs = staff1; NHibernateRepository repo = new NHibernateRepository(); //repo.DeleteByQuery("from Item a"); //object id = repo.Insert(staff1); //repo.DeleteByQuery("from Staff s"); //repo.DeleteByQuery("from Item t"); repo.SaveOrUpdate(staff1); //IList<Staff> st = repo.Query<Staff>(); //var tt = st[0]; repo.SaveOrUpdate(item2); //Restrictions.Like("Firstname", "YJing%") //InventoryApp.Common.NHibernateRepository.ICriterion criterion = new ICriterion(); //NHibernate.Criterion.ICriterion expr //System.Collections.IList it = repo.QueryBySQL("select * from item,staff where staff.groupCode = item.groupCode "); IList <Staff> st = repo.Query <Staff>("from Staff a where a.groupCode = 'Codde' "); Assert.AreEqual(repo.Query <Staff>().Count, 1); }
private IEnumerable<User> GetData() { User[] users; using (var sourceSession = SessionManager.BuildSessionFactory().OpenSession()) { IRepository repository = new NHibernateRepository(sourceSession); users = repository.Query<User>().ToArray(); sourceSession.Close(); } return users; }