public List <Product> GetAllProducts()
{
var query = _executers.ExecuteCommand(_connStr,
conn => conn.Query <Product>(_commandText.GetProducts)).ToList();
return(query);
}
public List <Employee> GetAllEmployees()
{
List <Employee> query = _executers.ExecuteCommand(_connStr,
conn => conn.Query <Employee>("sp_GetAllEmployee", commandType: CommandType.StoredProcedure)).ToList();
return(query);
}
public List <Categories> GetAllCategories()
{
var query = _executers.ExecuteCommand(_connStr,
conn => conn.Query <Categories>(_commandText.GetAllCategories)).ToList();
return(query);
}
Task IEmployeeRepository.AddEmployee(Employee employee)
{
return(_executers.ExecuteCommand(
connection => connection.ExecuteAsync(
_employeeCommands.AddEmployee,
employee
)
));
}
Task ICompanyRepository.AddCompany(Company company)
{
return(_executers.ExecuteCommand(
connnection => connnection.ExecuteAsync(
_companyCommands.AddCompany,
company
)
));
}
public MemberDto GetMember(string cardId)
{
var member = _executers.ExecuteCommand <Member>(_connStr, conn =>
conn.Query <Member>(_membersCommandText.GetMemberByCardId, new { @CardId = cardId }).SingleOrDefault());
if (member == null)
{
return(null);
}
return(new MemberDto
{
Name = member.Name
});
}
public BalanceDto GetBalance(string cardId)
{
var lastTransaction = _executers.ExecuteCommand <Transaction>(_connStr, conn =>
conn.Query <Transaction>(_commandText.GetLatestCardTransactionByCardId, new { @CardId = cardId }).SingleOrDefault());
if (lastTransaction == null)
{
return(null);
}
return(new BalanceDto
{
Balance = lastTransaction.Balance
});
}
public T Create(T dataModel, object parameters)
{
setCurrentTable();
dataModel.Id = _executers.ExecuteCommand(
_connStr,
conn =>
{
return(conn.ExecuteScalar <long>(
_commandText.CreateCommand,
parameters,
commandType: CommandType.StoredProcedure
));
});
return(Read(dataModel.Id));
}
