public void CreateBankManager()
{
BankManagerDao bankManagerDAO = new BankManagerDao();
BankManagerDto bankManagerDto = new BankManagerDto()
{
FirstName = "Aibek",
LastName = "Shulembekov",
Email = "*****@*****.**",
CreatedTime = DateTime.Now,
ApplicationClientType = ApplicationClientType.BankManager,
EntityStatus = EntityStatusType.IsActive,
PasswordHash = "123",
};
bankManagerDto.Id = ApplicationUserIdGenerator.GenerateUniqueId(
bankManagerDto.FirstName, bankManagerDto.LastName,
bankManagerDto.ApplicationClientType);
Assert.IsTrue(bankManagerDto.Id == bankManagerDAO.Create(bankManagerDto));
}
public void DeleteBankManager()
{
BankManagerDao bankManagerDAO = new BankManagerDao();
BankManagerDto bankManagerDto = new BankManagerDto()
{
FirstName = "Serik",
LastName = "Shulembekov",
Email = "*****@*****.**",
CreatedTime = DateTime.Now,
ApplicationClientType = ApplicationClientType.BankManager,
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(BankManagerDto 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(BankManagerDto dto)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
{
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "BankManagers");
DataRow dataRowToAdd = dataSet.Tables["BankManagers"].NewRow();
foreach (var item in dto.GetType().GetProperties())
{
dataRowToAdd[item.Name] = item.GetValue(dto, null);
}
dataSet.Tables["BankManagers"].Rows.Add(dataRowToAdd);
SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(adapter);
adapter.Update(dataSet.Tables["BankManagers"]);
}
sqlConnection.Close();
}
}
public void BankManagerDao_Create()
{
BankManagerDto dto = new BankManagerDto("asd", "asd", "asd", "asd", "asd");
dto.Id = "1";
BankManagerDao dao = new BankManagerDao();
string result = dao.Create(dto);
Assert.IsTrue(dto.Id == result);
}
public void BankManagerDao_Update()
{
BankManagerDto dto = new BankManagerDto("um", "um", "um", "um", "um");
dto.Id = "1";
BankManagerDao dao = new BankManagerDao();
string result = dao.Update(dto);
Assert.IsTrue(dto.Id == result);
}
public void UpdateBankManager()
{
BankManagerDao bankManagerDAO = new BankManagerDao();
BankManagerDto bankManagerDto = new BankManagerDto()
{
FirstName = "Arecr",
LastName = "Frers",
Email = "*****@*****.**",
CreatedTime = DateTime.Now,
ApplicationClientType = ApplicationClientType.BankManager,
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 BankManagerDto Read(string id)
{
BankManagerDto dtoToReturn = null;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString))
{
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "BankManagers");
dataSet.Tables["BankManagers"].PrimaryKey = new DataColumn[] { dataSet.Tables["BankManagers"].Columns["Id"] };
DataRow dataRowToReturn = dataSet.Tables["BankManagers"].Rows.Find(id);
foreach (var item in dataRowToReturn.ItemArray.ToList())
{
Console.WriteLine(item);
}
}
sqlConnection.Close();
}
return(null);
}