public List <Organization> Execute(StorageServiceBase storageService)
{
string sql = "select * from Organization where Name like @name";
storageService.ConnectionFactory.OpenConnection();
storageService.ConnectionFactory.CreateCommand(sql);
storageService.ConnectionFactory.AddParameter("@name", $"%{name}%");
var dr = storageService.ConnectionFactory.ExecuteReader();
List <Organization> result = new List <Organization>();
while (dr.Read())
{
result.Add(new Organization(
id: dr.GetString(0),
name: dr.GetString(1),
phone: dr.GetString(2),
address: dr.GetString(3)));
}
dr.Close();
storageService.ConnectionFactory.CloseConnection();
return(result);
}
public Organization Execute(StorageServiceBase storageService)
{
string sql = "select * from Organization where Id = @id";
storageService.ConnectionFactory.OpenConnection();
storageService.ConnectionFactory.CreateCommand(sql);
storageService.ConnectionFactory.AddParameter("@id", organizationId);
var dr = storageService.ConnectionFactory.ExecuteReader();
Organization result = null;
if (dr.Read())
{
result = new Organization(
id: dr.GetString(0),
name: dr.GetString(1),
phone: dr.GetString(2),
address: dr.GetString(3));
}
dr.Close();
storageService.ConnectionFactory.CloseConnection();
return(result);
}
public void Execute(StorageServiceBase storageService)
{
string sql = "delete from Organization where Id = @id";
storageService.ConnectionFactory.OpenConnection();
storageService.ConnectionFactory.CreateCommand(sql);
storageService.ConnectionFactory.AddParameter("@id", organization.Id);
storageService.ConnectionFactory.ExecuteCommand();
storageService.ConnectionFactory.CloseConnection();
}
public void Execute(StorageServiceBase storageService)
{
string sql = @"insert into Organization
(Id, Name, Phone, Address)
values
(@id, @name, @phone, @address)";
storageService.ConnectionFactory.OpenConnection();
storageService.ConnectionFactory.CreateCommand(sql);
storageService.ConnectionFactory.AddParameter("@id", organization.Id);
storageService.ConnectionFactory.AddParameter("@name", organization.Name);
storageService.ConnectionFactory.AddParameter("@phone", organization.Phone);
storageService.ConnectionFactory.AddParameter("@address", organization.Address);
storageService.ConnectionFactory.ExecuteCommand();
storageService.ConnectionFactory.CloseConnection();
}
public void Execute(StorageServiceBase storageService)
{
string sql = @"update Organization set
Name = @name,
Phone = @phone,
Address = @address
where Id = @id
";
storageService.ConnectionFactory.OpenConnection();
storageService.ConnectionFactory.CreateCommand(sql);
storageService.ConnectionFactory.AddParameter("@id", organization.Id);
storageService.ConnectionFactory.AddParameter("@name", organization.Name);
storageService.ConnectionFactory.AddParameter("@phone", organization.Phone);
storageService.ConnectionFactory.AddParameter("@address", organization.Address);
storageService.ConnectionFactory.ExecuteCommand();
storageService.ConnectionFactory.CloseConnection();
}