private void SoftDelete(tblM_MappingUserToRoleGroup mappingUserToRoleGroup) { if (mappingUserToRoleGroup != null) { mappingUserToRoleGroup.Status_FK = (int)RecordStatus.Deleted; } }
private void HardDelete(tblM_MappingUserToRoleGroup mappingUserToRoleGroup) { if (mappingUserToRoleGroup != null) { Db.tblM_MappingUserToRoleGroup.Remove(mappingUserToRoleGroup); } }
public tblM_MappingUserToRoleGroup Insert(MappingUserToRoleGroupDTO mappingUserToRoleGroupDTO, DateTime dateStamp) { if (mappingUserToRoleGroupDTO == null) { throw new ArgumentNullException("MappingUserToRoleGroup model is null."); } var recordIsExist = Db.tblM_MappingUserToRoleGroup.Find(mappingUserToRoleGroupDTO.User_PK, mappingUserToRoleGroupDTO.RoleGroup_PK) != null; if (recordIsExist) { throw new KairosException("User already exist in the group."); } var user = new UserQuery(Db).GetByPrimaryKey((int)mappingUserToRoleGroupDTO.User_PK); if (user != null) { if (assignableJabatan.Contains(user.KategoriJabatan_FK)) { var mappingUserRoleGroupCount = Db.tblM_MappingUserToRoleGroup.Where(x => x.User_PK == user.User_PK).Count(); //if (mappingUserRoleGroupCount > 0) //{ // throw new KairosException($"This user cannot have more than one role group because its position is '{user.KategoriJabatanTitle}'."); //} } } tblM_MappingUserToRoleGroup mappingUserToRoleGroup = mappingUserToRoleGroupFactory.CreateFromDTO(mappingUserToRoleGroupDTO, dateStamp); return(Db.tblM_MappingUserToRoleGroup.Add(mappingUserToRoleGroup)); }
public void Update(MappingUserToRoleGroupDTO mappingUserToRoleGroupDTO, DateTime dateStamp) { if (mappingUserToRoleGroupDTO == null) { throw new ArgumentNullException("MappingUserToRoleGroup model is null."); } tblM_MappingUserToRoleGroup mappingUserToRoleGroup = mappingUserToRoleGroupFactory.CreateFromDbAndUpdateFromDTO(mappingUserToRoleGroupDTO, dateStamp); }
public tblM_MappingUserToRoleGroup CreateFromDTO(MappingUserToRoleGroupDTO mappingUserToRoleGroupDTO, DateTime dateStamp) { if (mappingUserToRoleGroupDTO == null) { throw new ArgumentNullException("MappingUserToRoleGroup model is null."); } mappingUserToRoleGroupDTO.Status_FK = (int)RecordStatus.Active; mappingUserToRoleGroupDTO.CreatedBy = User.Username; mappingUserToRoleGroupDTO.CreatedDate = dateStamp; mappingUserToRoleGroupDTO.UpdatedBy = User.Username; mappingUserToRoleGroupDTO.UpdatedDate = dateStamp; tblM_MappingUserToRoleGroup mappingUserToRoleGroup = mappingUserToRoleGroupDTO.ToObject <tblM_MappingUserToRoleGroup>(); return(mappingUserToRoleGroup); }
public tblM_MappingUserToRoleGroup Insert(MappingUserToRoleGroupDTO mappingUserToRoleGroupDTO, DateTime dateStamp) { if (mappingUserToRoleGroupDTO == null) { throw new ArgumentNullException("MappingUserToRoleGroup model is null."); } var recordIsExist = Db.tblM_MappingUserToRoleGroup.Find(mappingUserToRoleGroupDTO.User_PK, mappingUserToRoleGroupDTO.RoleGroup_PK) != null; if (recordIsExist) { throw new KairosException("User already exist in the group."); } tblM_MappingUserToRoleGroup mappingUserToRoleGroup = mappingUserToRoleGroupFactory.CreateFromDTO(mappingUserToRoleGroupDTO, dateStamp); return(Db.tblM_MappingUserToRoleGroup.Add(mappingUserToRoleGroup)); }
public SaveResult <MappingUserToRoleGroupEntryModel> Save(MappingUserToRoleGroupDTO mappingUserToRoleGroupDTO, DateTime dateStamp) { ModelValidationResult validationResult = mappingUserToRoleGroupValidator.Validate(mappingUserToRoleGroupDTO); bool success = false; MappingUserToRoleGroupEntryModel model = null; if (validationResult.IsValid) { tblM_MappingUserToRoleGroup mappingUserToRoleGroup = Insert(mappingUserToRoleGroupDTO, dateStamp); Db.SaveChanges(); success = true; model = mappingUserToRoleGroupEntryDataProvider.Get(mappingUserToRoleGroup.RoleGroup_PK, mappingUserToRoleGroup.User_PK); } return(new SaveResult <MappingUserToRoleGroupEntryModel> { Success = success, Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.", Model = model, ValidationResult = validationResult }); }
public DeleteResult <tblM_MappingUserToRoleGroup> Execute(int roleGroupPk, int userPk, DeleteMethod deleteMethod) { tblM_MappingUserToRoleGroup mappingUserToRoleGroup = Db.tblM_MappingUserToRoleGroup.Find(userPk, roleGroupPk); if (mappingUserToRoleGroup == null) { return(new DeleteResult <tblM_MappingUserToRoleGroup>() { Success = false, Message = $"Id '{roleGroupPk} and {userPk}' is not found.", Record = null }); } switch (deleteMethod) { case DeleteMethod.Soft: SoftDelete(mappingUserToRoleGroup); break; case DeleteMethod.Hard: HardDelete(mappingUserToRoleGroup); break; default: break; } Db.SaveChanges(); return(new DeleteResult <tblM_MappingUserToRoleGroup>() { Success = true, Message = $"User member of role group successfully deleted.", Record = mappingUserToRoleGroup }); }