private async void button1_Click(object sender, EventArgs e)
{
string firstName = textBox2.Text;
string lastName = textBox1.Text;
BankClientDto bankClientDto = new BankClientDto()
{
FirstName = firstName,
LastName = lastName,
ApplicationClientType = ApplicationClientType.BankClient,
CreatedTime = DateTime.Now,
Email = firstName,
EntityStatus = EntityStatusType.IsActive,
PasswordHash = "12345"
};
if (ConnectionManagerUtil.IsConnectionAvailable())
{
var pastData = _offlineDataPublisher.GetAllPastData <BankClientDto>();
if (pastData.Count > 0)
{
var sortedData = pastData.OrderBy(p => p.CreatedTime);
foreach (var item in sortedData)
{
_onlineDataPublisher.PublishMessageToStorage(item);
}
}
_onlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
else
{
_offlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
}
public void DeleteBankClient()
{
BankClientDao bankManagerDAO = new BankClientDao();
BankClientDto bankManagerDto = new BankClientDto()
{
FirstName = "Serik",
LastName = "Shulembekov",
Email = "*****@*****.**",
CreatedTime = DateTime.Now,
ApplicationClientType = ApplicationClientType.BankClient,
EntityStatus = EntityStatusType.IsActive,
PasswordHash = "123",
};
bankManagerDto.Id = ApplicationUserIdGenerator.GenerateUniqueId(
bankManagerDto.FirstName, bankManagerDto.LastName,
bankManagerDto.ApplicationClientType);
bankManagerDAO.Create(bankManagerDto);
bankManagerDAO.Remove(bankManagerDto.Id);
Assert.IsNull(bankManagerDAO.Read(bankManagerDto.Id));
}
public void Update(BankClientDto dto)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
{
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
DataColumn[] key = new DataColumn[1];
key[0] = dataSet.Tables[0].Columns[0];
dataSet.Tables[0].PrimaryKey = key;
DataRow dataRow = dataSet.Tables[0].Rows.Find(dto.Id);
dataRow.BeginEdit();
dataRow["Id"] = dto.Id;
dataRow.EndEdit();
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(adapter);
adapter.Update(dataSet);
}
sqlConnection.Close();
}
}
public void Create(BankClientDto dto)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
{
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "BankClients");
DataRow dataRowToAdd = dataSet.Tables["BankClients"].NewRow();
foreach (var item in dto.GetType().GetProperties())
{
dataRowToAdd[item.Name] = item.GetValue(dto, null);
}
dataSet.Tables["BankClients"].Rows.Add(dataRowToAdd);
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(adapter);
adapter.Update(dataSet.Tables["BankClients"]);
}
sqlConnection.Close();
}
}
public void EntityDto_GetDetailedTypeInfo()
{
BankClientDto bankClientDto =
new BankClientDto("Assel", "Assel", "Assel", "Assel", "Assel");
bankClientDto.Id = "2222";
Debug.WriteLine(bankClientDto.ToString());
}
public void BankClientDao_Update()
{
BankClientDto dto = new BankClientDto("uc", "uc", "uc", "uc", "uc");
dto.Id = "1";
BankClientDao dao = new BankClientDao();
string result = dao.Update(dto);
Assert.IsTrue(dto.Id == result);
}
public void BankClientDao_Create()
{
BankClientDto dto = new BankClientDto("qwert", "qwert", "qwert", "qwert", "qwert");
dto.Id = "1";
BankClientDao dao = new BankClientDao();
string result = dao.Create(dto);
Assert.IsTrue(dto.Id == result);
}
public string RegisterNewBankClient(BankClientDto bankClientDto)
{
bankClientDto.Id = ApplicationUserIdGenerator.GenerateUniqueId(
bankClientDto.FirstName,
bankClientDto.LastName,
ApplicationClientType.BankClient);
bankClientDto.PasswordHash =
PasswordHashGenerator.GetMd5Hash(bankClientDto.PasswordHash);
return(_bankClientDao.Create(bankClientDto));
}
public void ApplicationClientService_RegisterNewBankClient()
{
ApplicationClientService applicationClientService = new ApplicationClientService();
BankClientDto bankClientDto =
new BankClientDto("Test", "Test", "Test", "Test", "Test");
applicationClientService.RegisterNewBankClient(bankClientDto);
string result = bankClientDto.ToString();
Debug.WriteLine(result);
}
public void BankClientDao_Create()
{
// Arrange
BankClientDto bankClientDto =
new BankClientDto("Test", "Test", "Test", "Test", "Test");
bankClientDto.Id = "2222";
BankClientDao bankClientDao =
new BankClientDao();
// Act
string result = bankClientDao.Create(bankClientDto);
// Assert
Assert.IsTrue(bankClientDto.Id == result);
}
private void SignUpButton_Click(object sender, EventArgs e)
{
string firstName = textBox2.Text;
string lastName = textBox1.Text;
string password = passwordTextBox.Text;
string email = emailTextBox.Text;
if (!(String.IsNullOrEmpty(firstName) &&
string.IsNullOrEmpty(lastName) &&
string.IsNullOrEmpty(password) &&
string.IsNullOrEmpty(email)))
{
BankClientDto bankClientDto = new BankClientDto()
{
FirstName = firstName,
LastName = lastName,
ApplicationClientType = ApplicationClientType.BankClient,
CreatedTime = DateTime.Now,
Email = email,
EntityStatus = EntityStatusType.IsActive,
PasswordHash = password
};
if (ConnectionManagerUtil.IsConnectionAvailable())
{
var pastData = _offlineDataPublisher.GetAllPastData <BankClientDto>();
if (pastData.Count > 0)
{
var sortedData = pastData.OrderBy(p => p.CreatedTime);
foreach (var item in sortedData)
{
_onlineDataPublisher.PublishMessageToStorage(item);
}
}
_onlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
else
{
_offlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
}
}
private async void SignUpButton_Click(object sender, RoutedEventArgs e)
{
string firstName = firstNameTextBox.Text;
string lastName = lastNameTextBox.Text;
string email = emailTextBox.Text;
string password = passwordTextBox.Text;
string passwordConfirm = passwordConfirmTextBox.Text;
BankClientDto bankClientDto = new BankClientDto()
{
FirstName = firstName,
LastName = lastName,
Email = firstName,
PasswordHash = "12345",
ApplicationClientType = ApplicationClientType.BankClient,
CreatedTime = DateTime.Now,
EntityStatus = EntityStatusType.IsActive
};
if (ConnectionManagerUtil.IsConnectionAvailable())
{
var pastData = _offlineDataPublisher.GetAllPastData <BankClientDto>();
if (pastData.Count > 0)
{
var sortedData = pastData.OrderBy(p => p.CreatedTime);
foreach (var item in sortedData)
{
_onlineDataPublisher.PublishMessageToStorage(item);
}
}
_onlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
else
{
_offlineDataPublisher.PublishMessageToStorage(bankClientDto);
}
//_onlineDataPublisher.PublishMessageToQueue<BankClientDto>("bank_client_registration_queue", bankClientDto);
}
public void UpdateBankClient()
{
BankClientDao bankManagerDAO = new BankClientDao();
BankClientDto bankManagerDto = new BankClientDto()
{
FirstName = "Arecr",
LastName = "Frers",
Email = "*****@*****.**",
CreatedTime = DateTime.Now,
ApplicationClientType = ApplicationClientType.BankClient,
EntityStatus = EntityStatusType.IsActive,
PasswordHash = "123",
};
bankManagerDto.Id = ApplicationUserIdGenerator.GenerateUniqueId(
bankManagerDto.FirstName, bankManagerDto.LastName,
bankManagerDto.ApplicationClientType);
bankManagerDAO.Create(bankManagerDto);
bankManagerDto.LastName = "Reded";
string result = bankManagerDAO.Update(bankManagerDto);
Assert.IsTrue(result == "1");
}
public BankClientDto Read(string id)
{
BankClientDto dtoToReturn = null;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
{
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "BankClients");
dataSet.Tables["BankClients"].PrimaryKey = new DataColumn[] { dataSet.Tables["BankClients"].Columns["Id"] };
DataRow dataRowToReturn = dataSet.Tables["BankClients"].Rows.Find(id);
foreach (var item in dataRowToReturn.ItemArray.ToList())
{
Console.WriteLine(item);
}
}
sqlConnection.Close();
}
return(null);
}