/// <summary>
/// Gets an <see cref="IMacro"/> object by its alias
/// </summary>
/// <param name="alias">Alias to retrieve an <see cref="IMacro"/> for</param>
/// <returns>An <see cref="IMacro"/> object</returns>
public IMacro GetByAlias(string alias)
{
using (var repository = _repositoryFactory.CreateMacroRepository(_uowProvider.GetUnitOfWork()))
{
return(repository.Get(alias));
}
}
public GroupPageListEntity GetAll(GroupPageEntity entity, long pageIndex, long pageSize)
{
var list = new GroupPageListEntity();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
var query = PetaPoco.Sql.Builder.Append(@"SELECT * FROM GroupPage");
query.Append("ORDER BY ModifiedDate DESC");
var result = _uow.Db.Page <GroupPageEntity>(pageIndex, pageSize, query);
if (result != null && result.TotalItems > 0)
{
list.List = result.Items; // danh sách data trả về
list.PageTotal = result.TotalPages; // tổng số Pages
list.PageIndex = result.CurrentPage; // Page hiện tại của data duoc trả về
list.Count = Protector.Int(result.TotalItems); // count data
}
_uow.Commit();
}
}
catch (Exception ex)
{
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoGroupPage, "GetAll : ", ex.ToString());
}
return(list);
}
public StudentDto Add(StudentDto entity)
{
using (var uow = _uowProvider.GetUnitOfWork())
{
var id = uow.Db.Insert(entity);
uow.Commit();
entity.Id = Convert.ToInt32(id);
}
return(entity);
}
/// <summary>
/// Gets a list of all <see cref="Stylesheet"/> objects
/// </summary>
/// <returns>An enumerable list of <see cref="Stylesheet"/> objects</returns>
public IEnumerable <Stylesheet> GetStylesheets(params string[] names)
{
using (var repository = _repositoryFactory.CreateStylesheetRepository(_fileUowProvider.GetUnitOfWork()))
{
return(repository.GetAll(names));
}
}
public List <DepartmentEntity> GetDepartment(bool bActived, int branchId)
{
var list = new List <DepartmentEntity>();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
var query = PetaPoco.Sql.Builder.Append(@"SELECT Id, Name
FROM Department
WHERE bDeleted=@0
AND bActived=@1
AND BranchId=@2", false, bActived, branchId);
//if (cityId > 0)
//{
// query.Append("AND CityId=@0", cityId);
//}
query.Append("ORDER BY ModifiedDate DESC");
list = _uow.Db.Fetch <DepartmentEntity>(query);
_uow.Commit();
}
}
catch (Exception ex)
{
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoDepartment, "GetDepartment : ", ex.ToString());
}
return(list);
}
protected virtual IConnection CreateDbConnection(IEnumerable <IBaseRepository> repos = null)
{
IConnection uow = _unitOfWorkProvider.GetUnitOfWork(repos);
if (uow.NumberOfRepos > 1)
{
uow.BeginTransaction();
}
return(uow);
}
public AccountListEntity GetAll(AccountEntity entity, long pageIndex, long pageSize)
{
var list = new AccountListEntity();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
var query = PetaPoco.Sql.Builder.Append(@"SELECT *
FROM Account
WHERE bDeleted=@0", entity.bDeleted);
//if (entity.CityId > 0)
//{
// query.Append("AND CityId=@0", entity.CityId);
//}
//if (entity.Star > 0)
//{
// query.Append("AND Star=@0", entity.Star);
//}
query.Append("ORDER BY ModifiedDate DESC");
var result = _uow.Db.Page <AccountEntity>(pageIndex, pageSize, query);
if (result != null && result.TotalItems > 0)
{
list.List = result.Items; // danh sách data trả về
list.PageTotal = result.TotalPages; // tổng số Pages
list.PageIndex = result.CurrentPage; // Page hiện tại của data duoc trả về
list.Count = Protector.Int(result.TotalItems); // count data
}
_uow.Commit();
}
}
catch (Exception ex)
{
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoBranch, "GetAll : ", ex.ToString());
}
return(list);
}