public async Task <IActionResult> PutClientTable(int id, ClientTable clientTable) { if (id != clientTable.Id) { return(BadRequest()); } _context.Entry(clientTable).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ClientTableExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <ClientTable> > PostClientTable(ClientTable clientTable) { _context.Client.Add(clientTable); await _context.SaveChangesAsync(); return(CreatedAtAction("GetClientTable", new { id = clientTable.Id }, clientTable)); }
public void Setup() { new DataStoreTableHelper().clearAllTables(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); clientId = clientTable.create(clientModel); DogModel dogModel = new DogModel(); dogModel.clientID = clientId; dogModel.name = "Dog"; dogModel.age = 6; dogModel.breed = "Terrier"; dogModel.experienceOrQualification = false; DogTable dogTable = new DogTable(); dogId = dogTable.create(dogModel); ProgramTypeModel programTypeModel = new ProgramTypeModel(); programTypeModel.description = "Regular"; ProgramTypeTable programTypeTable = new ProgramTypeTable(); programTypeId = programTypeTable.create(programTypeModel); }
public ClientTable SelectClientTable(string UniqueHash) { TableQuery <ClientTable> query = connection.Table <ClientTable>().Where(cli => cli.UniqueHash.Equals(UniqueHash)); ClientTable table = query.FirstOrDefault(); return(table); }
private void ClientTableDragOver(object sender, DragEventArgs e) { var r = sender as DataGridRow; if (r == null) return; ClientTable.SelectedItem = r.Item; ClientTable.ScrollIntoView(r.Item); }
public static void ClassInitialize(TestContext context) { _database = new Database(IdentityConstants.ConnectionName); _userTable = new UserTable <IdentityUser>(_database); _claimTable = new ClaimTable(_database); _userClaimTable = new UserClaimTable(_database); _clientTable = new ClientTable(_database); _clientTable.Insert(new IdentityClient(client)); var TestClientId = _clientTable.GetClientByName(client).Id; _claimTable.Insert(new IdentityClaim(TestClientId, cType1, cValue1)); _claimTable.Insert(new IdentityClaim(TestClientId, cType2, cValue2)); _userTable.Insert(new IdentityUser(TestClientId, name1) { Email = email1 }); _userTable.Insert(new IdentityUser(TestClientId, name2) { Email = email2 }); }
public void CreateEmailConstraint_EmailLengthTooShort_Exception() { //Assemble ClientTable clientTable = new ClientTable(); ClientModel clientModel = new ClientModel(); clientModel.displayName = "Barry Bonds"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; int expected = 1; int counter = 0; //Act try { int id = clientTable.create(clientModel); } catch (Exception ex) { counter++; } //Assert Assert.AreEqual(expected, counter); }
public void CreateEmailConstraint_EmailLengthOk_NoException() { //Assemble ClientTable clientTable = new ClientTable(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; int expected = 1; int counter = 0; //Act try { int id = clientTable.create(clientModel); counter++; } catch (Exception ex) { } //Assert Assert.AreEqual(expected, counter); }
public void CreateNameConstraint_NameLengthOk_NoException() { //Assemble ClientTable clientTable = new ClientTable(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "07561 101169"; clientModel.email = "*****@*****.**"; int expected = 1; int counter = 0; //Act try { int id = clientTable.create(clientModel); counter++; } catch (Exception ex) { } //Assert Assert.AreEqual(expected, counter); }
public void CreatePhoneConstraint_PhoneLengthTooShort_Exception() { //Assemble ClientTable clientTable = new ClientTable(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "123456789"; clientModel.email = "*****@*****.**"; int expected = 1; int counter = 0; //Act try { int id = clientTable.create(clientModel); } catch (Exception ex) { counter++; } //Assert Assert.AreEqual(expected, counter); }
public ActionResult Save(ClientTable client) { bool status = false; if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { if (client.ClientID > 0) { //edycja var s = mainDB.ClientTables.Where(a => a.ClientID == client.ClientID).FirstOrDefault(); if (s != null) { s.Nip = client.Nip; s.CompanyName = client.CompanyName; s.Address = client.Address; s.Phone = client.Phone; s.Email = client.Email; } } else { //zapis mainDB.ClientTables.Add(client); } mainDB.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public void ReadAll_Create3Records_CountIs3() { //Assemble ClientModel clientModel1 = new ClientModel(); clientModel1.name = "Bob"; clientModel1.phone = "07561 101169"; clientModel1.email = "*****@*****.**"; ClientModel clientModel2 = new ClientModel(); clientModel2.name = "Bob2"; clientModel2.phone = "07561 101169"; clientModel2.email = "*****@*****.**"; ClientModel clientModel3 = new ClientModel(); clientModel3.name = "Bob3"; clientModel3.phone = "07561 101169"; clientModel3.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); int expected = 3; //Act int clientID1 = clientTable.create(clientModel1); int clientID2 = clientTable.create(clientModel2); int clientID3 = clientTable.create(clientModel3); List <ClientModel> actual = clientTable.readAll(); //Assert Assert.AreEqual(expected, actual.Count); }
public void Update_CreatedUpdateAndRead1Record_UpdatedValues() { //Assemble ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "07561 101169"; clientModel.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); int clientID = clientTable.create(clientModel); clientModel.id = clientID; clientModel.name = "Kate"; clientModel.phone = "07561 101170"; clientModel.email = "*****@*****.**"; //Act clientTable.update(clientModel); ClientModel actual = clientTable.read(clientID); //Assert Assert.AreEqual(clientModel.name, actual.name); Assert.AreEqual(clientModel.phone, actual.phone); Assert.AreEqual(clientModel.email, actual.email); }
public void CreatePhoneConstraint_PhoneLengthOk_NoException() { //Assemble ClientTable clientTable = new ClientTable(); ClientModel clientModel = new ClientModel(); clientModel.displayName = "Barry Bonds"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; int expected = 1; int counter = 0; //Act try { int id = clientTable.create(clientModel); counter++; } catch (Exception ex) { } //Assert Assert.AreEqual(expected, counter); }
public override void Load(ClientTable data) { base.Load(data); Prefix = data.Prefix; Permissions = Permissions == PermissionFlags.UnVerified ? data.Permissions | PermissionFlags.UnVerified : data.Permissions; PasswordHash = data.PasswordHash; }
public ClientViewModel(ClientTable table) { this.UniqueHash = table.UniqueHash; this.IsFromDatabase = true; this.clientTable = table; this.ChatViewModelContainer = ChatViewModelContainer.Instance; this.Init(); }
public static void ClassInitialize(TestContext context) { _database = new Database(IdentityConstants.ConnectionName); _userTable = new UserTable <IdentityUser>(_database); _clientTable = new ClientTable(_database); _database.Execute("DELETE FROM User"); _clientTable.Insert(new IdentityClient(client)); TestClientId = _clientTable.GetClientByName(client).Id; }
public void Setup() { new DataStoreTableHelper().clearAllTables(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); clientId = clientTable.create(clientModel); DogModel dogModel = new DogModel(); dogModel.clientID = clientId; dogModel.name = "Dog"; dogModel.age = 6; dogModel.breed = "Terrier"; dogModel.experienceOrQualification = false; DogTable dogTable = new DogTable(); dogId = dogTable.create(dogModel); ProgramTypeModel programTypeModel = new ProgramTypeModel(); programTypeModel.description = "Regular"; ProgramTypeTable programTypeTable = new ProgramTypeTable(); programTypeId = programTypeTable.create(programTypeModel); ProgramCostModel programeCostModel = new ProgramCostModel(); programeCostModel.depositAmount = 20.0; programeCostModel.sessionCost = 20.0; programeCostModel.fullPaymentPercentageDiscount = 20; ProgramCostTable programCostTable = new ProgramCostTable(); programeCostId = programCostTable.create(programeCostModel); ProgramModel programModel = new ProgramModel(); programModel.programTypeId = programTypeId; programModel.programCostId = programeCostId; programModel.dogSpacesMaximum = 50; programModel.noOfClasses = 50; ProgramTable programTable = new ProgramTable(); programId = programTable.create(programModel); }
public UserStore(Database nPocoDb) { NPocoDb = nPocoDb; _userTable = new UserTable <TUser>(nPocoDb); _roleTable = new RoleTable(nPocoDb); _claimTable = new ClaimTable(nPocoDb); _clientTable = new ClientTable(nPocoDb); _userRoleTable = new UserRoleTable(nPocoDb); _userClaimTable = new UserClaimTable(nPocoDb); _userLoginTable = new UserLoginTable(nPocoDb); }
public void Count_AllRecordsDeleted_0() { //Assemble int expected = 0; ClientTable clientTable = new ClientTable(); //Act int actual = clientTable.count(); //Assert Assert.AreEqual(expected, actual); }
public void Delete_NonExistantId_0() { //Assemble ClientTable clientTable = new ClientTable(); int expected = 0; //Act clientTable.delete(0); int actual = clientTable.count(); //Assert Assert.AreEqual(expected, actual); }
public ClientViewModel SelectClient(string UniqueHash) { ClientViewModel viewModel = null; ClientTable table = this.SelectClientTable(UniqueHash); if (table != null) { viewModel = new ClientViewModel(table); } return(viewModel); }
public void AddMember() { var newClientRow = ClientTable.NewRow(); newClientRow["RowGUID"] = Guid.NewGuid(); newClientRow["SponsorGUID"] = GUID == Guid.Empty.ToString() ? Fields["RowGUID"] : GUID; newClientRow["IsSponsor"] = HouseMembers.Count == 0; newClientRow["IsSpouse"] = false; newClientRow["Active"] = true; newClientRow["CCode"] = HouseMembers.Count > 0 ? HouseMembers[0]["CCode"] : ""; newClientRow.SetAllNonDBNullColumnsToEmptyString(); ClientTable.Rows.Add(newClientRow); }
public void Setup() { new DataStoreTableHelper().clearAllTables(); ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "1234567890"; clientModel.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); clientId = clientTable.create(clientModel); }
private void HandleSpecialMessage(Client initiator, Message message) { string[] values = message.GetValues(); switch (values[0]) { case "name": initiator.Name = values.Length > 1 ? values[1] : "Anon"; ClientTable.ReloadData(); break; case "bye": DisconnectClient(initiator); break; } }
public void Dispose() { if (NPocoDb != null) { NPocoDb.Dispose(); NPocoDb = null; } _userTable = null; _roleTable = null; _claimTable = null; _clientTable = null; _userRoleTable = null; _userClaimTable = null; _userLoginTable = null; }
private void _InitContainers(int size) { _rawArray = new object[size]; _list = new List <object>(size); _snapshotArray = new object[size]; _dict = new Dictionary <int, object>(size); _sorted = new ClientTable <int, object>(size); for (int i = 0; i < size; ++i) { var item = new object(); _rawArray[i] = item; _list.Add(item); _dict.Add(i, item); _sorted.Add(i, item); } }
public virtual bool AssignID(Client client) { var clientTable = Database.DatabaseGetAll <ClientTable>().FirstOrDefault(table => table.Name == client.Nickname); if (clientTable == null) { clientTable = new ClientTable(client); Database.DatabaseSet(clientTable); client.Load(clientTable); return(true); } else { client.Load(clientTable); return(true); } }
public void ReadAll_Create3Records_3DifferentRecords() { //Assemble ClientModel clientModel1 = new ClientModel(); clientModel1.name = "name1"; clientModel1.phone = "07561 101169"; clientModel1.email = "*****@*****.**"; ClientModel clientModel2 = new ClientModel(); clientModel2.name = "name2"; clientModel2.phone = "07561 101170"; clientModel2.email = "*****@*****.**"; ClientModel clientModel3 = new ClientModel(); clientModel3.name = "name3"; clientModel3.phone = "07561 101171"; clientModel3.email = "*****@*****.**"; ClientTable clientTable = new ClientTable(); //Act int clientID1 = clientTable.create(clientModel1); int clientID2 = clientTable.create(clientModel2); int clientID3 = clientTable.create(clientModel3); List <ClientModel> actual = clientTable.readAll(); //Assert Assert.AreEqual(clientID1, clientID1); Assert.AreEqual(clientModel1.name, actual[0].name); Assert.AreEqual(clientModel1.phone, actual[0].phone); Assert.AreEqual(clientModel1.email, actual[0].email); Assert.AreEqual(clientID2, clientID2); Assert.AreEqual(clientModel2.name, actual[1].name); Assert.AreEqual(clientModel2.phone, actual[1].phone); Assert.AreEqual(clientModel2.email, actual[1].email); Assert.AreEqual(clientID3, clientID3); Assert.AreEqual(clientModel3.name, actual[2].name); Assert.AreEqual(clientModel3.phone, actual[2].phone); Assert.AreEqual(clientModel3.email, actual[2].email); }
public void Count_Created1Record_1() { //Assemble ClientModel clientModel = new ClientModel(); clientModel.name = "Bob"; clientModel.phone = "07561 101169"; clientModel.email = "*****@*****.**"; int expected = 1; ClientTable clientTable = new ClientTable(); //Act int clientID = clientTable.create(clientModel); int actual = clientTable.count(); //Assert Assert.AreEqual(expected, actual); }