public async Task <bool> Delete(CompanyFileGrouping CompanyFileGrouping)
{
await DataContext.CompanyFileGrouping.Where(x => x.Id == CompanyFileGrouping.Id).UpdateFromQueryAsync(x => new CompanyFileGroupingDAO {
DeletedAt = StaticParams.DateTimeNow, UpdatedAt = StaticParams.DateTimeNow
});
return(true);
}
public Company_CompanyFileGroupingDTO(CompanyFileGrouping CompanyFileGrouping)
{
this.Id = CompanyFileGrouping.Id;
this.Title = CompanyFileGrouping.Title;
this.Description = CompanyFileGrouping.Description;
this.CompanyId = CompanyFileGrouping.CompanyId;
this.CreatorId = CompanyFileGrouping.CreatorId;
this.FileTypeId = CompanyFileGrouping.FileTypeId;
this.RowId = CompanyFileGrouping.RowId;
this.Creator = CompanyFileGrouping.Creator == null ? null : new Company_AppUserDTO(CompanyFileGrouping.Creator);
this.FileType = CompanyFileGrouping.FileType == null ? null : new Company_FileTypeDTO(CompanyFileGrouping.FileType);
this.RowId = CompanyFileGrouping.RowId;
this.Errors = CompanyFileGrouping.Errors;
}
public async Task <bool> Create(CompanyFileGrouping CompanyFileGrouping)
{
CompanyFileGroupingDAO CompanyFileGroupingDAO = new CompanyFileGroupingDAO();
CompanyFileGroupingDAO.Id = CompanyFileGrouping.Id;
CompanyFileGroupingDAO.Title = CompanyFileGrouping.Title;
CompanyFileGroupingDAO.Description = CompanyFileGrouping.Description;
CompanyFileGroupingDAO.CompanyId = CompanyFileGrouping.CompanyId;
CompanyFileGroupingDAO.CreatorId = CompanyFileGrouping.CreatorId;
CompanyFileGroupingDAO.FileTypeId = CompanyFileGrouping.FileTypeId;
CompanyFileGroupingDAO.RowId = CompanyFileGrouping.RowId;
CompanyFileGroupingDAO.CreatedAt = StaticParams.DateTimeNow;
CompanyFileGroupingDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.CompanyFileGrouping.Add(CompanyFileGroupingDAO);
await DataContext.SaveChangesAsync();
CompanyFileGrouping.Id = CompanyFileGroupingDAO.Id;
await SaveReference(CompanyFileGrouping);
return(true);
}
public async Task <bool> Update(CompanyFileGrouping CompanyFileGrouping)
{
CompanyFileGroupingDAO CompanyFileGroupingDAO = DataContext.CompanyFileGrouping.Where(x => x.Id == CompanyFileGrouping.Id).FirstOrDefault();
if (CompanyFileGroupingDAO == null)
{
return(false);
}
CompanyFileGroupingDAO.Id = CompanyFileGrouping.Id;
CompanyFileGroupingDAO.Title = CompanyFileGrouping.Title;
CompanyFileGroupingDAO.Description = CompanyFileGrouping.Description;
CompanyFileGroupingDAO.CompanyId = CompanyFileGrouping.CompanyId;
CompanyFileGroupingDAO.CreatorId = CompanyFileGrouping.CreatorId;
CompanyFileGroupingDAO.FileTypeId = CompanyFileGrouping.FileTypeId;
CompanyFileGroupingDAO.RowId = CompanyFileGrouping.RowId;
CompanyFileGroupingDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(CompanyFileGrouping);
return(true);
}
private async Task SaveReference(CompanyFileGrouping CompanyFileGrouping)
{
}
public async Task <CompanyFileGrouping> Get(long Id)
{
CompanyFileGrouping CompanyFileGrouping = await DataContext.CompanyFileGrouping.AsNoTracking()
.Where(x => x.Id == Id)
.Where(x => x.DeletedAt == null)
.Select(x => new CompanyFileGrouping()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
Title = x.Title,
Description = x.Description,
CompanyId = x.CompanyId,
CreatorId = x.CreatorId,
FileTypeId = x.FileTypeId,
RowId = x.RowId,
Company = x.Company == null ? null : new Company
{
Id = x.Company.Id,
Name = x.Company.Name,
Phone = x.Company.Phone,
FAX = x.Company.FAX,
PhoneOther = x.Company.PhoneOther,
Email = x.Company.Email,
EmailOther = x.Company.EmailOther,
ZIPCode = x.Company.ZIPCode,
Revenue = x.Company.Revenue,
Website = x.Company.Website,
Address = x.Company.Address,
NationId = x.Company.NationId,
ProvinceId = x.Company.ProvinceId,
DistrictId = x.Company.DistrictId,
NumberOfEmployee = x.Company.NumberOfEmployee,
RefuseReciveEmail = x.Company.RefuseReciveEmail,
RefuseReciveSMS = x.Company.RefuseReciveSMS,
CustomerLeadId = x.Company.CustomerLeadId,
ParentId = x.Company.ParentId,
Path = x.Company.Path,
Level = x.Company.Level,
ProfessionId = x.Company.ProfessionId,
AppUserId = x.Company.AppUserId,
CreatorId = x.Company.CreatorId,
CurrencyId = x.Company.CurrencyId,
CompanyStatusId = x.Company.CompanyStatusId,
Description = x.Company.Description,
RowId = x.Company.RowId,
},
Creator = x.Creator == null ? null : new AppUser
{
Id = x.Creator.Id,
Username = x.Creator.Username,
DisplayName = x.Creator.DisplayName,
Address = x.Creator.Address,
Email = x.Creator.Email,
Phone = x.Creator.Phone,
SexId = x.Creator.SexId,
Birthday = x.Creator.Birthday,
Avatar = x.Creator.Avatar,
Department = x.Creator.Department,
OrganizationId = x.Creator.OrganizationId,
Longitude = x.Creator.Longitude,
Latitude = x.Creator.Latitude,
StatusId = x.Creator.StatusId,
RowId = x.Creator.RowId,
Used = x.Creator.Used,
},
FileType = x.FileType == null ? null : new FileType
{
Id = x.FileType.Id,
Code = x.FileType.Code,
Name = x.FileType.Name,
},
}).FirstOrDefaultAsync();
if (CompanyFileGrouping == null)
{
return(null);
}
return(CompanyFileGrouping);
}
