public async Task <bool> Delete(ContactFileGrouping ContactFileGrouping)
{
await DataContext.ContactFileGrouping.Where(x => x.Id == ContactFileGrouping.Id).UpdateFromQueryAsync(x => new ContactFileGroupingDAO {
DeletedAt = StaticParams.DateTimeNow, UpdatedAt = StaticParams.DateTimeNow
});
return(true);
}
public Contact_ContactFileGroupingDTO(ContactFileGrouping ContactFileGrouping)
{
this.Id = ContactFileGrouping.Id;
this.Title = ContactFileGrouping.Title;
this.Description = ContactFileGrouping.Description;
this.CreatorId = ContactFileGrouping.CreatorId;
this.ContactId = ContactFileGrouping.ContactId;
this.FileTypeId = ContactFileGrouping.FileTypeId;
this.CreatedAt = ContactFileGrouping.CreatedAt;
this.UpdatedAt = ContactFileGrouping.UpdatedAt;
this.Errors = ContactFileGrouping.Errors;
this.Creator = ContactFileGrouping.Creator == null ? null : new Contact_AppUserDTO(ContactFileGrouping.Creator);
this.FileType = ContactFileGrouping.FileType == null ? null : new Contact_FileTypeDTO(ContactFileGrouping.FileType);
this.ContactFileMappings = ContactFileGrouping.ContactFileMappings?.Select(x => new Contact_ContactFileMappingDTO(x)).ToList();
}
public async Task <bool> Create(ContactFileGrouping ContactFileGrouping)
{
ContactFileGroupingDAO ContactFileGroupingDAO = new ContactFileGroupingDAO();
ContactFileGroupingDAO.Id = ContactFileGrouping.Id;
ContactFileGroupingDAO.Title = ContactFileGrouping.Title;
ContactFileGroupingDAO.Description = ContactFileGrouping.Description;
ContactFileGroupingDAO.ContactId = ContactFileGrouping.ContactId;
ContactFileGroupingDAO.CreatorId = ContactFileGrouping.CreatorId;
ContactFileGroupingDAO.FileTypeId = ContactFileGrouping.FileTypeId;
ContactFileGroupingDAO.RowId = ContactFileGrouping.RowId;
ContactFileGroupingDAO.CreatedAt = StaticParams.DateTimeNow;
ContactFileGroupingDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.ContactFileGrouping.Add(ContactFileGroupingDAO);
await DataContext.SaveChangesAsync();
ContactFileGrouping.Id = ContactFileGroupingDAO.Id;
await SaveReference(ContactFileGrouping);
return(true);
}
public async Task <bool> Update(ContactFileGrouping ContactFileGrouping)
{
ContactFileGroupingDAO ContactFileGroupingDAO = DataContext.ContactFileGrouping.Where(x => x.Id == ContactFileGrouping.Id).FirstOrDefault();
if (ContactFileGroupingDAO == null)
{
return(false);
}
ContactFileGroupingDAO.Id = ContactFileGrouping.Id;
ContactFileGroupingDAO.Title = ContactFileGrouping.Title;
ContactFileGroupingDAO.Description = ContactFileGrouping.Description;
ContactFileGroupingDAO.ContactId = ContactFileGrouping.ContactId;
ContactFileGroupingDAO.CreatorId = ContactFileGrouping.CreatorId;
ContactFileGroupingDAO.FileTypeId = ContactFileGrouping.FileTypeId;
ContactFileGroupingDAO.RowId = ContactFileGrouping.RowId;
ContactFileGroupingDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(ContactFileGrouping);
return(true);
}
private async Task SaveReference(ContactFileGrouping ContactFileGrouping)
{
}
public async Task <ContactFileGrouping> Get(long Id)
{
ContactFileGrouping ContactFileGrouping = await DataContext.ContactFileGrouping.AsNoTracking()
.Where(x => x.Id == Id)
.Where(x => x.DeletedAt == null)
.Select(x => new ContactFileGrouping()
{
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt,
Id = x.Id,
Title = x.Title,
Description = x.Description,
ContactId = x.ContactId,
CreatorId = x.CreatorId,
FileTypeId = x.FileTypeId,
RowId = x.RowId,
Contact = x.Contact == null ? null : new Contact
{
Id = x.Contact.Id,
Name = x.Contact.Name,
ProfessionId = x.Contact.ProfessionId,
CompanyId = x.Contact.CompanyId,
ContactStatusId = x.Contact.ContactStatusId,
Address = x.Contact.Address,
NationId = x.Contact.NationId,
ProvinceId = x.Contact.ProvinceId,
DistrictId = x.Contact.DistrictId,
CustomerLeadId = x.Contact.CustomerLeadId,
ImageId = x.Contact.ImageId,
Description = x.Contact.Description,
EmailOther = x.Contact.EmailOther,
DateOfBirth = x.Contact.DateOfBirth,
Phone = x.Contact.Phone,
PhoneHome = x.Contact.PhoneHome,
FAX = x.Contact.FAX,
Email = x.Contact.Email,
Department = x.Contact.Department,
ZIPCode = x.Contact.ZIPCode,
SexId = x.Contact.SexId,
AppUserId = x.Contact.AppUserId,
RefuseReciveEmail = x.Contact.RefuseReciveEmail,
RefuseReciveSMS = x.Contact.RefuseReciveSMS,
PositionId = x.Contact.PositionId,
CreatorId = x.Contact.CreatorId,
},
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 (ContactFileGrouping == null)
{
return(null);
}
return(ContactFileGrouping);
}
