public MessageEntity Create(GroupPageEntity entity)
{
var msgEntity = new MessageEntity();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
int Id = Protector.Int(_uow.Db.Insert(entity));
if (Id > 0)
{
msgEntity.code = 0;
msgEntity.result = true;
msgEntity.message = ConstantsHandler.ErrorMessage.Message_OK;
_uow.Commit();
}
else
{
msgEntity.code = -2;
msgEntity.result = false;
msgEntity.message = ConstantsHandler.ErrorMessage.Message_ERR;
}
}
}
catch (Exception ex)
{
msgEntity.code = -1;
msgEntity.result = false;
msgEntity.message = ConstantsHandler.ErrorMessage.Message_EX;
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoGroupPage, "Create : ", ex.ToString());
}
return(msgEntity);
}
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 MessageEntity Update(GroupPageEntity entity)
{
var msgEntity = new MessageEntity();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
var data = _uow.Db.SingleOrDefault <BranchEntity>("SELECT * FROM GroupPage WHERE Id=@0", entity.Id);
if (data != null && data.Id == entity.Id)
{
entity.CreatedBy = data.CreatedBy;
entity.CreatedDate = data.CreatedDate;
_uow.Db.Update(entity);
msgEntity.message = ConstantsHandler.ErrorMessage.Message_OK;
msgEntity.result = true;
msgEntity.code = 0;
}
_uow.Commit();
}
}
catch (Exception ex)
{
msgEntity.result = false;
msgEntity.message = ConstantsHandler.ErrorMessage.Message_EX;
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoGroupPage, "Update : ", ex.ToString());
}
return(msgEntity);
}
public GroupPageEntity GetById(int id)
{
var entity = new GroupPageEntity();
try
{
using (var _uow = _unitOfWorkProvider.GetUnitOfWork())
{
entity = _uow.Db.SingleOrDefault <GroupPageEntity>("SELECT * FROM GroupPage WHERE Id=@0", id);
_uow.Commit();
}
}
catch (Exception ex)
{
Logger.ErrorLog(ConstantsHandler.ForderLogName.RepoGroupPage, "GetById : ", ex.ToString());
}
return(entity);
}