public async Task <bool> Delete(CustomerLeadFileGroup CustomerLeadFileGroup)
{
await DataContext.CustomerLeadFileGroup.Where(x => x.Id == CustomerLeadFileGroup.Id).UpdateFromQueryAsync(x => new CustomerLeadFileGroupDAO {
DeletedAt = StaticParams.DateTimeNow, UpdatedAt = StaticParams.DateTimeNow
});
return(true);
}
public CustomerLead_CustomerLeadFileGroupDTO(CustomerLeadFileGroup CustomerLeadFileGroup)
{
this.Id = CustomerLeadFileGroup.Id;
this.Title = CustomerLeadFileGroup.Title;
this.Description = CustomerLeadFileGroup.Description;
this.CreatorId = CustomerLeadFileGroup.CreatorId;
this.CustomerLeadId = CustomerLeadFileGroup.CustomerLeadId;
this.FileTypeId = CustomerLeadFileGroup.FileTypeId;
this.CreatedAt = CustomerLeadFileGroup.CreatedAt;
this.UpdatedAt = CustomerLeadFileGroup.UpdatedAt;
this.Errors = CustomerLeadFileGroup.Errors;
this.Creator = CustomerLeadFileGroup.Creator == null ? null : new CustomerLead_AppUserDTO(CustomerLeadFileGroup.Creator);
this.FileType = CustomerLeadFileGroup.FileType == null ? null : new CustomerLead_FileTypeDTO(CustomerLeadFileGroup.FileType);
this.CustomerLeadFileMappings = CustomerLeadFileGroup.CustomerLeadFileMappings?.Select(x => new CustomerLead_CustomerLeadFileMappingDTO(x)).ToList();
}
public async Task <bool> Create(CustomerLeadFileGroup CustomerLeadFileGroup)
{
CustomerLeadFileGroupDAO CustomerLeadFileGroupDAO = new CustomerLeadFileGroupDAO();
CustomerLeadFileGroupDAO.Id = CustomerLeadFileGroup.Id;
CustomerLeadFileGroupDAO.Title = CustomerLeadFileGroup.Title;
CustomerLeadFileGroupDAO.Description = CustomerLeadFileGroup.Description;
CustomerLeadFileGroupDAO.CustomerLeadId = CustomerLeadFileGroup.CustomerLeadId;
CustomerLeadFileGroupDAO.CreatorId = CustomerLeadFileGroup.CreatorId;
CustomerLeadFileGroupDAO.FileTypeId = CustomerLeadFileGroup.FileTypeId;
CustomerLeadFileGroupDAO.RowId = CustomerLeadFileGroup.RowId;
CustomerLeadFileGroupDAO.CreatedAt = StaticParams.DateTimeNow;
CustomerLeadFileGroupDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.CustomerLeadFileGroup.Add(CustomerLeadFileGroupDAO);
await DataContext.SaveChangesAsync();
CustomerLeadFileGroup.Id = CustomerLeadFileGroupDAO.Id;
await SaveReference(CustomerLeadFileGroup);
return(true);
}
public async Task <bool> Update(CustomerLeadFileGroup CustomerLeadFileGroup)
{
CustomerLeadFileGroupDAO CustomerLeadFileGroupDAO = DataContext.CustomerLeadFileGroup.Where(x => x.Id == CustomerLeadFileGroup.Id).FirstOrDefault();
if (CustomerLeadFileGroupDAO == null)
{
return(false);
}
CustomerLeadFileGroupDAO.Id = CustomerLeadFileGroup.Id;
CustomerLeadFileGroupDAO.Title = CustomerLeadFileGroup.Title;
CustomerLeadFileGroupDAO.Description = CustomerLeadFileGroup.Description;
CustomerLeadFileGroupDAO.CustomerLeadId = CustomerLeadFileGroup.CustomerLeadId;
CustomerLeadFileGroupDAO.CreatorId = CustomerLeadFileGroup.CreatorId;
CustomerLeadFileGroupDAO.FileTypeId = CustomerLeadFileGroup.FileTypeId;
CustomerLeadFileGroupDAO.RowId = CustomerLeadFileGroup.RowId;
CustomerLeadFileGroupDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(CustomerLeadFileGroup);
return(true);
}
private async Task SaveReference(CustomerLeadFileGroup CustomerLeadFileGroup)
{
}
public async Task <CustomerLeadFileGroup> Get(long Id)
{
CustomerLeadFileGroup CustomerLeadFileGroup = await DataContext.CustomerLeadFileGroup.AsNoTracking()
.Where(x => x.Id == Id)
.Where(x => x.DeletedAt == null)
.Select(x => new CustomerLeadFileGroup()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
Title = x.Title,
Description = x.Description,
CustomerLeadId = x.CustomerLeadId,
CreatorId = x.CreatorId,
FileTypeId = x.FileTypeId,
RowId = x.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,
},
CustomerLead = x.CustomerLead == null ? null : new CustomerLead
{
Id = x.CustomerLead.Id,
Name = x.CustomerLead.Name,
CompanyName = x.CustomerLead.CompanyName,
TelePhone = x.CustomerLead.TelePhone,
Phone = x.CustomerLead.Phone,
Fax = x.CustomerLead.Fax,
Email = x.CustomerLead.Email,
SecondEmail = x.CustomerLead.SecondEmail,
Website = x.CustomerLead.Website,
CustomerLeadSourceId = x.CustomerLead.CustomerLeadSourceId,
CustomerLeadLevelId = x.CustomerLead.CustomerLeadLevelId,
CompanyId = x.CustomerLead.CompanyId,
CampaignId = x.CustomerLead.CampaignId,
ProfessionId = x.CustomerLead.ProfessionId,
Revenue = x.CustomerLead.Revenue,
EmployeeQuantity = x.CustomerLead.EmployeeQuantity,
Address = x.CustomerLead.Address,
NationId = x.CustomerLead.NationId,
ProvinceId = x.CustomerLead.ProvinceId,
DistrictId = x.CustomerLead.DistrictId,
CustomerLeadStatusId = x.CustomerLead.CustomerLeadStatusId,
BusinessRegistrationCode = x.CustomerLead.BusinessRegistrationCode,
SexId = x.CustomerLead.SexId,
RefuseReciveSMS = x.CustomerLead.RefuseReciveSMS,
RefuseReciveEmail = x.CustomerLead.RefuseReciveEmail,
Description = x.CustomerLead.Description,
AppUserId = x.CustomerLead.AppUserId,
CreatorId = x.CustomerLead.CreatorId,
ZipCode = x.CustomerLead.ZipCode,
CurrencyId = x.CustomerLead.CurrencyId,
RowId = x.CustomerLead.RowId,
},
FileType = x.FileType == null ? null : new FileType
{
Id = x.FileType.Id,
Code = x.FileType.Code,
Name = x.FileType.Name,
},
}).FirstOrDefaultAsync();
if (CustomerLeadFileGroup == null)
{
return(null);
}
return(CustomerLeadFileGroup);
}
