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); }