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);
}
